Re: BUG #2289: insert into tables not working

[Please copy the mailing list on replies.]

On Wed, Mar 01, 2006 at 08:55:29AM -0800, Abhilash Krishnan wrote:
> ya.... the transactions are commited.... also no error has been shown in any
> of the operations....

How are you determining that data isn't getting inserted?  If you
do a select in the same transaction as the inserts, do you see the
data?  If you commit the transaction and then start a new transaction,
does a select in the new transaction see the data?  If concurrent
transactions aren't able to see the data even after it's committed,
what isolation level are those transactions using?  A SERIALIZABLE
transaction won't see data committed by other transactions after
its snapshot has been taken.

If none of this helps then could you post a series of steps that
somebody could use to duplicate the problem?

--
Michael Fuhr