PgSql

Postgres-R: primary key patches
Hi, as you might know, Postgres-R relies on primary keys to address tuples of a table. It cannot replicate tables without a primary key. Primary keys currently aren't really used within the executor, so I had to extended and modify Postgres here and there, to get the required information. To ease reviewing ... 22 Jul 2008 17:50

PATCH: CITEXT 2.0 v4
On Jul 15, 2008, at 22:23, David E. Wheeler wrote: * The README for citext 1.0 on pgFoundry says: I had to make a decision on casting between types for regular expressions and decided that if any parameter is of citext type then case insensitive applies. For example applying regular expr... 22 Jul 2008 17:50

ExecuteTruncate quirk: expects a unique list ofrelations
Nikhils wrote: Hi, Consider this simple case: postgres=# TRUNCATE foo, foo; ERROR: cannot TRUNCATE "foo" because it is being used by active queries in this session The above occurs because the ExecuteTruncate() function invokes truncate_check_rel() in a loop. Since the same table name ... 16 Jul 2008 13:00

autovacuum crash due to null pointer
There's a fairly interesting crash here: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=jaguar&dt=2008-07-16%2003:00:02 The buildfarm was nice enough to provide a stack trace at the bottom of the page, which shows clearly that autovac tried to pfree a null pointer. What I think happened was that the table tha... 17 Jul 2008 17:53

temp table problem
Hi, I have come across a problem. When you try to access a temp table created via SPI_EXEC, you get a table not found error. SPI_EXEC("CREATE TEMP TABLE my_temp_table(first_name text, last_name text)", UTILITY); SPI_EXEC("REVOKE ALL ON TABLE my_temp_table FROM PUBLIC", UTILITY); The second statement gener... 20 Jul 2008 12:28

gsoc, store hash index tuple with hash code only
A problem here is that _create_hash_desc is called many times to create a TupleDesc with int32 attribute. I've tried to implement the function like this , TupleDesc _create_hash_desc() { static bool firstcall = true; static TupleDesc tupdesc; if(firstcall){ tupdesc = CreateTemplateTupleDesc(... 16 Jul 2008 06:49

rfc: add pg_dump options to dump output
Is this a TODO item? --------------------------------------------------------------------------- Greg Smith wrote: On Tue, 3 Jun 2008, Tom Lane wrote: Well, the stuff included into the dump by pg_dump -v is informative, too. But we stopped doing that by default because of complaints. I re... 15 Jul 2008 21:36

Lookup penalty for VARIADIC patch
The proposed variadic-functions patch inserts some none-too-cheap code into FuncnameGetCandidates (it's deconstructing the proargmodes column to see if the function is variadic or not) which gets executed whether or not there are any variadic functions involved. I checked whether this would cause a noticeable slow... 16 Jul 2008 00:40

Postgres-R: current state of development
Hi, After having published the source code, I'd like to add some words about the current state of the project. Postgres-R is currently capable of replicating tuples via binary change sets, does proper conflict detection and prevention. It offers three different timing methods: sync, eager and lazy. Out of t... 16 Jul 2008 16:09

Core team statement on replication inPostgreSQL
Tom Lane wrote: Bruce Momjian <bruce(a)momjian.us> writes: Agreed. I realize why we are not zeroing those bytes (for performance), but can't we have the archiver zero those bytes before calling the 'archive_command'? The archiver doesn't know any more about where the end-of-data is than the a... 15 Jul 2008 19:33