Re: [SQL] trigger failed to identify the partions

2009-09-09 Thread Sridhar Reddy Ratna
Sridhar ratna -Original Message- From: [email protected] [mailto:[email protected]] On Behalf Of Richard Huxton Sent: Wednesday, September 09, 2009 3:35 PM To: Sridhar Reddy Ratna Cc: [email protected] Subject: Re: [SQL] trigger failed to

[SQL] trigger failed to identify the partions

2009-09-09 Thread Sridhar Reddy Ratna
Hi all, I have created a table and partitions as below. CREATE TABLE coll_fp_submission_details ( rrid numeric NOT NULL, sid numeric NOT NULL, pfid numeric NOT NULL, "timestamp" date NOT NULL, schema_version numeric NOT NULL, details character varying NOT NULL, app_