bigserial field in a view, nextval function ?

From: "Zlatko Matic" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: bigserial field in a view, nextval function ?
Date: 2005-04-21 14:18:28
Message-ID: 007601c5467c$fdadc500$0f8b1dc3@zlatkovyfkpgz6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher J. Bottaro 2005-04-21 14:22:26 Re: CURRENT_TIMESTAMP vs actual time
Previous Message Palle Girgensohn 2005-04-21 14:13:25 Re: transaction started without BEGIN??? Please help!