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