From: | "Jon Horsman" <horshaq(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Permission denied for sequece... |
Date: | 2006-08-21 19:03:42 |
Message-ID: | 4f4c2a010608211203j6591249cifc9c0a793183aee@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hey,
I'm in the process of porting an app from MySQL to PostgreSQL and am
pretty new with PostgreSQL and am having permission problems.
First, a little background info.
- The postmaster is set to startup with -i and i'm able to actually
connect without an exception.
- I've added the following lines to the pg_hba.conf files (for testing purposes)
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
I create my db, as follows:
createdb testdb
then i log into psql and run the following
CREATE USER testuser PASSWORD 'default';
GRANT ALL ON DATABASE testdb TO testuser;
GRANT ALL ON [my table names] TO testuser;
In my app i connect to the db with the following, which is run without issue.
connection = DriverManager.getConnection("jdbc:postgresql:testdb",
"testuser", "default");
I then call the following insert
INSERT INTO Property (Name,Value) VALUES ("some name", "some value")
and get the following error
org.postgresql.util.PSQLException: ERROR: permission denied for
sequence property_propertyid_seq
The sql used to create the property table is
CREATE TABLE Property
(PropertyID SERIAL PRIMARY KEY,
Name VARCHAR(64) UNIQUE NOT NULL,
Value VARCHAR(255) NOT NULL);
Can someone tell me what would cause this error message to occur and
suggest ways that i could fix it?
Thanks,
Jon Horsman
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2006-08-21 20:55:02 | Re: Permission denied for sequece... |
Previous Message | student23 | 2006-08-21 08:06:54 | I can't retrieve a scrollable ResultSet from CallableStatement |