Re: pgAdmin bug? creating functions

Hi Michael,

> -----Original Message-----
> From: Michael Shapiro [mailto:mshapiro(at)ncsa(dot)edu]
> Sent: 14 November 2003 19:25
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] pgAdmin bug? creating functions
>
> If I create this function using psql, it works just fine.
> However, when I look at the function in PgAdmin, I see this
>
> create or replace function sss.doit(mytable)
>

I have just commited a fix to cvs that should resolve this, and allow
you to create functions with class type arguments and return types as
well. This should appear in the next snapshot release (these can be
found at http://snake.pgadmin.org/snapshots for various platforms -
Windows ones are created manually every now and again by Andreas).

> A similar problem occurs when creating triggers. If doit
> (above) were a trigger function (ie, returns trigger),
> PgAdmin lists it in the pulldown when creating the trigger,
> but when it tries to create the trigger, the following error occurs:
>
> ERROR: CreateTrigger: function doit() does not exist.

This already appears to be fixed.

> I think it might be a search path issue that the GUI isn't
> handling properly.

pgAdmin goes out of it's way to ignore the search path actually :-) It's
safer to prefix everything, some things just get missed though :-(

Thanks for the bug report.

Regards, Dave.