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

Re: BUG #1481: ERROR: type tablename does not exist

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: alagu madhu <almadhu(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1481: ERROR: type tablename does not exist
Date: 2005-02-14 18:24:39
Message-ID: 20050214182439.GA28267@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, Feb 14, 2005 at 10:21:08AM +0000, alagu madhu wrote:
> 
> Description:        ERROR:  type tablename does not exist
> Details: 
> 
> CREATE FUNCTION merge_fields(t_row tablename) RETURNS text AS $$

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/

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-02-14 18:46:29
Subject: Re: Bug in ALTER LANGUAGE ... RENAME TO ...;
Previous:From: Tom LaneDate: 2005-02-14 17:12:10
Subject: Re: BUG #1480: A wildcard for the listen address doesn't work

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