Problems with inserting into tables...
От | Gemeinschaft Studienarbeit Datenbanken |
---|---|
Тема | Problems with inserting into tables... |
Дата | |
Msg-id | 199809261655.3937655.6@onyx обсуждение исходный текст |
Список | 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
В списке pgsql-sql по дате отправления: