Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group