No permission to set nextval of sequence
От | Joachim Andree |
---|---|
Тема | No permission to set nextval of sequence |
Дата | |
Msg-id | 001e01c11347$4fd3a240$4e04a8c0@gcd.de обсуждение исходный текст |
Ответы |
Re: No permission to set nextval of sequence
|
Список | pgsql-odbc |
Hi, after upgrade from 6.5.3 to PostgreSQL 7.1.2 my ODBC-calls don't work. The following sql-statement should insert a new record into a table with a sequence visclient fb-11b ENTER SQLExecDirect HSTMT 018425D0 UCHAR * 0x088D0E80 [ 98] "insert into st_login2(log_name,log_in,log_machine) VALUES ('vt71','20.07.01 09:17:22','gcdw4078');" if i connect to the database as user 'postgres' it works, when i connect as anybody else i get the following error: DIAG [00000] Error while executing the query (non-fatal); ERROR: idlogin.nextval: you don't have permissions to set sequence idlogin (-1) Permission to the table are correct, but I don't know where i can set permissions to a sequence Has anybody an idea? thx Joachim _________________________________________________________ Joachim Andree GCD - Systemhaus mbH Weisse Breite 3 D-49084 Osnabrück Softwareentwicklung, +49 541 73091 Voice,+49 541 73095 Fax E-Mail: JAndree@gcd.de, HTTP://www.gcd.de _________________________________________________________
В списке pgsql-odbc по дате отправления: