Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] calculated identity field in views, again...

From: Keith Worthington <KeithW(at)NarrowPathInc(dot)com>
To: Zlatko Matic <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] calculated identity field in views, again...
Date: 2005-05-04 03:58:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-interfaces
Zlatko Matic wrote:
> 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.
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>      joining column's datatypes do not match

Another option is to toss the MS Access altogether and program the front 
end entirely in VB.  That is what we did.

Kind Regards,

In response to


pgsql-interfaces by date

Next:From: Lipy ReisDate: 2005-05-04 04:21:44
Subject: Postgre 8.0 for Linux i586
Previous:From: Zlatko MaticDate: 2005-05-03 22:04:41
Subject: calculated identity field in views, again...

pgsql-general by date

Next:From: Dinesh PandeyDate: 2005-05-04 04:08:40
Subject: Re: Date addition/subtraction
Previous:From: Tom LaneDate: 2005-05-04 03:22:54
Subject: Re: Favorable Postgresql write up

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group