Re: Can't get the debugger going - Mailing list pgadmin-support

- I enabled the option "Show system objects in the treeview" to see the
templates and this is done, thank you.Templates don't have any functions in
them?

- My platform is win XP. I created three schemas, each have different
tables. One schema will create a table with the data from the other tables
that resides in other two schemas. I need to write a cursor-loop-fetch
function to extract data from some fields from the two schemas and insert
into a new table in the third schema...I wrote a test function but can't
debug it and not sure if I should use sql or pl/pgsql.  

This is a copy from Function treeview, not sure why it writes two headers
and adds more stuff to the bottom.
-- Function: "MySchema".create_data()

-- DROP FUNCTION "MySchema".create_data();

CREATE OR REPLACE FUNCTION "MySchema".create_data() RETURNS void AS
$BODY$CREATE FUNCTION "MySchema".create_data() RETURNS varchar(3) AS '

DECLARE   
my_cursor CURSOR for select prov from "SecondSchema".data_load;
province varchar(3);   
BEGIN      open my_cursor; RAISE info ''prov'';     RAISE INFO ''-----'';      LOOP          FETCH my_cursor INTO
province;         RAISE INFO ''%'', province;          EXIT WHEN my_cursor%NOT FOUND;        RAISE INFO ''%'',
province;     END LOOP;      CLOSE my_cursor;     return province; 
 
END; 
'LANGUAGE 'plpgsql';
$BODY$ LANGUAGE 'sql' VOLATILE COST 100;
ALTER FUNCTION "MySchema".create_data() OWNER TO postgres;


- I tried to install the debugger by running the command you recommended in
the cmd window. Now when I run "C:...PostgreSQL\8.3\share\contrib\psql -f
pldbgapi.sql my_dbase" it says: "psql is not recognized as an internal or
external command, operable or batch file" Is that mean I don't have psql.exe
installed? I see it under the bin folder, when I run it from the cmd line it
asks me for a password. I tried the password for windows and postgresql both
don't work.
Schatz.



Raymond O'Donnell wrote:
> 
> [Redirecting to the list]
> 
> On 13/04/2009 16:33, gaybana2000@hotmail.com wrote:
>> Thank you for your reply. I only have pgadmin3 installed. where do I
>> run these commands from. what do I need to install to rund these
>> command line commands?
> 
> What platform are you on? Also, what exactly are you trying to do?
> 
>> I looked in the docs for how to use the
>> pg_dumpall commands...don't know where to run these commands.
> 
> You just run them at the system command line... if you're on Windows, go
> to Start -> Run and type 'cmd' to bring up a command prompt. Of course,
> you need to have these utilities installed in the first place - how you
> do this depends on your platform.
> 
>> I also don't have template1 dbase.
> 
> I think pgAdmin hides it by default. To see it (and a lot of other
> stuff), go to File -> Options -> Display, and check "Show system objects
> in the treeview"; then refresh the "Databases" node of the treeview by
> clicking on it and pressing F5.
> 
> Ray.
> 
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod@iol.ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
> 
> -- 
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
> 
> 

-- 
View this message in context: http://www.nabble.com/Can%27t-get-the-debugger-going-tp15271521p23025672.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.