Hello PgAdmin Team and Users,
It seems like there is a minor bug in tree refresh (PgAdmin 1.12.1 and
earlier) when working on PL/PGSQL functions.
The client OS is Win 7 x64 Ultimate, server 8.4 running Fedora 12 x86_64
and 9.0.1 running W2K8R2.
When one changes function arguments and/or result (which leads to DROP
and CREATE)m the first refresh of the tree results in disappearing of
the function, second refresh shows up new one.
Details below.
The steps to reproduce behavior:
- write and compile some plpgsql functions (here is about 16 I'm working
on, located in the dedicated schema) using Query window,
- open PgAdmin and navigate tree towards a list of functions, expand it.
- using Query window (or any other third party application) modify
function by changing it's list argument type and/or return value type
(at least one type change is essential chere) which leads to DROP and
reCREATE
- refresh function list in PgAdmin (modified function should disappear,
but it do exists on the database)
- refresh once more - a function with modified argument / return type is
visible again
Regards
Piotr Czekalski
--
--------------------------------------------------------------
"TECHBAZA.PL" Sp. z o.o.
Technologie WEB, eDB& eCommerce
Oddział Gliwice
ul. Chorzowska 50
44-100 Gliwice
tel. (+4832) 7186081
fax. (+4832) 7003289