Re: sql window issues

> -----Original Message-----
> From: Antoine [mailto:melser(dot)anton(at)gmail(dot)com]
> Sent: 07 April 2006 19:21
> To: Dave Page
> Subject: Re: [pgadmin-support] sql window issues
>
> > What does: La requête a inséré une ligne d'OID 0. mean?
>
> It means "The query inserted a line (row) with OID 0"
>
> We have this on (at least) several win 2000 pro machines. We
> are running postgres 8.1.1 on an mdk 10.1 but I can't see how
> that would make any difference...
> btw, a number of these queries I run with the analyse button,
> as I like to check what is going to happen beforehand. They
> give me an error so I don't bother executing...
> Any pointers welcome.
> Cheers
> Antoine
> ps. we have been running 1.4.1 for some time now but same
> deal when I upgraded to 1.4.2.

Well the error comes from PostgreSQL, not pgAdmin - and now you mention you are using EXPLAIN ANALYZE it all makes sense. EXPLAINing a CREATE TABLE is pointless and unsupported by PostgreSQL. You will get the same error from psql.

If you want to test one or more queries before executing them for real, try something like:

BEGIN;

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";

ROLLBACK;

Then when you're happy, just change the ROLLBACK to COMMIT.

Regards, Dave.