Обсуждение: bug language "plpgsql" already exists

Поиск
Список
Период
Сортировка

bug language "plpgsql" already exists

От
beulah prasanthi
Дата:
hello

I deleted existing DB and i created new DB
i am getting below error how can i resolve it can any one help please

"language "plpgsql" already exists"

Re: bug language "plpgsql" already exists

От
Pavel Stehule
Дата:
Hello

it's not bug. You registered plpgsql inside template1 database.

Regards
Pavel Stehule

2010/3/16 beulah prasanthi <itsbeulah@gmail.com>:
> hello
>
> I deleted existing DB and i created new DB
> i am getting below error how can i resolve it can any one help please
>
> "language "plpgsql" already exists"
>

Re: bug language "plpgsql" already exists

От
John R Pierce
Дата:
beulah prasanthi wrote:
> hello
>
> I deleted existing DB and i created new DB
> i am getting below error how can i resolve it can any one help please
>
> "language "plpgsql" already exists"

um, whats the problem?  that just means someone already did the CREATE
LANGUAGE "plpgsql";   possibly in template1 so its inherited by new
databases.    that sort of error can be ignored