Tom Lane a écrit :
Denis BUCHER dbuche...@hsolutions.ch writes:
To do this it will be a little complicated because of table
dependencies... And it could bug again at the next DROP COLUMN... Is
there a way to change my function (RETURN SETOF part) to specify the
column names/types ?
No, not
Denis BUCHER dbuche...@hsolutions.ch writes:
I have a strange problem, because it worked in a fonction for a table,
and now I created the same (?) function for another table and it doesn't
work...
The function is accepted but at runtime I get :
ERREUR: wrong record type supplied in RETURN
Hello Tom,
Tom Lane a écrit :
Denis BUCHER dbuche...@hsolutions.ch writes:
I have a strange problem, because it worked in a fonction for a table,
and now I created the same (?) function for another table and it doesn't
work...
The function is accepted but at runtime I get :
ERREUR:
Tom Lane wrote:
Denis BUCHER dbuche...@hsolutions.ch writes:
Does that table have any dropped columns? If you don't remember
whether you ever dropped any columns, a quick look into pg_attribute
will tell you:
select attname from pg_attribute where attrelid =
Hi Tom,
Another question :
Tom Lane a écrit :
Denis BUCHER dbuche...@hsolutions.ch writes:
I have a strange problem, because it worked in a fonction for a table,
and now I created the same (?) function for another table and it doesn't
work...
The function is accepted but at runtime I get
Denis BUCHER dbuche...@hsolutions.ch writes:
To do this it will be a little complicated because of table
dependencies... And it could bug again at the next DROP COLUMN... Is
there a way to change my function (RETURN SETOF part) to specify the
column names/types ?
No, not really. You could