Jim Nasby writes:
> Is anyone opposed to some kind of hint?
Would depend on the text of the hint. I'm a bit dubious that we can
come up with something that's not wildly inappropriate in other scenarios.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-h
On 11/8/13 2:21 PM, Tom Lane wrote:
Jim Nasby writes:
Ahh, duh. Hrm... I ran across this because someone here got confused by this:
SELECT pg_total_relation_size( schema_name || '.' || relname ) FROM
pg_stat_all_tables
ERROR: relation "moo" does not exist
Personally I'd do that like
Jim Nasby writes:
> Ahh, duh. Hrm... I ran across this because someone here got confused by this:
> SELECT pg_total_relation_size( schema_name || '.' || relname ) FROM
> pg_stat_all_tables
> ERROR: relation "moo" does not exist
Personally I'd do that like
select pg_total_relation_si
On 11/7/13 6:41 PM, Tom Lane wrote:
Jim Nasby writes:
decibel@decina.cashnetusa=# SELECT 'Moo'::regclass;
ERROR: relation "moo" does not exist at character 8
That's doing what it's supposed to. Compare
regression=# select 'Moo'::regclass;
ERROR: relation "moo" does not exist
LINE 1: selec
Jim Nasby writes:
> decibel@decina.cashnetusa=# SELECT 'Moo'::regclass;
> ERROR: relation "moo" does not exist at character 8
That's doing what it's supposed to. Compare
regression=# select 'Moo'::regclass;
ERROR: relation "moo" does not exist
LINE 1: select 'Moo'::regclass;
^
On Fri, Nov 8, 2013 at 12:29 AM, Jim Nasby wrote:
> decibel@decina.cashnetusa=# SELECT 'Moo'::regclass;
> ERROR: relation "moo" does not exist at character 8
>
> Obviously in this example it doesn't matter, but this can definitely
> confuse users.
>
I would actually say *not* downcasing would b
psql (9.3.1)
Type "help" for help.
decibel@decina.cashnetusa=# SELECT 'Moo'::regclass;
ERROR: relation "moo" does not exist at character 8
Obviously in this example it doesn't matter, but this can definitely confuse
users.
Same in 9.1 and HEAD.
--
Jim Nasby, Lead Data Architect (512) 569-94
