Re: [SQL] Removing a constraint?

2001-01-06 Thread mlw
Michael Davis wrote: > Does anyone know how to completely and accurately remove or drop a > constraint, specifically a foreign key constraint? I tried to remove a > constraint by deleting it's trigger from pg_triggers. This caused some > undesirable side effects with other tables involved with

Re: [SQL] Index of a table is not used (in any case)

2001-10-23 Thread mlw
Doug McNaught wrote: > Reiner Dassing <[EMAIL PROTECTED]> writes: > > > Hello PostgreSQl Users! > > > > PostSQL V 7.1.1: > > > > I have defined a table and the necessary indices. > > But the index is not used in every SELECT. (Therefore, the selects are > > *very* slow, due to seq scan on > > 20