Checking if Aggregate exists

Поиск
Список
Период
Сортировка
Искать
От
Josh Trutwin
Тема
Checking if Aggregate exists
Дата
Msg-id
20080324124743.521e5a5d@sinkhole.intrcomm.net
Список
Дерево обсуждения
Checking if Aggregate exists Josh Trutwin <josh@trutwins.homeip.net>
Re: Checking if Aggregate exists Martijn van Oosterhout <kleptog@svana.org>
Re: Checking if Aggregate exists Erik Jones <erik@myemma.com>
Re: Checking if Aggregate exists Josh Trutwin <josh@trutwins.homeip.net>
Re: Checking if Aggregate exists Erik Jones <erik@myemma.com>
Re: Checking if Aggregate exists Shane Ambler <pgsql@Sheeky.Biz>
Re: Checking if Aggregate exists Alvaro Herrera <alvherre@commandprompt.com>
Hi,

I have an upgrade script that is supposed to install items into a
postgresql database if they don't already exist.  One of the items I'm
having a hard time with is aggregates.  I want to check if aggregate
foo doesn't exist, then run an SQL command to generate it.

if (check_aggregate_exists('foo') === false) {
	$db->execute("CREATE AGGREGATE foo ....");
}

My code to check if an aggregate exists runs this query:

SELECT * FROM pg_catalog.pg_aggretate WHERE aggfnoid = 'foo'::REGPROC;

That works great IF foo exists, problem is if foo doesn't exist when
this query runs I get an error:

ERROR:  function "foo" does not exist

The error causes my transaction to abort and rollback all the changes
I had already made in my update script. 

Is there a better way to do this?  Maybe a stored proc that eats the
error message?

Thanks,

Josh
В списке pgsql-general по дате отправления
От: Bob Pawley
Дата:
Сообщение: Re: Insert
От: Martijn van Oosterhout
Дата:
FAQ