Re: cron job INSERT appears to bail.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Allan Kelly <allan(dot)kelly(at)buildstore(dot)co(dot)uk>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: cron job INSERT appears to bail.
Date: 2000-06-05 15:47:55
Message-ID: 12232.960220075@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Allan Kelly <allan(dot)kelly(at)buildstore(dot)co(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Hoffmann 2000-06-05 15:52:38 Re: Default timestamp value
Previous Message Tom Lane 2000-06-05 15:27:49 Re: Default timestamp value