"cinu" <cheriyamoozhiyilcinu@yahoo.co.in> writes:
Could anyone please tell me where I am going wrong and if there is a way I can get the same behaviour that I am getting
whileI am executing the through psql prompt.
a) you might try hitting return occasionally in your email :)
b) you maybe need to put a SELECT pg_sleep(10) between the two queries in the
first file you run so that it hasn't updated both tables and exited before the
second one even starts. But I'm just guessing since you haven't sent the
actual files you're running.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!