> -----Original Message----- > From: Antoine [mailto:[EMAIL PROTECTED] > Sent: 07 April 2006 08:54 > To: Dave Page > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] sql window issues > > Here is a typical error: > > CREATE TABLE etape > ( > n_etp_code numeric(6) NOT NULL, -- identifiant de la table > t_etp_intitule varchar(50), -- nom en clair de l'étape > CONSTRAINT pk_etape PRIMARY KEY (n_etp_code) > ) > WITHOUT OIDS; > ALTER TABLE etape OWNER TO "PRODUCTION"; > > > La requête a inséré une ligne d'OID 0. > > ERROR: syntax error at or near "numeric" at character 45 > > Could it be an encoding issue? That pgadmin doesn't like code > from a copy paste?
The code above works fine for me, copied'n'pasted from your email: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pk_etape" for table "etape" Query returned successfully with no result in 313 ms. What does: La requête a inséré une ligne d'OID 0. mean? Regards, Dave ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
