Re: [HACKERS] options in conninfo

2005-03-14 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
 Using libpq PQconnect function, what is the syntax for the 'options' 
 entry in the conninfo?

I think it's stuck straight into the backend command line, so whatever
you read in the 'postgres' reference page applies.

 I think the docs should be updated to give an example..

Send a patch...

regards, tom lane

---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [HACKERS] options in conninfo

2005-03-14 Thread Christopher Kings-Lynne
Using libpq PQconnect function, what is the syntax for the 'options' 
entry in the conninfo?

I think it's stuck straight into the backend command line, so whatever
you read in the 'postgres' reference page applies.
Oh, I thought it was for setting GUCs at connect time.  Is that 
possible? I thought it was in the new protocol, but I just cannot find 
the docs on it...

Chris
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send unregister YourEmailAddressHere to [EMAIL PROTECTED])


Re: [HACKERS] options in conninfo

2005-03-14 Thread Tom Lane
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
 Using libpq PQconnect function, what is the syntax for the 'options' 
 entry in the conninfo?

 I think it's stuck straight into the backend command line, so whatever
 you read in the 'postgres' reference page applies.

 Oh, I thought it was for setting GUCs at connect time.  Is that 
 possible? I thought it was in the new protocol, but I just cannot find 
 the docs on it...

No, the 'options' thing is exceedingly ancient.  Try something like
PGOPTIONS=-fn psql mydb
or equivalently
PGOPTIONS=-c enable-mergejoin=false psql mydb

The GUC-at-connect-time feature is new in the V3 protocol.  Offhand I do
not think libpq exposes that to its users; it does use it internally
IIRC.

regards, tom lane

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


[HACKERS] options in conninfo

2005-03-13 Thread Christopher Kings-Lynne
Hi,
Using libpq PQconnect function, what is the syntax for the 'options' 
entry in the conninfo?  I think the docs should be updated to give an 
example..

http://www.postgresql.org/docs/8.0/interactive/libpq.html#LIBPQ-CONNECT
Thanks,
Chris
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings