Postgres Pro
Downloads
Home   >   mailing lists

BYTEA: insert query max size - Mailing list pgsql-novice

From Dmitry
Subject BYTEA: insert query max size
Date
Msg-id 50516457.20060404171901@online.siberia.net
Whole thread Raw
List pgsql-novice
Tree view 
Dear All.

When i am trying to insert bytea with size of escape-coded data less than 16785346 bytes it works fine. But for more
than16785346 bytes it causes an 
error with dropping connection.
Please, let me know the reason of this limitation.

I am using PostgreSql 8.1.3 on WindowsXp with default settings of postgres.

Dmitry                          mailto:dmitry@online.siberia.net

pgsql-novice by date:

Previous
From: doris riedl
Date:
Subject: WAL - recovery of updated dataset
Next
From: James Long
Date:
Subject: How to append records into a file which has serial unique IDs?