[BUGS] 9.2 beta2 - pg_ctl crashes on Win32 when neither PGDATA nor -D specified

2012-06-10 Thread Edmund Horner
In 9.1, if I run "pg_ctl start" without providing way for it to find the datadir, it prints the error: C:\ehorner\pgsql-old\bin>pg_ctl start pg_ctl: no database directory specified and environment variable PGDATA unset Try "pg_ctl --help" for more information. In 9.2 (beta1 and beta2)

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 wrote: > On Fri, Jun 1, 2012 at 1:39 AM, Edmund Horner wrote: >> On 1 June 2012 12:36, Edmund Horner wrote: >>> On 1 June 2012 12:14, Edmund Horner wrote: I tried using an older libxml2.dll.  Replace with the one from ftp://ftp.zlatkovic.com/libxml/oldr

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 d

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

2012-06-10 Thread Kevin Grittner
[moving to -jdbc list with bcc to -bugs] wrote: > PostgreSQL version: 9.1.4 > java version "1.7.0_04" > Java(TM) SE Runtime Environment (build 1.7.0_04-b20) > Java HotSpot(TM) Client VM (build 23.0-b21, mixed mode) What PostgreSQL driver jar? -Kevin -- Sent via pgsql-bugs mailing list

[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 serial

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 extensio

[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 ta

[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" Java

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

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 tabl

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 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 dropped from t

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 tabl

[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 ch