From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Srinivasa T N <seenutn(at)gmail(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Meaning of below statement |
Date: | 2020-11-20 08:29:00 |
Message-ID: | CAKFQuwYq5nFtytpOnvGuVj4n-wLRuZQMCpYPh0dNApbOQTgvJg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Friday, November 20, 2020, Srinivasa T N <seenutn(at)gmail(dot)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: ROLLBACK
>
> Does 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Clarke | 2020-11-20 08:50:47 | Re: Meaning of below statement |
Previous Message | Raul Kaubi | 2020-11-20 07:59:03 | Re: Parameter value from (mb/gb) to bytes |