| From: | john gale <john(at)smadness(dot)com> |
|---|---|
| To: | Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: puzzling perl DBI vs psql problem |
| Date: | 2014-03-13 19:32:37 |
| Message-ID: | 14AC119F-E99F-4B6B-B336-AA058B921429@smadness.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mar 13, 2014, at 12:18 PM, Susan Cassidy <susan(dot)cassidy(at)decisionsciencescorp(dot)com> wrote:
> I copied and pasted the query from the program's log file, so I know I'm doing the exact same query. If it matters, I'm only seeing the rows with 'root' in them via DBI, which the CASE statement refers to.
Try enabling full query logging on postgres to see what query is actually running both times. %' shouldn't resolve to anything in perl, but there could be other issues with misquoting the query.
~ john
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2014-03-13 19:36:15 | Re: [BUGS] Very slow query in PostgreSQL 9.3.3 |
| Previous Message | fburgess | 2014-03-13 19:26:54 | Very slow query in PostgreSQL 9.3.3 |