Re: Re : Column names in view

On 24/11/2007 14:15, Laurent ROCHE wrote:
> The only time when I have seen this (including for views), is when a 
> data window has been opened then the data linked object (table or view) 
> has been re-created(i.e. drop + create) then when doing a refresh on the 
> data window, I don't see the colum names any more (even if they are 
> identical), data is displayed OK though ... I always thought of this as 
> a "feature" ! ;-)

D'you know, that might have been it....while I wasn't keeping the data 
window open, I didn't refresh the view definition in the tree view 
either - I tried dropping and re-creating the view (I'm still tinkering 
with it), then highlighted its node in the tree view and hit F5, then 
clicked "View data" - and the column names appeared!

So it seems that to see the columns I need to refresh pgAdmin's 
understanding of the view whenever I drop/recreate it.

> Have a good weekend,

You too, and thanks for the pointer.

Ray.


---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------