Re: [ADMIN] Reg:lo_open error..pls help me

2006-03-01 Thread Michael Fuhr
On Wed, Mar 01, 2006 at 11:03:12AM -0500, Tom Lane wrote: > "sandhya" <[EMAIL PROTECTED]> writes: > > But lo_open is returning -1(-ve value). > > Are you sure that's where it's failing? The fragment you showed looks > fine as far as it goes. The most likely bet is you forgot to wrap it in > a

Re: [ADMIN] Reg:lo_open error..pls help me

2006-03-01 Thread Tom Lane
"sandhya" <[EMAIL PROTECTED]> writes: > But lo_open is returning -1(-ve value). Are you sure that's where it's failing? The fragment you showed looks fine as far as it goes. The most likely bet is you forgot to wrap it in a transaction (BEGIN/COMMIT commands), but that would result in a failur

Re: [ADMIN] Reg:lo_open error..pls help me

2006-03-01 Thread Michael Fuhr
On Wed, Mar 01, 2006 at 05:48:51PM +0530, sandhya wrote: > Is it possible to use lo_open after creating the object while > the application is running? Yes, but that's off-topic for pgsql-admin. Try pgsql-interfaces or pgsql-general. -- Michael Fuhr ---(end of broadcast)