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 template
Hello
it's not bug. You registered plpgsql inside template1 database.
Regards
Pavel Stehule
2010/3/16 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"
>
--
S
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"
Severity: Annoyance
Versions Tested: 8.4.2
Platform: Linux RHEL 5.4
Reproduceable: always
Steps to reproduce:
1. Create a function.
2. In one session, start an explicit transaction.
3. Do a CREATE OR REPLACE on the same function, but do not commit.
4. Open a 2nd session, and an explicit transactio
As per http://osdir.com/ml/pgsql-hackers/2010-03/msg00331.html, I would
certainly find it helpful is count(distinct(myfield)) wasn't a full index
scan.
Gregg Lind
