pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Zlatko Matic <zlatko.matic1@sb.t-com.hr>
To: Greg Stark <gsstark@mit.edu>
Cc: pgsql-general@postgresql.org
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] calculated identity field in views, again...
Date: Wed, 4 May 2005 10:56:25 +0200
Message-ID: <001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6> (raw)
References: <20050503151626.37630.qmail@web52405.mail.yahoo.com>
	<4277EAEF.5030707@mailblocks.com>
	<001201c5502c$1c030430$2d8b1dc3@zlatkovyfkpgz6>
	<877jifwp6r.fsf@stark.xeocode.com>

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...

How do I create sequence ?



----- Original Message ----- 
From: "Greg Stark" <gsstark@mit.edu>
To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr>
Cc: <pgsql-general@postgresql.org>; <pgsql-interfaces@postgresql.org>
Sent: Wednesday, May 04, 2005 7:11 AM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in views, 
again...


> "Zlatko Matic" <zlatko.matic1@sb.t-com.hr> writes:
>
>> In regular tables, I use bigserial field, but how can I create calculated
>> bigserial column in a view ?
>
> You would have to create a sequence and reference it with
> nextval('sequencename') in your view. But I doubt very much that it will 
> do
> anything useful.
>
> It sounds like Access wants to be able to update records by looking them 
> up by
> primary key. In that case assigning a new value in your view will make
> Postgres make up a brand new number that is utterly useless for finding 
> the
> record again later.
>
> -- 
> greg
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 




view thread (11+ messages)  latest in thread

Message-ID: <001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>
Permalink:  ../001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6/
Also on:    postgresql.org/message-id/001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: zlatko.matic1@sb.t-com.hr, gsstark@mit.edu, pgsql-general@postgresql.org
  Subject: Re: [INTERFACES] calculated identity field in views, again...
  In-Reply-To: <001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox