]> granicus.if.org Git - postgresql/log
postgresql
22 years agoAdd:
Bruce Momjian [Sat, 2 Nov 2002 05:42:01 +0000 (05:42 +0000)]
Add:

> * Acquire lock on a relation before building a relcache entry for it

22 years agoUpdate:
Bruce Momjian [Sat, 2 Nov 2002 02:44:16 +0000 (02:44 +0000)]
Update:

>  o MOVE 0 should not move to end of cursor (Bruce)

22 years agoAdd:
Bruce Momjian [Sat, 2 Nov 2002 02:43:03 +0000 (02:43 +0000)]
Add:

> * Support statement-level triggers and triggers on columns (Neil)

22 years agoFix permissions-checking bugs and namespace-search-path bugs in
Tom Lane [Sat, 2 Nov 2002 02:33:03 +0000 (02:33 +0000)]
Fix permissions-checking bugs and namespace-search-path bugs in
CONVERSION code.  Still need to figure out what to do about inappropriate
coding in parsing.

22 years agoAdd gcj discussion.
Bruce Momjian [Sat, 2 Nov 2002 02:27:49 +0000 (02:27 +0000)]
Add gcj discussion.

22 years agoRe-add Win32 missing files, I think.
Bruce Momjian [Sat, 2 Nov 2002 02:00:35 +0000 (02:00 +0000)]
Re-add Win32 missing files, I think.

22 years agoRe-add Win32 files.
Bruce Momjian [Sat, 2 Nov 2002 01:58:27 +0000 (01:58 +0000)]
Re-add Win32 files.

22 years agoUpdate port list.
Bruce Momjian [Sat, 2 Nov 2002 01:29:37 +0000 (01:29 +0000)]
Update port list.

22 years agoUpdates from Giles Lean.
Tom Lane [Sat, 2 Nov 2002 00:46:23 +0000 (00:46 +0000)]
Updates from Giles Lean.

22 years agoMake it possible to run 'make installcheck' in contrib when building
Tom Lane [Sat, 2 Nov 2002 00:16:21 +0000 (00:16 +0000)]
Make it possible to run 'make installcheck' in contrib when building
outside the source tree.

22 years agoAdd:
Bruce Momjian [Sat, 2 Nov 2002 00:15:38 +0000 (00:15 +0000)]
Add:

> * Allow psql to do table completion for SELECT * FROM schema_part and
>   table completion for SELECT * FROM schema_name.

22 years agoFix contrib/rserv to install successfully when built outside source tree.
Tom Lane [Fri, 1 Nov 2002 23:45:37 +0000 (23:45 +0000)]
Fix contrib/rserv to install successfully when built outside source tree.
(Not that it will actually work with 7.3, I fear.)

22 years agoOoops, forgot to fix contrib regression tests for WARNING/NOTICE change.
Tom Lane [Fri, 1 Nov 2002 23:44:34 +0000 (23:44 +0000)]
Ooops, forgot to fix contrib regression tests for WARNING/NOTICE change.

22 years agoNeed -I. to build outside source tree.
Tom Lane [Fri, 1 Nov 2002 23:23:29 +0000 (23:23 +0000)]
Need -I. to build outside source tree.

22 years agoFix incorrect subdir value.
Tom Lane [Fri, 1 Nov 2002 23:16:52 +0000 (23:16 +0000)]
Fix incorrect subdir value.

22 years agoAdd:
Bruce Momjian [Fri, 1 Nov 2002 22:53:05 +0000 (22:53 +0000)]
Add:

> * Have standalone backend read postgresql.conf

22 years agoArrange to compile flex output files as inclusions into other files
Tom Lane [Fri, 1 Nov 2002 22:52:34 +0000 (22:52 +0000)]
Arrange to compile flex output files as inclusions into other files
(usually bison output files), not as standalone files.  This hack
works around flex's insistence on including <stdio.h> before we are
able to include postgres.h; postgres.h will already be read before
the compiler starts to read the flex output file.  Needed for largefile
support on some platforms.

22 years agoOoops, forgot to fix contrib regression tests for WARNING/NOTICE change.
Tom Lane [Fri, 1 Nov 2002 22:46:04 +0000 (22:46 +0000)]
Ooops, forgot to fix contrib regression tests for WARNING/NOTICE change.

22 years agoReduce a couple of debugging messages from LOG to DEBUG1 category.
Tom Lane [Fri, 1 Nov 2002 19:33:09 +0000 (19:33 +0000)]
Reduce a couple of debugging messages from LOG to DEBUG1 category.

22 years agoReduce messages associated with shell-type function arguments/results
Tom Lane [Fri, 1 Nov 2002 19:19:58 +0000 (19:19 +0000)]
Reduce messages associated with shell-type function arguments/results
from WARNING to NOTICE, since they are expected messages in common cases.

22 years agoUpdate to match expected results on OS X 10.2.
Tom Lane [Fri, 1 Nov 2002 18:15:34 +0000 (18:15 +0000)]
Update to match expected results on OS X 10.2.

22 years agoAfter elog(PANIC), exit with abort() not proc_exit(). This allows a
Tom Lane [Fri, 1 Nov 2002 17:55:23 +0000 (17:55 +0000)]
After elog(PANIC), exit with abort() not proc_exit().  This allows a
core file to be produced for debugging, and avoids trying to run the
normal proc-exit cleanup hooks, which are likely to cause additional
problems if the system is hosed.

22 years agoCorrect ordering of geometry/freebsd entries, add one for freebsd5.
Tom Lane [Fri, 1 Nov 2002 16:32:32 +0000 (16:32 +0000)]
Correct ordering of geometry/freebsd entries, add one for freebsd5.

22 years agoUpdate for test changes.
Tom Lane [Fri, 1 Nov 2002 15:20:09 +0000 (15:20 +0000)]
Update for test changes.

22 years agoAvoid malloc(0) when printing a table of no columns. On some platforms
Tom Lane [Fri, 1 Nov 2002 15:12:19 +0000 (15:12 +0000)]
Avoid malloc(0) when printing a table of no columns.  On some platforms
this returns NULL, which confuses the code.

22 years agoFix some bogus comments.
Tom Lane [Fri, 1 Nov 2002 00:40:23 +0000 (00:40 +0000)]
Fix some bogus comments.

22 years agoAdd missing #include <errno.h>, per gripe from Alessio Bragadini.
Tom Lane [Thu, 31 Oct 2002 22:37:19 +0000 (22:37 +0000)]
Add missing #include <errno.h>, per gripe from Alessio Bragadini.

22 years agoUpdate description of timestamp types for 7.3 implementation.
Tom Lane [Thu, 31 Oct 2002 22:18:42 +0000 (22:18 +0000)]
Update description of timestamp types for 7.3 implementation.

22 years agoGot tired of explaining why this Assert is not wrong.
Tom Lane [Thu, 31 Oct 2002 21:59:32 +0000 (21:59 +0000)]
Got tired of explaining why this Assert is not wrong.

22 years agoCode review for statement_timeout patch. Fix some race conditions
Tom Lane [Thu, 31 Oct 2002 21:34:17 +0000 (21:34 +0000)]
Code review for statement_timeout patch.  Fix some race conditions
between signal handler and enable/disable code, avoid accumulation of
timing error due to trying to maintain remaining-time instead of
absolute-end-time, disable timeout before commit not after.

22 years agoFix miscalculation of remaining free space during tuple chain moving.
Tom Lane [Thu, 31 Oct 2002 19:25:29 +0000 (19:25 +0000)]
Fix miscalculation of remaining free space during tuple chain moving.
Only affects machines where MAXALIGN > 4, and is a boundary-condition
case even there, but still surprising that it's not been identified
before.  Also reduce tuple chain move give-up messages from WARNING
to DEBUG1, since they are not unexpected conditions.

22 years agoAvoid use of inline functions that are not declared static. Needed to
Tom Lane [Thu, 31 Oct 2002 19:11:48 +0000 (19:11 +0000)]
Avoid use of inline functions that are not declared static.  Needed to
conform to C99's brain-dead notion of how inline functions should work.

22 years agoClean up gram.y trailing spaces.
Bruce Momjian [Thu, 31 Oct 2002 02:31:00 +0000 (02:31 +0000)]
Clean up gram.y trailing spaces.

22 years agoAdd mention of T on .pot files, from pkuczynski@hypode.pl
Bruce Momjian [Wed, 30 Oct 2002 05:14:32 +0000 (05:14 +0000)]
Add mention of T on .pot files, from pkuczynski@hypode.pl

22 years agoReturn something meaningful for Statement.getFetchSize(). Previously we were
Barry Lind [Wed, 30 Oct 2002 04:33:29 +0000 (04:33 +0000)]
Return something meaningful for Statement.getFetchSize().  Previously we were
returning an exception when this method was called.

Modified Files:
jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java

22 years agoClean up Unixware entry for Larry Rosenman
Bruce Momjian [Wed, 30 Oct 2002 03:00:53 +0000 (03:00 +0000)]
Clean up Unixware entry for Larry Rosenman

22 years agoAdd additional ORDER BY to join regression test, per Tatsuo.
Bruce Momjian [Wed, 30 Oct 2002 01:28:12 +0000 (01:28 +0000)]
Add additional ORDER BY to join regression test, per Tatsuo.

22 years agoRemove /src/utils. Is final cleanup of getopt.c resurection.
Bruce Momjian [Wed, 30 Oct 2002 01:15:51 +0000 (01:15 +0000)]
Remove /src/utils.  Is final cleanup of getopt.c resurection.

22 years agoAdd popen/pclose -> _popen/_pclose() mapping for Win32.
Bruce Momjian [Tue, 29 Oct 2002 19:35:33 +0000 (19:35 +0000)]
Add popen/pclose -> _popen/_pclose() mapping for Win32.

22 years agoUpdate ports list.
Bruce Momjian [Tue, 29 Oct 2002 19:09:41 +0000 (19:09 +0000)]
Update ports list.

22 years agoUpdate ports list.
Bruce Momjian [Tue, 29 Oct 2002 18:59:38 +0000 (18:59 +0000)]
Update ports list.

22 years agoUpdate ports list.
Bruce Momjian [Tue, 29 Oct 2002 18:13:28 +0000 (18:13 +0000)]
Update ports list.

22 years agoUpdate comments.
Bruce Momjian [Tue, 29 Oct 2002 04:24:30 +0000 (04:24 +0000)]
Update comments.

22 years agogetopt.c now in /port, for MS Win.
Bruce Momjian [Tue, 29 Oct 2002 04:23:30 +0000 (04:23 +0000)]
getopt.c now in /port, for MS Win.

22 years agoRe-add getopt.c for MSWin psql.
Bruce Momjian [Tue, 29 Oct 2002 04:22:37 +0000 (04:22 +0000)]
Re-add getopt.c for MSWin psql.

22 years agoRe-add getopt.c.
Bruce Momjian [Tue, 29 Oct 2002 04:20:15 +0000 (04:20 +0000)]
Re-add getopt.c.

22 years agoClean up markup in ports list.
Bruce Momjian [Tue, 29 Oct 2002 03:56:51 +0000 (03:56 +0000)]
Clean up markup in ports list.

22 years agoUpdate ports list.
Bruce Momjian [Tue, 29 Oct 2002 03:47:41 +0000 (03:47 +0000)]
Update ports list.

22 years agoUpdate regression for FreeBSD 4.7, for Larry Rosenman
Bruce Momjian [Tue, 29 Oct 2002 03:44:22 +0000 (03:44 +0000)]
Update regression for FreeBSD 4.7, for Larry Rosenman

22 years agoUpdate Giles email address.
Bruce Momjian [Tue, 29 Oct 2002 03:29:42 +0000 (03:29 +0000)]
Update Giles email address.

22 years agoReword:
Bruce Momjian [Tue, 29 Oct 2002 03:22:43 +0000 (03:22 +0000)]
Reword:

< * Improve concurrency in GIST
> * Add concurrency to GIST

22 years agoUpdate port list.
Bruce Momjian [Tue, 29 Oct 2002 03:07:11 +0000 (03:07 +0000)]
Update port list.

22 years agoUpdate port list.
Bruce Momjian [Tue, 29 Oct 2002 02:57:28 +0000 (02:57 +0000)]
Update port list.

22 years agoDone:
Bruce Momjian [Tue, 29 Oct 2002 02:50:11 +0000 (02:50 +0000)]
Done:

> * -Prevent aggregates from being used in rule WHERE clauses

22 years agoUpdate port list.
Bruce Momjian [Tue, 29 Oct 2002 02:38:37 +0000 (02:38 +0000)]
Update port list.

22 years agoUpdate port list.
Bruce Momjian [Tue, 29 Oct 2002 02:36:55 +0000 (02:36 +0000)]
Update port list.

22 years agoAdd ORDER BY to join regression test.
Bruce Momjian [Mon, 28 Oct 2002 22:54:45 +0000 (22:54 +0000)]
Add ORDER BY to join regression test.

22 years agoUpdate from Neil Conway:
Bruce Momjian [Mon, 28 Oct 2002 20:05:18 +0000 (20:05 +0000)]
Update from Neil Conway:

< * Add floor(float8) and other missing functions
> * -Add floor(float8) and other missing functions
174c174
< * Improve concurrency of hash indexes (Neil Conway)
> * Improve concurrency of hash indexes (Neil)
277c277
<  o Allow array declarations and other data types in PL/PgSQl DECLARE
>  o Allow array declarations and other data types in PL/PgSQL DECLARE
293c293
< * -Have pg_dump use ADD PRIMARY KEY after COPY, for performance (Neil Conway)
> * -Have pg_dump use ADD PRIMARY KEY after COPY, for performance (Neil)
474c474
< * Precompile SQL functions to avoid overhead (Neil Conway)
> * Precompile SQL functions to avoid overhead (Neil)
549c549
< * Neil is Neil Conway <nconway@klamath.dyndns.org>
> * Neil is Neil Conway <neilc@samurai.com>

22 years agofseeko NetBSD fix.
Bruce Momjian [Mon, 28 Oct 2002 00:00:25 +0000 (00:00 +0000)]
fseeko NetBSD fix.

22 years agoUpdate ports list.
Bruce Momjian [Sun, 27 Oct 2002 23:50:05 +0000 (23:50 +0000)]
Update ports list.

22 years agoSuppress compile warnings on OS X.
Tom Lane [Sun, 27 Oct 2002 02:52:10 +0000 (02:52 +0000)]
Suppress compile warnings on OS X.

22 years agoUpdate ports.
Bruce Momjian [Sat, 26 Oct 2002 20:45:40 +0000 (20:45 +0000)]
Update ports.

22 years agoUpdate ports list.
Bruce Momjian [Sat, 26 Oct 2002 20:15:42 +0000 (20:15 +0000)]
Update ports list.

22 years agoUpdate port list.
Bruce Momjian [Sat, 26 Oct 2002 20:12:25 +0000 (20:12 +0000)]
Update port list.

22 years agoUpdate ports.
Bruce Momjian [Sat, 26 Oct 2002 20:04:55 +0000 (20:04 +0000)]
Update ports.

22 years agoAdd missing semicolons to a few PG_FUNCTION_INFO_V1 calls.
Tom Lane [Sat, 26 Oct 2002 15:01:01 +0000 (15:01 +0000)]
Add missing semicolons to a few PG_FUNCTION_INFO_V1 calls.

22 years agoUpdate BSD/OS as supported platform.
Bruce Momjian [Sat, 26 Oct 2002 02:17:05 +0000 (02:17 +0000)]
Update BSD/OS as supported platform.

22 years agoAdd dummy variable declaration to PG_FUNCTION_INFO_V1() to prevent
Tom Lane [Fri, 25 Oct 2002 22:17:32 +0000 (22:17 +0000)]
Add dummy variable declaration to PG_FUNCTION_INFO_V1() to prevent
'empty declaration' warnings from compilers that care about such things.
Per discussion back before 7.2 release; we didn't do it then because
we'd already missed all the beta cycle ...

22 years agoRemove #warning directive, which is nonstandard and isn't really
Tom Lane [Fri, 25 Oct 2002 22:08:44 +0000 (22:08 +0000)]
Remove #warning directive, which is nonstandard and isn't really
buying us anything to make it worth the porting risk.  Per discussion
quite some time ago.

22 years agoAdd:
Bruce Momjian [Fri, 25 Oct 2002 19:03:04 +0000 (19:03 +0000)]
Add:

> * Allow limits on per-db/user connections

22 years agoChange to fseeko(), per Philip.
Bruce Momjian [Fri, 25 Oct 2002 03:47:30 +0000 (03:47 +0000)]
Change to fseeko(), per Philip.

22 years agoPatch submitted by Kris Jurka to fix arrayindexoutofbounds exception caused
Barry Lind [Fri, 25 Oct 2002 02:54:37 +0000 (02:54 +0000)]
Patch submitted by Kris Jurka to fix arrayindexoutofbounds exception caused
by improper array initialization.

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

22 years agoAllow fseeko in pg_dump only if fseeko() will work for all supported file
Bruce Momjian [Fri, 25 Oct 2002 01:33:17 +0000 (01:33 +0000)]
Allow fseeko in pg_dump only if fseeko() will work for all supported file
sizes.

22 years agoCode review for connection timeout patch. Avoid unportable assumption
Tom Lane [Thu, 24 Oct 2002 23:35:55 +0000 (23:35 +0000)]
Code review for connection timeout patch.  Avoid unportable assumption
that tv_sec is signed; return a useful error message on timeout failure;
honor PGCONNECT_TIMEOUT environment variable in PQsetdbLogin; make code
obey documentation statement that timeout=0 means no timeout.

22 years agoFix some places that were unportably assuming struct timeval's tv_sec
Tom Lane [Thu, 24 Oct 2002 23:19:13 +0000 (23:19 +0000)]
Fix some places that were unportably assuming struct timeval's tv_sec
field is signed.  Clean up casting.

22 years agoFunction-call-style type coercions should be treated as explicit
Tom Lane [Thu, 24 Oct 2002 22:09:00 +0000 (22:09 +0000)]
Function-call-style type coercions should be treated as explicit
coercions, not implicit ones.  For example, 'select abstime(1035497293)'
should succeed because there is an explicit binary coercion from int4
to abstime.

22 years agoAdd note about sort order of character datatypes being locale-dependent,
Tom Lane [Thu, 24 Oct 2002 21:19:15 +0000 (21:19 +0000)]
Add note about sort order of character datatypes being locale-dependent,
per suggestion from Nicolaus Erichsen.

22 years agoMake link to schema inspection functions more clear.
Tom Lane [Thu, 24 Oct 2002 21:10:58 +0000 (21:10 +0000)]
Make link to schema inspection functions more clear.

22 years agoAdd introductory sections explaining what each book is about. Remove Y2K
Peter Eisentraut [Thu, 24 Oct 2002 17:48:54 +0000 (17:48 +0000)]
Add introductory sections explaining what each book is about.  Remove Y2K
statement.

22 years agoFix include for NetBSD.
Bruce Momjian [Thu, 24 Oct 2002 04:48:08 +0000 (04:48 +0000)]
Fix include for NetBSD.

22 years agoAdd prototype include to fseeko.c.
Bruce Momjian [Thu, 24 Oct 2002 04:33:46 +0000 (04:33 +0000)]
Add prototype include to fseeko.c.

22 years agoAdd fseeko for NetBSD.
Bruce Momjian [Thu, 24 Oct 2002 03:11:05 +0000 (03:11 +0000)]
Add fseeko for NetBSD.

22 years agoStamp for 7.3 beta3.
Bruce Momjian [Thu, 24 Oct 2002 03:03:37 +0000 (03:03 +0000)]
Stamp for 7.3 beta3.

22 years agoFix include files for new PageOutput call.
Bruce Momjian [Thu, 24 Oct 2002 01:33:50 +0000 (01:33 +0000)]
Fix include files for new PageOutput call.

22 years agoAdd fseeko/ftello prototypes for BSD/OS only to c.h.
Bruce Momjian [Wed, 23 Oct 2002 23:37:47 +0000 (23:37 +0000)]
Add fseeko/ftello prototypes for BSD/OS only to c.h.

22 years agoAdd mention of postgres signals to reference page
Bruce Momjian [Wed, 23 Oct 2002 23:33:08 +0000 (23:33 +0000)]
Add mention of postgres signals to reference page

Joseph Shraibman

22 years agoImprove coding style of new function.
Bruce Momjian [Wed, 23 Oct 2002 21:39:27 +0000 (21:39 +0000)]
Improve coding style of new function.

22 years agoMake BSD/OS fseeko thread-safe.
Bruce Momjian [Wed, 23 Oct 2002 21:16:17 +0000 (21:16 +0000)]
Make BSD/OS fseeko thread-safe.

22 years agoAdd comments on bsd/os handling.
Bruce Momjian [Wed, 23 Oct 2002 20:59:03 +0000 (20:59 +0000)]
Add comments on bsd/os handling.

22 years agoAdd fseeko/ftello using fsetpos/fgetpos for BSD/OS.
Bruce Momjian [Wed, 23 Oct 2002 20:56:24 +0000 (20:56 +0000)]
Add fseeko/ftello using fsetpos/fgetpos for BSD/OS.

22 years agoPage \h output and centralize psql paging code in PageOutput().
Bruce Momjian [Wed, 23 Oct 2002 19:23:57 +0000 (19:23 +0000)]
Page \h output and centralize psql paging code in PageOutput().

22 years agoPerform transaction cleanup operations in a less ad-hoc, more
Tom Lane [Tue, 22 Oct 2002 22:44:36 +0000 (22:44 +0000)]
Perform transaction cleanup operations in a less ad-hoc, more
principled order; in particular ensure that all shared resources
are released before we release transaction locks.  The code used
to release locks before buffer pins, which might explain an ancient
note I have about a bufmgr assertion failure I'd seen once several
years ago, and been unable to reproduce since.  (Theory: someone
trying to drop a relation might be able to reach FlushRelationBuffers
before the last user of the relation had gotten around to dropping
his buffer pins.)

22 years agoUpdated German FAQ, from Ian Barwick
Bruce Momjian [Tue, 22 Oct 2002 21:44:51 +0000 (21:44 +0000)]
Updated German FAQ, from Ian Barwick

22 years agocreate_index test must run after create_misc test.
Tom Lane [Tue, 22 Oct 2002 20:20:10 +0000 (20:20 +0000)]
create_index test must run after create_misc test.

22 years agoUpdate build system.
Peter Eisentraut [Tue, 22 Oct 2002 20:03:09 +0000 (20:03 +0000)]
Update build system.

22 years agoUpdate for test changes.
Peter Eisentraut [Tue, 22 Oct 2002 20:01:15 +0000 (20:01 +0000)]
Update for test changes.

22 years agoAdd DLLIMPORT declarations required by contrib with asserts enabled.
Peter Eisentraut [Tue, 22 Oct 2002 20:00:48 +0000 (20:00 +0000)]
Add DLLIMPORT declarations required by contrib with asserts enabled.

22 years agoAllow 8-byte off_t to properly pg_dump, from Philip Warner with mods by Bruce.
Bruce Momjian [Tue, 22 Oct 2002 19:15:23 +0000 (19:15 +0000)]
Allow 8-byte off_t to properly pg_dump, from Philip Warner with mods by Bruce.

22 years agoSpecify that we need bison >= 1.50.
Tom Lane [Tue, 22 Oct 2002 13:46:59 +0000 (13:46 +0000)]
Specify that we need bison >= 1.50.

22 years agoMove libpgeasy.sgml to gborg.
Bruce Momjian [Mon, 21 Oct 2002 23:14:10 +0000 (23:14 +0000)]
Move libpgeasy.sgml to gborg.