Jailer / Bugs / #43 PostgreSQL: Export of inet and interval

#43 PostgreSQL: Export of inet and interval

Milestone: v1.0_(example)

Status: pending-fixed

Owner: Ralf Wisser

Labels: None

Priority: 5

Updated: 2020-08-05

Created: 2020-07-30

Creator: Dennis Nowak

Private: No

Hi Ralf,

i have issues inserting scripst with columns of certain data types in postgresql database.

When exporting a value of type inet Jailer produces: "'192.168.1.1'"
PostgreSQL states: ERROR: column "terminal_ip" is of type inet but expression is of type text
Simply adding "::inet" solves this issue.

When exporting a value of type interval Jailer produces: "0 years 0 mons 0 days 0 hours 0 mins 0.00 secs"
PostgreSQL states: ERROR: syntax error at or near "years"
Quoting and casting this value resloves the issue: "'0 years 0 mons 0 days 0 hours 0 mins 0.00 secs'::INTERVAL"

Discussion

Ralf Wisser - 2020-07-31

Hi Dennis,

Thanks for the report, this is indeed a bug.
Based on release 9.5.0 I have attached a patch here. If you want to test it, please replace the files "jailer.jar" and "jailer.xml" with those in the attachment.

jailer.jar

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.
- Ralf Wisser - 2020-07-31
  
  Here is the second file.
  
  jailer.xml
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
  - Anonymous
    
    Add attachments
    Cancel
    You seem to have CSS turned off. Please don't fill out this field.
    
    You seem to have CSS turned off. Please don't fill out this field.

Dennis Nowak - 2020-07-31

Great. That solves the issues.
Thanks for the fast response.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Ralf Wisser - 2020-08-05

status: open --> pending-fixed

assigned_to: Ralf Wisser
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Ralf Wisser - 2020-08-05

fixed in release 9.5.1

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous

PostgreSQL: Export of inet and interval

Database Subsetter and Relational Data Browser

Group

Searches

Help

#43 PostgreSQL: Export of inet and interval

Discussion