Re: Column names in view

Поиск
Список
Период
Сортировка
Искать

Re: Column names in view

От:
"Dave Page" <dpage@postgresql.org>
Дата:


> ------- Original Message -------
> From: "Raymond O'Donnell" 
> 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 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).

How odd.

> 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.

/D

Re: Column names in view

От:
"Dave Page" <dpage@postgresql.org>
Дата:


> ------- Original Message -------
> From: "Raymond O'Donnell" 
> To: Dave Page 
> 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: "Raymond O'Donnell" 
> 
> >> 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 happening.

No thanks - the effect will get lost in the dump/reload anyway from the sound of it.

/D

Column names in view

От:
Raymond O'Donnell <rod@iol.ie>
Дата:
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
rod@iol.ie
---------------------------------------------------------------

Re: Column names in view

От:
Raymond O'Donnell <rod@iol.ie>
Дата:
Apologies - I was too quick with the "Send" button. Full version follows:

--------

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, but I thought it had been fixed. I
couldn't find the reference in the archives.

Thanks,

Ray.


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

Re: Column names in view

От:
Raymond O'Donnell <rod@iol.ie>
Дата:
On 24/11/2007 14:25, Dave Page wrote:
>> ------- Original Message -------
>> From: "Raymond O'Donnell" 

>> 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 happening.

Ray.


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