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;

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Mon, Feb 14, 2005 at 10:21:08AM +0000, alagu madhu wrote:
Do you have a table or composite type named "tablename"? Your
example works for me in 8.0.1 if tablename and table2name both
exist.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings