Re: Meaning of below statement
| От | David G. Johnston |
|---|---|
| Тема | Re: Meaning of below statement |
| Дата | |
| Msg-id | CAKFQuwYq5nFtytpOnvGuVj4n-wLRuZQMCpYPh0dNApbOQTgvJg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Meaning of below statement (Srinivasa T N <seenutn@gmail.com>) |
| Ответы |
Re: Meaning of below statement
Re: Meaning of below statement |
| Список | pgsql-general |
On Friday, November 20, 2020, Srinivasa T N <seenutn@gmail.com> wrote:
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: ROLLBACKDoes it mean that there was an error in "SELECT ..." and hence internally postgres executed ROLLBACK??
If there was an error you would see an error message. Plus, PostgreSQL doesn’t just internally issue a rollback on its own. That said I’m not sure what is being shown, or rather where the “execute” stuff comes from.
David J.
В списке pgsql-general по дате отправления: