[BUGS] BUG #6685: Concurrency fault in create table

2012-06-10 Thread mthornton
The following bug has been logged on the website: Bug reference: 6685 Logged by: Mark Thornton Email address: mthorn...@optrak.com PostgreSQL version: 9.1.4 Operating system: Ubuntu 12.04 Description: Executing create table child_a () inherits (parent) create table

Re: [BUGS] BUG #6685: Concurrency fault in create table

2012-06-10 Thread Craig Ringer
On 06/10/2012 06:25 PM, mthorn...@optrak.com wrote: The following bug has been logged on the website: Bug reference: 6685 Logged by: Mark Thornton Email address: mthorn...@optrak.com PostgreSQL version: 9.1.4 Operating system: Ubuntu 12.04 Description: Executing create

Re: [BUGS] BUG #6683: dropping a table with a serial column from an extension needs to explicitely drop the associated seq

2012-06-10 Thread Tom Lane
Craig Ringer ring...@ringerc.id.au writes: On 06/10/2012 06:14 AM, Tom Lane wrote: phb.e...@free.fr writes: When a table having a seial column has been created by a CREATE EXTENSION, and when this table is later dropped from the extension, the associated sequence must be also explicitely

Re: [BUGS] BUG #6685: Concurrency fault in create table

2012-06-10 Thread Tom Lane
mthorn...@optrak.com writes: The following bug has been logged on the website: Bug reference: 6685 Logged by: Mark Thornton Email address: mthorn...@optrak.com PostgreSQL version: 9.1.4 Operating system: Ubuntu 12.04 Description: Executing create table

Re: [BUGS] BUG #6685: Concurrency fault in create table

2012-06-10 Thread Mark Thornton
On 10/06/12 22:08, Tom Lane wrote: mthorn...@optrak.com writes: The following bug has been logged on the website: Bug reference: 6685 Logged by: Mark Thornton Email address: mthorn...@optrak.com PostgreSQL version: 9.1.4 Operating system: Ubuntu 12.04 Description: Executing

[BUGS] BUG #6684: An I/O error occured while sending to the backend

2012-06-10 Thread wbrana
The following bug has been logged on the website: Bug reference: 6684 Logged by: wbrana Email address: wbr...@gmail.com PostgreSQL version: 9.1.4 Operating system: Linux Description: I tried to post this to pgsql-jdbc, but it was blocked. java version 1.7.0_04

[BUGS] BUG #6686: plpgsql Can't assign a variable with the output of a SQL Sentence which is not a SELECT

2012-06-10 Thread stormbyte
The following bug has been logged on the website: Bug reference: 6686 Logged by: David Carlos Manuelda Email address: stormb...@gmail.com PostgreSQL version: 9.1.4 Operating system: Gentoo Linux Description: I will provide a really simple example: Suppose we have a

Re: [BUGS] BUG #6683: dropping a table with a serial column from an extension needs to explicitely drop the associated seq

2012-06-10 Thread Philippe BEAUDOIN
Craig Ringer a écrit : On 06/10/2012 06:14 AM, Tom Lane wrote: phb.e...@free.fr writes: When a table having a seial column has been created by a CREATE EXTENSION, and when this table is later dropped from the extension, the associated sequence must be also explicitely dropped from the

[Fwd: Re: [BUGS] BUG #6682: pg_dump and sequence values of serial columns for extension configuration tables]

2012-06-10 Thread Philippe BEAUDOIN
Sorry Tom, I forgot to include pgsql-bugs in the email list... Hi Tom, Thanks for your answer. Tom Lane a écrit : phb.e...@free.fr writes: When a table is registered as an extension configuration table and contains a serial column, the current value of the sequence associated to this

Re: [BUGS] BUG #6686: plpgsql Can't assign a variable with the output of a SQL Sentence which is not a SELECT

2012-06-10 Thread Kevin Grittner
wrote: CREATE OR REPLACE FUNCTION foo() RETURNS INTEGER AS $$ DECLARE dummy INTEGER; BEGIN dummy=(SELECT MAX(id) FROM test); -- VALID dummy=(UPDATE test SET i=i+10 RETURNING i); -- NOT VALID.. WHY? dummy=(INSERT INTO test(i) VALUES (10) RETURNING i); -- NOT VALID.. WHY? RETURN dummy;

Re: [BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-06-10 Thread Edmund Horner
On 9 June 2012 03:48, Dave Page dp...@pgadmin.org wrote: On Fri, Jun 1, 2012 at 1:39 AM, Edmund Horner ejr...@gmail.com wrote: On 1 June 2012 12:36, Edmund Horner ejr...@gmail.com wrote: On 1 June 2012 12:14, Edmund Horner ejr...@gmail.com wrote: I tried using an older libxml2.dll.  Replace