Re: Mystery SELECT * query

Andrew Puschak, 09.12.2013 22:07:

> I've inherited a web service on a Windows server that connects to a
> Postgres database. There is a "SELECT * FROM" query below that runs a
> long time and appears to happen whenever there is a web service
> update. I'd like to eliminate or limit it but I have to find it
> first. I have pgBadger set up and logging turned up which is how I
> found the query.
>
> The developer says the query is not in his code and gave me the
> source code. It's pasqual. I see the other queries but I don't see
> the select * either in the code. He also added logging of the queries
> and the SELECT * FROM is missing. Is it possible another query
> creates the select * such as the two queries before it shown below?

Maybe a "clever" ORM that re-selects any row that is touched by a DML statement in order to re-retrieve computed columns or generated IDs?

I don't know if there are any Pascal ORMs around, but I know that some ORMs in the Java world to crazy things like that.







--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice