View Issue Details

IDProjectCategoryView StatusLast Update
0000806PostgreSQLGeneralpublic2020-02-23 08:00
Reportershirokov Assigned Tobarry  
PriorityhighSeveritymajorReproducibilityalways
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.6.1.0.1652.png)

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.

Activities

shirokov

2015-04-06 15:16

administrator  

postgre_error.zip (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: postgre_error.zip
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