On Wed, Dec 01, 2004 at 06:07:34PM +0800, Andrew Thorley wrote:

> > Did you type the SQL statements and/or error messages instead
> > of cutting and pasting?
> 
> yes i C&P'ed the SQL code & error code.

But did you copy the error message associated with the SQL code you
copied, or did you copy some other error message?  I ask because
the function name in the error doesn't match the function name in
the INSERT statement.  Here's what I get when I execute the statements
in your message:

test=> CREATE TYPE qwerty_UDT AS (abc INT);
CREATE TYPE
test=> CREATE TABLE t (col1 qwerty_UDT);
CREATE TABLE
test=> INSERT INTO t (col1) Values (qwerty_UDT(123));
ERROR:  function qwerty_udt(integer) does not exist

You said the error you got was:

ERROR:  function test_x(integer) does not exist

The error is the same but the detail differs: your error refers
to test_x(integer) instead of qwerty_udt(integer).  So where is
test_x coming from?

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

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

Reply via email to