pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion about update syntaxt
2+ messages / 2 participants
[nested] [flat]
* Question about update syntaxt
@ 2005-04-29 15:08 Michael M Friedel <mfl@betty-tv.com>
0 siblings, 1 reply; 2+ messages in thread
From: Michael M Friedel @ 2005-04-29 15:08 UTC (permalink / raw)
To: pgsql-sql
I am trying to use an application (Through ODBC) that uses the
following update syntax
UPDATE MyTable SET MyTable.id=2 WHERE id=1
unfortunatly I get an error message
ERROR: column "mytable" of relation "mytable" does not exist
Question is, is ther something I can configure that will make
Postgresql accept these kind of statments ?
------------------------------------
Michael M Friedel
Research & Development
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Question about update syntaxt
@ 2005-04-30 03:51 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Michael M Friedel <mfl@betty-tv.com>
0 siblings, 0 replies; 2+ messages in thread
From: Stephan Szabo @ 2005-04-30 03:51 UTC (permalink / raw)
To: Michael M Friedel <mfl@betty-tv.com>; +Cc: pgsql-sql
On Fri, 29 Apr 2005, Michael M Friedel wrote:
> I am trying to use an application (Through ODBC) that uses the
> following update syntax
>
> UPDATE MyTable SET MyTable.id=2 WHERE id=1
>
> unfortunatly I get an error message
>
> ERROR: column "mytable" of relation "mytable" does not exist
>
> Question is, is ther something I can configure that will make
> Postgresql accept these kind of statments ?
I don't believe there's a way to make the server itself accept that. IIRC,
past discussions usually have bogged down into questions of whether to
support the syntax since it doesn't appear to be valid SQL and if so what
semantics to give cases where the tablename doesn't match. I'm not sure if
there's any way to get the ODBC driver to do something about it, however.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-30 03:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-29 15:08 Question about update syntaxt Michael M Friedel <mfl@betty-tv.com>
2005-04-30 03:51 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox