Re: [HACKERS] [PATCHES] ALTER TABLE ... SET TABLESPACE

2004-06-21 Thread Gavin Sherry
I'm rewriting the patch so don't worry :-) Thanks, Gavin On Mon, 21 Jun 2004, Mark Kirkwood wrote: I don't know if this provides any more info than you already have - but is my last few lines from a single process backend run with valgrind : ==19666== Syscall param write(buf) contains

[HACKERS] email browser?

2004-06-21 Thread Santo Quartarone
What's the safest email browser? ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list

Re: [HACKERS] [PATCHES] ALTER TABLE ... SET TABLESPACE

2004-06-21 Thread Mark Kirkwood
I don't know if this provides any more info than you already have - but is my last few lines from a single process backend run with valgrind : ==19666== Syscall param write(buf) contains uninitialised or unaddressable byte(s) ==19666==at 0x404D94F8: __GI___libc_write (in /lib/libc-2.3.2.so)

Re: [HACKERS] email browser?

2004-06-21 Thread John Hansen
On Fri, 2004-06-18 at 22:47, Santo Quartarone wrote: What's the safest email browser? telnet mailserver.domain.tld 110 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail

[HACKERS] Stuff I'm working on

2004-06-21 Thread Christopher Kings-Lynne
Hi, Since I'm waiting for someone to comment on my last question about dump ordering for grant and owner statements, what I think I'll do is submit a patch first (to get in before feature freeze) that adds all the OWNER TO commands, docs and regression tests. It will also do RENAME and OWNER

[HACKERS] placeholder syntax

2004-06-21 Thread Abhijit Menon-Sen
PostgreSQL currently uses $1/$2 for placeholders in prepared statements. I'm writing something that may potentially submit queries to both Oracle and Postgres, and it seems Oracle doesn't accept this syntax. Someone on IRC said I could use ? for both Oracle and Postgres. It isn't entirely clear to

Re: [HACKERS] placeholder syntax

2004-06-21 Thread Tom Lane
Abhijit Menon-Sen [EMAIL PROTECTED] writes: Should Postgres accept ? as a placeholder? We think it's an operator character: regression=# select 1 ? 4; ERROR: operator does not exist: integer ? integer I count eighteen standard operators that would be broken if we changed '?' to mean a

Re: [HACKERS] Compile failure with SSL

2004-06-21 Thread Merlin Moncure
Dave Page wrote: OK, looks like the error below is a Win32 thing. The patch attached #ifdef'd out the permissions check on the private key file as it won't work under Windows anyway (a similar check in postmaster.c has has already been ifdef'd out for the same reason). Incidently, the

Re: [HACKERS] placeholder syntax

2004-06-21 Thread Greg Stark
Tom Lane [EMAIL PROTECTED] writes: Abhijit Menon-Sen [EMAIL PROTECTED] writes: Should Postgres accept ? as a placeholder? In short, I think this notation sucks and I don't want to emulate it. Certainly it sucks. Unfortunately it's the supported ODBC API which is emulated by everyone else,

Re: [HACKERS] placeholder syntax

2004-06-21 Thread Mike Mascari
Greg Stark wrote: Tom Lane [EMAIL PROTECTED] writes: Abhijit Menon-Sen [EMAIL PROTECTED] writes: Should Postgres accept ? as a placeholder? In short, I think this notation sucks and I don't want to emulate it. Certainly it sucks. Unfortunately it's the supported ODBC API which is emulated by

Re: [HACKERS] placeholder syntax

2004-06-21 Thread Thomas Hallgren
Personally, I agree. The '?' sucks for multiple reasons. The major reason being when you want to use the same parameter in more than one place in a statement. Another reason is query rewrites where you have to reorganize the actual order of parameters. You are then forced to first convert the '?'

[HACKERS] creating a cluster

2004-06-21 Thread Alexander Cohen
Does anyone have any new ways to create clusters without using initdb or bootstrap mode? I need to be able to create one without those 2 things. Any ideas? thanks! Alex ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [HACKERS] creating a cluster

2004-06-21 Thread Alvaro Herrera
On Mon, Jun 21, 2004 at 09:16:35PM -0400, Alexander Cohen wrote: Does anyone have any new ways to create clusters without using initdb or bootstrap mode? I need to be able to create one without those 2 things. Any ideas? initdb'ing somewhere else and copying the resulting directory? --

Re: [HACKERS] creating a cluster

2004-06-21 Thread Tom Lane
Alexander Cohen [EMAIL PROTECTED] writes: Does anyone have any new ways to create clusters without using initdb or bootstrap mode? I need to be able to create one without those 2 things. Any ideas? Perhaps you should explain *why* you think you need this? regards,