Date: Wed, 4 May 2005 09:16:32 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Zlatko Matic <zlatko.matic1@sb.t-com.hr>
Cc: Greg Stark <gsstark@mit.edu>, pgsql-general@postgresql.org,
	pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
Message-ID: <20050504141632.GA8763@wolff.to>
Mail-Followup-To: Bruno Wolff III <bruno@wolff.to>,
	Zlatko Matic <zlatko.matic1@sb.t-com.hr>,
	Greg Stark <gsstark@mit.edu>, pgsql-general@postgresql.org,
	pgsql-interfaces@postgresql.org
References: <877jifwp6r.fsf@stark.xeocode.com>
	<001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>
User-Agent: Mutt/1.5.6i

On Wed, May 04, 2005 at 10:56:25 +0200,
  Zlatko Matic <zlatko.matic1@sb.t-com.hr> wrote:
> I will try...if it will be useless, I will quite. Then the only solution 
> will be make-table query based on nested pass-through query, so I will be 
> working on local JET tables that will be refreshed from server on each 
> session. But I would like to avoid local tables, if possible...

Didn'y you ask this same question a week or two ago? I am pretty sure
someone told you how to make access work with a view.

> How do I create sequence ?

You can't create a sequence for a view. You would need to have it in a
table that is joined as part of the view.