]> granicus.if.org Git - postgresql/log
postgresql
22 years agoUpdate ports list.
Bruce Momjian [Mon, 4 Nov 2002 22:40:43 +0000 (22:40 +0000)]
Update ports list.

22 years agoBrand CVS tip as 7.4devel.
Tom Lane [Mon, 4 Nov 2002 21:36:13 +0000 (21:36 +0000)]
Brand CVS tip as 7.4devel.

22 years agoRemove extraneous semicolons after routine bodies. These don't bother
Tom Lane [Mon, 4 Nov 2002 17:14:29 +0000 (17:14 +0000)]
Remove extraneous semicolons after routine bodies.  These don't bother
gcc, but some other compilers don't like 'em.

22 years agoFix inclusion order, per Andreas.
Tom Lane [Mon, 4 Nov 2002 14:27:21 +0000 (14:27 +0000)]
Fix inclusion order, per Andreas.

22 years agoRemove unnecessary inclusion, per Andreas.
Tom Lane [Mon, 4 Nov 2002 14:25:42 +0000 (14:25 +0000)]
Remove unnecessary inclusion, per Andreas.

22 years agoRemove no-longer-needed inclusion of bootstrap_tokens.h, per patch
Tom Lane [Mon, 4 Nov 2002 14:22:32 +0000 (14:22 +0000)]
Remove no-longer-needed inclusion of bootstrap_tokens.h, per patch
from Andreas.

22 years agoApplied two patches from Kris Jurka.
Barry Lind [Mon, 4 Nov 2002 06:42:33 +0000 (06:42 +0000)]
Applied two patches from Kris Jurka.
  - First fixes a problem with a recent patch allowing setNull on updateable
    resultsets
  - Second removed toLower() calls on database object names.  Leave it to
    the caller to correctly pass lower, upper or mixed case.  The driver
    already has methods that the caller can use to determine that postgres
    stores identifiers in lowercase. (unless the identifier was quoted when
    created).

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

22 years agoFix dblink regression test so that it works when repeated: don't
Tom Lane [Sun, 3 Nov 2002 04:52:09 +0000 (04:52 +0000)]
Fix dblink regression test so that it works when repeated: don't
create a second database, just loop back to 'regression'.  Patch
from Joe Conway 10/22/02.

22 years agoUpdate FAQ_DEV.
Bruce Momjian [Sun, 3 Nov 2002 04:02:32 +0000 (04:02 +0000)]
Update FAQ_DEV.

22 years agoStamp beta4.
Bruce Momjian [Sun, 3 Nov 2002 01:35:06 +0000 (01:35 +0000)]
Stamp beta4.

22 years agoThis patch adds a couple of extra index entries and removes some
Bruce Momjian [Sun, 3 Nov 2002 01:31:32 +0000 (01:31 +0000)]
This patch adds a couple of extra index entries and removes some
out-of-date text about multibyte encoding (which is now always
included).

Oliver Elphick

22 years agoThis patch adds information to the documentation on .pgpass and creates
Bruce Momjian [Sun, 3 Nov 2002 01:30:46 +0000 (01:30 +0000)]
This patch adds information to the documentation on .pgpass and creates
additional index entries for it.

Oliver Elphick

22 years agoUse sed rather than perl for reindexdb.
Bruce Momjian [Sun, 3 Nov 2002 01:20:06 +0000 (01:20 +0000)]
Use sed rather than perl for reindexdb.

22 years agoFix some misstatements in WAL parameter discussion.
Tom Lane [Sat, 2 Nov 2002 22:23:01 +0000 (22:23 +0000)]
Fix some misstatements in WAL parameter discussion.

22 years agoCode review for recent patch to allow ALTER TABLE ADD COLUMN when
Tom Lane [Sat, 2 Nov 2002 22:02:08 +0000 (22:02 +0000)]
Code review for recent patch to allow ALTER TABLE ADD COLUMN when
a child table already has a matching column.  Acquire appropriate
lock on child table; do the right thing with any CHECK constraints
attached to the new parent column.

22 years agoDuring swap_relfilenodes, swap relation size statistic fields along with
Tom Lane [Sat, 2 Nov 2002 21:20:40 +0000 (21:20 +0000)]
During swap_relfilenodes, swap relation size statistic fields along with
the relfilenode and toast fields.  This ensures that the newly-computed
statistics will be available on completion of CLUSTER.

22 years agoRemove encoding lookups from grammar stage, push them back to places
Tom Lane [Sat, 2 Nov 2002 18:41:22 +0000 (18:41 +0000)]
Remove encoding lookups from grammar stage, push them back to places
where it's safe to do database access.  Along the way, fix core dump
for 'DEFAULT' parameters to CREATE DATABASE.  initdb forced due to
change in pg_proc entry.

22 years agoClean up a few fprintf(stderr)'s that should be elog's.
Tom Lane [Sat, 2 Nov 2002 15:54:13 +0000 (15:54 +0000)]
Clean up a few fprintf(stderr)'s that should be elog's.

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.