OSDN Git Service
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.
Tom Lane [Fri, 1 Nov 2002 00:40:23 +0000 (00:40 +0000)]
Fix some bogus comments.
Tom Lane [Thu, 31 Oct 2002 22:37:19 +0000 (22:37 +0000)]
Add missing #include <errno.h>, per gripe from Alessio Bragadini.
Tom Lane [Thu, 31 Oct 2002 22:18:42 +0000 (22:18 +0000)]
Update description of timestamp types for 7.3 implementation.
Tom Lane [Thu, 31 Oct 2002 21:59:32 +0000 (21:59 +0000)]
Got tired of explaining why this Assert is not wrong.
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.
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.
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.
Bruce Momjian [Thu, 31 Oct 2002 02:31:00 +0000 (02:31 +0000)]
Clean up gram.y trailing spaces.
Bruce Momjian [Wed, 30 Oct 2002 05:14:32 +0000 (05:14 +0000)]
Add mention of T on .pot files, from pkuczynski@hypode.pl
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
Bruce Momjian [Wed, 30 Oct 2002 03:00:53 +0000 (03:00 +0000)]
Clean up Unixware entry for Larry Rosenman
Bruce Momjian [Wed, 30 Oct 2002 01:28:12 +0000 (01:28 +0000)]
Add additional ORDER BY to join regression test, per Tatsuo.
Bruce Momjian [Wed, 30 Oct 2002 01:15:51 +0000 (01:15 +0000)]
Remove /src/utils. Is final cleanup of getopt.c resurection.
Bruce Momjian [Tue, 29 Oct 2002 19:35:33 +0000 (19:35 +0000)]
Add popen/pclose -> _popen/_pclose() mapping for Win32.
Bruce Momjian [Tue, 29 Oct 2002 19:09:41 +0000 (19:09 +0000)]
Update ports list.
Bruce Momjian [Tue, 29 Oct 2002 18:59:38 +0000 (18:59 +0000)]
Update ports list.
Bruce Momjian [Tue, 29 Oct 2002 18:13:28 +0000 (18:13 +0000)]
Update ports list.
Bruce Momjian [Tue, 29 Oct 2002 04:24:30 +0000 (04:24 +0000)]
Update comments.
Bruce Momjian [Tue, 29 Oct 2002 04:23:30 +0000 (04:23 +0000)]
getopt.c now in /port, for MS Win.
Bruce Momjian [Tue, 29 Oct 2002 04:22:37 +0000 (04:22 +0000)]
Re-add getopt.c for MSWin psql.
Bruce Momjian [Tue, 29 Oct 2002 04:20:15 +0000 (04:20 +0000)]
Re-add getopt.c.
Bruce Momjian [Tue, 29 Oct 2002 03:56:51 +0000 (03:56 +0000)]
Clean up markup in ports list.
Bruce Momjian [Tue, 29 Oct 2002 03:47:41 +0000 (03:47 +0000)]
Update ports list.
Bruce Momjian [Tue, 29 Oct 2002 03:44:22 +0000 (03:44 +0000)]
Update regression for FreeBSD 4.7, for Larry Rosenman
Bruce Momjian [Tue, 29 Oct 2002 03:29:42 +0000 (03:29 +0000)]
Update Giles email address.
Bruce Momjian [Tue, 29 Oct 2002 03:22:43 +0000 (03:22 +0000)]
Reword:
< * Improve concurrency in GIST
> * Add concurrency to GIST
Bruce Momjian [Tue, 29 Oct 2002 03:07:11 +0000 (03:07 +0000)]
Update port list.
Bruce Momjian [Tue, 29 Oct 2002 02:57:28 +0000 (02:57 +0000)]
Update port list.
Bruce Momjian [Tue, 29 Oct 2002 02:50:11 +0000 (02:50 +0000)]
Done:
> * -Prevent aggregates from being used in rule WHERE clauses
Bruce Momjian [Tue, 29 Oct 2002 02:38:37 +0000 (02:38 +0000)]
Update port list.
Bruce Momjian [Tue, 29 Oct 2002 02:36:55 +0000 (02:36 +0000)]
Update port list.
Bruce Momjian [Mon, 28 Oct 2002 22:54:45 +0000 (22:54 +0000)]
Add ORDER BY to join regression test.
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>
Bruce Momjian [Mon, 28 Oct 2002 00:00:25 +0000 (00:00 +0000)]
fseeko NetBSD fix.
Bruce Momjian [Sun, 27 Oct 2002 23:50:05 +0000 (23:50 +0000)]
Update ports list.
Tom Lane [Sun, 27 Oct 2002 02:52:10 +0000 (02:52 +0000)]
Suppress compile warnings on OS X.
Bruce Momjian [Sat, 26 Oct 2002 20:45:40 +0000 (20:45 +0000)]
Update ports.
Bruce Momjian [Sat, 26 Oct 2002 20:15:42 +0000 (20:15 +0000)]
Update ports list.
Bruce Momjian [Sat, 26 Oct 2002 20:12:25 +0000 (20:12 +0000)]
Update port list.
Bruce Momjian [Sat, 26 Oct 2002 20:04:55 +0000 (20:04 +0000)]
Update ports.
Tom Lane [Sat, 26 Oct 2002 15:01:01 +0000 (15:01 +0000)]
Add missing semicolons to a few PG_FUNCTION_INFO_V1 calls.
Bruce Momjian [Sat, 26 Oct 2002 02:17:05 +0000 (02:17 +0000)]
Update BSD/OS as supported platform.
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 ...
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.
Bruce Momjian [Fri, 25 Oct 2002 19:03:04 +0000 (19:03 +0000)]
Add:
> * Allow limits on per-db/user connections
Bruce Momjian [Fri, 25 Oct 2002 03:47:30 +0000 (03:47 +0000)]
Change to fseeko(), per Philip.
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
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.
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.
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.
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.
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.
Tom Lane [Thu, 24 Oct 2002 21:10:58 +0000 (21:10 +0000)]
Make link to schema inspection functions more clear.
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.
Bruce Momjian [Thu, 24 Oct 2002 04:48:08 +0000 (04:48 +0000)]
Fix include for NetBSD.
Bruce Momjian [Thu, 24 Oct 2002 04:33:46 +0000 (04:33 +0000)]
Add prototype include to fseeko.c.
Bruce Momjian [Thu, 24 Oct 2002 03:11:05 +0000 (03:11 +0000)]
Add fseeko for NetBSD.
Bruce Momjian [Thu, 24 Oct 2002 03:03:37 +0000 (03:03 +0000)]
Stamp for 7.3 beta3.
Bruce Momjian [Thu, 24 Oct 2002 01:33:50 +0000 (01:33 +0000)]
Fix include files for new PageOutput call.
Bruce Momjian [Wed, 23 Oct 2002 23:37:47 +0000 (23:37 +0000)]
Add fseeko/ftello prototypes for BSD/OS only to c.h.
Bruce Momjian [Wed, 23 Oct 2002 23:33:08 +0000 (23:33 +0000)]
Add mention of postgres signals to reference page
Joseph Shraibman
Bruce Momjian [Wed, 23 Oct 2002 21:39:27 +0000 (21:39 +0000)]
Improve coding style of new function.
Bruce Momjian [Wed, 23 Oct 2002 21:16:17 +0000 (21:16 +0000)]
Make BSD/OS fseeko thread-safe.
Bruce Momjian [Wed, 23 Oct 2002 20:59:03 +0000 (20:59 +0000)]
Add comments on bsd/os handling.
Bruce Momjian [Wed, 23 Oct 2002 20:56:24 +0000 (20:56 +0000)]
Add fseeko/ftello using fsetpos/fgetpos for BSD/OS.
Bruce Momjian [Wed, 23 Oct 2002 19:23:57 +0000 (19:23 +0000)]
Page \h output and centralize psql paging code in PageOutput().
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.)
Bruce Momjian [Tue, 22 Oct 2002 21:44:51 +0000 (21:44 +0000)]
Updated German FAQ, from Ian Barwick
Tom Lane [Tue, 22 Oct 2002 20:20:10 +0000 (20:20 +0000)]
create_index test must run after create_misc test.
Peter Eisentraut [Tue, 22 Oct 2002 20:03:09 +0000 (20:03 +0000)]
Update build system.
Peter Eisentraut [Tue, 22 Oct 2002 20:01:15 +0000 (20:01 +0000)]
Update for test changes.
Peter Eisentraut [Tue, 22 Oct 2002 20:00:48 +0000 (20:00 +0000)]
Add DLLIMPORT declarations required by contrib with asserts enabled.
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.
Tom Lane [Tue, 22 Oct 2002 13:46:59 +0000 (13:46 +0000)]
Specify that we need bison >= 1.50.
Bruce Momjian [Mon, 21 Oct 2002 23:14:10 +0000 (23:14 +0000)]
Move libpgeasy.sgml to gborg.
Bruce Momjian [Mon, 21 Oct 2002 23:10:09 +0000 (23:10 +0000)]
Move odbc.sgml to gborg ODBC project.
Tom Lane [Mon, 21 Oct 2002 22:06:20 +0000 (22:06 +0000)]
Fix places that were using IsTransactionBlock() as an (inadequate) check
that they'd get to commit immediately on finishing. There's now a
centralized routine PreventTransactionChain() that implements the
necessary tests.
Bruce Momjian [Mon, 21 Oct 2002 20:35:07 +0000 (20:35 +0000)]
Add:
> * Allow pg_dump to dump a specific schema
Bruce Momjian [Mon, 21 Oct 2002 20:34:09 +0000 (20:34 +0000)]
Small update for the removal of some memory leaks in plpython SGML example.
Nigel J. Andrews
Bruce Momjian [Mon, 21 Oct 2002 20:33:21 +0000 (20:33 +0000)]
When I removed the cube based stuff from eathdistance I accidentally
left a reference to cube in a comment in the regression test (that also
shows up in the expected output). This doesn't cause any real problem,
but people who read the comment might be confused. Attached is a diff to
remove the reference.
Bruno Wolff III
Bruce Momjian [Mon, 21 Oct 2002 20:32:33 +0000 (20:32 +0000)]
Cleanup for CLUSTERDB failure:
On Sat, Oct 19, 2002 at 12:11:32AM +0200, Peter Eisentraut wrote:
> $ ./clusterdb
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> psql: could not connect to server: No such file or directory
> Is the server running locally and accepting
> connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
> clusterdb: While clustering peter, the following failed:
> $
>
> This could probably handled a little more gracefully.
Yes, sorry. A patch for this is attached. Please apply.
Alvaro Herrera
Bruce Momjian [Mon, 21 Oct 2002 20:31:52 +0000 (20:31 +0000)]
Fix ALTER TABLE ... ADD COLUMN for inheritance cases.
Alvaro Herrera
Tom Lane [Mon, 21 Oct 2002 19:59:14 +0000 (19:59 +0000)]
Remove unnecessary (and inadequate) check of IsTransactionBlock() in
pgstat_vacuum_tabstat(). Assume that caller (namely, VACUUM) has done
the appropriate state checking beforehand.
Tom Lane [Mon, 21 Oct 2002 19:55:49 +0000 (19:55 +0000)]
Avoid using IsTransactionBlock() in DeferredTriggerSetState(); no real
need for this optimization, and it's too easily fooled anyway.
Tom Lane [Mon, 21 Oct 2002 19:46:45 +0000 (19:46 +0000)]
Make CREATE/ALTER/DROP USER/GROUP transaction-safe, or at least pretty
nearly so, by postponing write of flat password file until transaction
commit.
Peter Eisentraut [Mon, 21 Oct 2002 18:57:35 +0000 (18:57 +0000)]
Add DLLIMPORT declarations needed by contrib modules.
Peter Eisentraut [Mon, 21 Oct 2002 18:56:30 +0000 (18:56 +0000)]
Need sys/param.h for endianness macros.
Peter Eisentraut [Mon, 21 Oct 2002 18:55:10 +0000 (18:55 +0000)]
Might need to link with -lcrypt.
Peter Eisentraut [Mon, 21 Oct 2002 18:53:20 +0000 (18:53 +0000)]
Add guards against double inclusion.
Peter Eisentraut [Mon, 21 Oct 2002 18:51:03 +0000 (18:51 +0000)]
Translation updates
Peter Eisentraut [Mon, 21 Oct 2002 18:05:24 +0000 (18:05 +0000)]
Remove obsoleted stuff merged in from branch.
Peter Eisentraut [Mon, 21 Oct 2002 18:04:05 +0000 (18:04 +0000)]
Improve ECPG documentation.
Michael Meskes [Mon, 21 Oct 2002 13:09:31 +0000 (13:09 +0000)]
Merged ecpg_big_bison back into HEAD
Tatsuo Ishii [Mon, 21 Oct 2002 05:14:06 +0000 (05:14 +0000)]
Update multibyte Japanese document
Tom Lane [Mon, 21 Oct 2002 04:33:39 +0000 (04:33 +0000)]
Since ANY is a reserved word, better suggest that ANY be quoted when
used for the input type of an aggregate.
Tom Lane [Mon, 21 Oct 2002 02:12:08 +0000 (02:12 +0000)]
Fix documented sizes of geometric types.
Tom Lane [Mon, 21 Oct 2002 02:11:37 +0000 (02:11 +0000)]
Fix example of doing a restore.
Bruce Momjian [Mon, 21 Oct 2002 01:42:14 +0000 (01:42 +0000)]
SET autocommit no longer needed in /contrib because pg_regress.sh does
it automatically now on regression session startup.
Bruce Momjian [Mon, 21 Oct 2002 00:47:44 +0000 (00:47 +0000)]
Updates from Ian Barwick.