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

Re: No permission to set nextval of sequence

From: Vince Vielhaber <vev(at)michvhf(dot)com>
To: Joachim Andree <jandree(at)gcd(dot)de>
Cc: <Pgsql-Odbc(at)postgresql(dot)org>
Subject: Re: No permission to set nextval of sequence
Date: 2001-07-23 09:35:37
Message-ID: Pine.BSF.4.30.0107230534090.41103-100000@paprika.michvhf.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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(at)michvhf(dot)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
==========================================================================




In response to

pgsql-odbc by date

Next:From: charlie derrDate: 2001-07-23 12:15:00
Subject: Re: Filemaker and pgsql
Previous:From: Henshall, Stuart - WCPDate: 2001-07-23 08:21:56
Subject: RE: Access 97 - problems with the result set

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