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

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

From: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: "Greg Stark" <gsstark(at)mit(dot)edu>
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 08:56:25
Message-ID: 001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
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(at)mit(dot)edu>
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>
Sent: Wednesday, May 04, 2005 7:11 AM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in views, 
again...


> "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)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
> 


In response to

Responses

pgsql-interfaces by date

Next:From: Zlatko MaticDate: 2005-05-04 08:58:34
Subject: Re: [INTERFACES] calculated identity field in views, again...
Previous:From: Greg StarkDate: 2005-05-04 05:11:24
Subject: Re: [INTERFACES] calculated identity field in views, again...

pgsql-general by date

Next:From: Zlatko MaticDate: 2005-05-04 08:58:34
Subject: Re: [INTERFACES] calculated identity field in views, again...
Previous:From: Magnus HaganderDate: 2005-05-04 07:37:42
Subject: Re: Favorable Postgresql write up

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