Postgres Pro
Downloads
Home   >   mailing lists

Thread: Access ODBC View update problem (#deleted)

Access ODBC View update problem (#deleted)

From
"Agnelo Roneberg"
Date:
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

Re: Access ODBC View update problem (#deleted)

From
"Peter Bense"
Date:
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.

Re: Access ODBC View update problem (#deleted)

From
"Agnelo Roneberg"
Date:
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

Re: Access ODBC View update problem (#deleted)

From
"Peter Bense"
Date:
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