Re: [pgadmin-support] PgAdmin 1.10 Beta 2 - can't create gist index against 8.4

2009-05-14 Thread Quan Zongliang
> There doesn't seem to be a way to turn this off except by explicitly > editing the SQL statement to remove the ASC clause. Can we have it not > enabled by default or if we must -- allow this to be unchecked. Thanks, Rigina. The PostgreSQL documentation mentioned: For index methods that support

[pgadmin-support] PgAdmin 1.10 Beta 2 - can't create gist index against 8.4

2009-05-14 Thread Obe, Regina
I see that the new version of PgAdmin now automatically puts in for CREATE INDEX a the new NULLS FIRST / LAST clause for PostgreSQL 8.4. Unfortunately when you try to use this for a gist index -- it generates something like this CREATE INDEX mytable_idx_the_geom ON mytable USING gist (poi_geo