Обсуждение: psql command and file size

Поиск
Список
Период
Сортировка

psql command and file size

От
Hugo
Дата:
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

От
Hugo
Дата:
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

От
Hugo
Дата:
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

От
Tom Lane
Дата:
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