Re: [PATCHES] OS X shared memory documentation

2006-02-23 Thread Neil Conway
Jim C. Nasby wrote: Outstanding writeup! Mind if I post it in our knowledgebase at http://www.pervasivepostgres.com/instantkb13/? (Unless someone has a better idea of where this could go...) Some of this information should be added to the documentation on how to configure the shared memory lim

[PATCHES] vacuumlo nonstandard use of \\ in a string literal

2006-02-23 Thread Michael Fuhr
In 8.1 and HEAD, if a role has escape_string_warning enabled then vacuumlo elicits the following warning: WARNING: nonstandard use of \\ in a string literal at character 323 HINT: Use the escape string syntax for backslashes, e.g., E'\\'. How backward compatible should vacuumlo remain? This pa

Re: [PATCHES] vacuumlo nonstandard use of \\ in a string literal

2006-02-23 Thread Tom Lane
Michael Fuhr <[EMAIL PROTECTED]> writes: > How backward compatible should vacuumlo remain? This patch changes > the string to E'...' but other ways would be to use dollar quotes > or ESCAPE. In this particular case, a far better answer is to replace > ! strcat(buf, " AND s.nspname NOT L

[PATCHES] fix initdb -U

2006-02-23 Thread Andrew Dunstan
the attached patch makes initdb -U username work as advertised. Barring objection I will apply it to head and backpatch to 8.0 and 8.1 branches. I guess nobody uses this much, or we'd surely have had reports of breakage long before now. cheers andrew Index: src/bin/initdb/initdb.c ===

Re: [PATCHES] WIP: further sorting speedup

2006-02-23 Thread Jim C. Nasby
On Wed, Feb 22, 2006 at 10:18:48PM -0500, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > Stupid question... how are varlena's handled in Datum? > > The Datum is just a pointer into the original tuple in that case. That would still result in a speedup since you don't have to figu

Re: [PATCHES] WIP: further sorting speedup

2006-02-23 Thread Tom Lane
"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > On Wed, Feb 22, 2006 at 10:18:48PM -0500, Tom Lane wrote: >> The Datum is just a pointer into the original tuple in that case. > That would still result in a speedup since you don't have to figure out > where the field begins though, right? I'm curious

Re: [PATCHES] Summary table trigger example race condition

2006-02-23 Thread Jim C. Nasby
On Wed, Feb 22, 2006 at 06:50:32PM -0600, Jim C. Nasby wrote: > Ok, here's some *Uber Ugly* code I hacked together to do something > similar for a potential book project. It's based loosely on docbook. Ok, no, for real this time... it's at http://jim.nasby.net/sgmlcode/ Thanks to all that pointed

Re: [PATCHES] WIP: further sorting speedup

2006-02-23 Thread Jim C. Nasby
On Thu, Feb 23, 2006 at 01:15:32PM -0500, Tom Lane wrote: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > On Wed, Feb 22, 2006 at 10:18:48PM -0500, Tom Lane wrote: > >> The Datum is just a pointer into the original tuple in that case. > > > That would still result in a speedup since you don't hav