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>
---------------------------------------------------------------------------
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 |