From: Glenn Holmer <gholmer@weycogroup.com>
To: Postgres Interface list <pgsql-interfaces@postgreSQL.org>
Subject: JDBC -- can't create table
Date: Mon, 18 Jan 1999 17:31:31 +0000
Message-ID: <199901182340.RAA07118@mailgw00.execpc.com> (raw)
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.
--
____________________________________________________________
Glenn Holmer gholmer@weycogroup.com
Programmer/Analyst phone: 414.263.8827
Weyco Group, Inc. fax: 414.263.8808
Attachments:
test.java (application/octet-stream, 1.5K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: gholmer@weycogroup.com
Subject: Re: JDBC -- can't create table
In-Reply-To: <199901182340.RAA07118@mailgw00.execpc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox