Skip site navigation (1) Skip section navigation (2)

Missing PgAdmin Feature

From: yoursoft <yoursoft(at)freemail(dot)hu>
To: pgadmin-support(at)postgresql(dot)org
Subject: Missing PgAdmin Feature
Date: 2006-08-03 10:12:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
Dear Developers,

Create varchar index with command:
CREATE INDEX name ON table (colum text_pattern_ops);

When you select index or table in left tree, In the reversed sql window 
you will see:
  ON table
  USING btree

In the properties window of index you see:
operator classes: text_pattern_ops

I think in the reversed sql window should be:
CREATE INDEX name ON table (colum text_pattern_ops);

If you backup the table, you will find in the sql script:
CREATE INDEX name ON table (colum text_pattern_ops);
(it is good)

Best Regards,
    Ferenc Lutischan


pgadmin-support by date

Next:From: Dave PageDate: 2006-08-03 10:15:01
Subject: Re: Missing PgAdmin Feature
Previous:From: ben sewellDate: 2006-08-03 09:25:37
Subject: Cannot run pgAgent after install

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group