Thread: UPDATE problem
Hi all, I'm using Postgresql 7.3.4-9 Debian binaries and ODBC 8.00.01.01, on Windows 2003 Server. Using ODBC, when the instruction PREPARE "_PLAN586fbb8"(int4, int4) as UPDATE "public"."plano" SET "alunosInscritos"=$1 WHERE "oid" = $2;EXECUTE "_PLAN586fbb8"(40,1676937) I get the following error: ERROR: parser: parse error at or near "=$" at character 84 I changed from "alunosInscritos"=$1 to "alunosInscritos" = $1 and worked. Is there any workaround for this? Also, I thought, probably using an older version of ODBC driver could create a different SQL expression, but, when I tried to uninstall the driver from Add/Remove Programs, everything went ok, but on ODBC Data Sources -> Drivers, the driver still remains there. Then I installed 7.03.0200, but didn't write over the other driver? How can I deinstall the most recent driver and install an older one? Best regards, Luis Sousa
Any of the snapshots available have this problems solved? Luis Sousa wrote: > Hi all, > > I'm using Postgresql 7.3.4-9 Debian binaries and ODBC 8.00.01.01, on > Windows 2003 Server. > > Using ODBC, when the instruction > PREPARE "_PLAN586fbb8"(int4, int4) as UPDATE "public"."plano" SET > "alunosInscritos"=$1 WHERE "oid" = $2;EXECUTE "_PLAN586fbb8"(40,1676937) > > I get the following error: > ERROR: parser: parse error at or near "=$" at character 84 > > I changed from "alunosInscritos"=$1 to "alunosInscritos" = $1 and worked. > Is there any workaround for this? > > Also, I thought, probably using an older version of ODBC driver could > create a different SQL expression, but, when I tried to uninstall the > driver from Add/Remove Programs, everything went ok, but on ODBC Data > Sources -> Drivers, the driver still remains there. > Then I installed 7.03.0200, but didn't write over the other driver? > How can I deinstall the most recent driver and install an older one? > > Best regards, > Luis Sousa > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > >
Luis Sousa <llsousa@ualg.pt> writes:
> I'm using Postgresql 7.3.4-9 Debian binaries and ODBC 8.00.01.01, on
> Windows 2003 Server.
> I get the following error:
> ERROR: parser: parse error at or near "=$" at character 84
> I changed from "alunosInscritos"=$1 to "alunosInscritos" = $1 and worked.
> Is there any workaround for this?
Use PG 7.4 or later.
regards, tom lane
I'm using this version on my production server so and I'm not very confortable to upgrade right now. Is there any chance to implement this change on ODBC? Or, does version 7.00.xxx works without problems? Best regards, Luis Sousa Tom Lane wrote: >Luis Sousa <llsousa@ualg.pt> writes: > > >>I'm using Postgresql 7.3.4-9 Debian binaries and ODBC 8.00.01.01, on >>Windows 2003 Server. >> >> > > > >>I get the following error: >>ERROR: parser: parse error at or near "=$" at character 84 >> >> > > > >>I changed from "alunosInscritos"=$1 to "alunosInscritos" = $1 and worked. >>Is there any workaround for this? >> >> > >Use PG 7.4 or later. > > regards, tom lane > > > >
Hello, If you already have an existing PsqlOdbc instalation, you just need to copy the psqlodbc.dll file (version 7.03.0200) in the "%WINDOWS%\system32\" folder Regards Miguel Juan ----- Original Message ----- From: Luis Sousa To: pgsql-odbc@postgresql.org Sent: Thursday, March 31, 2005 4:13 PM Subject: Re: [ODBC] UPDATE problem Any of the snapshots available have this problems solved? Luis Sousa wrote: > Hi all, > > I'm using Postgresql 7.3.4-9 Debian binaries and ODBC 8.00.01.01, on > Windows 2003 Server. > > Using ODBC, when the instruction > PREPARE "_PLAN586fbb8"(int4, int4) as UPDATE "public"."plano" SET > "alunosInscritos"=$1 WHERE "oid" = $2;EXECUTE "_PLAN586fbb8"(40,1676937) > > I get the following error: > ERROR: parser: parse error at or near "=$" at character 84 > > I changed from "alunosInscritos"=$1 to "alunosInscritos" = $1 and worked. > Is there any workaround for this? > > Also, I thought, probably using an older version of ODBC driver could > create a different SQL expression, but, when I tried to uninstall the > driver from Add/Remove Programs, everything went ok, but on ODBC Data > Sources -> Drivers, the driver still remains there. > Then I installed 7.03.0200, but didn't write over the other driver? > How can I deinstall the most recent driver and install an older one? > > Best regards, > Luis Sousa > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org