Ivan Voras wrote:
> Hello,
>
> On trying to drop an index named "employer_employerid_key" which supports a
> unique constraint:
>
> "employer_employerid_key" UNIQUE CONSTRAINT, btree (employerid)
>
> I get this error:
>
> ERROR: cannot drop index employer_employerid_key because constrain
On 11/18/15 10:48 AM, Emi wrote:
Hello,
Through java jdbc, is it possible that we do the following steps without
accessexclusivelock for index:
setautocommit(false);
drop index1, 2,;
insert millions records
set index1,2...
commit;
Found this post, but it says only within psql block begin/
"Pau Marc Munoz Torres" <[EMAIL PROTECTED]> writes:
> psql 8.2.6 (server 8.2.5)
> Schema | Name | Type | Owner |Table
> ++---+---+--
> public | h2dbp | index | pau | precalc
> public | icsp | index | pau | local
> public | icspn | index | pau
psql 8.2.6 (server 8.2.5)
Schema | Name | Type | Owner |Table
++---+---+--
public | h2dbp | index | pau | precalc
public | icsp | index | pau | local
public | icspn | index | pau | names
public | idx| index | pau | local
public | iid
Pau Marc Munoz Torres wrote:
> Hi everybody
>
> I have a problem with index, i droped a table before drop their indexs, so,
> now i can't remove the index
That shouldn't be possible. What version of PostgreSQL is this?
--
Richard Huxton
Archonet Ltd
--
Sent via pgsql-general mailing list
On Tue, Jul 22, 2008 at 1:39 AM, Giovanni Nervi
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I would like recreate all indexes on a database, the command reindex
> is exclusive lock on table so I prefer the method drop index and
> create index. Is there a script for extract the command for the create
> ind
