bug language "plpgsql" already exists

Started by beulah prasanthiabout 16 years ago3 messagesbugs
Jump to latest
#1beulah 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"

#2Pavel Stehule
pavel.stehule@gmail.com
In reply to: beulah prasanthi (#1)
Re: bug language "plpgsql" already exists

Hello

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

Regards
Pavel Stehule

2010/3/16 beulah prasanthi <itsbeulah@gmail.com>:

Show quoted text

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"

#3John R Pierce
pierce@hogranch.com
In reply to: beulah prasanthi (#1)
Re: bug language "plpgsql" already exists

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