X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0EB26D1B83D for ; Tue, 10 Feb 2004 09:44:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76528-10 for ; Tue, 10 Feb 2004 05:44:21 -0400 (AST) Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com [216.136.173.58]) by svr1.postgresql.org (Postfix) with SMTP id EFA4CD1D1A4 for ; Tue, 10 Feb 2004 05:44:18 -0400 (AST) Received: from unknown (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp014.mail.yahoo.com with SMTP; 10 Feb 2004 09:44:19 -0000 Message-ID: <01a301c3efba$8f023d30$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "Tom Lane" Cc: "psql" References: <006c01c3efa1$2379bde0$7502a8c0@hdsc.com> <10831.1076401948@sss.pgh.pa.us> Subject: Re: Error in declaring %rowtype for recurrence Date: Tue, 10 Feb 2004 15:14:59 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/98 X-Sequence-Number: 16789 I am sorry. I didn't get you. Can u pls tell me more Thanks kumar ----- Original Message ----- From: "Tom Lane" To: "Kumar" Cc: "psql" Sent: Tuesday, February 10, 2004 2:02 PM Subject: Re: [SQL] Error in declaring %rowtype for recurrence > "Kumar" 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. > > regards, tom lane