Re: libpq lo_open errors when first action in connection - Mailing list pgsql-hackers

From Greg Sabino Mullane
Subject Re: libpq lo_open errors when first action in connection
Date
Msg-id 20ad65bfef22e12c10c6e18c19890c5c@biglumber.com
Whole thread Raw
In response to Re: libpq lo_open errors when first action in connection  (Alvaro Herrera <alvherre@surnet.cl>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> The problem is that LO descriptors are only valid for the
> duration of the transaction.

Thanks, that's it all right. I forgot to update the lo_ stuff
when we switched the autocommit mojo around a while back.

> I think you should make the func() method open a transaction,
> just like a query does.

Yep, that's the basic solution - for lo_creat. Thanks again.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200505130807
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFChJjdvJuQZxSWSsgRAgh9AKDBRlAjbDt4zcfqnvTuEq9Z4cBfygCgwes6
hJ0De8jAcMYKOrSUH3uGoZk=
=/ooS
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Do you have any objections on contributing your improvements of the PostgreSQL core back into the product?
Next
From: Russell Smith
Date:
Subject: Re: Catalog Security WAS: Views, views, views: Summary