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

Reply via email to