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

Re : Column names in view

From: Laurent ROCHE <laurent_roche(at)yahoo(dot)com>
To: rod(at)iol(dot)ie, Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re : Column names in view
Date: 2007-11-24 14:15:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
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" ! ;-)

Have a good weekend,
The Computing Froggy

----- Message d'origine ----
De : Raymond O'Donnell <rod(at)iol(dot)ie>
À : Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>
Envoyé le : Samedi, 24 Novembre 2007, 15h02mn 15s
Objet : [pgadmin-support] Column names in view

Hi all,

A funny one I see from time to time....I have one particular view
when I click "View data", doesn't show up the column names in pgAdmin. 
It (pgAdmin) shows the names in two other views in the same database 
without any problem.

SELECTing from the view in psql shows the column names, as does 
SELECTing in the query tool.

There's nothing special about this view that I can see - it joins 5 
tables together, and one column is calculated in the view (and given an
alias also).

I can send a dump of the database if it's any use - it's a development 
one, and so quite small (160kb zipped).

Anyone else see this? I'm using pgAdmin 1.8 on Windows XP SP2, and PG 
8.2.5 on the same machine. I seem to recall a bug along these lines in 
an earlier version of pgAdmin

Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland

---------------------------(end of
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo(at)postgresql(dot)org so that
       message can get through to the mailing list cleanly

Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail 


pgadmin-support by date

Next:From: Raymond O'DonnellDate: 2007-11-24 14:25:03
Subject: Re: Re : Column names in view
Previous:From: Raymond O'DonnellDate: 2007-11-24 14:06:27
Subject: Re: Column names in view

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