Обсуждение: No permission to set nextval of sequence

Поиск
Список
Период
Сортировка

No permission to set nextval of sequence

От
"Joachim Andree"
Дата:
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
_________________________________________________________

Re: No permission to set nextval of sequence

От
Vince Vielhaber
Дата:
On Mon, 23 Jul 2001, Joachim Andree wrote:

> 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

It's a known problem, you need to go in and reset the permissions on
the sequences.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH    email: vev@michvhf.com    http://www.pop4.net
         56K Nationwide Dialup from $16.00/mo at Pop4 Networking
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================