Thread: DELETE/DROP and inheritance

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
(idint4);   CREATE   tst=> create table b (id2 int4) inherits (a);   CREATE   tst=> delete from a*;   ERROR:  parser:
parseerror 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@tph.tuwien.ac.at>
 
---------------------------------------------------------------------------

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

We have a number of "inheritance" items on our TODO list.  They just
haven't been high priority for anyone.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026