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
CONSTRAINTpk_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" <melser.anton@gmail.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.
