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

Re: sequences problem

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: gsmd(at)gmx-topmail(dot)de
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: sequences problem
Date: 2006-05-19 13:23:06
Message-ID: 20060519132306.GE9080@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugs
gsmd(at)gmx-topmail(dot)de wrote:
> >Could you provide a complete test case?
> As I've been told, there is no special code, just a usual sequence
> usage. There is no small part of code that can be reproduced.

How do you use tose sequences?

> The situation is that there are 2 applications working with the same
> DB and accessing sequences. Each time application is started the
> sequences are reloaded (without doing this the sequences go crazy,
> e.g. you can get 1000 with 5 being the last value).

What do you mean by reloaded?

> > What's the output of
> > "SELECT * FROM sequence_name"?
> ERROR:  relation "sequence_name" does not exist

Of course, you should have replaced "sequence_name" with the name of
your sequence.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-05-19 14:18:19
Subject: Re: BUG #2443: 1 hour error at date calculation
Previous:From: Jagadish Prasath RamuDate: 2006-05-19 10:09:24
Subject: BUG #2444: XA Connections given by posgres driver has auto-commit value false by default

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