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, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Raymond O'Donnell <[EMAIL PROTECTED]> À : Pgadmin-Support <pgadmin-support@postgresql.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 which, 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 [EMAIL PROTECTED] --------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly _____________________________________________________________________________ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail