Hi list !
I read in the manual that "Functions and trigger procedures are
always executed within a transaction established by an outer query".
Should I understand, that there is no way to make complex
procedures that would create tables AND fill them with data ?
I have a function that is defined as :
CREATE OR REPLACE FUNCTION my_function() RETURNS VOID AS $$
SELECT create_graph_tables('graph', 'int8');
UPDATE graph_edges SET cost=1;
$$ LANGUAGE SQL;
The create_graph_tables() function creates a table "graph_edges",
but when I run this 'CREATE FUNCTION' statement, I have an error
'relation "graph_edges" does not exist".
Is there no way to do this ?
Thanks a lot !
pgsql-novice by date
|Next:||From: Øyvind Møller Asbjørnsen||Date: 2006-02-03 12:09:03|
|Subject: How do I interpret the data returned from a DeadLock-Exception?(Java)|
|Previous:||From: A. Kretschmer||Date: 2006-02-03 10:03:42|
|Subject: Re: schemas in functions|