Re: Built in display of contents of temporary tables when select has no destination

From: Dave Page <dpage(at)postgresql(dot)org>
To: "Robert M(dot) Bernabe" <rbernabe(at)sandmansystems(dot)com>
Cc: Postgres <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Built in display of contents of temporary tables when select has no destination
Date: 2007-12-10 11:55:00
Message-ID: 475D2914.4090700@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Robert M. Bernabe wrote:
> Hi Dave,
> Within a function just type select * from table; ...call the function
> and the SQL editor will give an error saying that the select statement
> has no destination...which is true...:) but often very complex stored
> functions have temporary tables within and the only way to display the
> contents while debugging is to use a loop with raise info calls. It
> would be great if the debugger automatically streams all select
> statements to a output and formatted already for viewing.

Oh, I see what you mean. Unfortunately thats not possible with the way
the server is currently designed - you would need to use RAISE as you
mention I'm afraid.

Regards, Dave

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2007-12-10 11:58:50 Re: Fedora Core 8.0 status?
Previous Message Dave Page 2007-12-10 11:52:33 Re: Unable to add server in PGadmin