Received: from onyx (ONyx.Floppy.ORG [195.222.226.249]) by hub.org (8.8.8/8.8.8) with SMTP id KAA28166 for ; Sat, 26 Sep 1998 10:55:06 -0400 (EDT) (envelope-from oodbms@floppy.org) Received: from onyx.floppy.org (onyx.floppy.org [195.222.226.249] ) by onyx (Hethmon Brothers Smtpd) ; Sat, 26 Sep 1998 16:55:39 +0100 Message-Id: <199809261655.3937655.6@onyx> From: "Gemeinschaft Studienarbeit Datenbanken" To: "PostgreSQL SQL Mailing List" Date: Sat, 26 Sep 1998 16:55:39 +0100 Reply-To: "Gemeinschaft Studienarbeit Datenbanken" Priority: Normal X-Mailer: PMMail 1.96a For OS/2 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Subject: 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@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