aboutsummaryrefslogtreecommitdiff
path: root/databases
diff options
context:
space:
mode:
authorVanilla I. Shu <vanilla@FreeBSD.org>2001-05-09 06:00:37 +0000
committerVanilla I. Shu <vanilla@FreeBSD.org>2001-05-09 06:00:37 +0000
commitdc12b458079779aa7d3ab79d9348bd3da6701315 (patch)
treed1e6118838c457f6049d19b428e5d1d6a8d39071 /databases
parentd117506b83b91b8c201f1dc5be775f851abe7509 (diff)
downloadports-dc12b458079779aa7d3ab79d9348bd3da6701315.tar.gz
ports-dc12b458079779aa7d3ab79d9348bd3da6701315.zip
Upgrade to 7.1.1
PR: ports/27220 Submitted by: maintainer
Notes
Notes: svn path=/head/; revision=42436
Diffstat (limited to 'databases')
-rw-r--r--databases/postgresql-devel-server/Makefile3
-rw-r--r--databases/postgresql-devel-server/distinfo6
-rw-r--r--databases/postgresql-devel-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql-devel-server/pkg-plist.doc9
-rw-r--r--databases/postgresql-devel/Makefile3
-rw-r--r--databases/postgresql-devel/distinfo6
-rw-r--r--databases/postgresql-devel/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql-devel/pkg-plist.doc9
-rw-r--r--databases/postgresql7/Makefile3
-rw-r--r--databases/postgresql7/distinfo6
-rw-r--r--databases/postgresql7/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql7/pkg-plist.doc9
-rw-r--r--databases/postgresql73-server/Makefile3
-rw-r--r--databases/postgresql73-server/distinfo6
-rw-r--r--databases/postgresql73-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql73-server/pkg-plist.doc9
-rw-r--r--databases/postgresql73/Makefile3
-rw-r--r--databases/postgresql73/distinfo6
-rw-r--r--databases/postgresql73/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql73/pkg-plist.doc9
-rw-r--r--databases/postgresql74-server/Makefile3
-rw-r--r--databases/postgresql74-server/distinfo6
-rw-r--r--databases/postgresql74-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql74-server/pkg-plist.doc9
-rw-r--r--databases/postgresql80-server/Makefile3
-rw-r--r--databases/postgresql80-server/distinfo6
-rw-r--r--databases/postgresql80-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql80-server/pkg-plist.doc9
-rw-r--r--databases/postgresql81-server/Makefile3
-rw-r--r--databases/postgresql81-server/distinfo6
-rw-r--r--databases/postgresql81-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql81-server/pkg-plist.doc9
-rw-r--r--databases/postgresql82-server/Makefile3
-rw-r--r--databases/postgresql82-server/distinfo6
-rw-r--r--databases/postgresql82-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql82-server/pkg-plist.doc9
-rw-r--r--databases/postgresql83-server/Makefile3
-rw-r--r--databases/postgresql83-server/distinfo6
-rw-r--r--databases/postgresql83-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql83-server/pkg-plist.doc9
-rw-r--r--databases/postgresql84-server/Makefile3
-rw-r--r--databases/postgresql84-server/distinfo6
-rw-r--r--databases/postgresql84-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql84-server/pkg-plist.doc9
-rw-r--r--databases/postgresql90-server/Makefile3
-rw-r--r--databases/postgresql90-server/distinfo6
-rw-r--r--databases/postgresql90-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql90-server/pkg-plist.doc9
-rw-r--r--databases/postgresql91-server/Makefile3
-rw-r--r--databases/postgresql91-server/distinfo6
-rw-r--r--databases/postgresql91-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql91-server/pkg-plist.doc9
-rw-r--r--databases/postgresql92-server/Makefile3
-rw-r--r--databases/postgresql92-server/distinfo6
-rw-r--r--databases/postgresql92-server/files/patch-jdbc-getdate34
-rw-r--r--databases/postgresql92-server/pkg-plist.doc9
56 files changed, 602 insertions, 126 deletions
diff --git a/databases/postgresql-devel-server/Makefile b/databases/postgresql-devel-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql-devel-server/Makefile
+++ b/databases/postgresql-devel-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql-devel-server/distinfo b/databases/postgresql-devel-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql-devel-server/distinfo
+++ b/databases/postgresql-devel-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql-devel-server/files/patch-jdbc-getdate b/databases/postgresql-devel-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql-devel-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql-devel-server/pkg-plist.doc b/databases/postgresql-devel-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql-devel-server/pkg-plist.doc
+++ b/databases/postgresql-devel-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql-devel/Makefile b/databases/postgresql-devel/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql-devel/Makefile
+++ b/databases/postgresql-devel/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql-devel/distinfo b/databases/postgresql-devel/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql-devel/distinfo
+++ b/databases/postgresql-devel/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql-devel/files/patch-jdbc-getdate b/databases/postgresql-devel/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql-devel/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql-devel/pkg-plist.doc b/databases/postgresql-devel/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql-devel/pkg-plist.doc
+++ b/databases/postgresql-devel/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql7/Makefile b/databases/postgresql7/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql7/Makefile
+++ b/databases/postgresql7/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql7/distinfo b/databases/postgresql7/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql7/distinfo
+++ b/databases/postgresql7/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql7/files/patch-jdbc-getdate b/databases/postgresql7/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql7/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql7/pkg-plist.doc b/databases/postgresql7/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql7/pkg-plist.doc
+++ b/databases/postgresql7/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql73-server/Makefile b/databases/postgresql73-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql73-server/Makefile
+++ b/databases/postgresql73-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql73-server/distinfo b/databases/postgresql73-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql73-server/distinfo
+++ b/databases/postgresql73-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql73-server/files/patch-jdbc-getdate b/databases/postgresql73-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql73-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql73-server/pkg-plist.doc b/databases/postgresql73-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql73-server/pkg-plist.doc
+++ b/databases/postgresql73-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql73/Makefile b/databases/postgresql73/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql73/Makefile
+++ b/databases/postgresql73/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql73/distinfo b/databases/postgresql73/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql73/distinfo
+++ b/databases/postgresql73/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql73/files/patch-jdbc-getdate b/databases/postgresql73/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql73/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql73/pkg-plist.doc b/databases/postgresql73/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql73/pkg-plist.doc
+++ b/databases/postgresql73/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql74-server/Makefile b/databases/postgresql74-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql74-server/Makefile
+++ b/databases/postgresql74-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql74-server/distinfo b/databases/postgresql74-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql74-server/distinfo
+++ b/databases/postgresql74-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql74-server/files/patch-jdbc-getdate b/databases/postgresql74-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql74-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql74-server/pkg-plist.doc b/databases/postgresql74-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql74-server/pkg-plist.doc
+++ b/databases/postgresql74-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql80-server/Makefile b/databases/postgresql80-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql80-server/Makefile
+++ b/databases/postgresql80-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql80-server/distinfo b/databases/postgresql80-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql80-server/distinfo
+++ b/databases/postgresql80-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql80-server/files/patch-jdbc-getdate b/databases/postgresql80-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql80-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql80-server/pkg-plist.doc b/databases/postgresql80-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql80-server/pkg-plist.doc
+++ b/databases/postgresql80-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql81-server/Makefile b/databases/postgresql81-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql81-server/Makefile
+++ b/databases/postgresql81-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql81-server/distinfo b/databases/postgresql81-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql81-server/distinfo
+++ b/databases/postgresql81-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql81-server/files/patch-jdbc-getdate b/databases/postgresql81-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql81-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql81-server/pkg-plist.doc b/databases/postgresql81-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql81-server/pkg-plist.doc
+++ b/databases/postgresql81-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql82-server/Makefile b/databases/postgresql82-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql82-server/Makefile
+++ b/databases/postgresql82-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql82-server/distinfo b/databases/postgresql82-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql82-server/distinfo
+++ b/databases/postgresql82-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql82-server/files/patch-jdbc-getdate b/databases/postgresql82-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql82-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql82-server/pkg-plist.doc b/databases/postgresql82-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql82-server/pkg-plist.doc
+++ b/databases/postgresql82-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql83-server/Makefile b/databases/postgresql83-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql83-server/Makefile
+++ b/databases/postgresql83-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql83-server/distinfo b/databases/postgresql83-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql83-server/distinfo
+++ b/databases/postgresql83-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql83-server/files/patch-jdbc-getdate b/databases/postgresql83-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql83-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql83-server/pkg-plist.doc b/databases/postgresql83-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql83-server/pkg-plist.doc
+++ b/databases/postgresql83-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql84-server/Makefile b/databases/postgresql84-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql84-server/Makefile
+++ b/databases/postgresql84-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql84-server/distinfo b/databases/postgresql84-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql84-server/distinfo
+++ b/databases/postgresql84-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql84-server/files/patch-jdbc-getdate b/databases/postgresql84-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql84-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql84-server/pkg-plist.doc b/databases/postgresql84-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql84-server/pkg-plist.doc
+++ b/databases/postgresql84-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql90-server/Makefile b/databases/postgresql90-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql90-server/Makefile
+++ b/databases/postgresql90-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql90-server/distinfo b/databases/postgresql90-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql90-server/distinfo
+++ b/databases/postgresql90-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql90-server/files/patch-jdbc-getdate b/databases/postgresql90-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql90-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql90-server/pkg-plist.doc b/databases/postgresql90-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql90-server/pkg-plist.doc
+++ b/databases/postgresql90-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql91-server/Makefile b/databases/postgresql91-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql91-server/Makefile
+++ b/databases/postgresql91-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql91-server/distinfo b/databases/postgresql91-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql91-server/distinfo
+++ b/databases/postgresql91-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql91-server/files/patch-jdbc-getdate b/databases/postgresql91-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql91-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql91-server/pkg-plist.doc b/databases/postgresql91-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql91-server/pkg-plist.doc
+++ b/databases/postgresql91-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html
diff --git a/databases/postgresql92-server/Makefile b/databases/postgresql92-server/Makefile
index 28d87052487d..0cc01070446c 100644
--- a/databases/postgresql92-server/Makefile
+++ b/databases/postgresql92-server/Makefile
@@ -6,8 +6,7 @@
#
PORTNAME= postgresql
-PORTVERSION= 7.1
-PORTREVISION= 2
+PORTVERSION= 7.1.1
CATEGORIES= databases
MASTER_SITES= ftp://ftp.iodynamics.com/pub/mirror/postgresql/%SUBDIR%/ \
ftp://ftp.postgresql.org/pub/%SUBDIR%/ \
diff --git a/databases/postgresql92-server/distinfo b/databases/postgresql92-server/distinfo
index bdec3e130f6c..c4ab6e29b6ff 100644
--- a/databases/postgresql92-server/distinfo
+++ b/databases/postgresql92-server/distinfo
@@ -1,3 +1,3 @@
-MD5 (postgresql/postgresql-base-7.1.tar.gz) = fce51e036ea8aadafe42f35841e50cc6
-MD5 (postgresql/postgresql-opt-7.1.tar.gz) = dca8a70020caab1024afe4d0f203fef1
-MD5 (postgresql/postgresql-docs-7.1.tar.gz) = 8fd7a862909663a6034d4aeb70ea7b71
+MD5 (postgresql/postgresql-base-7.1.1.tar.gz) = 7f579a6274d5b5e251b256c7525f861b
+MD5 (postgresql/postgresql-opt-7.1.1.tar.gz) = 3b06dc74de6721a3fcd7c9d8c4c0bce8
+MD5 (postgresql/postgresql-docs-7.1.1.tar.gz) = 9daf2d044b0805aa2d47df769cfa4069
diff --git a/databases/postgresql92-server/files/patch-jdbc-getdate b/databases/postgresql92-server/files/patch-jdbc-getdate
new file mode 100644
index 000000000000..744407ae14b5
--- /dev/null
+++ b/databases/postgresql92-server/files/patch-jdbc-getdate
@@ -0,0 +1,34 @@
+--- src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java~ Fri Feb 23 19:12:23 2001
++++ src/interfaces/jdbc/org/postgresql/jdbc2/ResultSet.java Wed May 9 04:31:11 2001
+@@ -423,8 +423,13 @@
+ String s = getString(columnIndex);
+ if(s==null)
+ return null;
+-
+- return java.sql.Date.valueOf(s);
++ // length == 10: SQL Date
++ // length > 10: SQL Timestamp, assumes PGDATESTYLE=ISO
++ try {
++ return java.sql.Date.valueOf((s.length() == 10) ? s : s.substring(0,10));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.baddate", s);
++ }
+ }
+
+ /**
+@@ -441,8 +446,13 @@
+
+ if(s==null)
+ return null; // SQL NULL
+-
+- return java.sql.Time.valueOf(s);
++ // length == 8: SQL Time
++ // length > 8: SQL Timestamp
++ try {
++ return java.sql.Time.valueOf((s.length() == 8) ? s : s.substring(11,19));
++ } catch (NumberFormatException e) {
++ throw new PSQLException("postgresql.res.badtime",s);
++ }
+ }
+
+ /**
diff --git a/databases/postgresql92-server/pkg-plist.doc b/databases/postgresql92-server/pkg-plist.doc
index 34366cec7aaa..5f13201ae647 100644
--- a/databases/postgresql92-server/pkg-plist.doc
+++ b/databases/postgresql92-server/pkg-plist.doc
@@ -152,12 +152,12 @@ share/doc/postgresql/html/libpqpp-copy.html
share/doc/postgresql/html/libpqpp-exec.html
share/doc/postgresql/html/libpqpp-notify.html
share/doc/postgresql/html/lisp.html
-share/doc/postgresql/html/ln11307.html
+share/doc/postgresql/html/ln11330.html
share/doc/postgresql/html/ln1274.html
-share/doc/postgresql/html/ln15103.html
+share/doc/postgresql/html/ln15154.html
share/doc/postgresql/html/ln24.html
-share/doc/postgresql/html/ln24896.html
-share/doc/postgresql/html/ln37046.html
+share/doc/postgresql/html/ln24983.html
+share/doc/postgresql/html/ln37149.html
share/doc/postgresql/html/ln8.html
share/doc/postgresql/html/lo-funcs.html
share/doc/postgresql/html/lo-implementation.html
@@ -471,6 +471,7 @@ share/doc/postgresql/html/user.html
share/doc/postgresql/html/wal-configuration.html
share/doc/postgresql/html/wal-implementation.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/x14487.html
share/doc/postgresql/html/xact-read-committed.html
share/doc/postgresql/html/xact-serializable.html
share/doc/postgresql/html/xaggr.html