pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gemeinschaft Studienarbeit Datenbanken <oodbms@floppy.org>
To: PostgreSQL SQL Mailing List <pgsql-sql@hub.org>
Subject: Problems with inserting into tables...
Date: Sat, 26 Sep 1998 16:55:39 +0100
Message-ID: <199809261655.3937655.6@onyx> (raw)

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 








Message-ID: <199809261655.3937655.6@onyx>
Permalink:  ../199809261655.3937655.6@onyx/
Also on:    postgresql.org/message-id/199809261655.3937655.6@onyx

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: oodbms@floppy.org, pgsql-sql@hub.org
  Subject: Re: Problems with inserting into tables...
  In-Reply-To: <199809261655.3937655.6@onyx>
  References: <199809261655.3937655.6@onyx>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox