Re: " keywords... Is it normal ?

Hi,

I have the some trouble in Fedora Core 2, with a cvs tree checked out
yesterday.

I thougth that it was working OK, until I tried to make a new table.
These bug make pgadmin3 almost unusable. It's strange that nobody else
complains !.

I will try to find what changed from my last working snapshot.

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