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

Updating of serial ID fields

From: Lan Barnes <lan(at)falleagle(dot)net>
To: Postgres Newbie <pgsql-novice(at)postgresql(dot)org>
Subject: Updating of serial ID fields
Date: 2006-07-19 20:46:13
Message-ID: 20060719204613.GA24974@falleagle.net (view raw or flat)
Thread:
Lists: pgsql-novice
I have defined several tables with a field names "id" that is type
serial-not null-primary index. Here is a partial dump:

CREATE TABLE builds (
    id serial NOT NULL,
    dev_label character varying(25),
    build_label character varying(25),
    build_category character varying(15),
    sw_delta_build text,
    request_date date,
    delivery_date date,
    scm_remarks text,
    requester character varying(25),
    build_reason text,
    build_number character varying(5),
    code_line character varying(25),
    unit_test_results text,
    change_lists_submitted text,
    lines_of_code character varying(8),
    build_logs text,
    special_instructions text,
    build_status character varying(10),
    scm_builder character varying(15)
);

The field in question is the first field.

I have written front ends in Tcl/Tk (using pgtcl) to, among other
things, insert records. Originally, I added logic to get the last value
on this field, increment it, and then insert the new value. However, I
noticed that this happened whether or not I added the logic, so I
stopped doing that.

Now after several iterations, I find that this is no longer happening.
Also, even though the dumps still list these fields as serial, pgaccess
now says they're int4.

I have done several schema saves, db drops, and schema restores. Did I
lose something?

I figured these fields were getting updated as automatic triggers. I
need them to stay consistent for internal integrity. How do I best do
this?

TIA,

-- 
Lan Barnes
Linux Guy, SCM Specialist     
Tcl/Tk Enthusiast 

No matter how good you feel, if four friends tell you you're drunk,
you'd better lie down.
                             - Theodore Sorensen


Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2006-07-19 21:38:25
Subject: Re: Updating of serial ID fields
Previous:From: Gregory AmatoDate: 2006-07-19 18:40:51
Subject: Installation error

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