Re: CREATE SEQUENCE commits transaction

From: Gert Brinkmann <gbrinkmann_at_dimedis.de>
Date: Wed, 06 Mar 2002 13:59:24 +0100
Message-ID: <3C8612AC.4AB24524@dimedis.de>

Niall Litchfield wrote:
>
> I imagine the tables are pre-created, that is they don't get created in code
> as well. If so it really sould be part of the app install to create the
> sequence (and an associated trigger/primary key combo) which the app then
> uses.

Yes, we are about to change the table-creation to this way.

But there comes another question to my mind: What happens if a temp-table is created? This is something that should be normal doing it inside a transaction, isn't it? Does this result in a commit, too?

Ciao,

Gert Received on Wed Mar 06 2002 - 06:59:24 CST