| 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: | Whole Thread | Raw Message | 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 |