BUG #1481: ERROR: type tablename does not exist - Mailing list pgsql-bugs

From alagu madhu
Subject BUG #1481: ERROR: type tablename does not exist
Date
Msg-id 20050214102108.9CBE0F0AC6@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1481: ERROR: type tablename does not exist  (Michael Fuhr <mike@fuhr.org>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1481
Logged by:          alagu madhu
Email address:      almadhu@yahoo.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;

pgsql-bugs by date:

Previous
From: "Glen"
Date:
Subject: BUG #1480: A wildcard for the listen address doesn't work
Next
From: Adrian Plohn
Date:
Subject: Bug #1451