2019-09-30

postgresql partitions partition of table from to inclusive

When creating a range partition, the lower bound specified with FROM is an inclusive bound, whereas the upper bound specified with TO is an exclusive bound.

So in fact in
CREATE TABLE parsel_2014_10 PARTITION OF parsel_part 
     FOR VALUES FROM ('2014-10-01') TO ('2014-10-31');
the date 2014-10-31 is not included in this partition, and hence nowhere in all your partition tables (and same for all ending dates)

6 doctors

“Six Best Doctors in the World…
  • Sunlight
  • Rest
  • Exercise
  • Diet
  • Self Confidence
  • Friends”

2019-09-10

ora-00604 ORA-01882: timezone region not found

ORA-604 and ORA-01882 With JDBC Connections to Database 11.2.0.3 (Doc ID 2291718.1)

SOLUTION


Apply patch:13417321   DST 18 : HALF YEARLY DST PATCHES, MAY 2012  to the 11.2.0.3 database.
The timezone Etc/UTC support for Oracle database 11.2.0.3.0 is added via DSTv18 Patch 13417321.
Refer to:
Bug 13417321    - DST 18 : HALF YEARLY DST PATCHES, MAY 2012
Applying the DSTv18 update for the Oracle Database (Doc ID 1448706.1)

Or

As a workaround, set the TZ variable to UTC ($ export TZ=UTC) or use -Duser.timezone=UTC to change it in the JVM. Then, restart the application.

Or

set the connection property oracle.jdbc.timezoneAsRegion to "false".

(This option is not recommended as it will revert to sending a fixed offset on the connection and can reintroduce incorrect DST related behavior, which is why the change in JDBC to use timezone name/region directly if it is a known Oracle one rather than convert to a GMT offset was done in the first place).