From: | "Diego A(dot) Gil" <diego(at)adminsa(dot)com> |
---|---|
To: | Raphaël Enrici <blacknoz(at)club-internet(dot)fr> |
Cc: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, PgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: " keywords... Is it normal ? |
Date: | 2004-09-10 04:28:41 |
Message-ID: | 1094790520.3271.18.camel@roadwarrior.adminsa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Hi all,
It seems that the only "quoted" types are :
SET
any
bit
char
interval
numeric
time
timestamp
trigger
unknown
varchar
that makes any sense for anyone ?
Other types, like int2, int4, date, text, etc don't get quotes.
Diego.
El jue, 09-09-2004 a las 17:29, Raphaël Enrici escribió:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-09-10 08:22:58 | Re: " keywords... Is it normal ? |
Previous Message | Diego A. Gil | 2004-09-10 03:05:07 | Re: " keywords... Is it normal ? |