OSDN Git Service
Bruce Momjian [Fri, 3 Mar 2006 23:49:12 +0000 (23:49 +0000)]
Avoid trying to open /dev/tty on Win32. Some Win32 systems have
/dev/tty, but it isn't a device file and doesn't work as expected.
This fixes a known bug where psql does not prompt for a password on some
Win32 systems.
Backpatch to 8.1.X.
Robert Kinberg
Tom Lane [Fri, 3 Mar 2006 23:38:30 +0000 (23:38 +0000)]
Improve pg_dump and psql to use libpq's newer COPY support routines,
instead of the old deprecated ones.
Volkan Yazici, with some editorializing by moi.
Bruce Momjian [Fri, 3 Mar 2006 23:11:48 +0000 (23:11 +0000)]
Fixes for Win32-client only compiles.
Hiroshi Saito
Bruce Momjian [Fri, 3 Mar 2006 22:02:08 +0000 (22:02 +0000)]
Rename Online Backup to Continuous Archiving.
Bruce Momjian [Fri, 3 Mar 2006 21:52:37 +0000 (21:52 +0000)]
Update ipcclean to use try 'id' first for root check.
Bruce Momjian [Fri, 3 Mar 2006 21:35:46 +0000 (21:35 +0000)]
Add workaround so MSVC doesn't try to load strings.h, which it doesn't
have. This happens when MSVC uses pg_config.h generated by MinGW.
Per report from Charles F. I. Savage
Tom Lane [Fri, 3 Mar 2006 20:57:32 +0000 (20:57 +0000)]
Teach PQcmdTuples() that a COPY command tag might contain a row count,
and tighten up its sanity checking of the tag as a safety measure.
Volkan Yazici.
Bruce Momjian [Fri, 3 Mar 2006 20:52:36 +0000 (20:52 +0000)]
Clarify macro layout for win32 IMPORT.
Bruce Momjian [Fri, 3 Mar 2006 20:43:00 +0000 (20:43 +0000)]
Done:
> * -Allow TRUNCATE ... CASCADE/RESTRICT
Bruce Momjian [Fri, 3 Mar 2006 20:37:29 +0000 (20:37 +0000)]
Done:
< o %Have COPY return the number of rows loaded/unloaded?
> o -Have COPY return the number of rows loaded/unloaded?
Tom Lane [Fri, 3 Mar 2006 19:54:10 +0000 (19:54 +0000)]
Make the COPY command return a command tag that includes the number of
rows copied. Backend side of Volkan Yazici's recent patch, with
corrections and documentation.
Tom Lane [Fri, 3 Mar 2006 18:25:14 +0000 (18:25 +0000)]
Dept. of second thoughts: rejigger the TRUNCATE ... CASCADE patch so that
relations are still checked for permissions etc as soon as they are
opened. The original form of the patch could hold exclusive lock for a
long time on relations that the user doesn't even have permissions to
access, let alone truncate.
Bruce Momjian [Fri, 3 Mar 2006 16:49:21 +0000 (16:49 +0000)]
In ipcclean, check LOGNAME only if USER is not set.
Fixes problem with 'su' on some platforms.
Neil Conway [Fri, 3 Mar 2006 04:31:07 +0000 (04:31 +0000)]
Fix a typo.
Tom Lane [Fri, 3 Mar 2006 03:30:54 +0000 (03:30 +0000)]
Add CASCADE option to TRUNCATE. Joachim Wieland
Bruce Momjian [Fri, 3 Mar 2006 03:13:04 +0000 (03:13 +0000)]
Add:
> * Allow FSM to return free space toward the beginning of the heap file,
> in hopes that empty pages at the end can be truncated by VACUUM
Bruce Momjian [Fri, 3 Mar 2006 03:06:05 +0000 (03:06 +0000)]
Appended is a small documentation patch that adds a note to the CREATE
ROLE page, based on what Tom Lane told me here:
http://archives.postgresql.org/pgsql-general/2005-11/msg00998.php
Joachim Wieland
Bruce Momjian [Fri, 3 Mar 2006 02:38:57 +0000 (02:38 +0000)]
Add:
> * Add missing parameter handling in to_char()
>
> http://archives.postgresql.org/pgsql-hackers/2005-12/msg00948.php
>
Bruce Momjian [Fri, 3 Mar 2006 02:18:09 +0000 (02:18 +0000)]
Add:
> * Allow to_date() and to_timestamp() accept localized month names
Bruce Momjian [Fri, 3 Mar 2006 02:17:30 +0000 (02:17 +0000)]
Add comment about localized month names for to_date and to_timestamp.
Tom Lane [Fri, 3 Mar 2006 00:02:02 +0000 (00:02 +0000)]
Arrange to call AbsorbFsyncRequests every so often while performing a
checkpoint in the bgwriter. This forestalls overflow of the fsync request
queue, which is not fatal but causes considerable performance degradation
when it occurs (because backends then have to do their own fsyncs). Per
patch from Itagaki Takahiro, modified a little bit by me.
Tom Lane [Thu, 2 Mar 2006 21:56:14 +0000 (21:56 +0000)]
Remove unnecessary lo_lseek call in lo_open. Apparently there was once
a need for it back in the neolithic era, but it's certainly dead code in
any PG release we would recognize as such. Since it forces an additional
network round trip to the backend, getting rid of it should provide some
small performance improvement for large-object-using clients.
Tom Lane [Thu, 2 Mar 2006 21:49:09 +0000 (21:49 +0000)]
Fix ancient error in large objects usage example: overwrite() subroutine
was opening with INV_READ flag and then writing. Prior to 8.1 the backend
did not reject this, but now it does.
Tom Lane [Thu, 2 Mar 2006 21:13:04 +0000 (21:13 +0000)]
Repair oidvectorrecv and int2vectorrecv, which I broke while changing
them to use array_recv :-(. Per report from Tim Kordas.
Bruce Momjian [Thu, 2 Mar 2006 20:30:21 +0000 (20:30 +0000)]
Update OS X shared memory documentation for 10.3.9 and later to use
/etc/sysctl.conf.
Chris Campbell
Bruce Momjian [Thu, 2 Mar 2006 19:34:43 +0000 (19:34 +0000)]
Mark tsearch2 item as Tom's, not Teodor's.
Bruce Momjian [Thu, 2 Mar 2006 19:21:05 +0000 (19:21 +0000)]
Update TODO.detail/qsort.
Bruce Momjian [Thu, 2 Mar 2006 19:20:44 +0000 (19:20 +0000)]
Update TODO.detail/qsort.
Teodor Sigaev [Thu, 2 Mar 2006 19:07:19 +0000 (19:07 +0000)]
Significantly improve ranking:
1) rank_cd now use weight of lexemes
2) rank_cd and rank can use any combination of normalization methods:
no normalization
normalization by log(length of document)
-----/------- by length of document
-----/------- by number of unique word in document
-----/------- by log(number of unique word in document)
-----/------- by number of covers (only rank_cd)
Improve cover's search.
TODO: changes in documentation
Bruce Momjian [Thu, 2 Mar 2006 18:20:25 +0000 (18:20 +0000)]
Update TODO.detail/qsort.
Bruce Momjian [Thu, 2 Mar 2006 18:18:13 +0000 (18:18 +0000)]
Add to TODO.detail for qsort.
Bruce Momjian [Thu, 2 Mar 2006 18:18:00 +0000 (18:18 +0000)]
Add:
> * Improve port/qsort() to handle sorts with 50% unique and 50% duplicate
> value [qsort]
>
> This involves choosing better pivot points for the quicksort.
Tom Lane [Thu, 2 Mar 2006 05:34:12 +0000 (05:34 +0000)]
Fix possible crash at transaction end when a plpgsql function is used and
then modified within the same transaction. The code was using a linked list
of active PLpgSQL_expr structs, which was OK when it was written because
plpgsql never released any parse data structures for the life of the backend.
But since Neil fixed plpgsql's memory management, elements of the linked list
could be freed, leading to crash when the list is chased. Per report and test
case from Kris Jurka.
Tom Lane [Thu, 2 Mar 2006 01:18:26 +0000 (01:18 +0000)]
Fix up pg_dump to emit shell-type definitions at the proper time, to
make use of the recently added ability to create a shell type explicitly.
I also put in place some infrastructure to allow dump/no dump decisions
to be made separately for each database object, rather than the former
hardwired 'dump if in a dumpable schema' policy. This was needed anyway
for shell types so now seemed a convenient time to do it. The flexibility
isn't exposed to the user yet, but is ready for future extensions.
Neil Conway [Wed, 1 Mar 2006 23:00:56 +0000 (23:00 +0000)]
Woops: also update the alternative "expected" files for contrib/cube's
regression tests to account for the new error message wording. It seems
today is not my day...
Bruce Momjian [Wed, 1 Mar 2006 22:24:51 +0000 (22:24 +0000)]
Update text file.
Bruce Momjian [Wed, 1 Mar 2006 22:23:14 +0000 (22:23 +0000)]
Update patch generation instructions.
Robert Treat
Neil Conway [Wed, 1 Mar 2006 21:09:32 +0000 (21:09 +0000)]
Update the expected regression test results to account for the changes to
error messages I made yesterday -- thanks to Andrew Dunstan for reporting
this, and my apologies for missing it the first time.
Bruce Momjian [Wed, 1 Mar 2006 20:31:29 +0000 (20:31 +0000)]
Update Japanese FAQ, backpatched to 8.1.X.
Neil Conway [Wed, 1 Mar 2006 06:51:01 +0000 (06:51 +0000)]
Attached is a patch that replaces a bunch of places where StringInfos
are unnecessarily allocated on the heap rather than the stack. If the
StringInfo doesn't outlive the stack frame in which it is created,
there is no need to allocate it on the heap via makeStringInfo() --
stack allocation is faster. While it's not a big deal unless the
code is in a critical path, I don't see a reason not to save a few
cycles -- using stack allocation is not less readable.
I also cleaned up a bit of code along the way: moved variable
declarations into a more tightly-enclosing scope where possible,
fixed some pointless copying of strings in dblink, etc.
Neil Conway [Wed, 1 Mar 2006 06:30:32 +0000 (06:30 +0000)]
This patch makes the error message strings throughout the backend
more compliant with the error message style guide. In particular,
errdetail should begin with a capital letter and end with a period,
whereas errmsg should not. I also fixed a few related issues in
passing, such as fixing the repeated misspelling of "lexeme" in
contrib/tsearch2 (per Tom's suggestion).
Bruce Momjian [Wed, 1 Mar 2006 00:23:21 +0000 (00:23 +0000)]
Add pg_service.conf documentation for libpq.
Neil Conway [Tue, 28 Feb 2006 23:38:13 +0000 (23:38 +0000)]
Fix typo in comment.
Tom Lane [Tue, 28 Feb 2006 22:37:27 +0000 (22:37 +0000)]
Allow the syntax CREATE TYPE foo, with no parameters, to permit explicit
creation of a shell type. This allows a less hacky way of dealing with
the mutual dependency between a datatype and its I/O functions: make a
shell type, then make the functions, then define the datatype fully.
We should fix pg_dump to handle things this way, but this commit just deals
with the backend.
Martijn van Oosterhout, with some corrections by Tom Lane.
Bruce Momjian [Tue, 28 Feb 2006 22:35:35 +0000 (22:35 +0000)]
Back out libpq changes for service --- not ready yet.
Bruce Momjian [Tue, 28 Feb 2006 22:34:24 +0000 (22:34 +0000)]
Fix PG_VERSION_NUM for different awk -F handling.
Bruce Momjian [Tue, 28 Feb 2006 21:59:19 +0000 (21:59 +0000)]
Fix PG_VERSION_NUM awk -F parameter.
Neil Conway [Tue, 28 Feb 2006 20:56:14 +0000 (20:56 +0000)]
Tweak the error message emitted when a void-returning PL/Python function
does not return None, per suggestion from Tom.
Neil Conway [Tue, 28 Feb 2006 20:03:52 +0000 (20:03 +0000)]
Allow PL/Python functions to return void, per gripe from James Robinson
(I didn't use his patch, however). A void-returning PL/Python function
must return None (from Python), which is translated into a void datum
(and *not* NULL) for Postgres. I also added some regression tests for
this functionality.
Bruce Momjian [Tue, 28 Feb 2006 19:48:03 +0000 (19:48 +0000)]
Add:
* Split out libpq pgpass and environment documentation sections to make
it easier for non-developers to find
Bruce Momjian [Tue, 28 Feb 2006 16:41:21 +0000 (16:41 +0000)]
Add PG_VERSION_NUM for use by 3rd party applications wanting to test the
backend version in C using > and < comparisons.
Tom Lane [Tue, 28 Feb 2006 05:48:44 +0000 (05:48 +0000)]
Teach nodeSort and nodeMaterial to optimize out unnecessary overhead
when the passed-down eflags indicate they can.
Simon Riggs and Tom Lane
Tom Lane [Tue, 28 Feb 2006 04:10:28 +0000 (04:10 +0000)]
Extend the ExecInitNode API so that plan nodes receive a set of flag
bits indicating which optional capabilities can actually be exercised
at runtime. This will allow Sort and Material nodes, and perhaps later
other nodes, to avoid unnecessary overhead in common cases.
This commit just adds the infrastructure and arranges to pass the correct
flag values down to plan nodes; none of the actual optimizations are here
yet. I'm committing this separately in case anyone wants to measure the
added overhead. (It should be negligible.)
Simon Riggs and Tom Lane
Peter Eisentraut [Mon, 27 Feb 2006 16:09:50 +0000 (16:09 +0000)]
Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in
particular get rid of single quotes around language names and old WITH ()
construct.
Peter Eisentraut [Mon, 27 Feb 2006 12:54:39 +0000 (12:54 +0000)]
contrib uninstall scripts
by David Fetter
Bruce Momjian [Mon, 27 Feb 2006 01:41:16 +0000 (01:41 +0000)]
Add mention that tid perhaps someday should be output as a record.
Tom Lane [Sun, 26 Feb 2006 22:58:12 +0000 (22:58 +0000)]
Improve sorting speed by pre-extracting the first sort-key column of
each tuple, as per my proposal of several days ago. Also, clean up
sort memory management by keeping all working data in a separate memory
context, and refine the handling of low-memory conditions.
Neil Conway [Sun, 26 Feb 2006 22:26:39 +0000 (22:26 +0000)]
Fix a few minor typos in comments in PL/Perl.
Bruce Momjian [Sun, 26 Feb 2006 21:22:47 +0000 (21:22 +0000)]
Done:
> * -Add 'tid != tid ' operator for use in corruption recovery
Neil Conway [Sun, 26 Feb 2006 18:36:23 +0000 (18:36 +0000)]
Implement the <> operator for the tid type. Original patch from Mark
Kirkwood, minor improvements by Neil Conway. The regression tests have
been updated and the catversion has been bumped.
Neil Conway [Sun, 26 Feb 2006 03:20:46 +0000 (03:20 +0000)]
Minor SGML work: add some more hyperlinks, where appropriate.
Neil Conway [Sun, 26 Feb 2006 02:23:41 +0000 (02:23 +0000)]
Fix typo in comment.
Neil Conway [Sun, 26 Feb 2006 01:21:57 +0000 (01:21 +0000)]
TODO updates:
- "Add ON COMMIT capability to CREATE TABLE AS ... SELECT" is done
- "Allow PREPARE to automatically determine parameter types" is done
- "Clean up compiler warnings (especially with gcc version 4)" is done:
AFAIK there are no remaining gcc4 compiler warnings to be fixed.
- Creating rules to do view updates is *not* an easy TODO item
Peter Eisentraut [Sat, 25 Feb 2006 19:18:58 +0000 (19:18 +0000)]
Remove ora2pg; now available at <samse.fr/GPL/ora2pg/>.
Bruce Momjian [Sat, 25 Feb 2006 16:34:52 +0000 (16:34 +0000)]
Add intervals:
> o Allow infinite dates and intervals just like infinite timestamps
Bruce Momjian [Sat, 25 Feb 2006 04:28:54 +0000 (04:28 +0000)]
Fix computation of sample table size.
Bruce Momjian [Sat, 25 Feb 2006 03:40:14 +0000 (03:40 +0000)]
Remove duplicate:
< o %Disallow dropping of an inherited constraint
Bruce Momjian [Fri, 24 Feb 2006 14:59:54 +0000 (14:59 +0000)]
Remove mention of MIN/MAX() not using indexes.
Bruce Momjian [Fri, 24 Feb 2006 14:03:01 +0000 (14:03 +0000)]
Mention that the archive history file has the wal start/stop file names.
Peter Eisentraut [Fri, 24 Feb 2006 13:25:44 +0000 (13:25 +0000)]
The Makefile was invoking perl scripts as ./script.pl. This fails when
the script is not executable as UCS_to_most.pl is in CVS. It also won't
pick up any custom setting of the perl version/location to use. This
patch calls perl scripts like $(PERL) $(srcdir)/script.pl.
Kris Jurka
Andrew Dunstan [Fri, 24 Feb 2006 02:02:41 +0000 (02:02 +0000)]
Make restricted_exec feature for Windows more robust by using the environment
to pass the flag instead of the command line - some implementations of
getopt fail if getopt arguments are present after non-getopt arguments.
Andrew Dunstan [Fri, 24 Feb 2006 00:55:49 +0000 (00:55 +0000)]
make initdb -U username work as advertised; back out bogus patch at rev 1.42
and supply real fix for problem it tried to address.
Tom Lane [Thu, 23 Feb 2006 22:33:59 +0000 (22:33 +0000)]
Fix vacuumlo to avoid unnecessary use of backslash in search pattern.
Per Michael Fuhr.
Neil Conway [Tue, 21 Feb 2006 23:01:54 +0000 (23:01 +0000)]
Cleanup the usage of ScanDirection: use the symbolic names for the
possible ScanDirection alternatives rather than magic numbers
(-1, 0, 1). Also, use the ScanDirection macros in a few places
rather than directly checking whether `dir == ForwardScanDirection'
and the like. Per patch from James William Pye. His patch also
changed ScanDirection to be a "char" rather than an enum, which
I haven't applied.
Tom Lane [Tue, 21 Feb 2006 18:01:32 +0000 (18:01 +0000)]
Fix old pg_dump oversight: default values for domains really need to be dumped
by decompiling the typdefaultbin expression, not just printing the typdefault
text which may be out-of-date or assume the wrong schema search path. (It's
the same hazard as for adbin vs adsrc in column defaults.) The catalogs.sgml
spec for pg_type implies that the correct procedure is to look to
typdefaultbin first and consider typdefault only if typdefaultbin is NULL.
I made dumping of both domains and base types do that, even though in the
current backend code typdefaultbin is always correct for domains and
typdefault for base types --- might as well try to future-proof it a little.
Per bug report from Alexander Galler.
Tom Lane [Tue, 21 Feb 2006 06:06:50 +0000 (06:06 +0000)]
Adjust probe for getaddrinfo to cope with macro-ized definitions, such
as Tru64's. Per previous discussion.
Neil Conway [Mon, 20 Feb 2006 20:10:37 +0000 (20:10 +0000)]
Fix three Python reference leaks in PLy_traceback(). This would result
in leaking memory when invoking a PL/Python procedure that raises an
exception. Unfortunately this still leaks memory, but at least the
largest leak has been plugged.
This patch also fixes a reference counting mistake in PLy_modify_tuple()
for 8.0, 8.1 and HEAD: we don't actually own a reference to `platt', so
we shouldn't Py_DECREF() it.
Teodor Sigaev [Mon, 20 Feb 2006 17:51:05 +0000 (17:51 +0000)]
Fixing and improve compound word support. This changes cannot be applied to
previous version iwthout recreating tsvector fields...
Thanks to Alexander Presber <aljoscha@weisshuhn.de> to discover a problem.
Tom Lane [Sun, 19 Feb 2006 19:59:53 +0000 (19:59 +0000)]
Update obsolete comment.
Tom Lane [Sun, 19 Feb 2006 05:58:36 +0000 (05:58 +0000)]
Modify logtape.c so that the initial LogicalTapeSetCreate call only
allocates the control data. The per-tape buffers are allocated only
on first use. This saves memory in situations where tuplesort.c
overestimates the number of tapes needed (ie, there are fewer runs
than tapes). Also, this makes legitimate the coding in inittapes()
that includes tape buffer space in the maximum-memory calculation:
when inittapes runs, we've already expended the whole allowed memory
on tuple storage, and so we'd better not allocate all the tape buffers
until we've flushed some tuples out of memory.
Tom Lane [Sun, 19 Feb 2006 05:54:06 +0000 (05:54 +0000)]
Improve tuplesort.c to support variable merge order. The original coding
with fixed merge order (fixed number of "tapes") was based on obsolete
assumptions, namely that tape drives are expensive. Since our "tapes"
are really just a couple of buffers, we can have a lot of them given
adequate workspace. This allows reduction of the number of merge passes
with consequent savings of I/O during large sorts.
Simon Riggs with some rework by Tom Lane
Neil Conway [Sun, 19 Feb 2006 00:04:28 +0000 (00:04 +0000)]
Add TABLESPACE and ON COMMIT clauses to CREATE TABLE AS. ON COMMIT is
required by the SQL standard, and TABLESPACE is useful functionality.
Patch from Kris Jurka, minor editorialization by Neil Conway.
Neil Conway [Sat, 18 Feb 2006 23:14:45 +0000 (23:14 +0000)]
Minor SGML style police work.
Peter Eisentraut [Sat, 18 Feb 2006 22:54:50 +0000 (22:54 +0000)]
' is not valid HTML 4.01, so print the plain character instead.
Neil Conway [Sat, 18 Feb 2006 20:48:51 +0000 (20:48 +0000)]
Patch from Marko Kreen:
pgcrypto crypt()/md5 and hmac() leak memory when compiled against
OpenSSL as openssl.c digest ->reset will do two DigestInit calls
against a context. This happened to work with OpenSSL 0.9.6
but not with 0.9.7+.
Reason for the messy code was that I tried to avoid creating
wrapper structure to transport algorithm info and tried to use
OpenSSL context for it. The fix is to create wrapper structure.
It also uses newer digest API to avoid memory allocations
on reset with newer OpenSSLs.
Thanks to Daniel Blaisdell for reporting it.
Peter Eisentraut [Sat, 18 Feb 2006 16:15:23 +0000 (16:15 +0000)]
Add support for Windows codepages 1253, 1254, 1255, and 1257 and clean
up a bunch of the support utilities.
In src/backend/utils/mb/Unicode remove nearly duplicate copies of the
UCS_to_XXX perl script and replace with one version to handle all generic
files. Update the Makefile so that it knows about all the map files.
This produces a slight difference in some of the map files, using a
uniform naming convention and not mapping the null character.
In src/backend/utils/mb/conversion_procs create a master utf8<->win
codepage function like the ISO 8859 versions instead of having a separate
handler for each conversion.
There is an externally visible change in the name of the win1258 to utf8
conversion. According to the documentation notes, it was named
incorrectly and this changes it to a standard name.
Running the Unicode mapping perl scripts has shown some additional mapping
changes in koi8r and iso8859-7.
Neil Conway [Sat, 18 Feb 2006 01:44:35 +0000 (01:44 +0000)]
Mark unescape_single_char() "static": as far as I can see this function
is only used by scan.l/scan.c
Neil Conway [Fri, 17 Feb 2006 03:29:02 +0000 (03:29 +0000)]
Fix typo in comment.
Peter Eisentraut [Thu, 16 Feb 2006 23:23:50 +0000 (23:23 +0000)]
Change MemSet to use long instead of int32, for better performance on
64-bit platforms.
by ITAGAKI Takahiro
Peter Eisentraut [Thu, 16 Feb 2006 01:03:48 +0000 (01:03 +0000)]
Put the first section of a chapter in its own chunk.
Tom Lane [Wed, 15 Feb 2006 17:23:10 +0000 (17:23 +0000)]
Since we only use libld on AIX, don't include it in LIBS on any other
platforms (it does exist on HPUX, for one). We could probably even make
this a test for specific AIX versions, but I don't know which ones need it.
Tom Lane [Tue, 14 Feb 2006 23:30:43 +0000 (23:30 +0000)]
Repair --single-transaction patch so it handles blobs correctly.
Simon Riggs
Tom Lane [Tue, 14 Feb 2006 17:20:01 +0000 (17:20 +0000)]
Move btbulkdelete's vacuum_delay_point() call to a place in the loop where
we are not holding a buffer content lock; where it was, InterruptHoldoffCount
is positive and so we'd not respond to cancel signals as intended. Also
add missing vacuum_delay_point() call in btvacuumcleanup. This should fix
complaint from Evgeny Gridasov about failure to respond to SIGINT/SIGTERM
in a timely fashion (bug #2257).
Tom Lane [Tue, 14 Feb 2006 16:39:32 +0000 (16:39 +0000)]
Add some missing vacuum_delay_point calls in GIST vacuuming.
Tom Lane [Tue, 14 Feb 2006 15:34:46 +0000 (15:34 +0000)]
AllocSetStats should probably be using unsigned format to show space totals.
Tom Lane [Tue, 14 Feb 2006 15:03:59 +0000 (15:03 +0000)]
Need a DLLIMPORT for MaxFSMPages, per buildfarm failure on snake.
Bruce Momjian [Tue, 14 Feb 2006 03:32:14 +0000 (03:32 +0000)]
Document that GRANT on a table does not affect sequence permissions,
inclusing SERIAL column sequences.
Bruce Momjian [Tue, 14 Feb 2006 02:03:44 +0000 (02:03 +0000)]
Document that xact commit/abort stats are collected if any stat variable
is set.
Tom Lane [Mon, 13 Feb 2006 22:33:57 +0000 (22:33 +0000)]
Add positive defense against trying to connect when the connection
option state hasn't been fully set up. This is possible via PQreset()
and might occur in other code paths too, so a state flag seems the
most robust solution. Per report from Arturs Zoldners.
Tom Lane [Mon, 13 Feb 2006 21:30:19 +0000 (21:30 +0000)]
IMHO, --single-transaction should wrap *all* the commands in BEGIN/COMMIT,
not just some of them.