- 20 4月, 2004 17 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
> >> 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 提交于
-
由 PostgreSQL Daemon 提交于
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
-
由 Bruce Momjian 提交于
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 提交于
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 提交于
-
由 Bruce Momjian 提交于
Create diff of custom changes Tom made to the utility for CREATE FUNCTION. This will make moving this utility out of CVS easier.
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
one apparent error and makes a minor stylistic change that makes it more consistent and makes clear something that confused me :-) Andrew Dunstan
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Fix for code originally added for 7.5.
-
由 Bruce Momjian 提交于
* removed a few redundant defines * get_user_name safe under win32 * rationalized pipe read EOF for win32 (UPDATED PATCH USED) * changed all backend instances of sleep() to pg_usleep - except for the SLEEP_ON_ASSERT in assert.c, as it would exceed a 32-bit long [Note to patcher: If a SLEEP_ON_ASSERT of 2000 seconds is acceptable, please replace with pg_usleep(2000000000L)] I added a comment to that part of the code: /* * It would be nice to use pg_usleep() here, but only does 2000 sec * or 33 minutes, which seems too short. */ sleep(1000000); Claudio Natoli
-
由 Bruce Momjian 提交于
o -Allow dump/load of CSV format This adds new keywords to COPY and \copy: CSV - enable CSV mode (comma separated variable) QUOTE - specify quote character ESCAPE - specify escape character FORCE - force quoting of specified column LITERAL - suppress null comparison for columns Doc changes included. Regression updates coming from Andrew.
-
由 Bruce Momjian 提交于
> o -Allow dump/load of CSV format
-
- 19 4月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
< * -Allow psql \du to show groups, and add \dg for groups > * -Allow psql \du to show users, and add \dg for groups
-
由 Tom Lane 提交于
are sought first as local FROM columns, then as local SELECT-list aliases, and finally as outer FROM columns; the former behavior made outer FROM columns take precedence over aliases. This does not change spec conformance because SQL99 allows only the first case anyway, and it seems more useful and self-consistent. Per gripe from Dennis Bjorklund 2004-04-05.
-
- 16 4月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 15 4月, 2004 6 次提交
-
-
由 Tom Lane 提交于
RETURN NEXT.
-
由 Peter Eisentraut 提交于
-
由 Peter Eisentraut 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * Alvaro Herrera <alvherre@dcc.uchile.cl> > * Alvaro is Alvaro Herrera <alvherre@dcc.uchile.cl>
-
由 Bruce Momjian 提交于
< * Add the concept of dataspaces/tablespaces [tablespaces] > * Add the concept of dataspaces/tablespaces [tablespaces] (Gavin) 167c167 < * Allow savepoints / nested transactions [transactions] (Bruce) > * Allow savepoints / nested transactions [transactions] (Alvaro) 240c240 < o Allow Java server-side programming [java] > o Allow Java server-side programming [java] (Dave) 496a497 > * Alvaro Herrera <alvherre@dcc.uchile.cl>
-
- 13 4月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
It works on the principle of turning sockets into non-blocking, and then emulate blocking behaviour on top of that, while allowing signals to run. Signals are now implemented using an event instead of APCs, thus getting rid of the issue of APCs not being compatible with "old style" sockets functions. It also moves the win32 specific code away from pqsignal.h/c into port/win32, and also removes the "thread style workaround" of the APC issue previously in place. In order to make things work, a few things are also changed in pgstat.c: 1) There is now a separate pipe to the collector and the bufferer. This is required because the pipe will otherwise only be signalled in one of the processes when the postmaster goes down. The MS winsock code for select() must have some kind of workaround for this behaviour, but I have found no stable way of doing that. You really are not supposed to use the same socket from more than one process (unless you use WSADuplicateSocket(), in which case the docs specifically say that only one will be flagged). 2) The check for "postmaster death" is moved into a separate select() call after the main loop. The previous behaviour select():ed on the postmaster pipe, while later explicitly saying "we do NOT check for postmaster exit inside the loop". The issue was that the code relies on the same select() call seeing both the postmaster pipe *and* the pgstat pipe go away. This does not always happen, and it appears that useing WSAEventSelect() makes it even more common that it does not. Since it's only called when the process exits, I don't think using a separate select() call will have any significant impact on how the stats collector works. Magnus Hagander
-
- 12 4月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
Add pstdin/pstdout to read from psql's stdin/stdout. BACKWARD INCOMPATIBLE CHANGE
-
由 Bruce Momjian 提交于
> > pronouns and formatting in the Russian FAQ. Serguei Mokhov
-
- 11 4月, 2004 2 次提交
-
-
由 Bruce Momjian 提交于
calling proc_exit() directly. This should make SIGTERM more reliable.
-
由 Bruce Momjian 提交于
"millennium" date part implementation in postgresql, both in the code and the documentation, so that it conforms to the official definition. If you do not agree with the official definition, please send your complaint to "pope@vatican.org". I'm not responsible for them;-) With the previous version, the centuries and millenniums had a wrong number and started the wrong year. Moreover century number 0, which does not exist in reality, lasted 200 years. Also, millennium number 0 lasted 2000 years. If you want postgresql to have it's own definition of "century" and "millennium" that does not conform to the one of the society, just give them another name. I would suggest "pgCENTURY" and "pgMILLENNIUM";-) IMO, if someone may use the options, it means that postgresql is used for historical data, so it make sense to have an historical definition. Also, I just want to divide the year by 100 or 1000, I can do that quite easily. BACKWARD INCOMPATIBLE CHANGE Fabien Coelho - coelho@cri.ensmp.fr
-
- 10 4月, 2004 1 次提交
-
-
由 Bruce Momjian 提交于
gborg.
-
- 09 4月, 2004 3 次提交
-
-
由 Dennis Bjorklund 提交于
-
由 Dennis Bjorklund 提交于
-
由 Bruce Momjian 提交于
so remove regression result map line: horology/win32=horology-no-DST-before-1970
-
- 08 4月, 2004 4 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
< * Allow LOCALE on a per-column basis, default to ASCII > * Allow locale to be set at database creation > * Allow locale on a per-column basis, default to ASCII > * Optimize locale to have minimal performance impact when not used (Peter E) 105d106 < * Optimize locale to have minimal performance impact when not used (Peter E) 111d111 < * Allow locale to be set at database creation
-
由 Bruce Momjian 提交于
crash with debug in log_statement patch.
-