aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add discussion and example about predicate locking and why "serializable"Tom Lane2004-08-14
| | | | | mode isn't really serializable. I had thought this was covered already in our docs, but I sure can't find it.
* Minor editorializing.Tom Lane2004-08-14
|
* Translation updatesPeter Eisentraut2004-08-14
|
* Add:Bruce Momjian2004-08-14
| | | | | | | | | | | | > > * Allow buffered WAL writes and fsync > > Instead of guaranteeing recovery of all committed transactions, this > would provide improved performance by delaying WAL writes and fsync > so an abrupt operating system restart might lose a few seconds of > committed transactions but still be consistent. We could perhaps > remove the 'fsync' parameter (which results in an an inconsistent > database) in favor of this capability.
* Fix psql's COPY support to deal with \r\n line endings.Tom Lane2004-08-13
| | | | Andrew Dunstan, some further hacking by Tom Lane.
* Fix breakage with PUBLIC schema. Try to untwist the remarkably contortedTom Lane2004-08-13
| | | | logic a little bit.
* Give a more specific error message for "you can't do that" error casesTom Lane2004-08-13
| | | | in plpgsql, particularly trying to begin/end/rollback a transaction.
* Preliminary release notes for 7.4.4, 7.3.7, 7.2.5. Will add to theTom Lane2004-08-13
| | | | back branches later.
* New translationsPeter Eisentraut2004-08-13
|
* Translation updatePeter Eisentraut2004-08-13
|
* Translation updatesPeter Eisentraut2004-08-13
|
* Mention log_statement_stats can not be enabled with the other options.Bruce Momjian2004-08-13
|
* Clarify trigger function return convention, per Thomas Hallgren.Tom Lane2004-08-13
|
* Fix core dumps, inability to count, etc associated with canonicalize_pathTom Lane2004-08-13
| | | | patches.
* Change order of operations in ALTER TABLE SET TABLESPACE so that weTom Lane2004-08-13
| | | | | | don't hold an open file reference to the original table at the end. This is a good thing in any case, particularly so on Windows which cannot drop the table file otherwise.
* Mention the installer doesn't run on NT4.Bruce Momjian2004-08-13
|
* Add:Bruce Momjian2004-08-13
| | | | | > o Add ALTER INDEX that works just like ALTER TABLE already does > on an index
* Allow commas in BEGIN, START TRANSACTION, and SET TRANSACTION, as requiredTom Lane2004-08-12
| | | | | | by the SQL standard. For backwards compatibility, however, continue to accept the syntax without. Minor editorialization in the reference pages for these commands, too.
* Add:Bruce Momjian2004-08-12
| | | | | | | | | | | > * Allow finer control over the caching of prepared query plans > > Currently, queries prepared via the libpq API are planned on first > execute using the supplied parameters --- allow SQL PREPARE to do the > same. Also, allow control over replanning prepared queries either > manually or automatically when statistics for execute parameters > differ dramatically from those used during planning. >
* dbsize modification to support tablespacesBruce Momjian2004-08-12
| | | | Gavin Sherry
* Allow optional SAVEPOINT keyword in RELEASE and ROLLBACK TO, for greaterTom Lane2004-08-12
| | | | | | compliance with SQL2003 spec syntax. Oliver Jowett
* Cleanup Win32 COPY handling, and move archive examples to SGML.Bruce Momjian2004-08-12
|
* Add mention of "WIN32" COPY.Bruce Momjian2004-08-12
|
* Add make_native_path() because Win32 COPY is an internal CMD.EXE commandBruce Momjian2004-08-12
| | | | | | | | | | and doesn't process forward slashes in the same way as external commands. Quoting the first argument to COPY does not convert forward to backward slashes, but COPY does properly process quoted forward slashes in the second argument. Win32 COPY works with quoted forward slashes in the first argument only if the current directory is the same as the directory of the first argument.
* Be more aggressive about adding flags to thread compiles. The configureBruce Momjian2004-08-12
| | | | | | | | | | test only tests for building a binary, not building a shared library. On Linux, you can build a binary with -pthread, but you can't build a binary that uses a threaded shared library unless you also use -pthread when building the binary, or adding -lpthread to the shared library build. This patch has the effect of doing the later by adding both -pthread and -lpthread when building libpq.
* Minor style cleanup of thread test script.Bruce Momjian2004-08-12
|
* Cause initdb to actually accept -s as intended, and fix some typos inTom Lane2004-08-11
| | | | | | a comment. Jon Jensen
* Fix broken parsing of CREATE TABLE AS (looks like a mis-sync with mainTom Lane2004-08-11
| | | | parser).
* Avoid crashing when restoring a saved GUC session_authorization valueTom Lane2004-08-11
| | | | that refers to a now-deleted userid. Per gripe from Chris Ochs.
* Add PQserverVersion() to libpq to provide more-convenient access toTom Lane2004-08-11
| | | | | | | the server version number. This commit also removes bogus DOS line endings from libpqddll.def. Greg Sabino Mullane
* Work around broken strtod() that's present in many Solaris releases.Tom Lane2004-08-11
| | | | Thanks to Michael Fuhr for identifying the problem.
* Fix function definition that somehow missed being ANSI-fied, and alignTom Lane2004-08-11
| | | | | | it with previous prototype to suppress complaints from picky compilers, per report from Scott Bailey. Also, remove substitute strerror definition --- not needed, since we link this with libpgport.
* Allow compilation when CODESET is not defined (OpenBSD).Peter Eisentraut2004-08-11
|
* Translation updatePeter Eisentraut2004-08-11
|
* Add translation from 7.4 branch to head.Peter Eisentraut2004-08-11
|
* Fix failure to guarantee that a checkpoint will write out pg_clog updatesTom Lane2004-08-11
| | | | | | for transaction commits that occurred just before the checkpoint. This is an EXTREMELY serious bug --- kudos to Satoshi Okada for creating a reproducible test case to prove its existence.
* Hashed crosstab was dying with an SPI_finish error when the source SQLJoe Conway2004-08-11
| | | | | produced no rows. Now it returns 0 rows instead. Adjusted regression test for this case.
* Set DYLD_LIBRARY_PATH so that 'make check' works without priorTom Lane2004-08-10
| | | | 'make install' on OS X. Per suggestion from Adam Witney.
* New translationPeter Eisentraut2004-08-10
|
* Translation updatesPeter Eisentraut2004-08-10
|
* Translation updatePeter Eisentraut2004-08-10
|
* Translation updatesPeter Eisentraut2004-08-10
|
* Translation updatePeter Eisentraut2004-08-10
|
* Update DELETE FROM:Bruce Momjian2004-08-10
| | | | | | | | | | | | | | | | | < * Allow DELETE to handle table aliases for self-joins > * Allow an alias to be provided for the target table in UPDATE/DELETE 276,279c276,282 < There is no way to create a table alias for the deleted table for use < in the DELETE WHERE clause. The agreed approach is to allow a USING < clause to specify additional tables. UPDATE already has an optional < FROM clause for this purpose. > This is not SQL-spec but many DBMSs allow it. > > * Allow additional tables to be specified in DELETE for joins > > UPDATE already allows this (UPDATE...FROM) but we need similar > functionality in DELETE. It's been agreed that the keyword should > be USING, to avoid anything as confusing as DELETE FROM a FROM b.
* Update DELETE FROM TODO info.Bruce Momjian2004-08-10
|
* Add:Bruce Momjian2004-08-10
| | | | | * Add COMMENT ON for all cluster global objects (users, groups, databases and tablespaces)
* Update documentation to reflect the fact that we now know exactly whatTom Lane2004-08-10
| | | | time zone names we support.
* Removed, shared table:Bruce Momjian2004-08-09
| | | | < * Add COMMENT for tablespaces
* Add:Bruce Momjian2004-08-09
| | | | > * Add COMMENT for tablespaces
* syslogger.c needs <sys/time.h> on some platforms, per Greg Mullane.Tom Lane2004-08-09
|