| Lists: | pgsql-jdbc |
|---|
| From: | Xavier Poinsard <xpoinsard(at)openpricer(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Permission denied error with testGetUDTQualified |
| Date: | 2004-11-17 15:25:58 |
| Message-ID: | cnfqi4$99h$1@sea.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
Hi,
Trying to run the tests from Build 308 againt a 7.4.1 server I got the
following error :
[junit] Testcase:
testGetUDTQualified(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
Caused an ERROR
[junit] ERROR: permission denied for database test
[junit] java.sql.SQLException: ERROR: permission denied for
database test
[junit] at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1356)
[junit] at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1151)
[junit] at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:166)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:363)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:293)
[junit] at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:285)
[junit] at
org.postgresql.test.jdbc2.DatabaseMetaDataTest.testGetUDTQualified(DatabaseMetaDataTest.java:503)
Can someone provides the way to solve this error (and add a note in the
code) ?
Thanks.
| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Xavier Poinsard <xpoinsard(at)openpricer(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Permission denied error with testGetUDTQualified |
| Date: | 2004-11-17 19:08:45 |
| Message-ID: | Pine.BSO.4.56.0411171405570.4002@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
On Wed, 17 Nov 2004, Xavier Poinsard wrote:
> Trying to run the tests from Build 308 againt a 7.4.1 server I got the
> following error :
>
> [junit] Testcase:
> testGetUDTQualified(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
> Caused an ERROR
> [junit] ERROR: permission denied for database test
> [junit] java.sql.SQLException: ERROR: permission denied for
> database test
>
> Can someone provides the way to solve this error (and add a note in the
> code) ?
The code is trying to create a schema, which you apparently don't have
permission to do.
GRANT CREATE ON DATABASE test TO test;
should fix this. Making test the owner of the test database, or making
test a superuser will also make this work.
Kris Jurka
| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Xavier Poinsard <xpoinsard(at)openpricer(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Permission denied error with testGetUDTQualified |
| Date: | 2004-11-17 20:17:00 |
| Message-ID: | 419BB1BC.7090801@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
Xavier Poinsard wrote:
> [junit] Testcase:
> testGetUDTQualified(org.postgresql.test.jdbc2.DatabaseMetaDataTest):
> Caused an ERROR
> [junit] ERROR: permission denied for database test
The test user must own the test database. See
http://jdbc.postgresql.org/development/intro.html.
-O