Thread: Tree refresh bug possible.

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

Hi,

Le 20/01/2011 09:42, Piotr Czekalski a écrit :
> [...]
> 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
> 

Yeah, this is a known issue. I have quite some difficulties with this
one. But I'm working on it.

Thanks for your report.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com