Problems with inserting into tables...

Hello,

Appended to the description of our problem is how we are trying to
insert sample values into the tables.

The definition for the table is:

--------8<--------
create table personen (
Name text not null,
Strasse text not null,
Hausnummer text not null,
Postleitzahl text not null,
Stadt text not null,
Telefax text[],
eMail text[],
www text[] );

create table hersteller (
Herstellernummer int4 not null primary key,
Telefon text[] not null,
SupportTelefon text[] not null ) inherits ( personen );

create table kunde (
Vorname text not null,
Kundennummer int4 not null primary key,
Telefon text[],
Kontostand money not null,
Kontonummer text not null,
Bankleitzahl text not null,
Kontoinhaber text not null ) inherits ( personen );

create table lieferant (
Lieferantennummer int4 not null primary key,
Telefonnummer text[] not null,
Kontostand money not null,
Kontonummer text,
Bankleitzahl text ) inherits ( personen );

--------8<--------

And this is how we want to fill in the values:

/* Hersteller */
insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Electronic Arts', 1,
'Colordrive', '37 e', '38120', 'Braunschweig',
'+49-531-2880001', '0800-1133', '+49-531-2880002',
'support(at)ea(dot)com', {"www.ea.com", "www.games.com/ea"} );
ERROR: parser: parse error at or near "{"

eMail and www are arrays....

any ideas?

thanks for helping...

............8<----------->8..............

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('EPIC Megagames', 2,
'Colordrive', '19', '38120', 'Braunschweig',
'+49-531-377001', '0800-442233', '+49-531-382141',
'info(at)epic(dot)com', 'www.epic.com' );
ERROR: array_in: Need to specify dimension
commit;
NOTICE: EndTransactionBlock and not inprogress/abort state
insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('LucasArts Games Ltd.', 30,
'StarRoad', '4', '38112', 'Braunschweig',
'+49-531-74747', '0800-911911', '+49-531-74748',
'support(at)lucasarts(dot)com', 'www.lucasarts.com' );
ERROR: array_in: Need to specify dimension

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('LucasArts InterActive Ltd.', 31,
'StarRoad', '4', '38112', 'Braunschweig',
'+49-531-74740', '0800-911911', '+49-531-73744',
{"interactive(at)lucasarts(dot)com", "support(at)lucasarts(dot)com") , 'interactive.lucasarts.com' );
ERROR: parser: parse error at or near "{"
commit;
NOTICE: EndTransactionBlock and not inprogress/abort state
insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('LucasArts Strategic Ltd.', 32,
'StarRoad', '4 b', '38112', 'Braunschweig',
'+49-531-74700', '0800-1000', '+49-531-74777',
'strategic(at)lucasarts(dot)com', 'strategic.lucasarts.com' );
ERROR: array_in: Need to specify dimension

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('FASA Electronic Ltd.', 4,
'Eichenstedt-Allee', '199', '37666', 'Ganzweitdraussen',
'+49-499-2216677', '0190-9331133', '+49-190-7660002',
'support(at)fasa(dot)com', 'www.fasa.com' );
ERROR: array_in: Need to specify dimension
commit;
NOTICE: EndTransactionBlock and not inprogress/abort state
insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Origin Systems', 5,
'Rue de Britannica', '4711', '20202', 'Moonglow',
'+49-411-4114114', '0800-441144', '+49-411-4114111',
'support(at)origin(dot)com', 'www.origin.com' );
ERROR: array_in: Need to specify dimension

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Microsoft', 6,
'Redmondallee', '11', '67667', 'Kohlecity',
'+49-190-99991199', '+49-190-99119911', '+49-190-99779977',
'devnull(at)microsoft(dot)com', 'www.microsoft.com/lizenzgebuehr' );
ERROR: array_in: Need to specify dimension
commit;
NOTICE: EndTransactionBlock and not inprogress/abort state
insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Blueborg Electronics', 7,
'SpaceDrive', '77a', '38114', 'Braunschweig',
'+49-531-388000', '+49-531-776655', '+49-531-388014',
'info(at)blueborg(dot)com', 'www.blueborg.com' );
ERROR: array_in: Need to specify dimension

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('IBM Deutschland Spiele GmbH', 8,
'Bundesallee', '1', '70015', 'Stuttgart',
'+49-711-7853389', { '+49-711-785-0', '+49-711-788-0' }, '+49-180-5200025',
'games(at)ibm(dot)com', 'www.ibm.com' );
ERROR: parser: parse error at or near "{"

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('SSI Strategic Simulations Inc.', 66,
'Pensaukenroad', '44a', 'MA77631', 'Milwaukee',
'+1-377-555-7899', { '+1-377-555-1414', '0800-1414' }, '+1-377-555-7898',
'info(at)ssi(dot)com', 'www.ssi.com' );
ERROR: parser: parse error at or near "{"
commit;
NOTICE: EndTransactionBlock and not inprogress/abort state
insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Mindscape Ltd.', 70,
'Milkywaystreet', '4', 'EAF55XPB', 'Scarborough',
'+44-7-552-7229', { '+44-7-552-8814', '0800-321414' }, '+44-7-553-7229',
'orders(at)mindscape(dot)com', 'www.mindscape.com' );
ERROR: parser: parse error at or near "{"

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Bullfrog', 99,
'Pensaukenroad', '44g', 'MA77631', 'Milwaukee',
'+1-377-555-7894', '0800-77282', '+1-377-555-7891',
'blasters(at)bullfrog(dot)com', 'www.bullfrog.com' );
ERROR: array_in: Need to specify dimension
commit;
NOTICE: EndTransactionBlock and not inprogress/abort state
insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Infocom', 17,
'The Unsolvable Street', '666', 'Unknownland-99', 'Never Solved City',
'+99-969-666-9966', '0800-99669966', '+99-969-666-6699',
'solutionneeded(at)infocom(dot)com', 'www.infocom.com' );
ERROR: array_in: Need to specify dimension

insert into hersteller
(Name, Herstellernummer,
Strasse, Hausnummer, Postleitzahl, Stadt,
Telefon, SupportTelefon, Telefax, eMail, www )
values
('Sirrius', 99,
'Pensaukenroad', '14', 'MA77631', 'Milwaukee',
'+1-377-555-6614', '0800-1883', '+1-377-555-6617',
'orders(at)sirrius(dot)com', 'www.sirrius.com' );
ERROR: array_in: Need to specify dimension
commit;
NOTICE: EndTransactionBlock and not inprogress/abort state