PostgreSQL-11 partition creation issue

From: Ravi Tammineni <RTammineni(at)jackhenry(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL-11 partition creation issue
Date: 2020-08-07 14:49:09
Message-ID: F88AD378-F50D-4FEC-BEF0-581D3E60FDDE@jackhenry.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am trying to create a partition table for UNIX epoch column. Here are the details of the table. Our application is converting the date and storing the date in UNIX epoch time format.

CREATE TABLE public.oauth_server_nonce_new (
osn_id integer NOT NULL,
osn_consumer_key character varying(64) NOT NULL,
osn_token character varying(64) NOT NULL,
osn_timestamp bigint NOT NULL,
osn_nonce character varying(80) NOT NULL
) partition by to_timestamp(osn_timestamp/1000)::date;

CREATE TABLE measurement_y2016 PARTITION OF oauth_server_nonce_new FOR VALUES FROM ('2020-07-01') TO ('2020-08-01');
CREATE TABLE measurement_y2017 PARTITION OF oauth_server_nonce_new FOR VALUES FROM ('2020-08-01') TO ('2020-09-01');

Getting the following error.

ERROR: syntax error at or near "/"
LINE 7: ) partition by to_timestamp(osn_timestamp/1000)::date;

Any help is appreciated.

Regards,
Ravi
NOTICE: This electronic mail message and any files transmitted with it are intended
exclusively for the individual or entity to which it is addressed. The message,
together with any attachment, may contain confidential and/or privileged information.
Any unauthorized review, use, printing, saving, copying, disclosure or distribution
is strictly prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all copies.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2020-08-07 15:49:54 Re: PostgreSQL-11 partition creation issue
Previous Message JC JC 2020-08-06 14:03:24 Re: Oracle Package equivalent in Postgres