psql command and file size
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
Sorry, forgot to mention, running Postgres 8.1 on a SUSE 10
Show quoted text
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
sorry again, the psql I am running from a Windows client
Show quoted text
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.000insert sentences, but only inserts 3900 rows, what can I do to "see" what
insert sentences are failing ?thanks for any advice
best regards
Hugo
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