Commit for a single table?

From: Hannes Lechner <hannes_at_lechner.com>
Date: Thu, 15 Apr 1999 20:57:23 +0200
Message-ID: <7f5cqt$q8m@fstgal00.tu-graz.ac.at>

Hi!

is there any way of performing a COMMIT on a single table only (i.e. w/o also commiting changes to the rest of the tables)?

or is it possible to maybe have two (or more) independent table-spaces (or simmilar) in a database so that a connection to a specific db-space only commits all tables in this table-space - leaving all others untouched?

i need this to code some sort of DB-based IPC (a message queue implemented in a table; whenever adding a message (=row) this row must be visible to all connections/sessions - i.e. i do have to perform a commit after inserting the row... but for the sake of tranactions i don't want to many commits...

any suggestions????

Thanks,
Hannes Received on Thu Apr 15 1999 - 13:57:23 CDT