Received: from frithjof.reiner (qmailr@c51.dialin.tuwien.ac.at [192.35.243.61]) by hub.org (8.9.3/8.9.3) with SMTP id OAA57370 for ; Mon, 11 Oct 1999 14:59:25 -0400 (EDT) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 444 invoked by uid 500); 11 Oct 1999 11:55:49 -0000 From: "Albert REINER" Date: Mon, 11 Oct 1999 13:55:48 +0200 To: PostgreSQL-SQL Subject: DELETE/DROP and inheritance Message-ID: <19991011135548.A194@frithjof> Mail-Followup-To: PostgreSQL-SQL Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.6i Why don't DELETE and DROP work with the *-notation for inherited tables? I think they should, and I don't see why it should be difficult to implement (but I cannot, not being C-literate). albert=> create database tst; CREATEDB albert=> \c tst connecting to new database: tst tst=> create table a (id int4); CREATE tst=> create table b (id2 int4) inherits (a); CREATE tst=> delete from a*; ERROR: parser: parse error at or near "*" (here I would like to get "DELETE 0" instead) tst=> drop table a*; ERROR: parser: parse error at or near "a" (here I would like to get "DROP" instead) Bye, Albert. -- --------------------------------------------------------------------------- Post an / Mail to / Skribu al: Albert Reiner ---------------------------------------------------------------------------