BUG #1481: ERROR: type tablename does not exist

From: "alagu madhu" <almadhu(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1481: ERROR: type tablename does not exist
Date: 2005-02-14 10:21:08
Message-ID: 20050214102108.9CBE0F0AC6@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1481
Logged by: alagu madhu
Email address: almadhu(at)yahoo(dot)com
PostgreSQL version: 8.0
Operating system: Redhat
Description: ERROR: type tablename does not exist
Details:

CREATE FUNCTION merge_fields(t_row tablename) RETURNS text AS $$
DECLARE
t2_row table2name%ROWTYPE;
BEGIN
SELECT * INTO t2_row FROM table2name WHERE ... ;
RETURN t_row.f1 || t2_row.f3 || t_row.f5 || t2_row.f7;
END;
$$ LANGUAGE plpgsql;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander M. Pravking 2005-02-14 12:10:13 ROLLBACK of SET TimeZone
Previous Message Magnus Hagander 2005-02-14 08:56:40 Re: BUG #1478: Upper function does not work