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: 44D1CC12.80709@freemail.hu (view raw or flat)
Thread:
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:
CREATE INDEX name
  ON table
  USING btree
  (column);

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

Responses

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-2014 The PostgreSQL Global Development Group