diff options
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 |