Re: [pgadmin-support] Creating functions with pgAdmin III

[Andreas Pflug]

Michael Shapiro wrote:

The list in the pulldown is in a random order, especially srt
to the list of tables in mutilple schemas. It woudld be nice
if the list was ordered with builtin types listed first, then
each table within each schema listed next. Within each of the
builtin, and schemas the list would be alphabetical:
 

Actually it isn't random, but the sort order might not be what you 
expect. It looks like (regard as meta code)
ORDER BY isdomain, isArray, typname


I would even be great if the various columns could somehow be
accessible as well (although that would make too large a list if
put all in one pulldown)
 

I'm not too happy about the current combobox implementation; this should 
be rewritten in a menu/submenu or tree style.

Also, I reported a bug in that if the return type is a table type
pgadmin fails to include the schema when extracting the ddl.
 

Nearly lost it... I added it to BUGS.txt now. We might need to refactor 
the code a little bit, that's why I don't fix it instantly.

Regards,
Andreas


---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

Re: [pgadmin-support] Creating functions with pgAdmin III

[Ian Freislich]

Andreas Pflug wrote:
> Ian Freislich wrote:
> 
> >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.
> >  
> >
> Not all 'p' types are allowed as return types for functions, but 
> apparently the list was too restricted.
> I expanded the list (to be precise: allow all for certain exceptions), 
> committed to cvs.

Thanks.  That will fix all the niggles for us.

Beigin new to this list, is there a place where I could suggest
functionality (I have one nice to have request on low priority for
the developers which would make pgAdmin a TOAD equivalent for
PostgreSQL for us)?

Ian

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