Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Pgadmin Hackers > Re: Sup****t of...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 11 Topic 4686 of 4873
Post > Topic >>

Re: Sup****t of INHERIT in existing tables (8.2+ releases)

by dpage@[EMAIL PROTECTED] ("Dave Page") Jul 14, 2008 at 09:21 AM

On Fri, Jul 11, 2008 at 11:30 PM, Guillaume Lelarge
<guillaume@[EMAIL PROTECTED]
> wrote:

> So, here is a patch to add sup****t on adding inherited tables on already
> existing tables. The feature is available since PostgreSQL 8.2 release.
>
> Tested on Linux. It works fine there. I didn't check Win32 platform
because
> I didn't change any xrc files :) Didn't check on Mac OS X either cause I
> don't have one (btw, I'm following ebay's Mac Mini list to get one
soon).

Hmm, testing on 8.3.3 on Windows, I created parent and child table,
then tried to add parent to child's inherit list separately and got:

ERROR:  syntax error at or near "from"
LINE 1: ALTER TABLE child ADD COLUMN id Inherited from table ...

The actual SQL generated is:

ALTER TABLE child ADD COLUMN id Inherited from table parent;
ALTER TABLE child INHERIT parent;

Shouldn't it just be doing:

ALTER TABLE child INHERIT parent;


-- 
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com

-- 
Sent via pgadmin-hackers mailing list (pgadmin-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
 




 11 Posts in Topic:
Support of INHERIT in existing tables (8.2+ releases)
guillaume@[EMAIL PROTECTE  2008-07-12 00:30:48 
Re: Support of INHERIT in existing tables (8.2+ releases)
dpage@[EMAIL PROTECTED]   2008-07-12 01:33:33 
Re: Support of INHERIT in existing tables (8.2+ releases)
dpage@[EMAIL PROTECTED]   2008-07-14 09:21:44 
Re: Support of INHERIT in existing tables (8.2+
guillaume@[EMAIL PROTECTE  2008-07-14 10:49:05 
Re: Support of INHERIT in existing tables (8.2+
guillaume@[EMAIL PROTECTE  2008-07-14 21:09:00 
Re: Support of INHERIT in existing tables (8.2+ releases)
dpage@[EMAIL PROTECTED]   2008-07-15 11:30:25 
Re: Support of INHERIT in existing tables (8.2+
guillaume@[EMAIL PROTECTE  2008-08-10 19:55:07 
Re: Support of INHERIT in existing tables (8.2+ releases)
dpage@[EMAIL PROTECTED]   2008-08-11 09:44:16 
Re: Support of INHERIT in existing tables (8.2+
guillaume@[EMAIL PROTECTE  2008-08-11 14:50:09 
Re: Support of INHERIT in existing tables (8.2+ releases)
dpage@[EMAIL PROTECTED]   2008-08-11 13:53:18 
Re: Support of INHERIT in existing tables (8.2+
guillaume@[EMAIL PROTECTE  2008-08-11 15:02:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 22:44:09 CST 2008.