Re: The bugs are getting harder to find...

Hi Donald

-----Original Message-----
From: Donald Fraser [mailto:demolish(at)cwgsy(dot)net]
Sent: 17 December 2002 16:54
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] The bugs are getting harder to
find...


pgAdmin: 1.4.12
PostgreSQL: 7.3
OS: W2K SP2

1)
Edit a view and you loose any comments that you have made about
it. Have not tested this but it probably means that you loose any rules
that you have made too which is even worse!

You don't lose the comments, it just doesn't refresh the cache to get
the new ones (fixed in the latest snapshot). You are right about the
rules though, but a warning is given and the user is given the option to
abort. I have reworded the warning in the snapshot though as it was
definately a 2AM one!! The real fix for this is substantial work which I
probably won't do for 2 reasons - I'm concentrating on pgAdmin III now,
and I expect create or replace view to be added to PostgreSQL 7.4.

2)
Trigger functions that take parameters show up as ??????? and
not the text typed. For example CREATE TRIGGER trig_btrim_cap BEFORE
INSERT OR UPDATE ON public.tbl_country FOR EACH ROW EXECUTE PROCEDURE
btrim_cap('s_name'); is shown by pgAdmin as CREATE TRIGGER
trig_btrim_cap BEFORE INSERT OR UPDATE ON public.tbl_country FOR EACH
ROW EXECUTE PROCEDURE btrim_cap(??????? which is not what was
originally entered.
Obviously I have first created a function named btrim_cap:
CREATE FUNCTION public.btrim_cap() RETURNS trigger AS 'util_funcs.so'
LANGUAGE 'c' VOLATILE; I think pgAdmin is trying to do something smart
and recognise the data types for the functions available.

I need to look into this one in more detail. Unfortunately I'm quite
busy at the moment but leave it with me.

3)
Leading on from bug 2) exposes another annoying bug. pgAdmin
doesn't report the loadable module that contains the function.
When I create a function that is found in a loadable library
e.g. CREATE FUNCTION public.btrim_cap() RETURNS trigger AS
'util_funcs.so' LANGUAGE 'c' VOLATILE; pgAdmin always returns the
statement without the loadable module e.g. CREATE FUNCTION
public.btrim_cap() RETURNS trigger AS 'btrim_cap' LANGUAGE 'c' VOLATILE;

That's the best info we can get from the PostgreSQL catalogues. It only
stores the module name in the compiled binary code for the function
which we can't easily decode client side :-(

Regards, Dave.