Quick Links

Any patch for delete and insert same row in a function ( transaction )

From:	MindTerm <mindterm(at)yahoo(dot)com>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	Any patch for delete and insert same row in a function ( transaction )
Date:	2001-12-05 10:37:03
Message-ID:	20011205103703.71878.qmail@web20201.mail.yahoo.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

Hi all,

Postgresql shows error message
"triggered data change violation on relation"
when trying to insert and delete same row ( same
primary key ) with in a function or transaction.

Does any solution available to solve this problem ?

Thx.

M.T.

__________________________________________________
Do You Yahoo!?
Buy the perfect holiday gifts at Yahoo! Shopping.
http://shopping.yahoo.com

In response to

Re: Memory exhausted in AllocSetAlloc(269039) at 2001-12-04 22:43:17 from Tom Lane

Responses

Re: Any patch for delete and insert same row in a function ( at 2001-12-05 18:14:47 from Stephan Szabo
Re: Any patch for delete and insert same row in a function ( transaction at 2001-12-05 18:16:36 from Bruce Momjian
Re: Any patch for delete and insert same row in a function ( transaction at 2001-12-05 18:17:05 from Bruce Momjian

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Dinesh Parikh	2001-12-05 12:07:11	Fw: Creating Postgres DB from Remote Machine
Previous Message	DI Hasenöhrl	2001-12-05 08:52:52	Re: make query faster??