Обсуждение: Access ODBC View update problem (#deleted)
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. Sometimes when the user updates some data on the form he gets the #deleted on all fields (I'm not able to reproduce it). Primary key is defined when linking the view as table. Row source versioning is defined in the odbc driver (and it solved the same problem with tables). I'm able to see xmin field in the linked tables but not in the linked views, therefore the problem with the update AFAIK. What should I do to correct this #deleted behaviour ? Is there a way to include xmin in the linked views ? best regards, Roneberg
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.
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
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