Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

2008-02-18 Thread Juho Saarikko
Tom Lane wrote: Bruce Momjian <[EMAIL PROTECTED]> writes: Juho Saarikko wrote: While I didn't test, I'd imagine that this would also mean that any attempt to insert such values to an already unique column would fail. Works here in 8.3: test=> crea

Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

2008-02-18 Thread Kris Jurka
On Mon, 18 Feb 2008, Bruce Momjian wrote: Juho Saarikko wrote: While I didn't test, I'd imagine that this would also mean that any attempt to insert such values to an already unique column would fail. Works here in 8.3: test=> insert into test values (repeat('a', 5) || 'b');

[BUGS] BUG #3968: ssh tunnel instructions could use improvement

2008-02-18 Thread Faheem Mitha
The following bug has been logged online: Bug reference: 3968 Logged by: Faheem Mitha Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.11 Operating system: Debian etch Description:ssh tunnel instructions could use improvement Details: Hi, Currently http://w

[BUGS] BUG #3967: EXISTS clause on subquery

2008-02-18 Thread Bernard Le Jour
The following bug has been logged online: Bug reference: 3967 Logged by: Bernard Le Jour Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.3 Operating system: i386-apple-darwin8.9.1 Description:EXISTS clause on subquery Details: Please see the following SQL:

Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

2008-02-18 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Juho Saarikko wrote: >> While I didn't test, I'd imagine that this would also mean that any attempt >> to insert such values to an already unique column would fail. > Works here in 8.3: > test=> create table test (x text unique); > N

Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

2008-02-18 Thread Bruce Momjian
Juho Saarikko wrote: > While I didn't test, I'd imagine that this would also mean that any attempt > to insert such values to an already unique column would fail. Works here in 8.3: test=> create table test (x text unique); NOTICE: CREATE TABLE / UNIQUE will create implic

Re: [BUGS] BUG #3966: problem with implicit cast array parameter

2008-02-18 Thread Tom Lane
"Pawel Kasperek" <[EMAIL PROTECTED]> writes: > In PostgreSQL 8.2 I can call function: test_func(p1 text[]) as "PERFORM > test_func(ARRAY[0,1])". The server could be implicit cast array of integer > elements to array of text. In PostgreSQL 8.3 I have error: function > test_func(integer[]) does not

Re: [BUGS] BUG #3965: UNIQUE constraint fails on long column values

2008-02-18 Thread Gregory Stark
"Juho Saarikko" <[EMAIL PROTECTED]> writes: > It is propably impossible to fix this in a simple way, since it is an > inherent result of the underlying storage specification rather than a mere > programming error, so the documentation needs to be updated to warn about > this. Point taken. > I s

Re: [BUGS] Bug (#3484) - Missing pg_clog/0AE6

2008-02-18 Thread Zdenek Kotala
Alexandra Nitzschke napsal(a): We went on with analyzing: - the table was created at 2008/01/03 17:56h - the nightly dump started at 2008/01/03 22:00h - it tried to copy the table 'adresse_080103' at 22:00:08 - the dump crashed at 22:32:10 ( because of the error we reported 2007/12/14; we re

[BUGS] BUG #3966: problem with implicit cast array parameter

2008-02-18 Thread Pawel Kasperek
The following bug has been logged online: Bug reference: 3966 Logged by: Pawel Kasperek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: openSuse 10.3 Description:problem with implicit cast array parameter Details: In PostgreSQL 8.2 I can c

[BUGS] Bug (#3484) - Missing pg_clog/0AE6

2008-02-18 Thread Alexandra Nitzschke
We did some analyzing and found out some mysterious things. First we used the pg_check tool to analyze the table. The result is: # select pgcheck_page( 211593798 ); WARNING: relation 'adresse_080103', tuple (46,11): start of tuple is not aligned properly WARNING: relation 'adresse_080103', tu

[BUGS] BUG #3965: UNIQUE constraint fails on long column values

2008-02-18 Thread Juho Saarikko
The following bug has been logged online: Bug reference: 3965 Logged by: Juho Saarikko Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3RC2 Operating system: Linux Description:UNIQUE constraint fails on long column values Details: It is impossible to add an U