"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Ragnar Hafstað wrote:
>> On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote:
>>> If I understand right, oids are globally
>>> unique within your database.
>>
>> I am affraid not
> oids are globally unique within the catalog.
... until the OID
Ragnar Hafstað wrote:
On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote:
If I understand right, oids are globally
unique within your database.
I am affraid not
oids are globally unique within the catalog.
gnari
---(end of broadcast)---
TIP 4
On Wed, 2005-05-04 at 09:01 -0700, Jeff Eckermann wrote:
> If I understand right, oids are globally
> unique within your database.
I am affraid not
gnari
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
al Message -
From: "Jeff Eckermann" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>;
; <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 6:01 PM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in views,
again...
--- Zlatko Matic <[EMA
On Wed, May 04, 2005 at 11:47:12 -0400,
Greg Stark <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III <[EMAIL PROTECTED]> writes:
>
> > > How do I create sequence ?
> >
> > You can't create a sequence for a view. You would need to have it in a
> > table that is joined as part of the view.
>
> Sure y
--- Zlatko Matic <[EMAIL PROTECTED]> wrote:
> I asked this question several weeks ago, but nobody
> proposed a solution, so
> I am repeating the same question again...
> I have an MS Access front-end for a database on
> PostgreSQL.
> I could use pass-through queries as record sources
> for reports
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> > How do I create sequence ?
>
> You can't create a sequence for a view. You would need to have it in a
> table that is joined as part of the view.
Sure you can. You can have any expression you want, including nextval('seq')
in your view. The problem
On Wed, May 04, 2005 at 10:56:25 +0200,
Zlatko Matic <[EMAIL PROTECTED]> wrote:
> 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
>> Zlatko Matic wrote:
>>
>>> I asked this question several weeks ago, but nobody proposed a
>>> solution, so I am repeating the same question again...
>>> I have an MS Access front-end for a database on PostgreSQL.
>>> I could use pass-through queries as record sources for reports and it
>>> works
create sequence ?
- Original Message -
From: "Greg Stark" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 7:11 AM
Subject: Re: [GENERAL] [INTERFACES] calculated identity field in vie
You mean VB.NET ?
- Original Message -
From: "Keith Worthington" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc: ; <[EMAIL PROTECTED]>
Sent: Wednesday, May 04, 2005 5:58 AM
Subject: Re: [INTERFACES] calculated identity field in views, again...
Zlatko Matic wrote:
I asked t
"Zlatko Matic" <[EMAIL PROTECTED]> 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 usef
Zlatko Matic wrote:
I asked this question several weeks ago, but nobody proposed a solution,
so I am repeating the same question again...
I have an MS Access front-end for a database on PostgreSQL.
I could use pass-through queries as record sources for reports and it
works fine...
Unfortunately,
13 matches
Mail list logo
