[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-1000) Problem with PostgreSQL using uppercase letters in tables

[ http://opensource.atlassian.com/projects/hibernate/browse/HBX-1000?page=c... ] Jeff Adama commented on HBX-1000: --------------------------------- There is an additional issue where the backticks workaround does - not - work. This happens when working with mixed case PostgreSQL sequences associated with auto numbering ids and a sequence generator in the code (JBOSS Seam in my case). The - only - way that I was able to make this work was by changing all sequence names in the PostgreSQL database to lowercase. Consider the following JBOSS Seam entity code: @Id @NotNull //The following version does - NOT - work: (where the sequence name in PostgreSQL is mixed case) @SequenceGenerator(name="discountRate_autoGenerationDefault_seqIdentifier", sequenceName="discountRate_autoGenerationDefault_seq", allocationSize=1) //The following version - DOES - work: (where the sequence name in PostgreSQL is all lowercase) @SequenceGenerator(name="discountRate_autoGenerationDefault_seqIdentifier", sequenceName="discountrate_autogenerationdefault_seq", allocationSize=1) @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="discountRate_autoGenerationDefault_seqIdentifier") @Column(name="`autoGenerationDefault`", unique=true, columnDefinition="bigserial") public Long getId() For developers working with hibernate and PostgreSQL, these issues are significant. Regards, Jeff -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira