-Original Message-
From: "Antoine"<[EMAIL PROTECTED]>
Sent: 09/04/06 11:38:08
To: "Dave Page"
Cc: "pgadmin-support@postgresql.org"
Subject: Re: [pgadmin-support] sql window issues
> ps. I remember using a db frontend that had a syntax check fun
> 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 execut
> -Original Message-
> From: Antoine [mailto:[EMAIL PROTECTED]
> 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
> -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
>
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 lign
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 exec
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
