View Issue Details

IDProjectCategoryView StatusLast Update
0000806PostgreSQLGeneralpublic2020-02-23 08:00
Reportershirokov Assigned Tobarry  
Status closedResolutionfixed 
Summary0000806: The PostgreSQL parser (and db extractor) comparing errors.
DescriptionThe customer has reported about database comparing errors in parsing of "select from into" statement (see the attached screenshot Database+Comparer+v.

I tried to reproduce the error and compared the provided master and target scripts: there are multiple extraction errors:
1. the parser does not recognize the DROP DATABASE statement
2. the CREATE DATABASE parsing error (WITH is not recognized)

I've commented out both statements and tried to compare the databases again:
3. ALTER database is not parsed.
4. CREATE EXTENSION is not parsed.

The master and target db scripts are attached as well.
TagsNo tags attached.



2015-04-06 15:16

administrator (145,310 bytes)

Issue History

Date Modified Username Field Change
2015-04-06 15:16 shirokov New Issue
2015-04-06 15:16 shirokov File Added:
2019-04-19 14:54 barry Project Database Comparer => PostgreSQL
2019-12-12 21:03 barry Assigned To => barry
2019-12-12 21:03 barry Status new => resolved
2019-12-12 21:03 barry Resolution open => fixed
2020-02-23 08:00 barry Status resolved => closed