From: | Jon Lapham <lapham(at)extracta(dot)com(dot)br> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Odd rule behavior? |
Date: | 2001-08-29 17:27:49 |
Message-ID: | 3B8D2615.3070703@extracta.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello-
I'm receiving the following error message:
ERROR: Relation "log" with OID 3694127 no longer exists
When running the following script (a stripped-down version of what I'm
really doing, but it demostrates the behavior):
CREATE TABLE log (logid int4);
CREATE TABLE data (dataid int4);
CREATE RULE r_delete_data
AS ON DELETE TO data
DO DELETE FROM log WHERE logid=OLD.dataid;
CREATE RULE r_insert_data
AS ON INSERT TO data
DO INSERT INTO log (logid) VALUES (NEW.dataid);
INSERT INTO data (dataid) VALUES (1);
DROP TABLE log;
CREATE TABLE log (logid int4);
DELETE FROM data WHERE dataid=1;
My setup: linux v2.4.9, pg v7.1.2
Is this a bug? If this is *not* a bug in postgres, then any suggestions
on the right way to go about rebuilding the "log" table above? In my
real application, I've dropped and added some columns to "log" (changes
such that ALTER TABLE isn't able to help).
TIA, Jon
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham(at)extracta(dot)com(dot)br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2001-08-29 17:36:25 | Re: Re: Toast,bytea, Text -blob all confusing |
Previous Message | Arne Weiner | 2001-08-29 17:23:59 | Re: Hi |