Access ODBC View update problem (#deleted)

Hi,=20


sw versions :=20

-PG 8.1.4=20
-windows 2000 server (fully patched)=20
-odbc ANSI 8.01.02=20
-Access 2003 (fully patched)=20


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).=20

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).=20

I'm able to see xmin field in the linked tables but not in the linked
views, therefore the problem with the update AFAIK.=20

What should I do to correct this #deleted behaviour ? Is there a way to
include xmin in the linked views ?


best regards,=20
Roneberg



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: 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=20
Database Administrator
Prevention Research Center
University of South Carolina
>>> "Agnelo Roneberg" 08/24/06 4:56 PM >>>
Hi,=20


sw versions :=20

-PG 8.1.4=20
-windows 2000 server (fully patched)=20
-odbc ANSI 8.01.02=20
-Access 2003 (fully patched)=20


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

Re: Access ODBC View update problem (#deleted)

Hi,

I've done (again) some googling but I was not able to find a solution.=20

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.
=20
Best regards,
A Roneberg

-----Original Message-----
From: Peter Bense [mailto:ptbense@gwm.sc.edu]=20
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" 08/24/06 4:56 PM >>>
Hi,=20


sw versions :=20

-PG 8.1.4
-windows 2000 server (fully patched)
-odbc ANSI 8.01.02
-Access 2003 (fully patched)=20


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




---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

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" 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" 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





---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings