Re: Access ODBC View update problem (#deleted)

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