Re: Table whose name has Capital letters

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <jdavis(at)wasabimg(dot)com>
Cc: Gabriel Fernandez <gabi(at)unica(dot)edu>, pgsql-general(at)postgresql(dot)org
Subject: Re: Table whose name has Capital letters
Date: 2000-11-25 16:46:46
Message-ID: 659.975170806@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Davis <jdavis(at)wasabimg(dot)com> writes:
> The way it is supposed to work, everything should be
> case-insensitive. It should not matter whether you ask for nov2000 or
> Nov2000, it should be the same table, and should give you an error if
> you try to make both tables.

I am betting that he initially did CREATE TABLE "Nov2000", and is now
trying to access the table without using double quotes around its name.
Which won't work...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2000-11-25 17:20:51 Re: Table whose name has Capital letters
Previous Message Tom Lane 2000-11-25 16:44:25 Re: Sql-bench