Received: from asterix.hrz.tu-chemnitz.de (asterix.hrz.tu-chemnitz.de [134.109.132.84]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA84555 for ; Thu, 26 Aug 1999 20:43:06 -0400 (EDT) (envelope-from enrico.scholz@wirtschaft.tu-chemnitz.de) Received: from gkar.ultra.csn.tu-chemnitz.de (actually ultra.csn.tu-chemnitz.de) by asterix.hrz.tu-chemnitz.de with Local SMTP (PP); Fri, 27 Aug 1999 02:43:01 +0200 Received: (from ensc@localhost) by gkar.ultra.csn.tu-chemnitz.de (8.9.3/8.9.3) id CAA19269 for pgsql-sql@postgresql.org; Fri, 27 Aug 1999 02:43:00 +0200 Received: (from news@localhost) by gkar.ultra.csn.tu-chemnitz.de (8.9.3/8.9.3) id CAA19262 for ensc+MAILLIST; Fri, 27 Aug 1999 02:43:00 +0200 Path: not-for-mail Newsgroups: maillists.pgsql-sql Subject: Inheritance and DELETE Date: 27 Aug 1999 02:42:59 +0200 Lines: 57 Message-ID: NNTP-Posting-Host: kosh.ultra.csn.tu-chemnitz.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: gkar.ultra.csn.tu-chemnitz.de 935714579 19250 192.168.5.2 (27 Aug 1999 00:42:59 GMT) X-Complaints-To: enrico.scholz@wirtschaft.tu-chemnitz.de NNTP-Posting-Date: 27 Aug 1999 00:42:59 GMT User-Agent: Gnus/5.070095 (Pterodactyl Gnus v0.95) XEmacs/21.2 (Shinjuku) To: pgsql-sql@postgresql.org From: Enrico.Scholz@informatik.tu-chemnitz.de Hi, to represent objects of a filesystem I am using these tables: --------------------- CREATE TABLE fsObject -- an abstract filesystem-object ( fsOid serial, name text NOT NULL, parent int -- a directory id ); CREATE TABLE files ( ) INHERITS (fsObject); CREATE TABLE directory -- can be the parent of a fsObject ( ) INHERITS (fsObject); ---------------------- Because chapter 9 (Inheritance) of the "User Guide" the documentation is saying "Many of the commands that we have already discussed -- select, update and *delete* -- support this "*" notation...", I tried to handle the deletion of a directory with this rule: ---------------------- CREATE RULE chg_fsO_on_dir_delete AS ON DELETE TO directory DO DELETE FROM fsObject* WHERE parent = OLD.fsOid; ---------------------- But PostgreSQL is complaining with the message 'ERROR: parser: parse error at or near "*"' What is to correct syntax for the "*" in a DELETE-statement? Enrico -- eMail: enrico.scholz@wirtschaft.tu-chemnitz.de talk: ensc@ultra.csn.tu-chemnitz.de