|Subject||Re: Problem with growing database|
|Author||Sten Karlson <email@example.com>|
Thanks heLen, that explains it.
--- In firstname.lastname@example.org, Helen Borrie <helebor@t...> wrote:
> At 08:00 AM 10-12-02 +0000, you wrote:
> >Hi and thanks every one. I think this kind of support is the best.
> >The growing database was (of cause) due to my lack of skill in DB-
> >programming. I did COMMIT RETAINING instead of COMMIT. But from
> >I understand this only stores some kind of Save Point and it does
> >not a real COMMIT.
> It's not a Savepoint (although Savepoints *are* coming in Fb 2).
It is a
> full (irreversible) Commit but, instead of closing the cursors
> with the transaction, it keeps them open for the new transaction.
> everything to do with the original transaction and each new one
> started after Commit with Retain, using the same cursors, remains
> interesting and therefore unavailable for garbage collection.