Laura Castro wrote:
> I'm trying to perform a massive load on a postgreSQL database
> from ODBC, but I've found that if the table contains a 'PRIMARY
> KEY' constraint, the sql-insert sentences from my program fail.
> I've also noticed that after creating the table, the ODBC driver
> (unixODBC) warnings me this way:
> NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index for table
> so I think if I could `deactivate' the index before doing the massive
> load it could possibly work, but I can't find the way of deactivating
> indexes looking at the documentation. Can this be done?
> If not, any idea
> about another suitable solution?
You can drop the index before doing the massive load and
can create a unique index with the same name after it.
The only difference is that pg_index.inidisprimary is
set to true or not.
In response to
- Indexes at 2002-07-24 09:44:27 from Laura Castro
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2002-07-25 08:29:25|
|Subject: Re: Write Conflict|
|Previous:||From: Moez Hielmy||Date: 2002-07-25 02:10:30|
|Subject: Write Conflict|