Received: from linux1.ieo.ch (root@[194.209.247.91]) by hub.org (8.8.8/8.8.8) with ESMTP id FAA24680 for ; Tue, 6 Oct 1998 05:29:41 -0400 (EDT) (envelope-from me@ieo.ch) Received: from ieo.ch (centauri-prime.ieo.ch [194.209.247.90]) by linux1.ieo.ch (8.8.8/8.8.7) with SMTP id LAA10725 for ; Tue, 6 Oct 1998 11:30:25 +0200 Message-Id: <199810060930.LAA10725@linux1.ieo.ch> Date: Tue, 6 Oct 1998 11:29:39 +0200 From: Marc Eggenberger Reply-To: Marc Eggenberger To: pgsql-general@postgresql.org Subject: Still the problem with the autoincrement field X-Mailer: Marc Eggenberger's registered AK-Mail 3.0b sppb1 [ger] Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id FAA24686 Hi there. As two people said I created now a sequence .... I have the following now: Database = jobforum +------------------+----------------------------------+----------+ | Owner | Relation | Type | +------------------+----------------------------------+----------+ | postgres | offene_stellen | table | | postgres | seq | sequence | +------------------+----------------------------------+----------+ Table = offene_stellen +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | id | int4 default nextval ( 'seq' ) | 4 | | bezeichnung | char() | 100 | | arbeitsort | char() | 100 | | berater | char() | 100 | | gefordert | char() | 1000 | | geboten | char() | 1000 | +----------------------------------+----------------------------------+-------+ Table = seq +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | sequence_name | name | 32 | | last_value | int4 | 4 | | increment_by | int4 | 4 | | max_value | int4 | 4 | | min_value | int4 | 4 | | cache_value | int4 | 4 | | is_cycled | char | 1 | | is_called | char | 1 | +----------------------------------+----------------------------------+-------+ and when I want to add some data .. how to do this? when I do the following: insert into offene_stellen values ('', 'Maurer', 'Buchs', 'Rheinhalter Claudio', 'flexibilitaet', 'gutes Team'); the id field is always 0, and when I do a: insert into offene_stellen values ('Maurer', 'Buchs', 'Rheinhalter Claudio', 'flexibilitaet', 'gutes Team'); I get a: ERROR: pg_atoi: error in "Maurer": can't parse "Maurer" How do I add data, so that the id field is autoincremented? -- mit freundlichen Gruessen ===================================== Eggenberger Marc me@ieo.ch Leimbachstr. 56 Tel 01/4802800 8041 Zuerich Fax 01/4802801 =====================================