| From: | Jan Oksfeldt Jonasen <joj(at)northmann(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Error message: Ralation X does not have |
| Date: | 2003-08-06 14:06:12 |
| Message-ID: | 5.2.1.1.0.20030806144714.00b078c8@mail.northmann.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 :-)
Best regards
Jan Oksfeldt Jonasen
Northmann A/S
web: http://www.northmann.com
newsgroup: news:news.northmann.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-08-06 14:07:53 | Re: v7.4 on Windows ... (Was: Re: v7.4 Beta 1 Bundle ...) |
| Previous Message | Teodor Sigaev | 2003-08-06 13:54:28 | Re: tsearch2 on postgresql 7.3.4 |