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 10:57:16
Message-ID: 4278AA8C.6050502@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
 >>
 > Zlatko Matic wrote:
 > You mean VB.NET ?

Actually we wrote our interface using VB6.

-- 
Kind Regards,
Keith

In response to

pgsql-interfaces by date

Next:From: Bruno Wolff IIIDate: 2005-05-04 14:16:32
Subject: Re: [INTERFACES] calculated identity field in views, again...
Previous:From: Zlatko MaticDate: 2005-05-04 08:58:34
Subject: Re: [INTERFACES] calculated identity field in views, again...

pgsql-general by date

Next:From: Michelle KonzackDate: 2005-05-04 11:08:04
Subject: Re: Rekall for Debian ?
Previous:From: Devrim GUNDUZDate: 2005-05-04 10:31:48
Subject: Re: Rekall for Debian ?

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