From: Muhyiddin A.M Hayat <middink@indo.net.id>
To: pgsql-sql@postgresql.org
Subject: Re: auto_increment
Date: Sat, 20 Sep 2003 18:14:38 +0800
Message-ID: <007901c37f60$058de880$1f00a8c0@middinkcomp> (raw)
References: <001d01c37f3e$983ed3a0$2363a8c0@ckeskin>
<002201c37f54$29608e40$1f00a8c0@middinkcomp>
<200309201105.30370.dev@archonet.com>
Where/How can i put this below sql statement, to set value of
guest_guest_id_seq before i do insert to table
SELECT setval('guest_guest_id_seq', max(guest.guest_id)) FROM guest;
i have been try
CREATE TRIGGER "before_insert_guest_update_room_number" BEFORE INSERT
ON "public"."guest" FOR EACH ROW
EXECUTE PROCEDURE "public"."generate_guest_id"();
but error
----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Muhyiddin A.M Hayat" <middink@indo.net.id>; <pgsql-sql@postgresql.org>
Sent: Saturday, September 20, 2003 6:05 PM
Subject: Re: [SQL] auto_increment
> On Saturday 20 September 2003 09:43, Muhyiddin A.M Hayat wrote:
> > Ok, but if i do rollback, the auto_increment don't roolback.
>
> It's not supposed to.
>
> > How to use nextval(), currval() and setval() functions.
>
> Something like:
> INSERT INTO my_table(nextval('my_sequence_name'),'aaa',1);
> But you'll get the same problem.
>
> What are you trying to do with the auto-increment? If you want to
guarantee
> that the numbers go up in sequence and have no gaps (e.g. 1,2,3,4,5 NOT
> 1,2,4,6) then you'll need to do some more work.
>
> Think about what you want to have happen when three clients insert rows at
the
> same time and one rolls back. Once you've decided what you want, ask again
if
> you need some help.
>
> --
> Richard Huxton
> Archonet Ltd
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: middink@indo.net.id
Subject: Re: auto_increment
In-Reply-To: <007901c37f60$058de880$1f00a8c0@middinkcomp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox