On Thu, Jul 2, 2009 at 1:25 AM, Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)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