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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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