From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Jan Oksfeldt Jonasen <joj(at)northmann(dot)com> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error message: Ralation X does not have |
Date: | 2003-08-06 14:39:11 |
Message-ID: | 20030806143911.GC6743@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Aug 06, 2003 at 03:06:12PM +0100, Jan Oksfeldt Jonasen wrote:
> At 01:40 PM 8/6/2003, Peter Eisentraut wrote:
> >You need to double-quote the names or they will be converted to lower
> >case.
> >
>
> Thank you both. The reason why the initial table creation have quoted
> columns names is that it's generated by a program we use for schema
> creation. I'm currently adding to it so it can support Postgres too and the
> way columns are set up was more or less copied from the MS Sql
> implementation.
>
> I'm really not used to databases being so case sensitive, neither Oracle or
> MS Sql Server is that, but I'll keep this thing in mind moving along. Quite
> impressed with the response time, or maybe it was just a too easy question
> :-)
Well, it's only case-sensetive if you ask for it, ie by quoting. The basic
rule is:
Either always quote or never quote.
Always quote = case-sensetive
Never quote = case-insensetive
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-06 14:45:55 | Re: tsearch2 on postgresql 7.3.4 |
Previous Message | Franco Bruno Borghesi | 2003-08-06 14:37:20 | Re: How to do? |