I am sorry. I didn't get you. Can u pls tell me more
Thanks
kumar
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Kumar" <[EMAIL PROTECTED]>
Cc: "psql" <[EMAIL PROTECTED]>
Sent: Tuesday, February 10, 2004 2:02
"Kumar" <[EMAIL PROTECTED]> writes:
> WARNING: plpgsql: ERROR during compile of fn_rowtypetest near line 0
> ERROR: cache lookup for type 0 of recurrences.pg.dropped.16...=
> . failed
PG 7.4 is a little better at dealing with dropped columns in plpgsql
rowtypes.
Dear Friends,
Postgres 7.3.4 on RH Linux 7.2
I am having an table name recurrence under the schema crm.
While I refer it as %rowtype I have error msgs.
CREATE OR REPLACE FUNCTION crm.fn_rowtypetest() RETURNS
varchar
AS'DECLARE rec_recurrence crm.recurrences%rowtype;BEGINFOR
rec_recurre
