RE: [HACKERS] Problem with query length
От | Ansley, Michael |
---|---|
Тема | RE: [HACKERS] Problem with query length |
Дата | |
Msg-id | 1BF7C7482189D211B03F00805F8527F70ED0F8@S-NATH-EXCH2 обсуждение исходный текст |
Список | pgsql-hackers |
No, it appears that the flex module doesn't handle any tokens with a length above this value. I didn't realise that it happened at about 4k in normal operation though; I had intentionally set my YY_BUF_SIZE to 4096 to try some testing. I thought that this was causing the problem. Does anybody know (scan.l, parse.l) reasonably intimately? Any info regarding this would be appreciated? Somebody mentioned this to me in mail regarding the query string length >> -----Original Message----- >> From: Natalya S. Makushina [mailto:mak@rtsoft.msk.ru] >> Sent: Tuesday, August 17, 1999 3:15 PM >> To: 'pgsql-hackers@postgreSQL.org' >> Subject: [HACKERS] Problem with query length >> >> >> ------------------------------------------------------------- ---------------------------------------------------------------- >> I have posted this mail to psql-general. But i didn't get >> any answer yet. >> ------------------------------------------------------------- ---------------------------------------------------------------- >> >> When i had tried to insert into text field text (length >> about 4000 chars), the backend have crashed with status 139. >> This error is happened when the query length ( SQL query) is >> more than 4095 chars. I am using PostgreSQL 6.4.2 on Linux. >> >> My questions are: >> 1. Is there problem with text field or with length of SQL query? >> 2. Would postgresql have any limits for SQL query length? >> I checked the archives but only found references to the 8K >> limit. Any help would be greatly appreciated. >> Thanks for help >> Natalya Makushina >> mak@rtsoft.msk.ru >> >>
В списке pgsql-hackers по дате отправления: