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(at)gwm(dot)sc(dot)edu) - 803-777-9476
Database Administrator
Prevention Research Center
University of South Carolina
>>> "Agnelo Roneberg" <aroneberg(at)bergfone(dot)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(at)gwm(dot)sc(dot)edu]
Sent: sexta-feira, 25 de Agosto de 2006 0:01
To: Agnelo Roneberg; pgsql-odbc(at)postgresql(dot)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(at)gwm(dot)sc(dot)edu) - 803-777-9476
Database Administrator
Prevention Research Center
University of South Carolina
>>> "Agnelo Roneberg" <aroneberg(at)bergfone(dot)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