X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1B9525460C; Wed, 4 May 2005 05:56:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12910-09; Wed, 4 May 2005 08:56:37 +0000 (GMT) Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97]) by svr1.postgresql.org (Postfix) with ESMTP id D11155445D; Wed, 4 May 2005 05:56:34 -0300 (ADT) Received: from ls413.htnet.hr (ls413.htnet.hr [195.29.150.117]) by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id j448uQwV009934; Wed, 4 May 2005 10:56:26 +0200 Received: from ls413.htnet.hr (localhost.localdomain [127.0.0.1]) by ls413.htnet.hr (Qmali) with ESMTP id 657D9AC004; Wed, 4 May 2005 10:56:26 +0200 (CEST) Received: from zlatkovyfkpgz6 (ad6-m197.net.t-com.hr [195.29.134.197]) by ls413.htnet.hr (Qmali) with SMTP id C6439EC05F; Wed, 4 May 2005 10:56:24 +0200 (CEST) Message-ID: <001801c55087$2828d9a0$c5861dc3@zlatkovyfkpgz6> From: "Zlatko Matic" To: "Greg Stark" Cc: , References: <20050503151626.37630.qmail@web52405.mail.yahoo.com><4277EAEF.5030707@mailblocks.com><001201c5502c$1c030430$2d8b1dc3@zlatkovyfkpgz6> <877jifwp6r.fsf@stark.xeocode.com> Subject: Re: [INTERFACES] calculated identity field in views, again... Date: Wed, 4 May 2005 10:56:25 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="ISO-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 1 X-MSMail-Priority: High X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.17 tagged_above=0 required=5 tests=AWL, X_MSMAIL_PRIORITY_HIGH, X_PRIORITY_HIGH X-Spam-Level: X-Archive-Number: 200505/171 X-Sequence-Number: 77519 I will try...if it will be useless, I will quite. Then the only solution will be make-table query based on nested pass-through query, so I will be working on local JET tables that will be refreshed from server on each session. But I would like to avoid local tables, if possible... How do I create sequence ? ----- Original Message ----- From: "Greg Stark" To: "Zlatko Matic" Cc: ; Sent: Wednesday, May 04, 2005 7:11 AM Subject: Re: [GENERAL] [INTERFACES] calculated identity field in views, again... > "Zlatko Matic" writes: > >> In regular tables, I use bigserial field, but how can I create calculated >> bigserial column in a view ? > > You would have to create a sequence and reference it with > nextval('sequencename') in your view. But I doubt very much that it will > do > anything useful. > > It sounds like Access wants to be able to update records by looking them > up by > primary key. In that case assigning a new value in your view will make > Postgres make up a brand new number that is utterly useless for finding > the > record again later. > > -- > greg > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >