Re: [GENERAL] size limits on insert/copy/etc

1999-05-24 Thread Chris Bitmead
Unfortunately tuples cannot be bigger than 8k. Many of us I think look forward to the day when this restriction doesn't apply (it is on the to-do list), but at this point in time 8k is the limit. Large objects will work, but they have other problems that make them fairly impractical. John Browni

[GENERAL] size limits on insert/copy/etc

1999-05-24 Thread John Browning
I'm trying to add large text items to a table (field declared as type text). PQSendQuery can't take more than 8192 bytes.That's OK. But COPY also complains that tuples of 29896 bytes are too big (trying to copy from a file). So how do I get big text fields into a table? Do I have to make them larg