Re: bigserial field in a view, nextval function ?

Well, my front-end is MS Access, and Access sees views as tables.
When I have forms with subforms there is a problem with linking them if
table has no primary key. As Access thinks that a view is a table, I need a
primary key in the view.
Also, Access doesn't like text field of ODBC-linked table to be primary key
(#Deleted phenomena#). Instead, it should be a numeric field.
Therefore, I would like to have an autoincrement field, which Access will
consider as primary key...I need a calculated bigserial field...
Can I accomplish it whith nextval ?

Greetings,

Zlatko

----- Original Message -----
From: "Richard Huxton" <dev(at)archonet(dot)com>
To: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, April 21, 2005 5:06 PM
Subject: Re: [GENERAL] bigserial field in a view, nextval function ?

> Zlatko Matic wrote:
>> I need to have an "identity" column in a view.
>> I was using bigserial columns in tables and Postgre created nextval
>> function expression automatically.
>> Now I have tried with nextval function in the view, but with no
>> success....
>> How can I put a bigserial column in a view ?
>
> What do you mean by an "identity" column in a view? A view is just a named
> query, so doesn't hold any data of its own. Can you explain what you are
> trying to achieve?
>
> --
> Richard Huxton
> Archonet Ltd
>