Re: [GENERAL] 8.1 Table partition and getting error

2010-10-07 Thread Igor Neyman
> -Original Message- > From: AI Rumman [mailto:rumman...@gmail.com] > Sent: Thursday, October 07, 2010 7:07 AM > To: pgsql-general General > Subject: 8.1 Table partition and getting error > > I am using POstgreql 8.1. > > I create table partition as follows: > alter table crm rename t

[GENERAL] 8.1 Table partition and getting error

2010-10-07 Thread AI Rumman
I am using POstgreql 8.1. I create table partition as follows: alter table crm rename to crm_bak; CREATE TABLE crm ( crmid integer NOT NULL, description text, deleted integer NOT NULL DEFAULT 0 ) WITHOUT OIDS; ALTER TABLE crm OWNER TO vcrm; create table crm_deleted ( check ( deleted = 1 )