Re: bigserial field in a view, nextval function ?
От | Zlatko Matic |
---|---|
Тема | Re: bigserial field in a view, nextval function ? |
Дата | |
Msg-id | 000701c54687$d8af3ee0$b0748353@zlatkovyfkpgz6 обсуждение исходный текст |
Ответ на | CURRENT_TIMESTAMP vs actual time ("Christopher J. Bottaro" <cjbottaro@alumni.cs.utexas.edu>) |
Список | pgsql-general |
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@archonet.com> To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr> Cc: <pgsql-general@postgresql.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 >
В списке pgsql-general по дате отправления: