From: | Antoine <melser(dot)anton(at)gmail(dot)com> |
---|---|
To: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: sql window issues |
Date: | 2006-04-07 07:53:50 |
Message-ID: | 92d3a4950604070053h3b60398dhbc281e57005c3b55@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-04-07 08:25:29 | Re: sql window issues |
Previous Message | Dave Page | 2006-04-06 20:41:23 | Re: sql window issues |