Обсуждение: JDBC -- can't create table

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

I've installed PostgreSQL on my RH 5.1 box and would now like to put it on
my NT box.  I know this isn't the right mailing list, but was wondering if
anyone knew if it was available for NT and, if so, where might I find it?

Thanks,

    Randy Barrett

"Randall W. Barrett" wrote:

> I've installed PostgreSQL on my RH 5.1 box and would now like to put it on
> my NT box.  I know this isn't the right mailing list, but was wondering if
> anyone knew if it was available for NT and, if so, where might I find it?
>

Hi, Randy,

There is a web page created by Joost Kraaijeveld regarding porting Postgres
to NT, but it is a bit out of date, see:

http://www.askesis.nl/AskesisPostgresIndex.html

I ported Postgres to NT successfully :) Thank Joost and Dan for their help.

Hope this helps,
Kevin.

Thanks,

    Randy

On Tue, 19 Jan 1999, Kevin Lo wrote:

> "Randall W. Barrett" wrote:
>
> > I've installed PostgreSQL on my RH 5.1 box and would now like to put it on
> > my NT box.  I know this isn't the right mailing list, but was wondering if
> > anyone knew if it was available for NT and, if so, where might I find it?
> >
>
> Hi, Randy,
>
> There is a web page created by Joost Kraaijeveld regarding porting Postgres
> to NT, but it is a bit out of date, see:
>
> http://www.askesis.nl/AskesisPostgresIndex.html
>
> I ported Postgres to NT successfully :) Thank Joost and Dan for their help.
>
> Hope this helps,
> Kevin.
>
>
>

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

Peter T Mount wrote:
>
> On Mon, 18 Jan 1999, Glenn Holmer wrote:
>
> > --------------------------------------------------------
> >
> > loading JDBC class "postgresql.Driver"...
> >
> > connecting to jdbc:postgresql://miranda:5432/factory...
> >
> > creating skid table...
> > ERROR:  cannot create skids
> >
> > --------------------------------------------------------
>
> Can you create the table using psql?
>
> I've just compiled and tested your class, and it runs fine here unaltered.
>
> Peter
>

Sometimes (rarely) it "just works" using psql, most of the time
I get that message.  I can't seem to isolate the cause (logged in
as database owner, logged in on the same machine, etc).  If it's
not Java (that would be a good thing), which mailing list is most
appropriate for a question like this?  I am quite new to Postgres.
The relevant portion of pg_hba.conf looks like this:

local   all                                   trust
host    all   192.168.6.0   255.255.255.0     trust
host    all   127.0.0.1     255.255.255.255   trust

--
____________________________________________________________
Glenn Holmer                          gholmer@weycogroup.com
Programmer/Analyst                       phone: 414.263.8827
Weyco Group, Inc.                          fax: 414.263.8808