| From: | Srinivasa T N <seenutn(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Meaning of below statement |
| Date: | 2020-11-20 07:45:14 |
| Message-ID: | CAFruNde0MKCkP8A1bEBBAGpKLpxunhcoJZhWO2dAzjhpOYvsAA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have the following in my log files:
2020-11-20 11:20:46.216 IST [38207] LOG: execute S_1/C_2: SELECT
"gid",encode(ST_AsBinary(ST_Simplify(ST_Force2D("shape"),
14.929338247701526, true)),'base64') as "shape" FROM
"ami_smart_new"."aoi_boundary" WHERE ("sectioncode" IN ('4683', '4587') AND
"sectioncode" IS NOT NULL AND "shape" && ST_GeomFromText('POLYGON
((683696.123647752 989199.9990667417, 683696.123647752 1000723.135701899,
708574.8226023088 1000723.135701899, 708574.8226023088 989199.9990667417,
683696.123647752 989199.9990667417))', 32643))
2020-11-20 11:20:46.218 IST [38207] LOG: execute S_3: ROLLBACK
Does it mean that there was an error in "SELECT ..." and hence internally
postgres executed ROLLBACK??
Regards,
Seenu.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raul Kaubi | 2020-11-20 07:59:03 | Re: Parameter value from (mb/gb) to bytes |
| Previous Message | Dirk Mika | 2020-11-20 07:13:42 | Set COLLATE on a session level |