OSDN Git Service
Teodor Sigaev [Fri, 26 May 2006 08:01:17 +0000 (08:01 +0000)]
Fix findParents() in case of multiple levels to find.
By Andreas Seltenreich <andreas+pg@gate450.dyndns.org>
Tom Lane [Thu, 25 May 2006 18:42:17 +0000 (18:42 +0000)]
Reduce per-character overhead in COPY OUT by combining calls to
CopySendData.
Tom Lane [Wed, 24 May 2006 21:20:11 +0000 (21:20 +0000)]
Fix pg_restore to process BLOB COMMENT entries correctly; they aren't
really tables and shouldn't get DISABLE TRIGGER processing. Per bug
#2452 from Robert Treat.
Bruce Momjian [Wed, 24 May 2006 18:12:38 +0000 (18:12 +0000)]
Remove pg_attribute detail, add URL
< pg_attribute.attislocal has to be set to 'false' for ADD, and
< pg_attribute.attinhcount adjusted appropriately
> See http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php.
Teodor Sigaev [Wed, 24 May 2006 11:01:39 +0000 (11:01 +0000)]
* Add support NULL to GiST.
* some refactoring and simplify code int gistutil.c and gist.c
* now in some cases it can be called used-defined
picksplit method for non-first column in index, but here
is a place to do more.
* small fix of docs related to support NULL.
Bruce Momjian [Tue, 23 May 2006 22:14:27 +0000 (22:14 +0000)]
Remove trailing blank line from exports.txt.
Bruce Momjian [Tue, 23 May 2006 22:13:19 +0000 (22:13 +0000)]
Add PQisthreadsafe() to libpq, to allow library applications to query
the thread-safety status of the library.
Tom Lane [Tue, 23 May 2006 21:37:59 +0000 (21:37 +0000)]
Tweak writetup_heap/readtup_heap to avoid storing the tuple identity
and transaction visibility fields of tuples being sorted. These are
always uninteresting in a tuple being sorted (if the fields were actually
selected, they'd have been pulled out into user columns beforehand).
This saves about 24 bytes per row being sorted, which is a useful savings
for any but the widest of sort rows. Per recent discussion.
Bruce Momjian [Tue, 23 May 2006 20:59:29 +0000 (20:59 +0000)]
Update text:
> This allows tables to be added/removed from an inheritance
> hierarchy. This is particularly useful for table partitioning.
Bruce Momjian [Tue, 23 May 2006 20:57:53 +0000 (20:57 +0000)]
Add:
> o Add ALTER TABLE tab ADD/DROP INHERITS parent
>
> pg_attribute.attislocal has to be set to 'false' for ADD, and
> pg_attribute.attinhcount adjusted appropriately
>
Bruce Momjian [Tue, 23 May 2006 20:20:52 +0000 (20:20 +0000)]
Rename in release notes: Mac -> OS/X, Intel to x86:
Fix for OS/X Bonjour on x86 systems (Ashley Clark)
Bruce Momjian [Tue, 23 May 2006 19:28:45 +0000 (19:28 +0000)]
Avoid duplicate definition of LOCALEDIR in pg_config.h, already defined
in port/pg_config_paths.h.
Bruce Momjian [Tue, 23 May 2006 15:51:07 +0000 (15:51 +0000)]
New wording, "What is the upgrade process for PostgreSQL?"
Bruce Momjian [Tue, 23 May 2006 15:47:43 +0000 (15:47 +0000)]
Update heading for upgrades.
Bruce Momjian [Tue, 23 May 2006 15:22:20 +0000 (15:22 +0000)]
Add mention that everyone should upgrade to minor releases.
Tom Lane [Tue, 23 May 2006 15:21:52 +0000 (15:21 +0000)]
Remove CXT_printf/CXT1_printf macros. If anyone had found them to be of
any use in the past many years, we'd have made some effort to include
them in all executor node types; but in fact they were only in
nodeAppend.c and nodeIndexscan.c, up until I copied nodeIndexscan.c's
occurrence into the new bitmap node types. Remove some other unused
macros in execdebug.h, too. Some day the whole header probably ought to
go away in favor of better-designed facilities.
Bruce Momjian [Mon, 22 May 2006 20:39:23 +0000 (20:39 +0000)]
Make "trigger" section:
> * Referential Integrity
>
> o Add MATCH PARTIAL referential integrity
> o Change foreign key constraint for array -> element to mean element
> in array?
> o Enforce referential integrity for system tables
>
>
< Referential Integrity
< =====================
<
< * Add MATCH PARTIAL referential integrity
> Triggers
> ========
< * Change foreign key constraint for array -> element to mean element
< in array?
801d804
< * Enforce referential integrity for system tables
Bruce Momjian [Mon, 22 May 2006 14:12:55 +0000 (14:12 +0000)]
Update Japanese FAQ.
J.Kuwamura
Bruce Momjian [Mon, 22 May 2006 14:08:06 +0000 (14:08 +0000)]
Change \; to ; in RULE, \; unnecessary.
Peter Eisentraut [Mon, 22 May 2006 11:21:54 +0000 (11:21 +0000)]
Add strerror to pg_dump error messages where missing.
Tom Lane [Sun, 21 May 2006 21:49:22 +0000 (21:49 +0000)]
Update release notes for upcoming releases.
Bruce Momjian [Sun, 21 May 2006 20:29:16 +0000 (20:29 +0000)]
Remove mention of pg_upgrade in release checklist.
Tom Lane [Sun, 21 May 2006 20:22:16 +0000 (20:22 +0000)]
Fix errors in fortuna PRNG reseeding logic that could cause a predictable
session key to be selected by pgp_sym_encrypt() in some cases. This only
affects non-OpenSSL-using builds. Marko Kreen
Tom Lane [Sun, 21 May 2006 20:19:23 +0000 (20:19 +0000)]
Modify libpq's string-escaping routines to be aware of encoding considerations
and standard_conforming_strings. The encoding changes are needed for proper
escaping in multibyte encodings, as per the SQL-injection vulnerabilities
noted in CVE-2006-2313 and CVE-2006-2314. Concurrent fixes are being applied
to the server to ensure that it rejects queries that may have been corrupted
by attempted SQL injection, but this merely guarantees that unpatched clients
will fail rather than allow injection. An actual fix requires changing the
client-side code. While at it we have also fixed these routines to understand
about standard_conforming_strings, so that the upcoming changeover to SQL-spec
string syntax can be somewhat transparent to client code.
Since the existing API of PQescapeString and PQescapeBytea provides no way to
inform them which settings are in use, these functions are now deprecated in
favor of new functions PQescapeStringConn and PQescapeByteaConn. The new
functions take the PGconn to which the string will be sent as an additional
parameter, and look inside the connection structure to determine what to do.
So as to provide some functionality for clients using the old functions,
libpq stores the latest encoding and standard_conforming_strings values
received from the backend in static variables, and the old functions consult
these variables. This will work reliably in clients using only one Postgres
connection at a time, or even multiple connections if they all use the same
encoding and string syntax settings; which should cover many practical
scenarios.
Clients that use homebrew escaping methods, such as PHP's addslashes()
function or even hardwired regexp substitution, will require extra effort
to fix :-(. It is strongly recommended that such code be replaced by use of
PQescapeStringConn/PQescapeByteaConn if at all feasible.
Tom Lane [Sun, 21 May 2006 20:10:42 +0000 (20:10 +0000)]
Add a new GUC parameter backslash_quote, which determines whether the SQL
parser will allow "\'" to be used to represent a literal quote mark. The
"\'" representation has been deprecated for some time in favor of the
SQL-standard representation "''" (two single quote marks), but it has been
used often enough that just disallowing it immediately won't do. Hence
backslash_quote allows the settings "on", "off", and "safe_encoding",
the last meaning to allow "\'" only if client_encoding is a valid server
encoding. That is now the default, and the reason is that in encodings
such as SJIS that allow 0x5c (ASCII backslash) to be the last byte of a
multibyte character, accepting "\'" allows SQL-injection attacks as per
CVE-2006-2314 (further details will be published after release). The
"on" setting is available for backward compatibility, but it must not be
used with clients that are exposed to untrusted input.
Thanks to Akio Ishida and Yasuo Ohgaki for identifying this security issue.
Tom Lane [Sun, 21 May 2006 20:05:21 +0000 (20:05 +0000)]
Change the backend to reject strings containing invalidly-encoded multibyte
characters in all cases. Formerly we mostly just threw warnings for invalid
input, and failed to detect it at all if no encoding conversion was required.
The tighter check is needed to defend against SQL-injection attacks as per
CVE-2006-2313 (further details will be published after release). Embedded
zero (null) bytes will be rejected as well. The checks are applied during
input to the backend (receipt from client or COPY IN), so it no longer seems
necessary to check in textin() and related routines; any string arriving at
those functions will already have been validated. Conversion failure
reporting (for characters with no equivalent in the destination encoding)
has been cleaned up and made consistent while at it.
Also, fix a few longstanding errors in little-used encoding conversion
routines: win1251_to_iso, win866_to_iso, euc_tw_to_big5, euc_tw_to_mic,
mic_to_euc_tw were all broken to varying extents.
Patches by Tatsuo Ishii and Tom Lane. Thanks to Akio Ishida and Yasuo Ohgaki
for identifying the security issues.
Alvaro Herrera [Fri, 19 May 2006 19:08:27 +0000 (19:08 +0000)]
Add last-vacuum/analyze-time columns to the stats collector, both manual and
issued by autovacuum. Add accessor functions to them, and use those in the
pg_stat_*_tables system views.
Catalog version bumped due to changes in the pgstat views and the pgstat file.
Patch from Larry Rosenman, minor improvements by me.
Teodor Sigaev [Fri, 19 May 2006 17:15:41 +0000 (17:15 +0000)]
Call MarkBufferDirty() before XLogInsert() during completion of insert
Teodor Sigaev [Fri, 19 May 2006 16:15:17 +0000 (16:15 +0000)]
Simplify gistSplit() and some refactoring related code.
Alvaro Herrera [Fri, 19 May 2006 15:15:37 +0000 (15:15 +0000)]
Have autovacuum report its activities to the stat collector.
Alvaro Herrera [Fri, 19 May 2006 14:26:58 +0000 (14:26 +0000)]
Fix typo in comment.
Bruce Momjian [Fri, 19 May 2006 13:10:11 +0000 (13:10 +0000)]
Fix Solaris/ASM test for x86.
Teodor Sigaev [Fri, 19 May 2006 11:10:25 +0000 (11:10 +0000)]
Rework completion of incomplete inserts. Now it writes
WAL log during inserts.
Bruce Momjian [Fri, 19 May 2006 04:39:47 +0000 (04:39 +0000)]
Back out \' change for tsearch2, broke regression tests.
Bruce Momjian [Fri, 19 May 2006 03:57:09 +0000 (03:57 +0000)]
Mention packager bumps configure.in/configure.
Bruce Momjian [Fri, 19 May 2006 03:55:40 +0000 (03:55 +0000)]
Stamp 8.1.4, except configure/configure.in.
Bruce Momjian [Fri, 19 May 2006 03:52:41 +0000 (03:52 +0000)]
Update for version 8.1.4.
Bruce Momjian [Fri, 19 May 2006 03:49:05 +0000 (03:49 +0000)]
Update release notes for 8.1.4.
Bruce Momjian [Fri, 19 May 2006 02:38:47 +0000 (02:38 +0000)]
Use SQL standard '' rather than \' in /contrib. Backpatch to 8.1.X.
Bruce Momjian [Thu, 18 May 2006 21:18:40 +0000 (21:18 +0000)]
Use unsigned into for slock_t for pre-sparcv8plus.
Tom Lane [Thu, 18 May 2006 19:56:46 +0000 (19:56 +0000)]
Fix choose_bitmap_and() so that partial index predicates are considered when
deciding whether a potential additional indexscan is redundant or not. As now
coded, any use of a partial index that was already used in a previous AND arm
will be rejected as redundant. This might be overly restrictive, but not
considering the point at all is definitely bad, as per example in bug #2441
from Arjen van der Meijden. In particular, a clauseless scan of a partial
index was *never* considered redundant by the previous coding, and that's
surely wrong. Being more flexible would also require some consideration
of how not to double-count the index predicate's selectivity.
Tom Lane [Thu, 18 May 2006 18:57:31 +0000 (18:57 +0000)]
When a bitmap indexscan is using a partial index, it is necessary to include
the partial index predicate in the scan's "recheck condition". Otherwise,
if the scan becomes lossy for lack of bitmap memory, we would fail to enforce
that returned rows satisfy the predicate. Noted while studying bug #2441
from Arjen van der Meijden.
Bruce Momjian [Thu, 18 May 2006 18:51:50 +0000 (18:51 +0000)]
Allow sparcv8plus to use "cas".
Theo Schlossnagle
Bruce Momjian [Thu, 18 May 2006 18:19:47 +0000 (18:19 +0000)]
Code alignment fix.
Tom Lane [Thu, 18 May 2006 17:12:10 +0000 (17:12 +0000)]
Fix thinko in recent changes to handle ScalarArrayOpExpr as an indexable
condition: when there are multiple possible index paths involving
ScalarArrayOpExprs, they are logically to be ANDed together not ORed.
This thinko was a direct consequence of trying to put the processing
inside generate_bitmap_or_paths(), which I now see was a bit too cute.
So pull it out and make the callers do it separately (there are only two
that need it anyway). Partially responds to bug #2441 from Arjen van der Meijden.
There are some additional infelicities exposed by his example, but they
are also in 8.1.x, while this mistake is not.
Bruce Momjian [Thu, 18 May 2006 16:26:44 +0000 (16:26 +0000)]
Remove canonicalize_path() call for .pgpass socket directory comparison;
not worth adding path.c to libpq.
Bruce Momjian [Thu, 18 May 2006 16:02:30 +0000 (16:02 +0000)]
Mention that gcc/sparc generates sparcv7 binaries.
Bruce Momjian [Thu, 18 May 2006 03:18:24 +0000 (03:18 +0000)]
Change <type>string</> to <parameter>string</>.
Bruce Momjian [Thu, 18 May 2006 02:32:15 +0000 (02:32 +0000)]
Add:
>
> * Add a GUC to control whether BEGIN inside a transcation should abort
> the transaction.
Bruce Momjian [Thu, 18 May 2006 01:06:28 +0000 (01:06 +0000)]
Add more sparcv8plus comments.
Bruce Momjian [Thu, 18 May 2006 00:50:08 +0000 (00:50 +0000)]
Make function param_name/type documentation more consistent.
Bruce Momjian [Thu, 18 May 2006 00:44:29 +0000 (00:44 +0000)]
Add mention of -xarch=v8plus for "cas" usage on Solaris/sparc.
Bruce Momjian [Thu, 18 May 2006 00:05:01 +0000 (00:05 +0000)]
Add simplified sparc8 ASM for solaris_sparc.s, from Alan Stange.
Bruce Momjian [Wed, 17 May 2006 23:57:03 +0000 (23:57 +0000)]
Add comments that Solaris Sun compiler only supports sparc9 ASM,
Bruce Momjian [Wed, 17 May 2006 22:06:19 +0000 (22:06 +0000)]
Change spaces to tabs, for consistency. (Caused by email cut/paste.)
Bruce Momjian [Wed, 17 May 2006 21:50:54 +0000 (21:50 +0000)]
Allow the .pgpass hostname to match the default socket directory, as
well as a blank pghost.
Teodor Sigaev [Wed, 17 May 2006 16:37:06 +0000 (16:37 +0000)]
Change catalog version due to WAL protocol changes in GiST
Teodor Sigaev [Wed, 17 May 2006 16:34:59 +0000 (16:34 +0000)]
Reduce size of critial section during vacuum full, critical
sections now isn't nested. All user-defined functions now is
called outside critsections. Small improvements in WAL
protocol.
TODO: improve XLOG replay
Bruce Momjian [Wed, 17 May 2006 01:44:24 +0000 (01:44 +0000)]
Rename macro parameter, for clarity.
Bruce Momjian [Sat, 13 May 2006 17:10:35 +0000 (17:10 +0000)]
Update pg_dump vesion wording.
Bruce Momjian [Sat, 13 May 2006 16:19:54 +0000 (16:19 +0000)]
Mention version portability of pg_dump.
Tom Lane [Fri, 12 May 2006 22:44:36 +0000 (22:44 +0000)]
Fix the sense of the test on DH_check()'s return value. This was preventing
custom-generated DH parameters from actually being used by the server.
Found by Michael Fuhr.
Tom Lane [Fri, 12 May 2006 16:50:52 +0000 (16:50 +0000)]
Upon closer inspection, the sparc code in s_lock.c is dead code, and
always has been, because it's not got any .globl declaration! We've
been relying on the solaris_sparc.s code instead. Rip it out.
(Not back-patched, since this is just cosmetic cleanup.)
Bruce Momjian [Thu, 11 May 2006 23:27:35 +0000 (23:27 +0000)]
Fix typo in comment.
Tom Lane [Thu, 11 May 2006 21:58:22 +0000 (21:58 +0000)]
Remove unnecessary .seg/.section directives, per Alan Stange.
Bruce Momjian [Thu, 11 May 2006 19:21:14 +0000 (19:21 +0000)]
Use SQL standard '' rather than \' for tutorial/sample code.
Backpatch to 8.1.X.
Tom Lane [Thu, 11 May 2006 19:15:36 +0000 (19:15 +0000)]
Code review for standard_conforming_strings patch. Fix it so it does not
throw warnings for 100%-SQL-standard constructs, clean up some minor
infelicities, try to un-break ecpg to the best of my ability. (It's not clear
how ecpg is going to find out the setting of standard_conforming_strings,
though.) I think pg_dump still needs work, too.
Tom Lane [Wed, 10 May 2006 23:18:39 +0000 (23:18 +0000)]
Clean up code associated with updating pg_class statistics columns
(relpages/reltuples). To do this, create formal support in heapam.c for
"overwrite" tuple updates (including xlog replay capability) and use that
instead of the ad-hoc overwrites we'd been using in VACUUM and CREATE INDEX.
Take the responsibility for updating stats during CREATE INDEX out of the
individual index AMs, and do it where it belongs, in catalog/index.c. Aside
from being more modular, this avoids having to update the same tuple twice in
some paths through CREATE INDEX. It's probably not measurably faster, but
for sure it's a lot cleaner than before.
Teodor Sigaev [Wed, 10 May 2006 11:39:12 +0000 (11:39 +0000)]
Some optimizations by Volkan YAZICI <yazicivo@ttnet.net.tr>
Teodor Sigaev [Wed, 10 May 2006 09:19:54 +0000 (09:19 +0000)]
Reduce size of critical section and remove call of user-defined functions in
insertion and deletion, modify gistSplit() to do not use buffers.
TODO: gistvacuumcleanup and XLOG
Bruce Momjian [Tue, 9 May 2006 23:12:54 +0000 (23:12 +0000)]
Revert documentation mention of array dimension checking, in next paragraph.
Bruce Momjian [Tue, 9 May 2006 16:31:23 +0000 (16:31 +0000)]
Mention array dimmensions are not enforced either.
Bruce Momjian [Mon, 8 May 2006 02:18:50 +0000 (02:18 +0000)]
Build server libpgport with all non-FRONTEND object files. This is to
fix a Win32 bug where pipe.c included a file that used FRONTEND, but it
wasn't on the server-build list.
Tom Lane [Mon, 8 May 2006 00:00:17 +0000 (00:00 +0000)]
Rewrite btree vacuuming to fold the former bulkdelete and cleanup operations
into a single mostly-physical-order scan of the index. This requires some
ticklish interlocking considerations, but should create no material
performance impact on normal index operations (at least given the
already-committed changes to make scans work a page at a time). VACUUM
itself should get significantly faster in any index that's degenerated to a
very nonlinear page order. Also, we save one pass over the index entirely,
except in the case where there were no deletions to do and so only one pass
happened anyway.
Original patch by Heikki Linnakangas, rework by Tom Lane.
Tom Lane [Sun, 7 May 2006 01:21:30 +0000 (01:21 +0000)]
Rewrite btree index scans to work a page at a time in all cases (both
btgettuple and btgetmulti). This eliminates the problem of "re-finding" the
exact stopping point, since the stopping point is effectively always a page
boundary, and index items are never moved across pre-existing page boundaries.
A small penalty is that the keys_are_unique optimization is effectively
disabled (and, therefore, is removed in this patch), causing us to apply
_bt_checkkeys() to at least one more tuple than necessary when looking up a
unique key. However, the advantages for non-unique cases seem great enough to
accept this tradeoff. Aside from simplifying and (sometimes) speeding up the
indexscan code, this will allow us to reimplement btbulkdelete as a largely
sequential scan instead of index-order traversal, thereby significantly
reducing the cost of VACUUM. Those changes will come in a separate patch.
Original patch by Heikki Linnakangas, rework by Tom Lane.
Bruce Momjian [Sun, 7 May 2006 01:05:11 +0000 (01:05 +0000)]
Use $(LIBS:-lpgport=) rather than $(patsubst -lpgport,, $(LIBS)), for consistency.
Bruce Momjian [Sat, 6 May 2006 23:35:32 +0000 (23:35 +0000)]
Add description:
* %Disallow changing DEFAULT expression of a SERIAL column?
>
> This should be done only if the existing SERIAL problems cannot be
> fixed.
>
Bruce Momjian [Sat, 6 May 2006 23:25:37 +0000 (23:25 +0000)]
Recommend more clearly custom pg_dump format over tar, buy showing
custom format examples first.
Bruce Momjian [Sat, 6 May 2006 16:25:11 +0000 (16:25 +0000)]
Document SSL CRL usage by libpq.
Tom Lane [Sat, 6 May 2006 15:51:07 +0000 (15:51 +0000)]
Further minor simplification of relcache startup: don't need a static
needNewCacheFile flag anymore, it can just be local in RelationCacheInitializePhase2.
Bruce Momjian [Sat, 6 May 2006 02:24:39 +0000 (02:24 +0000)]
Add SSL CRL support to libpq. Recently added to the backend.
Bruce Momjian [Sat, 6 May 2006 01:31:38 +0000 (01:31 +0000)]
Issue a log message if a CRL file exists and the SSL library does not
support CRL certificates.
Bruce Momjian [Fri, 5 May 2006 18:10:35 +0000 (18:10 +0000)]
Seems some NetBSD 3.0 x86 systems still need float8-small-is-zero, so
patch reverted.
Bruce Momjian [Fri, 5 May 2006 16:23:20 +0000 (16:23 +0000)]
On Solaris ASM, / '/' is the comment for x86, while '!' is the comment
for Sparc
Robert Lor
Bruce Momjian [Fri, 5 May 2006 16:16:49 +0000 (16:16 +0000)]
Use regression results float8-small-is-zero only for NetBSD < 3.0.
Backpatch to 8.1.X.
Simon Burge
Bruce Momjian [Fri, 5 May 2006 12:22:42 +0000 (12:22 +0000)]
Change Solaris comments from / to !.
Robert Lor
Bruce Momjian [Fri, 5 May 2006 09:51:53 +0000 (09:51 +0000)]
Update standards URL.
Robert Treat
Bruce Momjian [Fri, 5 May 2006 09:35:58 +0000 (09:35 +0000)]
Add/ cleanup:
< * %Disallow changing default expression of a SERIAL column?
> * %Disallow changing DEFAULT expression of a SERIAL column?
472a473,476
> * Add DEFAULT .. AS OWNER so permission checks are done as the table
> owner
>
> This would be useful for SERIAL nextval() calls and CHECK constraints.
Tom Lane [Thu, 4 May 2006 22:18:38 +0000 (22:18 +0000)]
Don't try to compile SSL CRL support if local SSL installation hasn't
got it. Per buildfarm failure on 'canary'.
Tom Lane [Thu, 4 May 2006 20:39:34 +0000 (20:39 +0000)]
Code review for contrib/pg_freespacemap. Add a storedpages column to
pg_freespacemap_relations --- while one could theoretically get that
number by counting rows in pg_freespacemap_pages, it's surely the hard
way to do it. Avoid expensive and inconvenient conversion to and from
text format. Minor code and docs cleanup.
Tom Lane [Thu, 4 May 2006 18:51:36 +0000 (18:51 +0000)]
Simplify relcache startup sequence. With the new design of InitPostgres
it's not necessary to have three separate calls anymore. This patch also
fixes things so we don't try to read pg_internal.init until after we've
obtained lock on the target database; which was fairly harmless, but it's
certainly cleaner this way.
Tom Lane [Thu, 4 May 2006 16:07:29 +0000 (16:07 +0000)]
Rethink the locking mechanisms used for CREATE/DROP/RENAME DATABASE.
The former approach used ExclusiveLock on pg_database, which being a
cluster-wide lock meant only one of these operations could proceed at
a time; worse, it also blocked all incoming connections in ReverifyMyDatabase.
Now that we have LockSharedObject(), we can use locks of different types
applied to databases considered as objects. This allows much more
flexible management of the interlocking: two CREATE DATABASEs need not
block each other, and need not block connections except to the template
database being used. Similarly DROP DATABASE doesn't block unrelated
operations. The locking used in flatfiles.c is also much narrower in
scope than before. Per recent proposal.
Tom Lane [Wed, 3 May 2006 22:45:26 +0000 (22:45 +0000)]
Create a syscache for pg_database-indexed-by-oid, and make use of it
in various places that were previously doing ad hoc pg_database searches.
This may speed up database-related privilege checks a little bit, but
the main motivation is to eliminate the performance reason for having
ReverifyMyDatabase do such a lot of stuff (viz, avoiding repeat scans
of pg_database during backend startup). The locking reason for having
that routine is about to go away, and it'd be good to have the option
to break it up.
Teodor Sigaev [Wed, 3 May 2006 16:31:07 +0000 (16:31 +0000)]
Make GIN opclass worked with intarray extensions
Teodor Sigaev [Wed, 3 May 2006 06:56:47 +0000 (06:56 +0000)]
Fix typo noticed by Alvaro Herrera
Tom Lane [Wed, 3 May 2006 00:24:56 +0000 (00:24 +0000)]
Fix calculation of plan node extParams to account for the possibility that one
initPlan sets a parameter for another. This could not (I think) happen before
8.1, but it's possible now because the initPlans generated by MIN/MAX
optimization might themselves use initPlans. We attach those initPlans as
siblings of the MIN/MAX ones, not children, to avoid duplicate computation
when multiple MIN/MAX aggregates are present; so this leads to the case of an
initPlan needing the result of a sibling initPlan, which is not possible with
ordinary query nesting. Hadn't been noticed because in most contexts having
too much stuff listed in extParam is fairly harmless. Fixes "plan should not
reference subplan's variable" bug reported by Catalin Pitis.
Tom Lane [Tue, 2 May 2006 22:25:10 +0000 (22:25 +0000)]
Clean up API for ambulkdelete/amvacuumcleanup as per today's discussion.
This formulation requires every AM to provide amvacuumcleanup, unlike before,
but it's surely a whole lot cleaner. Also, add an 'amstorage' column to
pg_am so that we can get rid of hardwired knowledge in DefineOpClass().
Tom Lane [Tue, 2 May 2006 18:07:51 +0000 (18:07 +0000)]
Fix broken markup.
Tom Lane [Tue, 2 May 2006 15:48:11 +0000 (15:48 +0000)]
Suppress some gcc warnings.
Tom Lane [Tue, 2 May 2006 15:45:37 +0000 (15:45 +0000)]
Fix grammar of new error message.