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@xxxxxxxxxxxx>
To: "Zlatko Matic" <zlatko.matic1@xxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, April 21, 2005 5:06 PM
Subject: Re: 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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
