Re: "Other users on Template1" when there aren't any - Mailing list pgsql-general

From Tom Lane
Subject Re: "Other users on Template1" when there aren't any
Date
Msg-id 27766.1114832126@sss.pgh.pa.us
Whole thread Raw
In response to "Other users on Template1" when there aren't any  ("John D. Tiedeman" <jdtiede@sstar.com>)
List pgsql-general
"John D. Tiedeman" <jdtiede@sstar.com> writes:
>    I have 8.0 on a Linux machine and a w2k box but only have this
> problem on w2k. I have rebooted in case an earlier effort left a loose
> end but that didn't help. I haven't been able to create a db at all on
> the w2k but have one on Linux. This is my first experience with pgsql on
> win32.

You haven't actually said what the problem was ...

Doing my best Carnac the Magnificent impersonation, I'm going to guess
that you have some problem with two successive connections to template1
wherein the first backend hasn't managed to exit by the time the second
one checks for concurrent connections.  But since you have not told us
what exactly you are doing, that's strictly a guess.

There are some tips at
http://www.postgresql.org/docs/8.0/static/bug-reporting.html
about creating useful problem reports.

            regards, tom lane

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Tuning queries inside a function
Next
From: Tom Lane
Date:
Subject: Re: Fatal error