About yashnaresh

Hi Ranjeet,   This solution works when there is not sequence used but when using a sequence it gives below error from application, though the manual insert query works. Have any suggestion ?   javax.persistence.PersistenceException: org.hibernate.HibernateException: The database returned no natively generated identity value   Thanks in advance.   ... View more

Thanks !! Ranjeet ,you rock !! ... View more

Also what is the function of  RETURNING city_id;' ... View more

Thanks !! Ranjeet,   Further, how to include primary key in this ,I am getting syntax err   EXECUTE 'CREATE TABLE ' || partition || ' ( CHECK ( request_time >= DATE ''' || startdate || '''  AND request_time <=  DATE ''' ||  enddate || ''')) ||' PRIMARY KEY (unique_id)||  INHERITS (' || TG_RELNAME || ');';   ERROR: syntax error at or near "PRIMARY" LINE 25: ...equest_time <= DATE ''' || enddate || ''')) ||' PRIMARY KE... ^ SQL state: 42601     ... View more

Thanks !! Ranjeet for the reply . Getting below err while inserting for nov.   insert into measurement values(1,'2017-11-15',10,10);   ERROR: date/time field value out of range: "2017-11-31" CONTEXT: SQL statement "CREATE TABLE measurement_2017_11_p2 ( CHECK ( logdate >= DATE '2017-11-15' AND logdate < DATE '2017-11-31' )) INHERITS (measurement);" PL/pgSQL function new_partition_creator() line 24 at EXECUTE statement SQL state: 22008       ... View more

Please share if anyone is having suggestions to write a script for 15 day automatic partition in postreSQL @yashnaresh wrote: How can I automate the  table partition having partition key of 15 days every month. Is there any solution in PostgreSQL which can be used.   ... View more