Permission denied for sequece...
От | Jon Horsman |
---|---|
Тема | Permission denied for sequece... |
Дата | |
Msg-id | 4f4c2a010608211203j6591249cifc9c0a793183aee@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Permission denied for sequece...
|
Список | 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
В списке pgsql-jdbc по дате отправления: