Re: [pgadmin-support] Column names in view

2007-11-24 Thread Dave Page
> --- Original Message --- > From: "Raymond O'Donnell" <[EMAIL PROTECTED]> > To: Dave Page <[EMAIL PROTECTED]> > Sent: 24/11/07, 14:34:49 > Subject: Re: [pgadmin-support] Column names in view > > On 24/11/2007 14:25, Dave Page wrote: > >> --- Original Message --- > >> From: "Raym

Re: [pgadmin-support] Column names in view

2007-11-24 Thread Raymond O'Donnell
On 24/11/2007 14:25, Dave Page wrote: --- Original Message --- From: "Raymond O'Donnell" <[EMAIL PROTECTED]> I can send a dump of the database if it's any use - it's a development one, and so quite small (160kb zipped). Please do. Do you still want me to? - I can see now what's h

Re : [pgadmin-support] Column names in view

2007-11-24 Thread Laurent ROCHE
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), da

Re: Re : [pgadmin-support] Column names in view

2007-11-24 Thread Raymond O'Donnell
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 name

Re: [pgadmin-support] Column names in view

2007-11-24 Thread Dave Page
> --- Original Message --- > From: "Raymond O'Donnell" <[EMAIL PROTECTED]> > To: Pgadmin-Support > Sent: 24/11/07, 14:02:15 > Subject: [pgadmin-support] Column names in view > > Hi all, > > A funny one I see from time to timeI have one particular view which, > when I click "View d

Re: [pgadmin-support] Column names in view

2007-11-24 Thread Raymond O'Donnell
Apologies - I was too quick with the "Send" button. Full version follows: Hi all, A funny one I see from time to timeI 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

[pgadmin-support] Column names in view

2007-11-24 Thread Raymond O'Donnell
Hi all, A funny one I see from time to timeI 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 n