Re: sql window issues

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

> -----Original Message-----
> From: Antoine [mailto:melser(dot)anton(at)gmail(dot)com] 
> Sent: 07 April 2006 08:54
> To: Dave Page
> Cc: pgadmin-support(at)postgresql(dot)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