Re: cron job INSERT appears to bail. - Mailing list pgsql-sql

From Tom Lane
Subject Re: cron job INSERT appears to bail.
Date
Msg-id 12232.960220075@sss.pgh.pa.us
Whole thread Raw
In response to cron job INSERT appears to bail.  (Allan Kelly <allan.kelly@buildstore.co.uk>)
List pgsql-sql
Allan Kelly <allan.kelly@buildstore.co.uk> writes:
> The intranet mirror for the client later grabs the file from the ISP
> and attempts the same 'psql -f' but appears to stop after a few
> inserts.

"Appears to stop" is hardly enough of a problem description to allow
useful advice to be given.  Does the process quit, or just hang up
waiting for something?  Is there anything reported in the postmaster
log?  (You might try firing up the psql run with environment variable
PGOPTIONS = "-d2" to cause individual queries to be logged.)
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Default timestamp value
Next
From: Jeff Hoffmann
Date:
Subject: Re: Default timestamp value