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 [EMAIL PROTECTED]
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
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster