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? Cheers Antoine On 06/04/06, Dave Page <dpage@vale-housing.co.uk> wrote: > > > > On 6/4/06 21:30, "Antoine" <[EMAIL PROTECTED]> wrote: > > > Hi, > > I have always liked the fact that when I click on a table I get the > > code to (re)create the table. It just don't seem to work when I try it > > in the sql window though... Even under 1.4.2, I regularly have queries > > that I can't execute in the sql window - what gives? Today I had to > > copy and paste a create table into a psql console on my remote > > postgres server! > > Can someone give me some idea of what is happening here? > > Not without a better definition of "It just don't seem to work". What error > message do you get? > > Regards, Dave. > > -- This is where I should put some witty comment. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
