Backup not attaching schema prefix to indexes

Backup not attaching schema prefix to indexes

Postby ccampbell » Thu 04 Apr 2013 18:05

Hi, (Using VB.Net 2010 & Devart.Data.PostgreSQL 6.6.217.0)

I ran into a problem where by backups are no longer restoring. I've traced the problem to the section in the backup where the indexes are getting created. Here is an example:

CREATE INDEX idx_aiimportlog_contactkey ON aiimportlog USING btree (contactkey NULLS FIRST);

As you can see, the table reference (aiimportlog) has no schema prefix. As a result it's looking in the the Public schema, not finding the table, and erroring out. All other references to the database objects have a schema prefix (schema.tablename, schema.viewname, etc.)

I'd hate to think that all the backups that my customers are making are useless, however, since it appears that the backup file was created incorrectly, I don't see a good way to resolve this.

Any ideas or suggestions would be greatly appreciated.

Sincerely,

Chris Campbell
ccampbell
 
Posts: 29
Joined: Tue 01 Jun 2010 17:31
Location: Oregon

Re: Backup not attaching schema prefix to indexes

Postby Pinturiccio » Fri 05 Apr 2013 14:31

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
Pinturiccio
Devart Team
 
Posts: 1983
Joined: Wed 02 Nov 2011 09:44

Re: Backup not attaching schema prefix to indexes

Postby Pinturiccio » Thu 18 Apr 2013 14:39

The new build of dotConnect for PostgreSQL 6.6.224 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgresql/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=26908
Pinturiccio
Devart Team
 
Posts: 1983
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for PostgreSQL