Re: [INTERFACES] JDBC -- can't create table

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