Re: Create Data Base fails - Mailing list pgsql-general

From Andrew Gould
Subject Re: Create Data Base fails
Date
Msg-id 20030701131130.71655.qmail@web13402.mail.yahoo.com
Whole thread Raw
In response to Create Data Base fails  (Martin Marques <martin@bugs.unl.edu.ar>)
Responses Re: Create Data Base fails  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-general
Are you using advanced authentication in phppgadmin?

Could this be caused when phppgadmin is configured to
have the database superuser connect to template1 to
manage user logins?

Andrew Gould

--- Martin Marques <martin@bugs.unl.edu.ar> wrote:
> OK, the picture is the latest CVS of phpPgAdmin on
> PostgreSQl 7.3.1.
>
> I created a user with createDB option. Here OK.
>
> I connect to phpPgAdmin as that user and try to
> create a DB and I get this
> error:
>
> Error de SQL:
> ERROR:  CREATE DATABASE: source database "template1"
> is being accessed by
> other users
>
> En la declaracio'n:
> CREATE DATABASE "phpbb" WITH ENCODING='LATIN1'
>
> I'm crossposting because I think it may be more of a
> PostgreSQL situation
> then a phpPgAdmin one.
>
> --
> Porqu� usar una base de datos relacional cualquiera,
> si pod�s usar PostgreSQL?
>
-----------------------------------------------------------------
> Mart�n Marqu�s                  |
> mmarques@unl.edu.ar
> Programador, Administrador, DBA |       Centro de
> Telematica
>                        Universidad Nacional
>                             del Litoral
>
-----------------------------------------------------------------
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Cannot create unique index
Next
From: "Henrik Steffen"
Date:
Subject: Re: Cannot create unique index