Skip site navigation (1) Skip section navigation (2)

Tree refresh bug possible.

From: Piotr Czekalski <pczekalski(at)techbaza(dot)pl>
To: pgadmin-support(at)postgresql(dot)org
Subject: Tree refresh bug possible.
Date: 2011-01-20 08:42:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
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 
- 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


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


pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-01-20 09:27:30
Subject: Re: Tree refresh bug possible.
Previous:From: Guillaume LelargeDate: 2011-01-20 07:41:33
Subject: Re: Issues with large message / history buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group