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

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

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