From: | Raphaël Enrici <blacknoz(at)club-internet(dot)fr> |
---|---|
To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: " keywords... Is it normal ? |
Date: | 2004-09-09 20:29:33 |
Message-ID: | 4140BD2D.7070202@club-internet.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Raphaël Enrici wrote:
> Raphaël Enrici wrote:
>
>> Hi,
>>
>> just noticed something I was not used to see. Is it normal that some
>> postgre keywords are quoted ?
>> http://www.enrici.com/pgadmin/SCREENSHOTS/Scr-1.1.0.20040908.png
>>
>
> Note that it gives me a sql source which is unusable in the query
> window... Example:
Sorry to insist... but I was not clear enough.
Here is my original sql source:
-- Table: pages
DROP TABLE pages;
CREATE TABLE pages
(
page varchar(50) NOT NULL DEFAULT '',
content bytea NOT NULL,
changetime timestamp NOT NULL
)
WITH OIDS;
GRANT ALL ON TABLE pages TO ralph WITH GRANT OPTION;
GRANT ALL ON TABLE pages TO GROUP "www-data";
I run it in the query window and then look at it in the schema browser
and re-open it in the query window... it gives the following source
which is unusable:
-- Table: pages
-- DROP TABLE pages;
CREATE TABLE pages
(
page "varchar"(50) NOT NULL DEFAULT ''::character varying,
content bytea NOT NULL,
changetime "timestamp" NOT NULL
)
WITH OIDS;
GRANT ALL ON TABLE pages TO ralph WITH GRANT OPTION;
GRANT ALL ON TABLE pages TO GROUP "\""www-data\""";
Known one ?
Regards,
Raphaël
From | Date | Subject | |
---|---|---|---|
Next Message | Diego A. Gil | 2004-09-10 02:58:44 | just a question .. |
Previous Message | Raphaël Enrici | 2004-09-09 20:24:30 | Re: " keywords... Is it normal ? |