inner <transto@inbox.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