calculated identity field in views, again...

From: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: calculated identity field in views, again...
Date: 2005-05-03 22:04:41
Message-ID: 001201c5502c$1c030430$2d8b1dc3@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces

I asked this question several weeks ago, but nobody proposed a solution, so
I am repeating the same question again...
I have an MS Access front-end for a database on PostgreSQL.
I could use pass-through queries as record sources for reports and it works
fine...
Unfortunately, MS Access doesn't allow pass-through queries to be records
sources for subforms.
Therefore I tried to base subforms on regular JET queries on linked tables.
It was too slow...
Then I tried to base subforms on DAO recordset code generated from
pass-through QueryDef objects. Although it worked, it was very unstable...

Now it seems to me that POstgreSQL views are the best solution, but Access
considers views as tables (!) and needs column with unique values.
All those views are complicated queries on several tables, so I can't use
any table's column as primary key. I need a calculated column in the view
that Access will consider as primary key column.
In regular tables, I use bigserial field, but how can I create calculated
bigserial column in a view ?

Thanks.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2005-05-03 22:06:37 Re: plpythonu and dollar quoting
Previous Message Mohan, Ross 2005-05-03 21:51:38 Re: Favorable Postgresql write up

Browse pgsql-interfaces by date

  From Date Subject
Next Message Keith Worthington 2005-05-04 03:58:28 Re: [INTERFACES] calculated identity field in views, again...
Previous Message Thomas Hallgren 2005-05-03 21:19:43 Re: Deep integration of PostgreSQL with Apache