From: | "Joachim Andree" <jandree(at)gcd(dot)de> |
---|---|
To: | <Pgsql-Odbc(at)postgresql(dot)org> |
Subject: | No permission to set nextval of sequence |
Date: | 2001-07-23 07:15:53 |
Message-ID: | 001e01c11347$4fd3a240$4e04a8c0@gcd.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gcd(dot)de, HTTP://www.gcd.de
_________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Henshall, Stuart - WCP | 2001-07-23 08:13:26 | RE: Access 2000 and ODBC driver Data changed by another user, Cop y to Clipboard or Drop changes |
Previous Message | Randall Perry | 2001-07-23 01:37:15 | Filemaker and pgsql |