Re: sql window issues

[Antoine <melser(dot)anton(at)gmail(dot)com>]

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(at)vale-housing(dot)co(dot)uk> wrote:
>
>
>
> On 6/4/06 21:30, "Antoine" <melser(dot)anton(at)gmail(dot)com> 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.