- 29 Sep, 2001 12 commits
- 
- 
Hiroshi Inoue authoredper tuple memory context doesn't discard them. 
- 
Tom Lane authored
- 
Tom Lane authored
- 
Tom Lane authoredStill need an update for horology-solaris-1947.out ... 
- 
Tom Lane authoredexisting lock manager and spinlocks: it understands exclusive vs shared lock but has few other fancy features. Replace most uses of spinlocks with lightweight locks. All remaining uses of spinlocks have very short lock hold times (a few dozen instructions), so tweak spinlock backoff code to work efficiently given this assumption. All per my proposal on pghackers 26-Sep-01. 
- 
Bruce Momjian authoredtwo performance improvements. I put an explanation of the changes at http://cs1.cs.nyu.edu/been/postgres-rtree.html The performance improvements are quite significant. All the changes are in the file src/backend/access/rtree/rtree.c I was working with the 7.1.3 code. I'm including the diff output as an attachment. Kenneth Been 
- 
Bruce Momjian authoredMarko Kreen 
- 
Bruce Momjian authoredConverted pgcrypto one too. * Changed default randomness source to libc random() That way pgcrypto does not have any external dependencies and should work everywhere. * Re-enabled pgcrypto build in contrib/makefile * contrib/README update - there is more stuff than only 'hash functions' * Noted the libc random fact in README.pgcrypto Marko Kreen 
- 
Bruce Momjian authoredLiam Stewart 
- 
Bruce Momjian authoredpg_ctl.sh which were unquoted when inside of []. Justin Clift 
- 
Bruce Momjian authoredDatabaseMetaData.getColumn(). I proposed a patch that would change the number of queries to find out all columns in a table from 2 * N + 1 to 1 (N being the number of columns reported) by using some outer joins. I also fixed the fact that getColumns() only returned columns that had a default defined. OTOH, I did not use to change the code required for obtaining a column's remarks (by using col_description() for 7.2 and requested by Tom Lane). Finally, I have found a way to get all the column details in a single query *and* use col_description() for 7.2 servers. A patch is attached. It overrules Ren? Pijlman's fix for this that was committed just today, but still used N + 1 queries (sorry Ren? ;-) ) I also fixed the return values for TABLE_CAT and TABLE_SCHEM from "" to null, to be more standard compliant (and requested in Ren?'s mail found at http://fts.postgresql.org/db/mw/msg.html?mid=1034253). As always, the JDBC1 version has not been tested as I have no JDK 1.1 Jeroen van Vianen 
- 
Hiroshi Inoue authoredKristis Markis. 
 
- 
- 28 Sep, 2001 11 commits
- 
- 
Bruce Momjian authored
- 
Thomas G. Lockhart authoredneed more work, but at least they have something now. 
- 
Bruce Momjian authored
- 
Bruce Momjian authored
- 
Bruce Momjian authored
- 
Bruce Momjian authored
- 
Bruce Momjian authored
- 
Bruce Momjian authored
- 
Thomas G. Lockhart authoredStart chapter on recovery techniques. Still needs work for release. 
- 
Thomas G. Lockhart authoredDefine a new function, GetCurrentTransactionStartTimeUsec() to get the time to this precision. Allow now() and timestamp 'now' to use this higher precision result so we now have fractional seconds in this "constant". Add timestamp without time zone type. Move previous timestamp type to timestamp with time zone. Accept another ISO variant for date/time values: yyyy-mm-ddThh:mm:ss (note the "T" separating the day from hours information). Remove 'current' from date/time types; convert to 'now' in input. Separate time and timetz regression tests. Separate timestamp and timestamptz regression test. 
- 
Thomas G. Lockhart authoredModify the timestamp test to reflect the "no time zone" behavior of this new code; timestamptz resembles the old timestamp code. 
 
- 
- 27 Sep, 2001 4 commits
- 
- 
Bruce Momjian authored
- 
Tom Lane authoredmore reasonable location for them. 
- 
Tom Lane authoredproposal of 26-Aug. 
- 
Bruce Momjian authored
 
- 
- 26 Sep, 2001 5 commits
- 
- 
Tom Lane authoredPer gripe 9/26. 
- 
Tom Lane authoredcheck *can* return HEAPTUPLE_INSERT_IN_PROGRESS or HEAPTUPLE_DELETE_IN_PROGRESS, even though we have ShareLock on the relation. To wit, this can happen if the tuple was inserted/deleted by our own transaction. Per report from Justin Clift 9/23. 
- 
Tom Lane authoredneed this, and it will create a Y2038 failure. Per report from David Wheeler, who is evidently running on a platform where time_t is already negative. 
- 
Bruce Momjian authored
- 
Bruce Momjian authoredsupported platforms in pg_hba.conf. 
 
- 
- 25 Sep, 2001 2 commits
- 
- 
Michael Meskes authored- Changed locale handling. 
- 
Tatsuo Ishii authoredchars are in the input. 
 
- 
- 24 Sep, 2001 2 commits
- 
- 
Peter Eisentraut authored
- 
Hiroshi Inoue authored2) Change *Common* --> *Default*. 
 
- 
- 23 Sep, 2001 4 commits
- 
- 
Peter Eisentraut authored
- 
Bruce Momjian authored
- 
Bruce Momjian authored
- 
Bruce Momjian authored
 
-