| Lists: | pgsql-bugs |
|---|
| From: | "Francisco Leovey" <fleovey(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4168: ECPG refuses datestyle SQL |
| Date: | 2008-05-14 19:06:03 |
| Message-ID: | 200805141906.m4EJ63oO033083@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4168
Logged by: Francisco Leovey
Email address: fleovey(at)yahoo(dot)com
PostgreSQL version: 8.3.1
Operating system: SuSE Linux 9.2
Description: ECPG refuses datestyle SQL
Details:
if you write
EXEC SQL SET datestyle TO SQL, DMY;
you get ERROR: syntax error at or near "SQL"
But
EXEC SQL SET datestyle TO Postgres, DMY;
works fine
| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Francisco Leovey <fleovey(at)yahoo(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: *****SPAM***** BUG #4168: ECPG refuses datestyle SQL |
| Date: | 2008-06-04 12:44:11 |
| Message-ID: | 20080604124411.GA16909@feivel.credativ.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On Wed, May 14, 2008 at 07:06:03PM +0000, Francisco Leovey wrote:
> if you write
> EXEC SQL SET datestyle TO SQL, DMY;
> you get ERROR: syntax error at or near "SQL"
>
> But
> EXEC SQL SET datestyle TO Postgres, DMY;
> works fine
Thanks for the report. I fixed it in CVS for 8.2, 8.3 and HEAD.
Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!