Question about update syntaxt

From: Michael M Friedel <mfl(at)betty-tv(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Question about update syntaxt
Date: 2005-04-29 15:08:18
Message-ID: 5BD9C777-3A63-4A00-8B4B-F1BB5C230893@betty-tv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tornroth, Phill 2005-04-29 16:13:25 multi-column unique constraints with nullable columns
Previous Message Rainer J. H. Brandt 2005-04-29 07:47:25 Re: Postgres 8.0.1 on Solaris 10 Sparc: library -lgcc_s: not