Re: [GENERAL] Query is too long

From: Silvio Emanuel Barbosa de Macedo <smacedo(at)inescn(dot)pt>
To: Bob Dusek <bobd(at)palaver(dot)net>
Cc: pgsql general mailing list <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Query is too long
Date: 1999-01-16 03:21:29
Message-ID: Pine.GSO.3.96.990116031535.16277A-100000@newton.inescn.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 15 Jan 1999, Bob Dusek wrote:
>Sorry,
>I should have been more clear:
>> One way to execute .sql scripts in your database is this:
>> psql -e dbname < script.sql
>That should be done from the command line.

Yes... I imagined....

Anyway, Query Buffer being full I CAN understand..., but
core dump ?! hummm... I think there should be some little correction
there...
It appears to me that if a core dump (SIGNAL=11=SIGSEV) is generated,
something inside is not ok... and could show up in other more orthodox
situations...

>> > PQsendQuery() -- query is too long. Maximum length is 8191
>> > query buffer max length of 20000 exceeded
>> > query line ignored
>> > Segmentation fault (core dumped)
>> >
>> >

>> > Gdb on the core:
>> > (gdb) bt
>> > #0 0x401066f8 in ?? () from /lib/libc.so.6
>> > #1 0x401066a1 in ?? () from /lib/libc.so.6
>> > #2 0x804e85b in MainLoop ()
>> > #3 0x804df44 in HandleSlashCmds ()
>> > #4 0x804e7c0 in MainLoop ()
>> > #5 0x804ef2d in main ()

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
`````````````````````````````````````````````
Silvio Emanuel Nunes Barbosa de Macedo
mailto:smacedo(at)inescn(dot)pt

INESC - Porto - Grupo CAV
Pc da Republica, 93 R/C Tel:351 2 209 42 21
4000 PORTO PORTUGAL Fax:351 2 208 41 72

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Silvio Emanuel Barbosa de Macedo 1999-01-16 03:23:31 Re: [GENERAL] Query is too long - thanks
Previous Message Paulo da Silva 1999-01-15 22:59:18 GUI