OSDN Git Service

pg-rex/syncrep.git
21 years agoFixed DatabaseMetaData to correctly handle NAME size of 64
Barry Lind [Sun, 8 Sep 2002 00:15:29 +0000 (00:15 +0000)]
Fixed DatabaseMetaData to correctly handle NAME size of 64
Fixed Statement to correctly DEALLOCATE any prepared statements

 Modified Files:
  jdbc/org/postgresql/PGStatement.java
  jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
  jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java

21 years agoChanges to documentation and the regression tests for the default
Bruce Momjian [Sat, 7 Sep 2002 18:39:05 +0000 (18:39 +0000)]
Changes to documentation and the regression tests for the default
NAMEDATALEN of 64.

Kris Jurka

21 years agoDone as far as possible:
Bruce Momjian [Sat, 7 Sep 2002 18:37:15 +0000 (18:37 +0000)]
Done as far as possible:

< * Add documentation to lock shared memory into RAM for each OS, if possible

21 years agoRemove pgaccess from docs; not shipping it anymore.
Bruce Momjian [Sat, 7 Sep 2002 16:49:50 +0000 (16:49 +0000)]
Remove pgaccess from docs; not shipping it anymore.

21 years agoAllow pg_dumpall to work with previous releases again. Don't pass the -c
Peter Eisentraut [Sat, 7 Sep 2002 16:14:33 +0000 (16:14 +0000)]
Allow pg_dumpall to work with previous releases again.  Don't pass the -c
option down to pg_dump, where it's useless, and clarify the meaning of -c
in the documentation.

21 years agoFix help output.
Peter Eisentraut [Sat, 7 Sep 2002 16:12:27 +0000 (16:12 +0000)]
Fix help output.

21 years agoMake sure the pg_dump tar archiver can handle members larger than 2 GB, but
Peter Eisentraut [Fri, 6 Sep 2002 21:58:36 +0000 (21:58 +0000)]
Make sure the pg_dump tar archiver can handle members larger than 2 GB, but
does not create members larger than allowed by the tar format.  Also, fix
the generation of the tar header to conform to POSIX.

21 years agoAdjust the tarball splitting scheme to the new reality.
Peter Eisentraut [Fri, 6 Sep 2002 21:57:11 +0000 (21:57 +0000)]
Adjust the tarball splitting scheme to the new reality.

21 years agoRun pgjindent for Java folks.
Bruce Momjian [Fri, 6 Sep 2002 21:23:06 +0000 (21:23 +0000)]
Run pgjindent for Java folks.

21 years agoFix another typo.
Bruce Momjian [Fri, 6 Sep 2002 20:26:00 +0000 (20:26 +0000)]
Fix another typo.

21 years agoFix typo.
Bruce Momjian [Fri, 6 Sep 2002 20:08:06 +0000 (20:08 +0000)]
Fix typo.

21 years agoUpdate for new IP.
Bruce Momjian [Fri, 6 Sep 2002 18:46:23 +0000 (18:46 +0000)]
Update for new IP.

21 years agoAdd JAVA_HOME test for Ant.
Bruce Momjian [Fri, 6 Sep 2002 14:31:16 +0000 (14:31 +0000)]
Add JAVA_HOME test for Ant.

21 years agoFix printf() quote handling and improper exit(), per Tom.
Bruce Momjian [Fri, 6 Sep 2002 02:33:47 +0000 (02:33 +0000)]
Fix printf() quote handling and improper exit(), per Tom.

21 years agoRemove heap_mark4update from AlterTableCreateToastTable. This has
Tom Lane [Fri, 6 Sep 2002 00:01:53 +0000 (00:01 +0000)]
Remove heap_mark4update from AlterTableCreateToastTable.  This has
never been the correct procedure for locking a relation, and the
recently-found ALTER TABLE bug with adding a constraint and a toast
table in the same command shows why it's a bad idea.

21 years agoFix some operator-precedence problems. New constructs IS DISTINCT FRM
Tom Lane [Thu, 5 Sep 2002 22:52:48 +0000 (22:52 +0000)]
Fix some operator-precedence problems.  New constructs IS DISTINCT FRM
and IS [NOT] OF were not being parsed consistently with other IS forms.
Also, make the world a little safer for functions named LEFT, RIGHT, etc.

21 years agoFix compile error.
Bruce Momjian [Thu, 5 Sep 2002 22:24:23 +0000 (22:24 +0000)]
Fix compile error.

21 years agoMissed mention of PGPASSWORDFILE.
Bruce Momjian [Thu, 5 Sep 2002 22:09:42 +0000 (22:09 +0000)]
Missed mention of PGPASSWORDFILE.

21 years agoUpdate HISTORY for PGPASSWORDFILE change.
Bruce Momjian [Thu, 5 Sep 2002 22:08:55 +0000 (22:08 +0000)]
Update HISTORY for PGPASSWORDFILE change.

21 years agoRemove PGPASSWORDFILE and default to always trying $HOME/.pgpass.
Bruce Momjian [Thu, 5 Sep 2002 22:05:50 +0000 (22:05 +0000)]
Remove PGPASSWORDFILE and default to always trying $HOME/.pgpass.

Cleanup up memory allocation for $HOME in related psql places.

Update mention of $HOME/.pgpass in the docs;  add mention in pg_dumpall.

21 years agoUpdate:
Bruce Momjian [Thu, 5 Sep 2002 22:03:02 +0000 (22:03 +0000)]
Update:

> * -Add ~/.pgpass to store passwords with user/host/password combinations

21 years agoFill in section on table modification.
Peter Eisentraut [Thu, 5 Sep 2002 21:32:23 +0000 (21:32 +0000)]
Fill in section on table modification.

21 years agoFix compile warning.
Tom Lane [Thu, 5 Sep 2002 21:19:13 +0000 (21:19 +0000)]
Fix compile warning.

21 years agoFix bit-rotted reference to GetUserName() ...
Tom Lane [Thu, 5 Sep 2002 21:13:03 +0000 (21:13 +0000)]
Fix bit-rotted reference to GetUserName() ...
it's GetUserNameFromId() now.

21 years agoFix breakage introduced by careless snprintf patching.
Tom Lane [Thu, 5 Sep 2002 21:09:54 +0000 (21:09 +0000)]
Fix breakage introduced by careless snprintf patching.

21 years agoFix unsafe macro definitions (which were producing incorrect code,
Tom Lane [Thu, 5 Sep 2002 21:08:26 +0000 (21:08 +0000)]
Fix unsafe macro definitions (which were producing incorrect code,
leading to compile warnings).

21 years agoRemove compile warnings, ensure consistent build environment for
Tom Lane [Thu, 5 Sep 2002 21:01:16 +0000 (21:01 +0000)]
Remove compile warnings, ensure consistent build environment for
largefile usage.

21 years agoFix compile warning.
Tom Lane [Thu, 5 Sep 2002 20:57:00 +0000 (20:57 +0000)]
Fix compile warning.

21 years agofindoidjoins and tsearch are not broken anymore.
Tom Lane [Thu, 5 Sep 2002 20:53:45 +0000 (20:53 +0000)]
findoidjoins and tsearch are not broken anymore.

21 years agoFix compile errors.
Tom Lane [Thu, 5 Sep 2002 20:51:39 +0000 (20:51 +0000)]
Fix compile errors.

21 years agoImprove opr_sanity regression test to check oprltcmpop and opgtcmpop
Tom Lane [Thu, 5 Sep 2002 20:23:19 +0000 (20:23 +0000)]
Improve opr_sanity regression test to check oprltcmpop and opgtcmpop
mergejoin links.

21 years agoUpdate oidjoins regression test for 7.3 catalogs.
Tom Lane [Thu, 5 Sep 2002 19:58:14 +0000 (19:58 +0000)]
Update oidjoins regression test for 7.3 catalogs.

21 years agofindoidjoins is updated for schemas, does not use libpgeasy.
Tom Lane [Thu, 5 Sep 2002 19:57:32 +0000 (19:57 +0000)]
findoidjoins is updated for schemas, does not use libpgeasy.
From Joe Conway.

21 years agoSeems like a good idea for template1 to contain ANALYZE stats for the
Tom Lane [Thu, 5 Sep 2002 19:56:57 +0000 (19:56 +0000)]
Seems like a good idea for template1 to contain ANALYZE stats for the
system tables.

21 years agoCommenting out doesn't work, so move the broken modules out of the list.
Peter Eisentraut [Thu, 5 Sep 2002 18:40:33 +0000 (18:40 +0000)]
Commenting out doesn't work, so move the broken modules out of the list.

21 years agoautoconf
Peter Eisentraut [Thu, 5 Sep 2002 18:39:11 +0000 (18:39 +0000)]
autoconf

21 years agoAssorted fixes for Cygwin:
Peter Eisentraut [Thu, 5 Sep 2002 18:28:46 +0000 (18:28 +0000)]
Assorted fixes for Cygwin:

Eliminate the mysterious games that the Cygwin build plays with the linker
flag variables.  DLLLIBS is gone, use SHLIB_LINK like everyone else.
Detect cygipc in configure, after the linker flags are set up, otherwise
configure might not work at all.

Make sure everything is covered by make clean.

Fix the build of the new conversion procedure modules.

Add new DLLIMPORT markers where required.

Finally, the compiler complains if we use an explicit
-I/usr/local/include, so don't do that.  Curiously, -L/usr/local/lib is
still necessary.

21 years agoDon't use gethostbyname2(). It's not portable and we don't claim to
Peter Eisentraut [Thu, 5 Sep 2002 18:27:13 +0000 (18:27 +0000)]
Don't use gethostbyname2().  It's not portable and we don't claim to
support IPv6 anyway.

21 years agoFix compilation warning. (Cygwin has char* as second argument of
Peter Eisentraut [Thu, 5 Sep 2002 18:26:18 +0000 (18:26 +0000)]
Fix compilation warning.  (Cygwin has char* as second argument of
recvfrom(), not void*.)

21 years agoRemove:
Bruce Momjian [Thu, 5 Sep 2002 16:40:18 +0000 (16:40 +0000)]
Remove:

< * Make pg_trigger.tgargs refer to columns by number, not name

21 years agoUpdate:
Bruce Momjian [Thu, 5 Sep 2002 05:11:11 +0000 (05:11 +0000)]
Update:

> * Make pg_trigger.tgargs refer to columns by number, not name

21 years agoDone:
Bruce Momjian [Thu, 5 Sep 2002 04:58:28 +0000 (04:58 +0000)]
Done:

> * -Make triggers refer to columns by number, not name

21 years agoremove pgaccess from GNUmakefile.in if we want the beta to build :)
Marc G. Fournier [Thu, 5 Sep 2002 02:05:30 +0000 (02:05 +0000)]
remove pgaccess from GNUmakefile.in if we want the beta to build :)

21 years agoRemove include of libpq-int.h --- dblink.c should not be (and was not)
Tom Lane [Thu, 5 Sep 2002 00:56:35 +0000 (00:56 +0000)]
Remove include of libpq-int.h --- dblink.c should not be (and was not)
depending on libpq internals.

21 years agoBe careful to include postgres.h *before* any system headers, to ensure
Tom Lane [Thu, 5 Sep 2002 00:43:07 +0000 (00:43 +0000)]
Be careful to include postgres.h *before* any system headers, to ensure
that the right flavors of largefile-related definitions are seen.
Most of these changes are probably unnecessary, but better safe than
sorry.

21 years agoGuard against send-lots-and-lots-of-data DoS attack from unauthenticated
Tom Lane [Wed, 4 Sep 2002 23:31:35 +0000 (23:31 +0000)]
Guard against send-lots-and-lots-of-data DoS attack from unauthenticated
users, by limiting the length of string we will accept for a password.
Patch by Serguei Mokhov, some editorializing by Tom Lane.

21 years agoAdd change by Neil.
Bruce Momjian [Wed, 4 Sep 2002 23:14:22 +0000 (23:14 +0000)]
Add change by Neil.

21 years agoRemove leftovers from subproject removals. Fixes for Python and Kerberos
Peter Eisentraut [Wed, 4 Sep 2002 22:54:18 +0000 (22:54 +0000)]
Remove leftovers from subproject removals.  Fixes for Python and Kerberos
configuration.

21 years agoFix compile warning.
Peter Eisentraut [Wed, 4 Sep 2002 22:51:23 +0000 (22:51 +0000)]
Fix compile warning.

21 years agoDisable findoidjoins while it doesn't compile.
Peter Eisentraut [Wed, 4 Sep 2002 22:50:43 +0000 (22:50 +0000)]
Disable findoidjoins while it doesn't compile.

21 years agoFix includes for plperl: ensure postgres.h is included first,
Tom Lane [Wed, 4 Sep 2002 22:49:37 +0000 (22:49 +0000)]
Fix includes for plperl: ensure postgres.h is included first,
remove unnecessary inclusions.

21 years agoAdd:
Bruce Momjian [Wed, 4 Sep 2002 22:09:47 +0000 (22:09 +0000)]
Add:

> * Remove Cyrillic recode support

21 years agoDone:
Bruce Momjian [Wed, 4 Sep 2002 21:07:41 +0000 (21:07 +0000)]
Done:

>       o -Add SHOW command to see locale

21 years agoAdd:
Bruce Momjian [Wed, 4 Sep 2002 21:05:40 +0000 (21:05 +0000)]
Add:

>  o -Add SHOW command to see locale

21 years agopgindent run.
Bruce Momjian [Wed, 4 Sep 2002 20:31:48 +0000 (20:31 +0000)]
pgindent run.

21 years agoUpdate:
Bruce Momjian [Wed, 4 Sep 2002 20:26:08 +0000 (20:26 +0000)]
Update:

Improvements to /contrib/intarray (Oleg, Teodor Sigaev, Andrey
Oktyabrski)

21 years agoAdd Joe's table functions description.
Bruce Momjian [Wed, 4 Sep 2002 20:06:23 +0000 (20:06 +0000)]
Add Joe's table functions description.

21 years agoUpdate symbols for 7.3.
Bruce Momjian [Wed, 4 Sep 2002 19:11:06 +0000 (19:11 +0000)]
Update symbols for 7.3.

21 years agoUpdate wording for Tom.
Bruce Momjian [Wed, 4 Sep 2002 19:07:43 +0000 (19:07 +0000)]
Update wording for Tom.

21 years agoUpdate for 7.3 typedefs.
Bruce Momjian [Wed, 4 Sep 2002 19:00:01 +0000 (19:00 +0000)]
Update for 7.3 typedefs.

21 years agoUpdate to reflect Tom's suggestions.
Bruce Momjian [Wed, 4 Sep 2002 18:45:52 +0000 (18:45 +0000)]
Update to reflect Tom's suggestions.

21 years agoRemove sh -x option that snuck in somehow.
Peter Eisentraut [Wed, 4 Sep 2002 18:04:57 +0000 (18:04 +0000)]
Remove sh -x option that snuck in somehow.

21 years agoReorder items.
Bruce Momjian [Wed, 4 Sep 2002 17:27:13 +0000 (17:27 +0000)]
Reorder items.

21 years agoMore HISTORY improvements from Joe.
Bruce Momjian [Wed, 4 Sep 2002 17:25:08 +0000 (17:25 +0000)]
More HISTORY improvements from Joe.

21 years agoUpdate HISTORY wording.
Bruce Momjian [Wed, 4 Sep 2002 17:11:47 +0000 (17:11 +0000)]
Update HISTORY wording.

21 years agoAvoid multiple scans of utils/mb/conversion_procs/ subdirectories during
Tom Lane [Wed, 4 Sep 2002 15:45:50 +0000 (15:45 +0000)]
Avoid multiple scans of utils/mb/conversion_procs/ subdirectories during
'make install'; there are enough of 'em that this slowed down the make
noticeably.  Ensure that 'all' is the default make target in all these
directories (defaulting to 'make install' is surprising and dangerous
IMHO).  Fix a couple small typos.

21 years agoStamp configure.in with 7.3b1, not just 7.3. Seems Marc does that
Bruce Momjian [Wed, 4 Sep 2002 08:08:29 +0000 (08:08 +0000)]
Stamp configure.in with 7.3b1, not just 7.3.   Seems Marc does that
usually anyway.

21 years agoUpdate based on TODO file contents.
Bruce Momjian [Wed, 4 Sep 2002 07:42:24 +0000 (07:42 +0000)]
Update based on TODO file contents.

21 years agoFile list cleanup.
Bruce Momjian [Wed, 4 Sep 2002 07:31:59 +0000 (07:31 +0000)]
File list cleanup.

21 years agoSpellcheck of HISTORY.
Bruce Momjian [Wed, 4 Sep 2002 07:30:33 +0000 (07:30 +0000)]
Spellcheck of HISTORY.

21 years agoUpdate files to be changed.
Bruce Momjian [Wed, 4 Sep 2002 07:26:37 +0000 (07:26 +0000)]
Update files to be changed.

21 years agoBrand 7.3. Ready for beta!
Bruce Momjian [Wed, 4 Sep 2002 07:23:04 +0000 (07:23 +0000)]
Brand 7.3.  Ready for beta!

21 years agoUpdate new HISTORY file for 7.3!
Bruce Momjian [Wed, 4 Sep 2002 07:16:32 +0000 (07:16 +0000)]
Update new HISTORY file for 7.3!

21 years agoRefrect changes made by Tom Lane
Tatsuo Ishii [Wed, 4 Sep 2002 02:54:59 +0000 (02:54 +0000)]
Refrect changes made by Tom Lane

21 years agoRefrect the changes to src/test/regress/sql/conversion.sql By Tom.
Tatsuo Ishii [Wed, 4 Sep 2002 02:42:34 +0000 (02:42 +0000)]
Refrect the changes to src/test/regress/sql/conversion.sql By Tom.

21 years agoAdd:
Bruce Momjian [Tue, 3 Sep 2002 23:39:04 +0000 (23:39 +0000)]
Add:

> * Gavin Sherry <swm@linuxworld.com.au>

21 years agoEXTRACT(EPOCH FROM timestamp) gave wrong answers in the int64-timestamp
Tom Lane [Tue, 3 Sep 2002 22:55:54 +0000 (22:55 +0000)]
EXTRACT(EPOCH FROM timestamp) gave wrong answers in the int64-timestamp
case for timestamptz input, and differently wrong answers in the float-
timestamp case for timestamp input.

21 years agoArrange for the default permissions on a database to allow temp table
Tom Lane [Tue, 3 Sep 2002 22:17:35 +0000 (22:17 +0000)]
Arrange for the default permissions on a database to allow temp table
creation to world, but disallow temp table creation in template1.  Per
latest round of pghackers discussion.
I did not force initdb, but the permissions lockdown on template1 will
not take effect unless you do one (or manually REVOKE TEMP ON DATABASE template1 FROM public).

21 years agoconversion test fails if there is an existing user named foo. Choose a name
Tom Lane [Tue, 3 Sep 2002 22:06:19 +0000 (22:06 +0000)]
conversion test fails if there is an existing user named foo.  Choose a name
somewhat less likely to provoke a conflict.

21 years agoRemove all traces of multibyte and locale options. Clean up comments
Peter Eisentraut [Tue, 3 Sep 2002 21:45:44 +0000 (21:45 +0000)]
Remove all traces of multibyte and locale options.  Clean up comments
referring to "multibyte" where it really means character encoding.

21 years agoWork around mktime() brain damage in recent versions of glibc by using
Tom Lane [Tue, 3 Sep 2002 19:46:32 +0000 (19:46 +0000)]
Work around mktime() brain damage in recent versions of glibc by using
a series of localtime() calls to determine the local timezone offset
when mktime() fails.  This eliminates regression failures on RHL 7.3,
and should continue to work until it occurs to the glibc boys to break
localtime() as well.  By then I hope we'll have our own timezone code...

21 years agoEliminate unnecessary dependency on mktime(), and consequent 'Unable to
Tom Lane [Tue, 3 Sep 2002 19:41:28 +0000 (19:41 +0000)]
Eliminate unnecessary dependency on mktime(), and consequent 'Unable to
convert date to tm' failures, by using DetermineLocalTimeZone() instead.

21 years agoWorkaround for format strings that are concatenated from macros
Peter Eisentraut [Tue, 3 Sep 2002 18:50:54 +0000 (18:50 +0000)]
Workaround for format strings that are concatenated from macros
(INT64_FORMAT), which gettext cannot handle.

21 years agoAIX shlib fix for building libpq.so from Tomoyuki Niijima
Bruce Momjian [Tue, 3 Sep 2002 17:17:24 +0000 (17:17 +0000)]
AIX shlib fix for building libpq.so from Tomoyuki Niijima

21 years agoAdd:
Bruce Momjian [Tue, 3 Sep 2002 17:09:49 +0000 (17:09 +0000)]
Add:

> * to_char(0,'FM999.99') returns a period, to_char(1,'FM999.99') does not

21 years agoFix SGML build failure.
Bruce Momjian [Tue, 3 Sep 2002 16:21:23 +0000 (16:21 +0000)]
Fix SGML build failure.

21 years agoI think reindex_index had better get AccessExclusiveLock on the parent
Tom Lane [Tue, 3 Sep 2002 16:00:02 +0000 (16:00 +0000)]
I think reindex_index had better get AccessExclusiveLock on the parent
heap, not just ExclusiveLock.

21 years agoClean out cruft left by nonstandard test procedure.
Tom Lane [Tue, 3 Sep 2002 04:01:05 +0000 (04:01 +0000)]
Clean out cruft left by nonstandard test procedure.

21 years agolast-minute CreateTemplateTupleDesc fixes.
Tom Lane [Tue, 3 Sep 2002 04:00:37 +0000 (04:00 +0000)]
last-minute CreateTemplateTupleDesc fixes.

21 years agoChange ownership:
Bruce Momjian [Tue, 3 Sep 2002 01:40:05 +0000 (01:40 +0000)]
Change ownership:

<  o -ALTER TABLE ADD PRIMARY KEY (Christopher)
<  o -ALTER TABLE ADD UNIQUE (Christopher)
>  o -ALTER TABLE ADD PRIMARY KEY (Tom)
>  o -ALTER TABLE ADD UNIQUE (Tom)

21 years agoDocumentation improvements.
Tom Lane [Tue, 3 Sep 2002 01:11:37 +0000 (01:11 +0000)]
Documentation improvements.

21 years agoCode review and documentation updates for indisclustered patch.
Tom Lane [Tue, 3 Sep 2002 01:04:41 +0000 (01:04 +0000)]
Code review and documentation updates for indisclustered patch.

21 years agoPartial solution for 'unexpected EOF' problem with pg_disconnect: it
Tom Lane [Mon, 2 Sep 2002 23:41:17 +0000 (23:41 +0000)]
Partial solution for 'unexpected EOF' problem with pg_disconnect: it
seems we have a choice between annoying messages and leaking memory
(or dumping core, but that's right out).  Patch also fixes several
other problems in pg_disconnect, such as being willing to close a
channel that isn't a PG channel.

21 years agoTranslation updates
Peter Eisentraut [Mon, 2 Sep 2002 22:22:12 +0000 (22:22 +0000)]
Translation updates

21 years agoAvoid shell syntax error if list of languages is empty.
Peter Eisentraut [Mon, 2 Sep 2002 22:19:42 +0000 (22:19 +0000)]
Avoid shell syntax error if list of languages is empty.

21 years agoFix typos.
Peter Eisentraut [Mon, 2 Sep 2002 22:18:56 +0000 (22:18 +0000)]
Fix typos.

21 years agoConvert control status codes to human-readable strings.
Peter Eisentraut [Mon, 2 Sep 2002 22:18:26 +0000 (22:18 +0000)]
Convert control status codes to human-readable strings.

21 years agopg_on_connection_loss command for libpgtcl. Patch from
Tom Lane [Mon, 2 Sep 2002 21:51:47 +0000 (21:51 +0000)]
pg_on_connection_loss command for libpgtcl.  Patch from
Gerhard Hintermayer, revised and documented by Tom Lane.

This patch also fixes a 'must fix' bug: libpgtcl's LISTEN/NOTIFY
support was broken by the recent changes to the PGnotify structure.
Guess that change wasn't quite so safe as we thought.

21 years agoFix obsolete description of PGnotify struct.
Tom Lane [Mon, 2 Sep 2002 20:21:32 +0000 (20:21 +0000)]
Fix obsolete description of PGnotify struct.

21 years agoDepartment of second thoughts: make checks for replacing a view slightly
Tom Lane [Mon, 2 Sep 2002 20:04:40 +0000 (20:04 +0000)]
Department of second thoughts: make checks for replacing a view slightly
more flexible, and improve the error reporting.  Also, add documentation
for REPLACE RULE/VIEW.