Thread: psql command and file size

psql command and file size

From

Hugo

Date:

08 June 2006, 21:48:27

Hello list,

If I feed psql with a file with sql sentences, what is the size limit for the file, I have a more or less 67MB file , with about 439.000 insert sentences, but only inserts 3900 rows, what can I do to "see" what insert sentences are failing ?

thanks for any advice

best regards

Hugo

Re: psql command and file size

From

Hugo

Date:

08 June 2006, 21:51:36

Sorry, forgot to mention, running Postgres 8.1 on a SUSE 10

On 6/8/06, Hugo <htakada@gmail.com> wrote:

Hello list,

If I feed psql with a file with sql sentences, what is the size limit for the file, I have a more or less 67MB file , with about 439.000 insert sentences, but only inserts 3900 rows, what can I do to "see" what insert sentences are failing ?

thanks for any advice

best regards

Hugo

Re: psql command and file size

From

Hugo

Date:

08 June 2006, 21:52:58

sorry again, the psql I am running from a Windows client

On 6/8/06, Hugo <htakada@gmail.com> wrote:

Sorry, forgot to mention, running Postgres 8.1 on a SUSE 10

On 6/8/06, Hugo < htakada@gmail.com> wrote:
Hello list,

If I feed psql with a file with sql sentences, what is the size limit for the file, I have a more or less 67MB file , with about 439.000 insert sentences, but only inserts 3900 rows, what can I do to "see" what insert sentences are failing ?

thanks for any advice

best regards

Hugo

Re: psql command and file size

From

Tom Lane

Date:

08 June 2006, 22:31:30

Hugo <htakada@gmail.com> writes:
> If I feed psql with a file with sql sentences, what is the size limit for
> the file,

There is no particular limit.

> I have a more or less 67MB file , with about 439.000 insert
> sentences, but only inserts 3900 rows, what can I do to "see" what insert
> sentences are failing ?

Check the postmaster log for errors, perhaps?

            regards, tom lane