[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 o

[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 param

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 everyo

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 ev

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 '?' i

[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? -- A

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