Re: BYTEA: insert query max size

inner <transto(at)inbox(dot)ru> writes:
> I am using PostgresDAC 2.3.1 for direct access to Postgres through CBuilder6.

> 1. creating stream of char 'a', which size is 16785347.
> 2. loading bytea parameter from stream into PGSQLQuery, where stored SQL query: 'insert into tcad (gtype,geom) values (:Size,:Data);'.
> 3. in parameter Size storing string: '16785347 b'.
> 4. when i try to execute query, i am getting error: 'Software caused connection abort (0x00002745/10053)'.

> For stream size of 16785346 it works fine.
> It looks like sql query size limit, isn't it?

There's no such limit hardwired into Postgres. I don't know anything
about CBuilder or PostgresDAC, though, and wouldn't be surprised if one
of them is creating the limitation.

regards, tom lane