Skip site navigation (1) Skip section navigation (2)

Re: rules

From: "Jie Liang" <jie(at)stbernard(dot)com>
To: "Jie Liang" <jie(at)stbernard(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "postgres-list" <pgsql-admin(at)postgresql(dot)org>,<pgsql-sql(at)postgresql(dot)org>
Subject: Re: rules
Date: 2004-05-19 17:41:57
Message-ID: E7E213858379814A9AE48CA6754F5ECB1E1FCA@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
Sorry, wrong question.

-----Original Message-----
From: Jie Liang 
Sent: Wednesday, May 19, 2004 10:20 AM
To: Tom Lane
Cc: postgres-list; pgsql-sql(at)postgresql(dot)org
Subject: [ADMIN] rules


According to the document of rule:

CREATE RULE rulename AS ON delete TO mytablename DO
(
delete from aaa where id=OLD.id;
Delete from bbb where id=OLD.id;
Delete from ccc where id=OLD.id
);


Should work, but it doesn't, what wrong with it?
Even I use { .... }

Jie Liang

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
      joining column's datatypes do not match

pgsql-admin by date

Next:From: Stephan SzaboDate: 2004-05-19 17:50:34
Subject: Re: [SQL] rules
Previous:From: Tony ReinaDate: 2004-05-19 17:25:18
Subject: Re: Postgresql ssl mode

pgsql-sql by date

Next:From: Stephan SzaboDate: 2004-05-19 17:50:34
Subject: Re: [SQL] rules
Previous:From: Martin KnipperDate: 2004-05-19 17:41:21
Subject: Re: Function valid only for one table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group