- 23 Apr, 2004 2 commits
-
-
Bruce Momjian authored
Allow additional thread flags to be added via port templates. Change thread flag names to PTHREAD_CFLAGS and PTHREAD_LIBS to match new configure script.
-
Michael Meskes authored
-
- 22 Apr, 2004 14 commits
-
-
Bruce Momjian authored
-
Neil Conway authored
contains OIDs. Also, minor documentation improvements to the psql reference page.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
-
Peter Eisentraut authored
-
Neil Conway authored
This saves a small amount of per-backend memory for LP64 machines.
-
Neil Conway authored
-
Bruce Momjian authored
Update log_statement to more clearly state it doesn't filter based on the statement type of the prepared statement.
-
Bruce Momjian authored
report socket errors. Magnus Hagander
-
Bruce Momjian authored
1. Fixed bug where sequences were being mirrored incorrectly if they exceeded 127 2. Fixed a bug in the perl script with mirroring sequences(John Burtenshaw sent an email to patches describing the bug in March but I htink he forgot to attach his patch) 3. The dates/times in the transaction files will always use 2 digits. Steven Singer
-
Bruce Momjian authored
completion tag of the actual statement executed. This allows the correct update count to be returned for UPDATE/INSERT/DELETE statements. Kris Jurka
-
Bruce Momjian authored
errors. This is the second submission, which integrates Tom comments about localisation and exit code. I also added some comments about one sql command which is not ignored. Fabien COELHO
-
Bruce Momjian authored
-
- 21 Apr, 2004 7 commits
-
-
Neil Conway authored
builtin aggregate functions.
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
the next are handled by ReleaseAndReadBuffer rather than separate ReleaseBuffer and ReadBuffer calls. This cuts the number of acquisitions of the BufMgrLock by a factor of 2 (possibly more, if an indexscan happens to pull successive rows from the same heap page). Unfortunately this doesn't seem enough to get us out of the recently discussed context-switch storm problem, but it's surely worth doing anyway.
-
Tom Lane authored
of whether we have successfully read data into a buffer; this makes the error behavior a bit more transparent (IMHO anyway), and also makes it work correctly for local buffers which don't use Start/TerminateBufferIO. Collapse three separate functions for writing a shared buffer into one. This overlaps a bit with cleanups that Neil proposed awhile back, but seems not to have committed yet.
-
Peter Eisentraut authored
-
Bruce Momjian authored
FORCE QUOTE to force quotes FORCE NOT NULL to quote null input values
-
- 20 Apr, 2004 12 commits
-
-
Bruce Momjian authored
< * Add NO WAIT option to various SQL commands > * -Add NO WAIT LOCKs
-
Bruce Momjian authored
process directly. Some parameters can only be set at server start; any changes to their entries in the configuration file will be ignored until the server is restarted.
-
Bruce Momjian authored
-
Bruce Momjian authored
> * Allow AFTER triggers on system tables
-
Bruce Momjian authored
-
Bruce Momjian authored
> * -Exit postmaster if postgresql.conf can not be opened
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Bruce Momjian authored
> >> have to accept a full table scan when locating records. > > > > It indexes them, but "is null" is not an indexable operator, so you > > can't directly solve the above with a 3-column index. What you can do > > instead is use a partial index, for instance > > > > create index i on CUSTOMER.WCCustOrderStatusLog (WCOrderStatusID) > > where Acknowledged is null and Processing is null; > > That's a very nifty trick and exactly the sort of answer I was after! Add CREATE INDEX doc mention of using partial indexes for IS NULL indexing; idea from Tom.
-
Bruce Momjian authored
-
PostgreSQL Daemon authored
Remove all of the libpgtcl and pgtclsh files, including all references to them within the various makefiles with_tcl is still required for the src/pl/tcl language
-
- 19 Apr, 2004 5 commits
-
-
Bruce Momjian authored
reference DEALLOCATE in any way. It points to EXECUTE, but not to DEALLOCATE. Suggested fix: ... This also means that a single prepared statement cannot be used by multiple simultaneous database clients; however, each client can create their own prepared statement to use. The prepared statement can be manually cleaned up using the DEALLOCATE command. James Robinson
-
Tom Lane authored
of VACUUM cases so that VACUUM requests don't affect the ARC state at all, avoid corner case where BufferSync would uselessly rewrite a buffer that no longer contains the page that was to be flushed. Make some minor other cleanups in and around the bufmgr as well, such as moving PinBuffer and UnpinBuffer into bufmgr.c where they really belong.
-
Bruce Momjian authored
-
Bruce Momjian authored
Create diff of custom changes Tom made to the utility for CREATE FUNCTION. This will make moving this utility out of CVS easier.
-
-