Skip site navigation (1) Skip section navigation (2)

No permission to set nextval of sequence

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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
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
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

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

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://


pgsql-odbc by date

Next:From: Henshall, Stuart - WCPDate: 2001-07-23 08:13:26
Subject: RE: Access 2000 and ODBC driver Data changed by another user, Cop y to Clipboard or Drop changes
Previous:From: Randall PerryDate: 2001-07-23 01:37:15
Subject: Best methods for selecting, editing data in Access 2000

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group