Creating functions with pgAdmin III - Mailing list pgadmin-support

From Ian Freislich
Subject Creating functions with pgAdmin III
Date
Msg-id 7569.1070618080@za.uu.net
Whole thread Raw
Responses Re: Creating functions with pgAdmin III  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgadmin-support
Hi

I don't know if anyone has encountered this problem before.  I
couldn't find any reference to this on the list archives or FAQ.

I can't find the pseudo-type RECORD in the drop-down list of return
types so it is impossible to create functions like "CREATE OR REPLACE
FUNCTION foo (TEXT) RETURNS SET OF RECORD AS..." using the gui.

Currently I have to work around this by manually creating the
function shell from psql or using the query editor and then editing
the function body using pgAdmin.

I've tried pgAdmin 1.0.1 and 1.0.2 against postgreSQL-7.2.3, 7.3.3,
7.3.4 and 7.4 but none of the combinations work.

BTW, this is a _great_ tool which has helped our sysadmins and
junior developers quickly and easily administer, grasp the structure
of our databases and develop their own schemas.

Any ideas?

Ian


pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Error Message: ERROR: cache lookup of type 44822021 failed
Next
From: Chay Luna
Date:
Subject: SQL window hangs/errors upon close of approx. 3,000 recs