Tom Lane [Tue, 12 Feb 2002 21:25:41 +0000 (21:25 +0000)]
Modify COPY TO to emit carriage returns and newlines as backslash escapes
(backslash-r, backslash-n) for protection against newline-conversion
munging. In future we will also tweak COPY FROM, but this part of the
change should be backwards-compatible. Per pghackers discussion.
Also, update COPY reference page to describe the backslash conversions
more completely and accurately.
Tom Lane [Mon, 11 Feb 2002 22:41:59 +0000 (22:41 +0000)]
Tweak GiST code to work correctly on machines where 8-byte alignment
of pointers is required. Patch from Teodor Sigaev per pghackers
discussion. It's an ugly kluge but avoids forcing initdb; we'll put
a better fix into 7.3 or later.
Tom Lane [Mon, 11 Feb 2002 20:10:50 +0000 (20:10 +0000)]
Repair problems with EvalPlanQual where target table is scanned as
inner indexscan (ie, one with runtime keys). ExecIndexReScan must
compute or recompute runtime keys even if we are rescanning in the
EPQ case. TidScan seems to have comparable problems. Per bug
noted by Barry Lind 11-Feb-02.
Tom Lane [Mon, 11 Feb 2002 00:14:10 +0000 (00:14 +0000)]
pg_dump and pg_restore man pages need to mention that one should restore
into a virgin database, ie, one created from template0, if there are any
site-local additions in template1.
Tom Lane [Sun, 10 Feb 2002 22:56:31 +0000 (22:56 +0000)]
Don't Assert() that fsync() and close() never fail; I have seen this
crash on Solaris when over disk quota. Instead, report such failures
via elog(DEBUG).
Tom Lane [Fri, 25 Jan 2002 18:49:31 +0000 (18:49 +0000)]
Tweak pg_dump to say GRANT ALL when appropriate, rather than enumerating
the individual privilege bits. I regard this as an important change for
cross-version compatibility: without this, a 7.1 dump loaded into 7.2
is likely to be short a few privileges.
Bruce Momjian [Fri, 25 Jan 2002 01:04:47 +0000 (01:04 +0000)]
Add 128 mention:
> * Increase identifier length (NAMEDATALEN) if small performance hit,
> perhaps to standard length of 128; change struct pgNotify to use pid
> first, breaks notify API;
Tom Lane [Thu, 24 Jan 2002 19:31:36 +0000 (19:31 +0000)]
pltcl's spi_execp didn't handle NULL arguments quite correctly.
It would try to call the input conversion routines for them anyway.
So, a valid input string for the datatype had to be supplied.
Tom Lane [Thu, 24 Jan 2002 15:31:43 +0000 (15:31 +0000)]
Fix logic error in insert_fsm_page_entry: because compact_fsm_page_list
removes any empty chunks, the chunk previously added won't be there
anymore, so it's possible there is zero free space in the rel's page list
afterwards. Must loop back and rerun the part that adds a chunk to
the list.
Tom Lane [Wed, 23 Jan 2002 18:45:41 +0000 (18:45 +0000)]
Clean up Red Hat Tcl RPM brain-damage in a more reliable way: fix the
value of TCL_SHLIB_LD in the shell script that creates Makefile.tcldefs,
rather than trying to persude gmake to do it.
Bruce Momjian [Wed, 23 Jan 2002 16:14:04 +0000 (16:14 +0000)]
Add:
> * Reorder postgresql.conf WAL items in order of importance
> * Remove wal_files postgresql.conf option because WAL files are now recycled
> * Find proper defaults for postgresql.conf WAL entries
> * Add checkpoint_min_warning postgresql.conf option to warn about checkpoints
> that are too frequent
Bruce Momjian [Tue, 22 Jan 2002 22:22:34 +0000 (22:22 +0000)]
Clarify URL:
< http://www1.distributed.net/source, in client/common/cpucheck.cpp
---
> from distributted.net, http://www1.distributed.net/source,
> in client/common/cpucheck.cpp
Tom Lane [Tue, 22 Jan 2002 19:02:40 +0000 (19:02 +0000)]
libpq++/pgconnection.h must not include postgres_fe.h, else it fails to
compile in client apps that use the standard installed header set.
To allow removing that include, move DLLIMPORT definitions out of c.h
and into the appropriate port-specific header files.
Tom Lane [Fri, 18 Jan 2002 17:13:51 +0000 (17:13 +0000)]
Fix pg_restore to handle the 'set max oid' entry correctly in archives
dumped by pg_dump -o. Per bug report posted by Bruce; fix is from
Philip Warner, reviewed by Tom Lane.