| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Timothy(dot)Oliver(at)worldspan(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: postgres sql 7.1.1 |
| Date: | 2003-04-25 20:17:48 |
| Message-ID: | 29631.1051301868@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Timothy(dot)Oliver(at)worldspan(dot)com writes:
> select
> create_new_airline_itinerary(693666,'DL','1111','Y','ATL','MCI','2003-04-27
> 15:54:00','2003-04-27 19:54:00','HK1','NW','2222','Y')
> Error: ERROR: parser: parse error at or near "$9" (State:HY000,
> Native Code: 7)
I don't know what those "state" and "native code" notations are, but
I'll bet you have some middleware layer in there that is changing the
query in a way you're not aware of.
You might try turning on query logging in Postgres so you can see
exactly what's being sent to the server.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-04-25 20:24:10 | Re: 7.1 -> 7.3 migration timestamp problem |
| Previous Message | Tom Lane | 2003-04-25 20:16:00 | Re: 7.3.2 indexes in PL/PgSQL |