[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-7009) PostgreSQL 8.1 and earlier does not support if exists before drop

[Gail Badner (JIRA)]

    [ https://hibernate.onjira.com/browse/HHH-7009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=45332#comment-45332 ] 

Gail Badner commented on HHH-7009:
----------------------------------

Here is what I propose:

1) move all the stuff from PostgreSQLDialect into PostgreSQL81Dialect, but don't override supportsIfExistsBeforeTableName()
2) PostgreSQL82Dialect extends PostgreSQL81Dialect; overrides supportsIfExistsBeforeTableName() to return true
3) PostgreSQLDialect extends PostgreSQL82Dialect

PostgreSQLDialect will be deprecated in 4.1.0 (HHH-7014) and will be removed in 5.0 (HHH-7015).

> PostgreSQL 8.1 and earlier does not support if exists before drop
> -----------------------------------------------------------------
>
>                 Key: HHH-7009
>                 URL: https://hibernate.onjira.com/browse/HHH-7009
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.0.1
>            Reporter: Eric Dalquist
>            Assignee: Gail Badner
>             Fix For: 4.1.0
>
>
> Only PostgreSQL 8.2 and later support the "if exists" syntax when dropping tables. The change made by the commit linked below results in "if exists" being used for all versions of PostgreSQL
> https://github.com/hibernate/hibernate-orm/commit/30a0c3843a4b46f8b3077a195a09e903c77bec71

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira