The following bug has been logged on the website:
Bug reference: 12259
Logged by: Michal
Email address: fcs1(at)poczta(dot)onet(dot)pl
PostgreSQL version: 9.1.14
Operating system: Windows 7 x64 Ultimate
Description:
Hello,
I have two schemas: public and blob01.
In blob01 schema I have only one table "blob" with primary index ID defined
as
nextval('blob01.osr_blob_id_seq'::regclass)
After restoring by PG_restore the definition is changed to
nextval('osr_blob_id_seq'::regclass), the schema definition is dropped.
Due to this the sequence is not accessible because it is in blob01 schema,
not in public schema.
How to restore blob01 saving schema for definition the ID field ?
Regards
Michal