SEO

#1 (**permalink**) 04-17-2008, 07:23 PM

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?
Cheers
Antoine

--
This is where I should put some witty comment.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#2 (**permalink**) 04-17-2008, 07:23 PM

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.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#3 (**permalink**) 04-17-2008, 07:23 PM

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@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.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

sql window issues