Re: Error message: Ralation X does not have

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