Provide full definitions for everything you're discussing.
I've worked with this issue a lot, it might be apparent.
-Peter
Peter T. Bense
Advanced Teradata Certified Professional V2R5
(ptbense@gwm.sc.edu) - 803-777-9476
Database Administrator
Prevention Research Center
University of South Carolina
>>> "Agnelo Roneberg" <aroneberg@bergfone.com> 09/06/06 2:53 AM >>>
Hi,
I've done (again) some googling but I was not able to find a solution.
My view has 2 tables but only one is to be updated.
Some posts point that the ctid field has to be in the view definition,
but pg give me an error when I am try to include the ctid from one of
the tables
I would be thankful if someone can point me some concrete posts or
solutions.
Best regards,
A Roneberg
-----Original Message-----
From: Peter Bense [mailto:ptbense@gwm.sc.edu]
Sent: sexta-feira, 25 de Agosto de 2006 0:01
To: Agnelo Roneberg; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Access ODBC View update problem (#deleted)
This is a known (and extremely well-documented) issue. Do some
googling...
-Peter
Peter T. Bense
Advanced Teradata Certified Professional V2R5
(ptbense@gwm.sc.edu) - 803-777-9476
Database Administrator
Prevention Research Center
University of South Carolina
>>> "Agnelo Roneberg" <aroneberg@bergfone.com> 08/24/06 4:56 PM >>>
Hi,
sw versions :
-PG 8.1.4
-windows 2000 server (fully patched)
-odbc ANSI 8.01.02
-Access 2003 (fully patched)
A Postgres view (linked as table) is been used as a Access form record
source. The view has Update rules and runs ok from pgAdmin for instance.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq