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 [EMAIL PROTECTED]
Leimbachstr. 56 Tel 01/4802800
8041 Zuerich Fax 01/4802801
=====================================
