From: | "Agnelo Roneberg" <aroneberg(at)bergfone(dot)com> |
---|---|
To: | "Peter Bense" <ptbense(at)gwm(dot)sc(dot)edu>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Access ODBC View update problem (#deleted) |
Date: | 2006-09-06 06:53:09 |
Message-ID: | 8202DB88944E224B9F64DC2120DBD31E253A00@servidor-rede.rede.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2006-09-06 07:15:09 | [ psqlodbc-Bugs-1000692 ] Broken UTF-8 support in Version 08.02.0002 |
Previous Message | Hiroshi Inoue | 2006-09-06 03:45:49 | Re: Ms Access 2000 - Update/Delete fails with Write conflict |