Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group