Explain SQL feature
I have written a script-driven database tool able to reverse engineer,
diagnose, and display as a network layout group database objects (see
www.seabirdsoftware.com), for SQL databases including postgres. One of
the features I support is the explain plan SQL feature. I create an ADO
record set from a SQL statement (such as 'explain select * from [..]')
and I expect a record set in return.
.. Except that no record set is returned. This is working (of course)
under psql.
Any hint...? Thank you...!
- Regis
regis@seabirdsoftware.com
www.seabirdsoftware.com
Regis <regis@seabirdsoftware.com> writes:
the features I support is the explain plan SQL feature. I create an ADO
record set from a SQL statement (such as 'explain select * from [..]')
and I expect a record set in return.
Explain's output comes back as a NOTICE message, not as a recordset.
regards, tom lane