DROP INDEX(7) SQL Commands DROP INDEX(7)NAME
DROP INDEX - remove an index
SYNOPSIS
DROP INDEX index_name [, ...] [ CASCADE | RESTRICT ]
INPUTS
index_name
The name (optionally schema-qualified) of an index to remove.
CASCADE
Automatically drop objects that depend on the index.
RESTRICT
Refuse to drop the index if there are any dependent objects. This is the default.
OUTPUTS
DROP INDEX
The message returned if the command completes successfully.
ERROR: index "index_name" does not exist
This message occurs if index_name is not an index in the database.
DESCRIPTION
DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.
NOTES
DROP INDEX is a PostgreSQL language extension.
Refer to CREATE INDEX [create_index(7)] for information on how to create indexes.
USAGE
This command will remove the title_idx index:
DROP INDEX title_idx;
COMPATIBILITY
SQL92
SQL92 defines commands by which to access a generic relational database. Indexes are an implementation-dependent feature and hence there
are no index-specific commands or definitions in the SQL92 language.
SQL - Language Statements 2002-11-22 DROP INDEX(7)
Check Out this Related Man Page
DROP INDEX(7) PostgreSQL 9.2.7 Documentation DROP INDEX(7)NAME
DROP_INDEX - remove an index
SYNOPSIS
DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.
PARAMETERS
CONCURRENTLY
Drop the index without locking out concurrent selects, inserts, updates, and deletes on the index's table. A normal DROP INDEX acquires
exclusive lock on the table, blocking other accesses until the index drop can be completed. With this option, the command instead waits
until conflicting transactions have completed.
There are several caveats to be aware of when using this option. Only one index name can be specified, and the CASCADE option is not
supported. (Thus, an index that supports a UNIQUE or PRIMARY KEY constraint cannot be dropped this way.) Also, regular DROP INDEX
commands can be performed within a transaction block, but DROP INDEX CONCURRENTLY cannot.
IF EXISTS
Do not throw an error if the index does not exist. A notice is issued in this case.
name
The name (optionally schema-qualified) of an index to remove.
CASCADE
Automatically drop objects that depend on the index.
RESTRICT
Refuse to drop the index if any objects depend on it. This is the default.
EXAMPLES
This command will remove the index title_idx:
DROP INDEX title_idx;
COMPATIBILITY
DROP INDEX is a PostgreSQL language extension. There are no provisions for indexes in the SQL standard.
SEE ALSO
CREATE INDEX (CREATE_INDEX(7))
PostgreSQL 9.2.7 2014-02-17 DROP INDEX(7)
I have a webpage, http://my.dns.com/~zp523/index.html,
I want all people to have read and execute privileges. I want to extend it with execute privilege. Which command should be used in chmod?
is it only give read(r) & execute(x) parameter in 'chmod ??? index.html'
thk a lot!! (1 Reply)
My system bench mark results
INDEX VALUES
TEST BASELINE RESULT INDEX
Arithmetic Test (type = double) 2541.7 876123.7 344.7
Dhrystone 2 without register variables 22366.3 5411602.3 ... (1 Reply)
Hai,
I have strings as follows.
0 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0030166' (INDEX (UNIQUE))
1 INDEX MODE: ANALYZED (UNIQUE SCAN) OF 'SYS_C0029845' (INDEX (UNIQUE)
9 INDEX MODE: ANALYZED (RANGE SCAN) OF ... (2 Replies)
Hi I am trying to substitute 2 words on the same line with _S02 as suffix. Like this .
IN "TSOPS09" INDEX IN "TSOPIX09" ;
to
IN "TSOPS09_S02" INDEX IN "TSOPIX09_S02" ;
i used the following code to make the change , it works fine for first substitution not the second one .
... (6 Replies)
Hi ,
I have a question. How do I replace 2 words in one line like this
IN CLO07 INDEX IN CLOIX07
to
IN CLO07_S02 INDEX IN CLOIX07_S02
But one thing to remember is that there are lots of words like CLODM001 .
So the only matching pattern is "IN CLO"
sample file... (4 Replies)
Hi,
There seems to some hack attempts in my site. I have attached the index page of my site and I need to remove the below lines from the index page. The below lines are at the center of the file.
-->
</style>
<script>E V A L( unescape(... (5 Replies)
Hi Guys,
I need to create a insert query for the below file
Fri Sep 4 06:25:51 2009
ACTION : 'CREATE INDEX S100S_DC.PLInsuranceReportRules_testI1 ON S100S_DC.PLInsuranceReportRules_test1(ENTITY_KEY)'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL: pts/3... (6 Replies)
Hi Folks,
Under the path /home, I need to remove the index.html/php files from all the users. But the thing is I need to move the index file from the username starting with a-d, then e-g. How can I do this via the shell script. (2 Replies)
hello everybody,
here's my code
mkf ()
{
INDEX=0;
while ; do
touch "file$1.f";
INDEX=$INDEX+1;
done
}
when I type
mkf 10
the loop seems to act infinite
and only the last file of the loop is created, in the example below, there just is file10.f in... (11 Replies)
Hi,
i want to extract the 'CREATE INDEX' or 'CREATE UNIQUE INDEX' statements from a ddl file and output each match to a separate file. i was looking around the net but couldnīt find anything.
a possible sed-script could be:
sed -n '/CREATE*INDEX*/,/COMMIT/p' filename.ddlbut i couldnīt find out... (11 Replies)
I have a series of observations of which one column is sometimes missing (zero):
date temp delta
1977 284.54 29.84
1978 149.82 0
1979 320.71 28.45
1980 176.76 0
1981 854.65 0
1984 817.65 0
1985 990.58 27.98
1986 410.21 0
1987 405.93 0
1988 482.9 0
What I would like to achieve is a... (8 Replies)
dear all,
i need your advice for convert bash shell to C programming
INDEX=/zpool1/NFS/INDEX/${1}
SCRIPT=/zpool1/NFS/script/${1}
LIST=SAMPLE
cd ${SCRIPT}
for i in `cat ${LIST}`
do
GETDATE=`echo ${i}|awk '{print substr($1,9,8)}'`
/usr/xpg4/bin/awk -F ":" '{close(f);f=$4}{print >>... (2 Replies)
hallow all i need your advice about this script
i have script like this:
INDEX=/zpool1/NFS/INDEX/${1}
SCRIPT=/zpool1/NFS/script/${1}
LIST=SAMPLE
cd ${SCRIPT}
for i in `cat ${LIST}`
do
GETDATE=`echo ${i}|awk '{print substr($1,9,8)}'`
/usr/xpg4/bin/awk -F ":" '{close(f);f=$4}{print >>... (4 Replies)
OK, so I just messed myself up. Thinking the /var/opt/ignite/data/INDEX files was static, I manually edited the file and added 2 more OS's to it. During an Install it only showed the first OS (started with 11.31, 3 versions then added a 11.23, and a 11.11 stanza's).
The 11.23 and 11.11 never... (2 Replies)