Re: trigger failed to identify the partions - Mailing list pgsql-sql

Sridhar Reddy Ratna wrote:
> 
>                         dateTable := coll_fp_subdtls_01;
> 
>             ELSE
> 
>                         dateTable := coll_fp_subdtls_02;


> ERROR:  column "coll_fp_subdtls_01" does not exist
> 
> ERROR: column "coll_fp_subdtls_01" does not exist


I think you missed the word "column" in the error message (easy to do,
you know you are naming tables). You've missed the quotes around the
partition-names so it's trying to find a column on a table that matches.
 dateTable := 'coll_fp_subdtls_01';


--  Richard Huxton Archonet Ltd