> -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
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 )