Re: trigger failed to identify the partions

From: Richard Huxton <dev(at)archonet(dot)com>
To: Sridhar Reddy Ratna <sridhar(dot)ratna(at)cmcltd(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: trigger failed to identify the partions
Date: 2009-09-09 10:05:11
Message-ID: 4AA77DD7.5040908@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sridhar Reddy Ratna 2009-09-09 11:05:42 Re: trigger failed to identify the partions
Previous Message Sridhar Reddy Ratna 2009-09-09 09:26:51 trigger failed to identify the partions