[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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
