Problems with inserting into tables... - Mailing list pgsql-sql

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@ea.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@epic.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@lucasarts.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@lucasarts.com", "support@lucasarts.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@lucasarts.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@fasa.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@origin.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@microsoft.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@blueborg.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@ibm.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@ssi.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@mindscape.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@bullfrog.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@infocom.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@sirrius.com', 'www.sirrius.com' );
ERROR:  array_in: Need to specify dimension
commit;
NOTICE:  EndTransactionBlock and not inprogress/abort state