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

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

In response to

Responses

Browse pgsql-interfaces by date

  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