Ruslan A Dautkhanov <[EMAIL PROTECTED]> writes:
> I have sometimes (rarely, once per some days) error during
> executting different queries in PostgreSQL:
> ERROR: Can't serialize access due to concurrent update
> All my transactions use
> SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
If y
Hello all,
I have sometimes (rarely, once per some days) error during
executting different queries in PostgreSQL:
ERROR: Can't serialize access due to concurrent update
All my transactions use
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
I can't found nothing about this problem in the h
"CN" <[EMAIL PROTECTED]> writes:
> db1=# update tt1 set remark ='xx';
> ERROR: Cannot insert a duplicate key into unique index tt2_pkey
The attached patch against 7.3 fixes it.
regards, tom lane
*** src/backend/optimizer/prep/prepunion.c.orig Wed Sep 18 17:35:21 2002
---
[EMAIL PROTECTED] writes:
> pg_dump segfault when using the option -Ft to make a tar file.
Does your database contain any views with comments?
If not, this is not a known bug, and you'll need to provide more detail.
regards, tom lane
---(end of b
"CN" <[EMAIL PROTECTED]> writes:
> db1=# update tt1 set remark ='xx';
> ERROR: Cannot insert a duplicate key into unique index tt2_pkey
This example works okay in 7.2.3. I think I broke it in 7.3 while
fixing another problem :-(. Will work on it.
regards, tom lane
Håkon Clausen ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
pg_dump segfaults
Long Description
pg_dump segfault when using the option -Ft to make a tar file.
> pg_dump -Ft rofus
Segmentation fault
I'm running PostgreSQL-7.3
Hello! Could you check the following testing results and questions?
Thank you!
CN
CREATE TABLE tt1 (
f1 INTEGER PRIMARY KEY
)WITHOUT OIDS;
CREATE TABLE tt2 (
PRIMARY KEY (f1,f2),
f2 INTEGER,
f3 VARCHAR(80)
)
INHERITS (tt1)
WITHOUT OIDS;
db1=# insert into tt2 values(1,1,'
