[GENERAL] Error after adding Foreign Keys

2004-11-26 Thread j0rd1 adame
Hi, When I add a FK to a table and then try to do \d table i get this ERROR: Function pg_catalog.pg_get_triggerdef(oid) does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts i have googled for this without any

Re: [ok] [GENERAL] Error after adding Foreign Keys

2004-11-26 Thread j0rd1 adame
Nevermind, I just upgraded to 7.4 and everything is just fine now thanx anyway El Vie 26 Nov 2004 12:24, j0rd1 adame escribió: > Hi, > > When I add a FK to a table and then try to do \d table > i get this > > ERROR: Function pg_catalog.pg_get_triggerdef(oid) does not exist &

[GENERAL] query variables

2005-01-27 Thread j0rd1 adame
Hi: Is there any way to save the result of a query in a variable, so that i could use that value in another query?? something like set VARIABLENAME = select count(1) from table; and then select 56778/VARIABLENAME as final_result; thanks -- Jordi Adame V jordi (.a.) jordi.net http://www.lawaloca