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. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
