Try:
insert into
offene_stellen (bezeichnung,arbeitsort,berater,gefordert,geboten)
values
('Maurer', 'Buchs', 'Rheinhalter Claudio', 'flexibilitaet', 'gutes Team');
Gregory S. Youngblood
ext 2164
-----Original Message-----
From: Marc Eggenberger [mailto:me@ieo.ch]
Sent: Tuesday, October 06, 1998 4:30 AM
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] Still the problem with the autoincrement field
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
=====================================
