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
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-interfaces by date

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

Browse pgsql-general by date

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