psql \dv+ shows view size as 0 bytes

Started by Peter Eisentrautover 12 years ago3 messages
#1Peter Eisentraut
peter_e@gmx.net

\dv+ shows the size of views as "0 bytes". This doesn't make any sense;
I think it should show null. Maybe this is even the fault of the
backend functions for returning a number to display in the first place.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#2Thom Brown
thom@linux.com
In reply to: Peter Eisentraut (#1)
Re: psql \dv+ shows view size as 0 bytes

On 4 June 2013 16:54, Peter Eisentraut <peter_e@gmx.net> wrote:

\dv+ shows the size of views as "0 bytes". This doesn't make any sense;
I think it should show null. Maybe this is even the fault of the
backend functions for returning a number to display in the first place.

It doesn't sound useful whether it's 0 or NULL in that output. Why
have the column in the first place when it can't have a value? Is it
somehow required for inclusion in the output of \d+ ?

--
Thom

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

#3Peter Eisentraut
peter_e@gmx.net
In reply to: Thom Brown (#2)
Re: psql \dv+ shows view size as 0 bytes

On 6/4/13 12:08 PM, Thom Brown wrote:

It doesn't sound useful whether it's 0 or NULL in that output. Why
have the column in the first place when it can't have a value? Is it
somehow required for inclusion in the output of \d+ ?

\dv is just a special case of \dvti...

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers