postgres « Table « JPA Q&A

1. Generating Postgres tables (case-sensitiv)

2. Postgres: Partitioned Table with trigger

3. Postgres identity in single table hierarchy

Hi, Firstly my environment: PostgreSQL 8.3 Hibernate-entitymanager 3.4.0.GA <-- installed from Glassfish update tool Hibernate-distribution 3.3.1.GA <-- installed from Glassfish update tool Glassfish V2 Mac OS X 10.5.x I'm having an issue when using a GenerationType of IDENTITY with a single table inheritance hierarchy. Here's my two entities: Code: @Entity @Inheritance(strategy=InheritanceType.SINGLE_TABLE) @DiscriminatorColumn(name="generation", discriminatorType=DiscriminatorType.STRING) @DiscriminatorValue("Parent") public class Parent implements Serializable { ...

4. hibernate failure with postgres partitioned tables

Hibernate version: 3.2 exception that occurs: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1 Name and version of the database : postgres 8.3 i have created partitioned tables in Postgres using trigger. As there is no automatic redirection of data into partioned tables in postgres, the trigger is written. It routs the data ...