[BUGS] BUG #4709: dump/restore introduces wrong CHECK constraint for inherited table

2009-03-17 Thread Andrey
The following bug has been logged online: Bug reference: 4709 Logged by: Andrey Email address: and...@ulab.ru PostgreSQL version: 8.3.6 Operating system: rhel-4-i386 Description:dump/restore introduces wrong CHECK constraint for inherited table Details: Assume we ha

Re: [BUGS] BUG #4709: dump/restore introduces wrong CHECK constraint for inherited table

2009-03-17 Thread Tom Lane
"Andrey" writes: > Assume we have 2 tables with additionally added CHECK constraints: > ... > ALTER TABLE ONLY t ADD CONSTRAINT type_eq_zero CHECK (type = 0); The way this is addressed in CVS HEAD is that such commands are forbidden: regression=# ALTER TABLE ONLY t ADD CONSTRAINT type_eq_zero CH

[BUGS] BUG #4710: Bug with sql functions, when using INSERT.. RETURNING .. statment

2009-03-17 Thread Oleg
The following bug has been logged online: Bug reference: 4710 Logged by: Oleg Email address: sero...@gmail.com PostgreSQL version: last stable Operating system: CentOS Description:Bug with sql functions, when using INSERT.. RETURNING .. statment Details: Example: C

[BUGS] BUG #4711: no mirror found in country selection for download

2009-03-17 Thread hanuman
The following bug has been logged online: Bug reference: 4711 Logged by: hanuman Email address: koppuravur...@gmail.com PostgreSQL version: 8.2-9.1.zip Operating system: windows Description:no mirror found in country selection for download Details: there is no mirro

Re: [BUGS] BUG #4711: no mirror found in country selection for download

2009-03-17 Thread Dave Page
On Tue, Mar 17, 2009 at 1:17 PM, hanuman wrote: > > The following bug has been logged online: > > Bug reference:      4711 > Logged by:          hanuman > Email address:      koppuravur...@gmail.com > PostgreSQL version: 8.2-9.1.zip > Operating system:   windows > Description:        no mirror fou

Re: [BUGS] BUG #4710: Bug with sql functions, when using INSERT.. RETURNING .. statment

2009-03-17 Thread Tom Lane
"Oleg" writes: > CREATE TABLE test (id BIGINT); > CREATE OR REPLACE FUNCTION test(in_row test) RETURNS bigint AS > $body$ > INSERT INTO test (SELECT $1.*) RETURNING id; > $body$ > LANGUAGE 'sql'; > WILL THROW: > ERROR: return type mismatch in function declared to return bigint This is imp

[BUGS] BUG #4712: Installing problems

2009-03-17 Thread Alexander
The following bug has been logged online: Bug reference: 4712 Logged by: Alexander Email address: alexan...@energy.at PostgreSQL version: latest Operating system: windows xp Description:Installing problems Details: i cant get by the password asked in the installer.