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
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',
Alexandra Nitzschke napsal(a):
snip
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;
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 suggest
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 exist.
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 implicit
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
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:
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);
NOTICE:
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');
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= create
11 matches
Mail list logo
