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: 42784864.4060408@NarrowPathInc.com (view raw or flat)
Thread:
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,
Keith

In response to

Responses

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-2014 The PostgreSQL Global Development Group