Bruce Momjian [Fri, 6 Sep 2002 14:31:16 +0000 (14:31 +0000)]
Add JAVA_HOME test for Ant.
Bruce Momjian [Fri, 6 Sep 2002 02:33:47 +0000 (02:33 +0000)]
Fix printf() quote handling and improper exit(), per Tom.
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.
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.
Bruce Momjian [Thu, 5 Sep 2002 22:24:23 +0000 (22:24 +0000)]
Fix compile error.
Bruce Momjian [Thu, 5 Sep 2002 22:09:42 +0000 (22:09 +0000)]
Missed mention of PGPASSWORDFILE.
Bruce Momjian [Thu, 5 Sep 2002 22:08:55 +0000 (22:08 +0000)]
Update HISTORY for PGPASSWORDFILE change.
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.
Bruce Momjian [Thu, 5 Sep 2002 22:03:02 +0000 (22:03 +0000)]
Update:
> * -Add ~/.pgpass to store passwords with user/host/password combinations
Peter Eisentraut [Thu, 5 Sep 2002 21:32:23 +0000 (21:32 +0000)]
Fill in section on table modification.
Tom Lane [Thu, 5 Sep 2002 21:19:13 +0000 (21:19 +0000)]
Fix compile warning.
Tom Lane [Thu, 5 Sep 2002 21:13:03 +0000 (21:13 +0000)]
Fix bit-rotted reference to GetUserName() ...
it's GetUserNameFromId() now.
Tom Lane [Thu, 5 Sep 2002 21:09:54 +0000 (21:09 +0000)]
Fix breakage introduced by careless snprintf patching.
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).
Tom Lane [Thu, 5 Sep 2002 21:01:16 +0000 (21:01 +0000)]
Remove compile warnings, ensure consistent build environment for
largefile usage.
Tom Lane [Thu, 5 Sep 2002 20:57:00 +0000 (20:57 +0000)]
Fix compile warning.
Tom Lane [Thu, 5 Sep 2002 20:53:45 +0000 (20:53 +0000)]
findoidjoins and tsearch are not broken anymore.
Tom Lane [Thu, 5 Sep 2002 20:51:39 +0000 (20:51 +0000)]
Fix compile errors.
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.
Tom Lane [Thu, 5 Sep 2002 19:58:14 +0000 (19:58 +0000)]
Update oidjoins regression test for 7.3 catalogs.
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.
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.
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.
Peter Eisentraut [Thu, 5 Sep 2002 18:39:11 +0000 (18:39 +0000)]
autoconf
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.
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.
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*.)
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
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
Bruce Momjian [Thu, 5 Sep 2002 04:58:28 +0000 (04:58 +0000)]
Done:
> * -Make triggers refer to columns by number, not name
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 :)
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.
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.
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.
Bruce Momjian [Wed, 4 Sep 2002 23:14:22 +0000 (23:14 +0000)]
Add change by Neil.
Peter Eisentraut [Wed, 4 Sep 2002 22:54:18 +0000 (22:54 +0000)]
Remove leftovers from subproject removals. Fixes for Python and Kerberos
configuration.
Peter Eisentraut [Wed, 4 Sep 2002 22:51:23 +0000 (22:51 +0000)]
Fix compile warning.
Peter Eisentraut [Wed, 4 Sep 2002 22:50:43 +0000 (22:50 +0000)]
Disable findoidjoins while it doesn't compile.
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.
Bruce Momjian [Wed, 4 Sep 2002 22:09:47 +0000 (22:09 +0000)]
Add:
> * Remove Cyrillic recode support
Bruce Momjian [Wed, 4 Sep 2002 21:07:41 +0000 (21:07 +0000)]
Done:
> o -Add SHOW command to see locale
Bruce Momjian [Wed, 4 Sep 2002 21:05:40 +0000 (21:05 +0000)]
Add:
> o -Add SHOW command to see locale
Bruce Momjian [Wed, 4 Sep 2002 20:31:48 +0000 (20:31 +0000)]
pgindent run.
Bruce Momjian [Wed, 4 Sep 2002 20:26:08 +0000 (20:26 +0000)]
Update:
Improvements to /contrib/intarray (Oleg, Teodor Sigaev, Andrey
Oktyabrski)
Bruce Momjian [Wed, 4 Sep 2002 20:06:23 +0000 (20:06 +0000)]
Add Joe's table functions description.
Bruce Momjian [Wed, 4 Sep 2002 19:11:06 +0000 (19:11 +0000)]
Update symbols for 7.3.
Bruce Momjian [Wed, 4 Sep 2002 19:07:43 +0000 (19:07 +0000)]
Update wording for Tom.
Bruce Momjian [Wed, 4 Sep 2002 19:00:01 +0000 (19:00 +0000)]
Update for 7.3 typedefs.
Bruce Momjian [Wed, 4 Sep 2002 18:45:52 +0000 (18:45 +0000)]
Update to reflect Tom's suggestions.
Peter Eisentraut [Wed, 4 Sep 2002 18:04:57 +0000 (18:04 +0000)]
Remove sh -x option that snuck in somehow.
Bruce Momjian [Wed, 4 Sep 2002 17:27:13 +0000 (17:27 +0000)]
Reorder items.
Bruce Momjian [Wed, 4 Sep 2002 17:25:08 +0000 (17:25 +0000)]
More HISTORY improvements from Joe.
Bruce Momjian [Wed, 4 Sep 2002 17:11:47 +0000 (17:11 +0000)]
Update HISTORY wording.
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.
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.
Bruce Momjian [Wed, 4 Sep 2002 07:42:24 +0000 (07:42 +0000)]
Update based on TODO file contents.
Bruce Momjian [Wed, 4 Sep 2002 07:31:59 +0000 (07:31 +0000)]
File list cleanup.
Bruce Momjian [Wed, 4 Sep 2002 07:30:33 +0000 (07:30 +0000)]
Spellcheck of HISTORY.
Bruce Momjian [Wed, 4 Sep 2002 07:26:37 +0000 (07:26 +0000)]
Update files to be changed.
Bruce Momjian [Wed, 4 Sep 2002 07:23:04 +0000 (07:23 +0000)]
Brand 7.3. Ready for beta!
Bruce Momjian [Wed, 4 Sep 2002 07:16:32 +0000 (07:16 +0000)]
Update new HISTORY file for 7.3!
Tatsuo Ishii [Wed, 4 Sep 2002 02:54:59 +0000 (02:54 +0000)]
Refrect changes made by Tom Lane
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.
Bruce Momjian [Tue, 3 Sep 2002 23:39:04 +0000 (23:39 +0000)]
Add:
> * Gavin Sherry
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.
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).
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.
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.
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...
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.
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.
Bruce Momjian [Tue, 3 Sep 2002 17:17:24 +0000 (17:17 +0000)]
AIX shlib fix for building libpq.so from Tomoyuki Niijima
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
Bruce Momjian [Tue, 3 Sep 2002 16:21:23 +0000 (16:21 +0000)]
Fix SGML build failure.
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.
Tom Lane [Tue, 3 Sep 2002 04:01:05 +0000 (04:01 +0000)]
Clean out cruft left by nonstandard test procedure.
Tom Lane [Tue, 3 Sep 2002 04:00:37 +0000 (04:00 +0000)]
last-minute CreateTemplateTupleDesc fixes.
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)
Tom Lane [Tue, 3 Sep 2002 01:11:37 +0000 (01:11 +0000)]
Documentation improvements.
Tom Lane [Tue, 3 Sep 2002 01:04:41 +0000 (01:04 +0000)]
Code review and documentation updates for indisclustered patch.
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.
Peter Eisentraut [Mon, 2 Sep 2002 22:22:12 +0000 (22:22 +0000)]
Translation updates
Peter Eisentraut [Mon, 2 Sep 2002 22:19:42 +0000 (22:19 +0000)]
Avoid shell syntax error if list of languages is empty.
Peter Eisentraut [Mon, 2 Sep 2002 22:18:56 +0000 (22:18 +0000)]
Fix typos.
Peter Eisentraut [Mon, 2 Sep 2002 22:18:26 +0000 (22:18 +0000)]
Convert control status codes to human-readable strings.
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.
Tom Lane [Mon, 2 Sep 2002 20:21:32 +0000 (20:21 +0000)]
Fix obsolete description of PGnotify struct.
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.
Bruce Momjian [Mon, 2 Sep 2002 19:02:02 +0000 (19:02 +0000)]
No more need for 'privileges' file.
Bruce Momjian [Mon, 2 Sep 2002 17:34:57 +0000 (17:34 +0000)]
Improve CVS log grouping.
Bruce Momjian [Mon, 2 Sep 2002 16:21:30 +0000 (16:21 +0000)]
Updated from Tom:
< o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher Kings-Lynne)
< o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence
> o -ALTER TABLE ALTER COLUMN SET/DROP NOT NULL (Christopher)
200a200,201
> o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence because
> of the item above
232c233
< o -Disallow missing columns in INSERT ... VALUES, per ANSI
> o -Disallow missing columns in INSERT ... (col) VALUES, per ANSI
335,
336d335
< * Have SERIAL generate non-colliding sequence names when we have
< auto-destruction
Bruce Momjian [Mon, 2 Sep 2002 16:14:01 +0000 (16:14 +0000)]
Add check for Ant version >= 1.5.
Bruce Momjian [Mon, 2 Sep 2002 15:30:50 +0000 (15:30 +0000)]
Updates from Tom:
< * Allow logging of query durations
> * -Allow logging of query durations
51,52d50
< * Make single-user local access permissions the default by limiting
< permissions on the socket file (Peter E)
72,73c70,71
< * Reserve last few process slots for super-user if max_connections reached
< * Add GUC parameter to print queries that generate errors
> * -Reserve last few process slots for super-user if max_connections reached
> * -Add GUC parameter to print queries that generate errors
82,83c80,81
< * Declare typein/out functions in pg_proc with a special "C string" data type
< * Functions returning sets do not totally work
> * -Declare typein/out functions in pg_proc with a special "C string" data type
> * -Functions returning sets do not totally work
90c88
< * Allow bytea to handle LIKE with non-TEXT patterns
> * -Allow bytea to handle LIKE with non-TEXT patterns
94c92
< o Store binary-compatible type information in the system
> o -Store binary-compatible type information in the system
97d94
< o -SELECT col FROM tab WHERE numeric_col = 10.1 fails, requires quotes
102c99
< o Ensure we have array-eq operators for every built-in array type
> o -Ensure we have array-eq operators for every built-in array type
119d115
< * Allow setting database character set without multibyte enabled
152d147
< * Have UPDATE/DELETE clean out indexes
198,
199d192
< o ALTER TABLE ADD COLUMN to inherited table put column in wrong place
< [inheritance]
201d193
< o Add ALTER FUNCTION
203,
204c195,196
< o -ALTER TABLE ADD PRIMARY KEY (Tom)
< o -ALTER TABLE ADD UNIQUE (Tom)
> o -ALTER TABLE ADD PRIMARY KEY (Christopher)
> o -ALTER TABLE ADD UNIQUE (Christopher)
248c240
< o -Remove SET KSQO option now that OR processing is improved (Tom)
> o -Remove SET KSQO option now that OR processing is improved (Bruce)
280c272
< * Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs
> * -Have pg_dump use LEFT OUTER JOIN in multi-table SELECTs
287d278
< * Add config file check for $ODBCINI, $HOME/.odbc.ini, installpath/etc/odbc.ini
318,
322d308
< * ODBC
< o ODBC 3.0 support
< o Unicode(UCS-2) support
< o Updatable cursors support
<
337c323
< * Fix foreign key constraints to not error on intermediate db states (Stephan)
> * -Fix foreign key constraints to not error on intermediate db states (Stephan)
352c338
< * Propagate column or table renaming to foreign key constraints
> * -Propagate column or table renaming to foreign key constraints
447c433
< * Remove wal_files postgresql.conf option because WAL files are now recycled
> * -Remove wal_files postgresql.conf option because WAL files are now recycled
460c446
< * Improve dynamic memory allocation by introducing tuple-context memory
> * -Improve dynamic memory allocation by introducing tuple-context memory
463c449
< * Nested FULL OUTER JOINs don't work (Tom)
> * -Nested FULL OUTER JOINs don't work (Tom)
Tom Lane [Mon, 2 Sep 2002 14:43:14 +0000 (14:43 +0000)]
Fix breakage introduced by evidently-completely-untested snprintf patch.
Tom Lane [Mon, 2 Sep 2002 13:45:30 +0000 (13:45 +0000)]
Fix broken markup.
Tatsuo Ishii [Mon, 2 Sep 2002 13:27:20 +0000 (13:27 +0000)]
Fix conversion regressin test failure.
Bruce Momjian [Mon, 2 Sep 2002 06:44:22 +0000 (06:44 +0000)]
Done:
> * -Add OR REPLACE clauses to non-FUNCTION object creation
> * -Allow autocommit so always in a transaction block
> * -Cache most recent query plan(s) (Neil) [prepare]
Bruce Momjian [Mon, 2 Sep 2002 06:32:41 +0000 (06:32 +0000)]
Add missing dblink files.
Bruce Momjian [Mon, 2 Sep 2002 06:28:06 +0000 (06:28 +0000)]
Fixes for intagg regression tests to match new array internal handling.
mlw
Bruce Momjian [Mon, 2 Sep 2002 06:27:04 +0000 (06:27 +0000)]
In case Florian and I don't finish his changes to this contrib before
beta, at least get this stuff in.
ftipatch.txt - Updates to docs and scripts. Run in the fulltextindexdir
WARNING - Add to fulltextindex dir
uninstall.sql - Add to fulltextindex dir