Re: BUG #1373: constraints, rules

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bazsi" <bazsi(at)jonapot(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1373: constraints, rules
Date: 2005-01-09 16:44:15
Message-ID: 27619.1105289055@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Bazsi" <bazsi(at)jonapot(dot)hu> writes:
> PostgreSQL version: 7.2.2
> ...
> If i want to delete this record from the folder table, then the server
> terminate abnormally (sigterm).

I tried to reproduce this in current versions (7.2.6, 7.3.7, etc)
and could not. So either it was fixed long ago, or you weren't
sufficiently clear about exactly how to trigger the crash. What
I substituted for the above handwaving was

SELECT * FROM folder;

UPDATE folder SET name = 'z' where name = 'teszt';

SELECT * FROM folder;

DELETE FROM folder WHERE name = 'z';

SELECT * FROM folder;

DELETE FROM folder;

SELECT * FROM folder;

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tony Caduto 2005-01-09 17:15:56 Re: BUG #1375: Problem with Dollar qouting functions
Previous Message Theodore Petrosky 2005-01-09 14:49:27 not a bug but where do i go for info