From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | inner <transto(at)inbox(dot)ru> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: BYTEA: insert query max size |
Date: | 2006-04-04 20:03:48 |
Message-ID: | 13973.1144181028@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | inner | 2006-04-04 21:00:11 | Re: BYTEA: insert query max size |
Previous Message | Richard Broersma Jr | 2006-04-04 19:53:03 | query to return hourly snapshot |