Postgres Pro
Downloads
Home   >   mailing lists

bigserial field in a view, nextval function ? - Mailing list pgsql-general

From Zlatko Matic
Subject bigserial field in a view, nextval function ?
Date
Msg-id 007601c5467c$fdadc500$0f8b1dc3@zlatkovyfkpgz6
Whole thread Raw
In response to CURRENT_TIMESTAMP vs actual time  ("Christopher J. Bottaro" <cjbottaro@alumni.cs.utexas.edu>)
Responses Re: bigserial field in a view, nextval function ?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Palle Girgensohn
Date:
Subject: Re: transaction started without BEGIN??? Please help!
Next
From: "Christopher J. Bottaro"
Date:
Subject: Re: CURRENT_TIMESTAMP vs actual time