Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: pg_migrator versus inherited columns
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
In response to
- Re: pg_migrator versus inherited columns at 2009-07-02 00:25:56 from Tom Lane
pgsql-hackers by date
Next: From: Bruce Momjian Date: 2009-07-02 01:32:19 Subject: Re: Query progress indication - an implementation Previous: From: Greg Stark Date: 2009-07-02 00:41:29 Subject: Re: single bit integer (TINYINT) revisited for 8.5