| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Sequence skipping values |
| Date: | 2006-02-11 00:08:57 |
| Message-ID: | 43ED2B19.60004@pinpointresearch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jean-Christophe Roux wrote:
> Hi,
> Thanks four your answers. Let me give more details here.
> The table with the id not incrementing by 1 as I expected is named topics.
>
> I have three other tables that contain rules that on insert into those
> tables, some fields of the table Topic should be updated.
> Each of those three tables contain a column that refer to topics.id as a
> foreign key.
> Those three columns contain id automatically generated by sequences and I
> have not observed any problem
Start psql and on each of those tables run "\d <tablename>". Also run
"select * from <sequencename>" for any sequences involved. Post results
here - I suspect some clues will be contained therein.
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-02-11 02:08:44 | Re: Sequence skipping values |
| Previous Message | Jean-Christophe Roux | 2006-02-10 23:27:23 | Re: Sequence skipping values |