From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Glenn Holmer <gholmer(at)weycogroup(dot)com> |
Cc: | Postgres Interface list <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | Re: [INTERFACES] JDBC -- can't create table |
Date: | 1999-01-19 20:59:45 |
Message-ID: | Pine.LNX.4.04.9901192057100.14361-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
On Mon, 18 Jan 1999, Glenn Holmer wrote:
> I am running Postgres 6.3 on a Linux box (S.u.S.E. 5.3, kernel 2.0.35)
> and connecting from another Linux box. Both are running Java 1.1.7
> from Blackdown. I can connect to the remote machine and even create a
> database, but I am unable to create a table.
>
> I've included the code as an attachment. The exact output is as follows:
>
> --------------------------------------------------------
>
> loading JDBC class "postgresql.Driver"...
>
> connecting to jdbc:postgresql://miranda:5432/factory...
>
> creating skid table...
> ERROR: cannot create skids
>
> --------------------------------------------------------
>
> I do wind up with an empty file named "skids" on the server at
> /var/lib/pgsql/data/base/factory. I can't understand if this is just
> some simple permissions problem or something else I overlooked. Does
> anybody see anything obvious? Is there a way to get a more detailed
> error message than "cannot create skids"? I created the database by
> hand with psql as user "factory" on the server before running this
> test code.
Can you create the table using psql?
I've just compiled and tested your class, and it runs fine here unaltered.
Peter
--
Peter T Mount peter(at)retep(dot)org(dot)uk
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
Java PDF Generator: http://www.retep.org.uk/pdf
From | Date | Subject | |
---|---|---|---|
Next Message | William McCracken | 1999-01-19 21:46:17 | |
Previous Message | William D. McCoy | 1999-01-19 20:32:25 | PostgreSQL, ODBC and Applix Data |