Обсуждение: Query is too long
Hi! I was using psql to insert data into the database. I have *.sql files with the necessary scripts, eg: insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl'); After many inserts... I've got this message: query buffer max length of 20000 exceeded query line ignored and then, a few inserts later, because the scritp went on... 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 () What has happened ? How can I avoid it ? Maybe using psql -f instead using \i inside psql ? ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ````````````````````````````````````````````` Silvio Emanuel Nunes Barbosa de Macedo mailto:smacedo@inescn.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
I'm designing a database schema and have questions about OID. First, I assume that OID are system assigned? [yes] Second, Can I use OID as a primary key? [no] Third, Is the OID invariant under an import/export process? [no] Fourth, Can I create table with an OID type for referencing another table? [no] I puy my assumed answers in brackets. Please let me know if I am mistaken. Thanks! Clark
Hey there, One way to execute .sql scripts in your database is this: psql -e dbname < script.sql That is how we recreate our databases from a dump file. "psql -ef script.sql dbname" seems to have the same problem you were having with the \i command: query buffer max length of 20000 exceeded good luck, Bob On Fri, 15 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote: > > Hi! > I was using psql to insert data into the database. > I have *.sql files with the necessary scripts, eg: > > insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl'); > > After many inserts... I've got this message: > > query buffer max length of 20000 exceeded > query line ignored > > and then, a few inserts later, because the scritp went on... > > 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 () > > What has happened ? How can I avoid it ? Maybe using psql -f instead using > \i inside psql ? > > > > ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > ````````````````````````````````````````````` > Silvio Emanuel Nunes Barbosa de Macedo > mailto:smacedo@inescn.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 > > > > > > > > >
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. > That is how we recreate our databases from a dump file. > > "psql -ef script.sql dbname" seems to have the same problem > you were having with the \i command: > > query buffer max length of 20000 exceeded > > good luck, > > Bob > > > On Fri, 15 Jan 1999, Silvio Emanuel Barbosa de Macedo wrote: > > > > > Hi! > > I was using psql to insert data into the database. > > I have *.sql files with the necessary scripts, eg: > > > > insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl'); > > > > After many inserts... I've got this message: > > > > query buffer max length of 20000 exceeded > > query line ignored > > > > and then, a few inserts later, because the scritp went on... > > > > 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 () > > > > What has happened ? How can I avoid it ? Maybe using psql -f instead using > > \i inside psql ? > > > > > > > > ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, > > ````````````````````````````````````````````` > > Silvio Emanuel Nunes Barbosa de Macedo > > mailto:smacedo@inescn.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 > > > > > > > > > > > > > > > > > > > > >
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@inescn.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
On Fri, 15 Jan 1999, Bob Dusek wrote: >Sorry, >> One way to execute .sql scripts in your database is this: >> psql -e dbname < script.sql >> good luck, >> Bob Ohh... sorry... I forgot to thank you! Thank you... :) Silvio Emanuel Nunes Barbosa de Macedo mailto:smacedo@inescn.pt