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] i need help its not working

2009-05-14 Thread chris . sullivan
Hi my name is Chris I have been asked to create a data base with apache, php, postgreSQL. now so far hi been able to get apache and php to work with each other but I spent the last few day trying to combind mysql and postgresql with the apache. I fresh out of ideas. when installing postgresql

[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