On Thu, Jul 2, 2009 at 1:25 AM, Tom Lane<t...@sss.pgh.pa.us> wrote: > > Hmm, 8.3 doesn't seem to recognize the syntax: > > regression=# alter table c add inherit p; > ERROR: type "p" does not exist > LINE 1: alter table c add inherit p; > ^
Oh I remember being caught by this myself. The above is trying to add a new column named "inherit". The syntax to add an inheritance parent is just "alter table c inherit p" -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers