Anand Kumria <wildfire (AT) progsoc (DOT) uts.edu.au> writes:
Are you doing anything multi-threaded in those scripts? libpq is not
thread-aware --- it's up to you to ensure that only one thread touches
a given PG connection (only one at a time anyway).

That might have nothing to do with your problem, but no other theories
come to mind with the limited info you've provided...

regards, tom lane

---------------------------(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