Re: [BUGS] BUG #5171: Composite type with array does not translate in plpythonu

2009-11-09 Thread Peter Eisentraut
On Sun, 2009-11-08 at 16:33 -0500, Robert Haas wrote: > On Sat, Nov 7, 2009 at 5:23 AM, Peter Eisentraut wrote: > > On fre, 2009-11-06 at 17:29 +, Jason wrote: > >> When I have a plpythonu function returning a composite type that has an > >> array column, the function does not work when I try

Re: [BUGS] odd deadlock on CREATE TABLE AS SELECT

2009-11-09 Thread digitaldeath
Oh no, I thought my message was rejected and I reposted it in a slightly modified form.. 2009/11/9 Tom Lane : > It's not a bug. The CREATE TABLE AS SELECT is acquiring a read lock on > table "adc", and then the ALTER TABLE RENAME tries to upgrade that lock > to exclusive. If you've got some othe

Re: [BUGS] odd deadlock on CREATE TABLE AS SELECT

2009-11-09 Thread Greg Stark
On Mon, Nov 9, 2009 at 9:48 AM, digitaldeath wrote: > Everybody is doing SELECT only on "adc" table, so why deadlocks if there > are no write attempts on any row? Well the deadlock error does include the information about what queries deadlocked. In newer versions it includes the full text of the

Re: [BUGS] BUG #5128: Returning nested composite types in plpython

2009-11-09 Thread Robert Haas
On Tue, Oct 20, 2009 at 12:19 PM, wrote: > > The following bug has been logged online: > > Bug reference:      5128 > Logged by: > Email address:      landrevi...@deadtreepages.com > PostgreSQL version: 8.4 > Operating system:   FreeBSD > Description:        Returning nested composite types in pl

[BUGS] postgresql installing problems

2009-11-09 Thread Tim van Loon
hello, I have problems with installing postgresql 8.3 after following a few steps. He starts to install, but after a while I get the next error. "user could not be created. user account already exists" ?? I tried to uninstall everything and installed it again, but I got the same error regar

Re: [BUGS] postgresql installing problems

2009-11-09 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Nov 09, 2009 at 10:28:51PM +0100, Tim van Loon wrote: > > hello, > > I have problems with installing postgresql 8.3 t would be helpful if you provided some more details. As it is, you leave it to our crystal ball to come up with things as "w