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@retep.org.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