DELETE/DROP and inheritance

From: "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
To: PostgreSQL-SQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: DELETE/DROP and inheritance
Date: 1999-10-11 11:55:48
Message-ID: 19991011135548.A194@frithjof
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
---------------------------------------------------------------------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-10-11 14:32:42 Re: [SQL] Questions about vacuum analyze
Previous Message Martin Dolog 1999-10-11 07:34:11 unsubscribe