OSDN Git Service
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.
Bruce Momjian [Mon, 21 Oct 2002 00:36:24 +0000 (00:36 +0000)]
Done:
> * -Move /contrib/retep to gborg.postgresql.org
Bruce Momjian [Mon, 21 Oct 2002 00:35:41 +0000 (00:35 +0000)]
Completely remove /contrib/retep, with Peter's approval; now on Source
Forge.
Bruce Momjian [Mon, 21 Oct 2002 00:12:46 +0000 (00:12 +0000)]
First step to removing /contrib/retep, with Peter Mount's approval.
Bruce Momjian [Sun, 20 Oct 2002 20:58:02 +0000 (20:58 +0000)]
Remove trailing blanks in cvs.sgml.
Tom Lane [Sun, 20 Oct 2002 20:47:31 +0000 (20:47 +0000)]
Fix potential problem with btbulkdelete deleting an indexscan's current
item, if the page containing the current item is split while the indexscan
is stopped and holds no read-lock on the page. The current item might
move right onto a page that the indexscan holds no pin on. In the prior
code this would allow btbulkdelete to reach and possibly delete the item,
causing 'my bits moved right off the end of the world!' when the indexscan
finally resumes. Fix by chaining read-locks to the right during
_bt_restscan and requiring btbulkdelete to LockBufferForCleanup on every
page it scans, not only those with deletable items. Per my pghackers
message of 25-May-02. (Too bad no one could think of a better way.)
Tom Lane [Sun, 20 Oct 2002 19:38:10 +0000 (19:38 +0000)]
Fix core dump recently introduced into pgbench.
Tatsuo Ishii [Sun, 20 Oct 2002 11:33:48 +0000 (11:33 +0000)]
Returns exit status 1 if invalid encoding name or
encoding number is given.
Tom Lane [Sun, 20 Oct 2002 05:05:46 +0000 (05:05 +0000)]
Update description of numeric constants to match 7.3 reality.
Miscellaneous other copy-editing.
Bruce Momjian [Sun, 20 Oct 2002 02:58:56 +0000 (02:58 +0000)]
Update char/varchar()/text/bytea to mention they have similar performance
characteristics.
Barry Lind [Sun, 20 Oct 2002 02:55:50 +0000 (02:55 +0000)]
Applied patch from Teofilis Martisius to improve performance.
Also removed some unused files and fixed the which needed a small change
after the previous patch to build.xml.
Modified Files:
jdbc/Makefile jdbc/org/postgresql/core/Encoding.java
jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
Removed Files:
jdbc/utils/CheckVersion.java jdbc/utils/buildDriver
jdbc/utils/changelog.pl
Bruce Momjian [Sun, 20 Oct 2002 02:51:21 +0000 (02:51 +0000)]
Add:
> * Make a transaction-safe TRUNCATE
Bruce Momjian [Sun, 20 Oct 2002 02:37:49 +0000 (02:37 +0000)]
Update Japanese FAQ, from Jun Kuwamura.
Bruce Momjian [Sun, 20 Oct 2002 02:30:04 +0000 (02:30 +0000)]
Add:
> o Add GUC parameter to control the maximum number of rewrite cycles
Tom Lane [Sun, 20 Oct 2002 01:43:32 +0000 (01:43 +0000)]
Add warning that autocommit=off is not well-supported yet.
Tom Lane [Sun, 20 Oct 2002 01:38:18 +0000 (01:38 +0000)]
Move BeOS and QNX4 to unsupported-platform list, until someone cares
to expend the effort to update them for new semaphore code.
Tom Lane [Sun, 20 Oct 2002 00:58:55 +0000 (00:58 +0000)]
Rule rewriter was doing the wrong thing with conditional INSTEAD rules
whose conditions might yield NULL. The negated qual to attach to the
original query is properly 'x IS NOT TRUE', not 'NOT x'. This fix
produces correct behavior, but we may be taking a performance hit because
the planner is much stupider about IS NOT TRUE than it is about NOT
clauses. Future TODO: teach prepqual, other parts of planner how to
cope with BooleanTest clauses more effectively.
Tom Lane [Sun, 20 Oct 2002 00:31:53 +0000 (00:31 +0000)]
Disallow aggregate functions in rule WHERE clauses. Per gripe from
Fritz Lehmann-Grube back in January.