| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | pranav(at)babultech(dot)com, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Bug #766: version difference creates problem |
| Date: | 2002-09-14 15:46:11 |
| Message-ID: | 27200.1032018371@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>> select * from "inout" is working. but, such thing can not be done in my
>> web application as it is a java code and I can't afford to change all
>> the queries with table name change thoroughout the system.
> You're going to have to or be stuck with old versions forever.
Actually, it looks like "inout" is an unreserved keyword as of 7.2,
so his real mistake was not upgrading far enough ;-)
In general though, using words that are stated to be reserved by SQL99
as column or table names is a recipe for trouble in the long term...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pgsql-bugs | 2002-09-14 20:41:36 | Bug #767: Bug when inserting in "bytea" column type |
| Previous Message | Peter Eisentraut | 2002-09-14 13:53:49 | Re: Bug #766: version difference creates problem |