OSDN Git Service
Magnus Hagander [Mon, 16 Apr 2007 20:15:38 +0000 (20:15 +0000)]
Don't write timing output in quiet mode.
Merlin Moncure
Tom Lane [Mon, 16 Apr 2007 18:50:49 +0000 (18:50 +0000)]
Tweak clean_encoding_name() API to avoid need to cast away const.
Kris Jurka
Tom Lane [Mon, 16 Apr 2007 18:42:10 +0000 (18:42 +0000)]
Fix pg_dump to not crash if -t or a similar switch is used to select a serial
sequence for dumping without also selecting its owning table. Make it not try
to emit ALTER SEQUENCE OWNED BY in this situation.
Per report from Michael Nolan.
Magnus Hagander [Mon, 16 Apr 2007 18:39:19 +0000 (18:39 +0000)]
Enable IPV6 for all MSVC builds, including the VC6 libpq-only build.
Per request from Hiroshi Saito.
Alvaro Herrera [Mon, 16 Apr 2007 18:30:04 +0000 (18:30 +0000)]
Add a multi-worker capability to autovacuum. This allows multiple worker
processes to be running simultaneously. Also, now autovacuum processes do not
count towards the max_connections limit; they are counted separately from
regular processes, and are limited by the new GUC variable
autovacuum_max_workers.
The launcher now has intelligence to launch workers on each database every
autovacuum_naptime seconds, limited only on the max amount of worker slots
available.
Also, the global worker I/O utilization is limited by the vacuum cost-based
delay feature. Workers are "balanced" so that the total I/O consumption does
not exceed the established limit. This part of the patch was contributed by
ITAGAKI Takahiro.
Per discussion.
Tom Lane [Mon, 16 Apr 2007 18:21:07 +0000 (18:21 +0000)]
Make plancache store cursor options so it can pass them to planner during
a replan. I had originally thought this was not necessary, but the new
SPI facilities create a path whereby queries planned with non-default
options can get into the cache, so it is necessary.
Tom Lane [Mon, 16 Apr 2007 17:21:24 +0000 (17:21 +0000)]
Support scrollable cursors (ie, 'direction' clause in FETCH) in plpgsql.
Pavel Stehule, reworked a bit by Tom.
Tom Lane [Mon, 16 Apr 2007 01:14:58 +0000 (01:14 +0000)]
Expose more cursor-related functionality in SPI: specifically, allow
access to the planner's cursor-related planning options, and provide new
FETCH/MOVE routines that allow access to the full power of those commands.
Small refactoring of planner(), pg_plan_query(), and pg_plan_queries()
APIs to make it convenient to pass the planning options down from SPI.
This is the core-code portion of Pavel Stehule's patch for scrollable
cursor support in plpgsql; I'll review and apply the plpgsql changes
separately.
Tom Lane [Sun, 15 Apr 2007 20:09:28 +0000 (20:09 +0000)]
Avoid running build_index_pathkeys() in situations where there cannot
possibly be any useful pathkeys --- to wit, queries with neither any
join clauses nor any ORDER BY request. It's nearly free to check for
this case and it saves a useful fraction of the planning time for simple
queries.
Andrew Dunstan [Sun, 15 Apr 2007 12:48:24 +0000 (12:48 +0000)]
Add --with-libxslt configure option
Tatsuo Ishii [Sun, 15 Apr 2007 10:56:30 +0000 (10:56 +0000)]
Make JOHAB client only encoding per discussions in pgsql-hackers
"Server-side support of all encodings" around 2007/3/26.
initdb required.
Tatsuo Ishii [Sun, 15 Apr 2007 10:49:26 +0000 (10:49 +0000)]
Fix description how to create conversion function.
Andrew Dunstan [Sat, 14 Apr 2007 12:57:07 +0000 (12:57 +0000)]
revert change to build xml2 until a better fix is found
Bruce Momjian [Fri, 13 Apr 2007 23:23:22 +0000 (23:23 +0000)]
Update TODO:
< o Consider reducing on-disk varlena length from four to two
< because a heap row cannot be more than 64k in length
> o Consider reducing on-disk varlena length from four bytes to
> two because a heap row cannot be more than 64k in length
Magnus Hagander [Fri, 13 Apr 2007 20:40:59 +0000 (20:40 +0000)]
Allow \timing in psql to have a better resolution than ~15ms on Windows.
ITAGAKI Takahiro
Bruce Momjian [Fri, 13 Apr 2007 20:00:10 +0000 (20:00 +0000)]
Update Win32 FAQ HTML version to match corrected text version.
Andrew Dunstan [Fri, 13 Apr 2007 18:50:01 +0000 (18:50 +0000)]
Enable building contrib/xml2 if configured using --with-libxml.
If this breaks things due to missing libxslt, then I'll have to
revert it, but let's see if it breaks the buildfarm.
Workarounds in case libxslt is missing include:
. don't configure with libxml, or
. don't build contrib modules from the contrib Makefile (use the individual module Makefiles instead), or
. change the xml2 Makefile
Magnus Hagander [Fri, 13 Apr 2007 10:30:30 +0000 (10:30 +0000)]
Add O_DIRECT support on Windows.
ITAGAKI Takahiro
Neil Conway [Thu, 12 Apr 2007 22:39:21 +0000 (22:39 +0000)]
Minor fixes for the EXPLAIN reference page. Mention the fact that
EXPLAIN ANALYZE can sometimes be significantly slower than running
the same query normally, and make some minor markup improvements.
Neil Conway [Thu, 12 Apr 2007 22:34:45 +0000 (22:34 +0000)]
Fixes for RESET SESSION patch, per Alvaro. Fix a typo in the RESET
ref page (sorry, my fault!), and simplify the coding of
ResetTempTableNamespace().
Bruce Momjian [Thu, 12 Apr 2007 19:38:26 +0000 (19:38 +0000)]
Done:
> * -Add RESET SESSION command to reset all session state
Tom Lane [Thu, 12 Apr 2007 17:10:55 +0000 (17:10 +0000)]
Rearrange mdsync() looping logic to avoid the problem that a sufficiently
fast flow of new fsync requests can prevent mdsync() from ever completing.
This was an unforeseen consequence of a patch added in Mar 2006 to prevent
the fsync request queue from overflowing. Problem identified by Heikki
Linnakangas and independently by ITAGAKI Takahiro; fix based on ideas from
Takahiro-san, Heikki, and Tom.
Back-patch as far as 8.1 because a previous back-patch introduced the problem
into 8.1 ...
Tom Lane [Thu, 12 Apr 2007 15:04:35 +0000 (15:04 +0000)]
Cancel pending fsync requests during WAL replay of DROP DATABASE, per bug
report from David Darville. Back-patch as far as 8.1, which may or may not
have the problem but it seems a safe change anyway.
Magnus Hagander [Thu, 12 Apr 2007 12:46:20 +0000 (12:46 +0000)]
Install debugger symbols (in their own directory)
Magnus Hagander [Thu, 12 Apr 2007 07:03:00 +0000 (07:03 +0000)]
Enable IPV6 when building with MSVC.
Neil Conway [Thu, 12 Apr 2007 06:53:49 +0000 (06:53 +0000)]
RESET SESSION, plus related new DDL commands. Patch from Marko Kreen,
reviewed by Neil Conway. This patch adds the following DDL command
variants: RESET SESSION, RESET TEMP, RESET PLANS, CLOSE ALL, and
DEALLOCATE ALL. RESET SESSION is intended for use by connection
pool software and the like, in order to reset a client session
to something close to its initial state.
Note that while most of these command variants can be executed
inside a transaction block (but are not transaction-aware!),
RESET SESSION cannot. While this is inconsistent, it is intended
to catch programmer mistakes: RESET SESSION in an open transaction
block is probably unintended.
Bruce Momjian [Wed, 11 Apr 2007 21:02:31 +0000 (21:02 +0000)]
Update text, per Greg Stark:
< o Allow single-byte header storage for arrays
> o Allow single-byte header storage for array elements
Tom Lane [Wed, 11 Apr 2007 20:47:38 +0000 (20:47 +0000)]
Code review for btree page split WAL reduction patch. Make it actually work
(original code *always* created a full-page image for the left page, thus
leaving the intended savings unrealized), avoid risk of not having enough room
on the page during xlog restore, squeeze out another couple bytes in the xlog
record, clean up neglected comments.
Bruce Momjian [Tue, 10 Apr 2007 01:33:39 +0000 (01:33 +0000)]
Add:
> o Allow single-byte header storage for arrays
Bruce Momjian [Tue, 10 Apr 2007 01:22:12 +0000 (01:22 +0000)]
Add:
> o Have WITH CONSTRAINTS also create constraint indexes
> http://archives.postgresql.org/pgsql-patches/2007-04/msg00149.php
Tom Lane [Mon, 9 Apr 2007 22:04:08 +0000 (22:04 +0000)]
Minor tweaking of index special-space definitions so that the various
index types can be reliably distinguished by examining the special space
on an index page. Per my earlier proposal, plus the realization that
there's no need for btree's vacuum cycle ID to cycle through every possible
16-bit value. Restricting its range a little costs nearly nothing and
eliminates the possibility of collisions.
Memo to self: remember to make bitmap indexes play along with this scheme,
assuming that patch ever gets accepted.
Bruce Momjian [Mon, 9 Apr 2007 21:18:29 +0000 (21:18 +0000)]
Add URL for:
* Simplify ability to create partitioned tables
> http://archives.postgresql.org/pgsql-hackers/2007-04/msg00151.php
Magnus Hagander [Mon, 9 Apr 2007 18:21:22 +0000 (18:21 +0000)]
Add cancel handlers so it's possible to Ctrl-C clusterdb, reindexdb
and vacuumdb.
ITAGAKI Takahiro, with minor fixes from me.
Bruce Momjian [Sun, 8 Apr 2007 02:17:02 +0000 (02:17 +0000)]
Done:
> o -Make CLUSTER preserve recently-dead tuples per MVCC requirements
Tom Lane [Sun, 8 Apr 2007 02:07:35 +0000 (02:07 +0000)]
Minor editorialization on CLUSTER reference page.
Tom Lane [Sun, 8 Apr 2007 01:26:33 +0000 (01:26 +0000)]
Make CLUSTER MVCC-safe. Heikki Linnakangas
Tatsuo Ishii [Sun, 8 Apr 2007 01:15:07 +0000 (01:15 +0000)]
Add -F option to set fillfactor for tellers, accounts and branches.
Patch contributed by Pavan Deolasee. Along with Japanese doc
modification by Tatsuo Ishii.
Bruce Momjian [Sun, 8 Apr 2007 00:36:08 +0000 (00:36 +0000)]
Done:
> o -Add more logical syntax CLUSTER table USING index;
Bruce Momjian [Sun, 8 Apr 2007 00:26:34 +0000 (00:26 +0000)]
Support syntax "CLUSTER table USING index", which is more logical.
Holger Schurig
Tom Lane [Sat, 7 Apr 2007 17:12:15 +0000 (17:12 +0000)]
Add note that TRUNCATE is not MVCC-safe.
Bruce Momjian [Sat, 7 Apr 2007 16:09:14 +0000 (16:09 +0000)]
Add the usage count statistics to the information available in
contrib/pgbuffercache.
Greg Smith
Bruce Momjian [Sat, 7 Apr 2007 04:04:56 +0000 (04:04 +0000)]
Slight wording improvement.
Neil Conway [Sat, 7 Apr 2007 03:58:08 +0000 (03:58 +0000)]
Fix a few typos in the docs.
Bruce Momjian [Sat, 7 Apr 2007 03:48:25 +0000 (03:48 +0000)]
Remove example of SQL-standard syntax for GRANT/REVOKE --- was causing
confusion.
Bruce Momjian [Sat, 7 Apr 2007 03:34:36 +0000 (03:34 +0000)]
In docs, Symetric -> Symmetric.
Michael Fuhr
Bruce Momjian [Sat, 7 Apr 2007 03:08:20 +0000 (03:08 +0000)]
Done:
> * -Allow use of indexes to search for NULLs
Bruce Momjian [Sat, 7 Apr 2007 02:48:16 +0000 (02:48 +0000)]
Done:
o -Support a smaller header for short variable-length fields
Tom Lane [Fri, 6 Apr 2007 22:57:20 +0000 (22:57 +0000)]
Don't remove the 'alias' field from flattened rangetable entries;
there are some corner cases where this is needed by ruleutils.c for
proper display of variables during EXPLAIN.
Tom Lane [Fri, 6 Apr 2007 22:33:43 +0000 (22:33 +0000)]
Make 'col IS NULL' clauses be indexable conditions.
Teodor Sigaev, with some kibitzing from Tom Lane.
Tom Lane [Fri, 6 Apr 2007 19:22:38 +0000 (19:22 +0000)]
Fix some now-obsolete comments about the space used by various data
types.
Andrew Dunstan [Fri, 6 Apr 2007 13:44:39 +0000 (13:44 +0000)]
Only run contrib check if there is a Makefile
Tatsuo Ishii [Fri, 6 Apr 2007 09:16:16 +0000 (09:16 +0000)]
Enhance pgbench -l option to add timestamp. Patch contributed by Greg
Smith. Along with Japanese doc updation by Tasuo Ishii.
> This patch changes the way pgbench outputs its latency log files so that
> every transaction gets a timestamp and notes which transaction type was
> executed. It's a one-line change that just dumps some additional
> information that was already sitting in that area of code. I also made a
> couple of documentation corrections and clarifications on some of the more
> confusing features of pgbench.
>
> It's straightforward to parse log files in this format to analyze what
> happened during the test at a higher level than was possible with the
> original format. You can find some rough sample code to convert this
> latency format into CVS files and then into graphs at
> http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm which I'll
> be expanding on once I get all my little patches sent in here.
Tatsuo Ishii [Fri, 6 Apr 2007 08:49:44 +0000 (08:49 +0000)]
Various pgbench enhancements. Patch contributed by ITAGAKI Takahiro.
Also tweak README.pgbench/README.pgbench_jis:
Remove history after pgbench was added to PostgreSQL contrib module.
Those info was not only redundant since it has already been in CVS
log, but also incomplete.
--------------------------------------------------------------------------
The attached is a patch to optimize contrib/pgbench using new 8.3 features.
- Use DROP IF EXISTS to suppress errors for initial loadings.
- Use a combination of TRUNCATE and COPY to reduce WAL on creating
the accounts table.
Also, there are some cosmetic changes.
- Change the output of -v option from "starting full vacuum..."
to "starting vacuum accounts..." in reflection of the fact.
- Shape duplicated error checks into executeStatement().
There is a big performance win in "COPY with no WAL" feature.
Thanks for the efforts!
--------------------------------------------------------------------------
Tom Lane [Fri, 6 Apr 2007 05:36:51 +0000 (05:36 +0000)]
Now that core functionality is depending on autoconf's AC_C_BIGENDIAN to be
right, there seems precious little reason to have a pile of hand-maintained
endianness definitions in src/include/port/*.h. Get rid of those, and make
the couple of places that used them depend on WORDS_BIGENDIAN instead.
Tom Lane [Fri, 6 Apr 2007 04:21:44 +0000 (04:21 +0000)]
Support varlena fields with single-byte headers and unaligned storage.
This commit breaks any code that assumes that the mere act of forming a tuple
(without writing it to disk) does not "toast" any fields. While all available
regression tests pass, I'm not totally sure that we've fixed every nook and
cranny, especially in contrib.
Greg Stark with some help from Tom Lane
Bruce Momjian [Thu, 5 Apr 2007 13:53:24 +0000 (13:53 +0000)]
Update XML error message text for missing libxml; update regression
output to match.
Magnus Hagander [Thu, 5 Apr 2007 12:31:36 +0000 (12:31 +0000)]
Continue running contrib regression tests if one fails, and exit
with errorlevel 1 is >= 1 checks failed.
Magnus Hagander [Thu, 5 Apr 2007 12:10:40 +0000 (12:10 +0000)]
Make sure list of tests is cleared out before getting the new list
of tests. Per Andrew Dunstan.
Bruce Momjian [Thu, 5 Apr 2007 02:08:53 +0000 (02:08 +0000)]
Add URL for:
* Reduce WAL traffic so only modified values are written rather than
entire rows
>
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg01589.php
>
Bruce Momjian [Thu, 5 Apr 2007 01:46:27 +0000 (01:46 +0000)]
Improve documentation/warning when --with-libxml is not used in the
installation.
Andrew Dunstan [Wed, 4 Apr 2007 20:53:44 +0000 (20:53 +0000)]
improve test headings
Bruce Momjian [Wed, 4 Apr 2007 19:26:58 +0000 (19:26 +0000)]
Re-add FAQ item 3.7 which was accidentally removed in previous commit:
<H3 id="item3.7">3.7) What computer hardware should I use?</H3>
Andrew Dunstan [Wed, 4 Apr 2007 18:45:59 +0000 (18:45 +0000)]
Don't install files for xml2 when building without libxml.
Bruce Momjian [Wed, 4 Apr 2007 17:28:11 +0000 (17:28 +0000)]
Remove plpython casts C source code casts:
It removes last remaining casts inside struct definitions.
Such usage is bad practice, as it hides problems from compiler.
Reason for the cast is popular practice in some circles
to define functions as foo(MyObj *) instead of foo(PyObject *)
thus avoiding a local variable inside functions and make
direct calling easier. As pl/python does not use such style,
the casts were unnecessary from the start.
Marko Kreen
Magnus Hagander [Wed, 4 Apr 2007 16:34:43 +0000 (16:34 +0000)]
Don't install files for sslinfo when building without openssl.
Per Andrew Dunstan.
Bruce Momjian [Tue, 3 Apr 2007 22:38:35 +0000 (22:38 +0000)]
Document how to identify an invalid index after a failed CREATE INDEX
CONCURRENTLY.
Gregory Stark
Tom Lane [Tue, 3 Apr 2007 16:34:36 +0000 (16:34 +0000)]
Remove the CheckpointStartLock in favor of having backends show whether they
are in their commit critical sections via flags in the ProcArray. Checkpoint
can watch the ProcArray to determine when it's safe to proceed. This is
a considerably better solution to the original problem of race conditions
between checkpoint and transaction commit: it speeds up commit, since there's
one less lock to fool with, and it prevents the problem of checkpoint being
delayed indefinitely when there's a constant flow of commits. Heikki, with
some kibitzing from Tom.
Bruce Momjian [Tue, 3 Apr 2007 15:51:36 +0000 (15:51 +0000)]
Done:
> o -Allow PL/PythonU to return boolean rather than 1/0
Bruce Momjian [Tue, 3 Apr 2007 15:50:58 +0000 (15:50 +0000)]
Allow pl/pythonu >= version 2.3 to return boolean, rather than 1/0.
Marko Kreen
Bruce Momjian [Tue, 3 Apr 2007 13:37:22 +0000 (13:37 +0000)]
Allow PL/PythonU to compile on Python 2.5. Change needed because of API
changes in Python.
Marko Kreen
Bruce Momjian [Tue, 3 Apr 2007 12:55:23 +0000 (12:55 +0000)]
Update comment for new thread_test location.
Tom Lane [Tue, 3 Apr 2007 04:14:26 +0000 (04:14 +0000)]
Decouple the values of TOAST_TUPLE_THRESHOLD and TOAST_MAX_CHUNK_SIZE.
Add the latter to the values checked in pg_control, since it can't be changed
without invalidating toast table content. This commit in itself shouldn't
change any behavior, but it lays some necessary groundwork for experimentation
with these toast-control numbers.
Note: while TOAST_TUPLE_THRESHOLD can now be changed without initdb, some
thought still needs to be given to needs_toast_table() in toasting.c before
unleashing random changes.
Bruce Momjian [Tue, 3 Apr 2007 04:12:00 +0000 (04:12 +0000)]
Update:
< * Add transaction_idle_timeout GUC so locks are not held for long
> * Add idle_in_transaction_timeout GUC so locks are not held for long
Bruce Momjian [Tue, 3 Apr 2007 02:17:11 +0000 (02:17 +0000)]
Update:
< * Add idle_timeout GUC so locks are not held for log periods of time
> * Add transaction_idle_timeout GUC so locks are not held for long
> periods of time
Bruce Momjian [Tue, 3 Apr 2007 01:25:12 +0000 (01:25 +0000)]
Add:
> * Allow all data types to cast to and from TEXT
>
> http://archives.postgresql.org/pgsql-hackers/2007-04/msg00017.php
>
>
Bruce Momjian [Tue, 3 Apr 2007 01:21:06 +0000 (01:21 +0000)]
Add:
>
> * Add idle_timeout GUC so locks are not held for log periods of time
Bruce Momjian [Tue, 3 Apr 2007 01:16:24 +0000 (01:16 +0000)]
Add URL for:
o Allow UPDATE tab SET ROW (col, ...) = (SELECT...)
<
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00865.php
Bruce Momjian [Mon, 2 Apr 2007 23:25:20 +0000 (23:25 +0000)]
Add URL for:
o Allow commenting of variables in postgresql.conf to restore them
to defaults
> http://archives.postgresql.org/pgsql-patches/2007-03/msg00180.php
Bruce Momjian [Mon, 2 Apr 2007 22:50:19 +0000 (22:50 +0000)]
Add URL for:
o Allow a warm standby system to also allow read-only
statements
[pitr]
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php
Bruce Momjian [Mon, 2 Apr 2007 22:49:03 +0000 (22:49 +0000)]
Add URL for:
* Improve speed with indexes
For large table adjustments during VACUUM FULL, it is faster to cluster
or reindex rather than update the index. Also, index updates can bloat
the index.
>
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00024.php
Bruce Momjian [Mon, 2 Apr 2007 22:46:10 +0000 (22:46 +0000)]
Add:
> o Have timestamp subtraction not call justify_hours()?
>
> http://archives.postgresql.org/pgsql-sql/2006-10/msg00059.php
>
< o Add overflow checking to timestamp and interval arithmetic
> o Add overflow checking to timestamp and interval arithmetic
Bruce Momjian [Mon, 2 Apr 2007 22:20:53 +0000 (22:20 +0000)]
Allow NOTIFY/LISTEN/UNLISTEN to only take relation names, not
schema.relation, because the notify code only honors the relation name.
schema.relation will now generate a syntax error.
Andrew Dunstan [Mon, 2 Apr 2007 22:14:17 +0000 (22:14 +0000)]
Check length of enum literals on definition and input to make sure they will fit in a name field and not cause syscache errors.
Bruce Momjian [Mon, 2 Apr 2007 21:28:10 +0000 (21:28 +0000)]
Pl/python -> Pl/PythonU:
< o Add table function support to pltcl, plpython
> o Add table function support to pltcl, plpythonu
< o Add PL/Python tracebacks
> o Add PL/PythonU tracebacks
< o Allow PL/Python to return boolean rather than 1/0
> o Allow PL/PythonU to return boolean rather than 1/0
Bruce Momjian [Mon, 2 Apr 2007 21:25:34 +0000 (21:25 +0000)]
Add:
> * Fix to_date()-related functions to consistently issue errors
>
> http://archives.postgresql.org/pgsql-hackers/2007-02/msg00915.php
>
Bruce Momjian [Mon, 2 Apr 2007 21:10:53 +0000 (21:10 +0000)]
Add:
>
> o Allow PL/Python to return boolean rather than 1/0
>
> http://archives.postgresql.org/pgsql-patches/2007-01/msg00596.php
>
Bruce Momjian [Mon, 2 Apr 2007 20:43:40 +0000 (20:43 +0000)]
Add item:
>
> * Consider reducing memory used for shared buffer reference count
>
> http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php
Bruce Momjian [Mon, 2 Apr 2007 20:10:16 +0000 (20:10 +0000)]
Add URL for:
o Allow RETURN to return row or record functions
> o Allow RETURN to return row or record functions
> http://archives.postgresql.org/pgsql-patches/2006-08/msg00397.php
> http://archives.postgresql.org/pgsql-hackers/2006-09/msg00388.php
Tom Lane [Mon, 2 Apr 2007 18:49:29 +0000 (18:49 +0000)]
Fix check_sql_fn_retval to allow the case where a SQL function declared to
return void ends with a SELECT, if that SELECT has a single result that is
also of type void. Without this, it's hard to write a void function that
calls another void function. Per gripe from Peter.
Back-patch as far as 8.0.
Bruce Momjian [Mon, 2 Apr 2007 17:18:44 +0000 (17:18 +0000)]
Done:
< * Support a data type with specific enumerated values (ENUM)
<
< http://archives.postgresql.org/pgsql-hackers/2006-08/msg00979.php
<
> * -Support a data type with specific enumerated values (ENUM)
Bruce Momjian [Mon, 2 Apr 2007 17:15:39 +0000 (17:15 +0000)]
> o Add PQexecf() that allows complex parameter substitution
>
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg01803.php
Peter Eisentraut [Mon, 2 Apr 2007 15:27:02 +0000 (15:27 +0000)]
Put documentation on XML data type and functions in better positions. Add
some index terms.
Magnus Hagander [Mon, 2 Apr 2007 12:11:26 +0000 (12:11 +0000)]
xcopy can only deal with forward-slashed paths when it's quoted - needed
for "vcregress check" to work.
Per report from Dave Page.
Teodor Sigaev [Mon, 2 Apr 2007 11:42:04 +0000 (11:42 +0000)]
Fix caching of unsuccessful initialization of parser or configuration.
Per report from Listmail <lists@peufeu.com>
Tom Lane [Mon, 2 Apr 2007 03:49:42 +0000 (03:49 +0000)]
Support enum data types. Along the way, use macros for the values of
pg_type.typtype whereever practical. Tom Dunstan, with some kibitzing
from Tom Lane.
Peter Eisentraut [Sun, 1 Apr 2007 09:56:02 +0000 (09:56 +0000)]
Update catversion for new XML mapping functions
Peter Eisentraut [Sun, 1 Apr 2007 09:42:57 +0000 (09:42 +0000)]
Update SQL conformance for SQL to XML mappings
Peter Eisentraut [Sun, 1 Apr 2007 09:00:26 +0000 (09:00 +0000)]
Mapping schemas and databases to XML and XML Schema.
Refactor and document the remaining mapping code.
Peter Eisentraut [Sun, 1 Apr 2007 08:56:58 +0000 (08:56 +0000)]
Complete cleaning
Magnus Hagander [Fri, 30 Mar 2007 18:34:56 +0000 (18:34 +0000)]
Add some instrumentation to the bgwriter, through the stats collector.
New view pg_stat_bgwriter, and the functions required to build it.