From: | jagadishk <jagadishkantubugata(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ; |
Date: | 2014-04-23 11:13:25 |
Message-ID: | 1398251605404-5801241.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I am writing a plsql code
DECLARE
sys_date character varying(500);
variablex character varying(500);
sys_date:='select to_char(now,''YYYYMMDD'')';
execute immediate sys_date into variablex;
dbms_output.put_line(variablex);
begin
ALTER TABLE some table ADD PARTITION partition_name VALUES less than
(TO_DATE('variablex', 'DD/MM/YYYY')) ;
I want to add a partition based on sysdate and each day a table would be
created. So i am writing the code as above
It throws an error
ERROR: date format not recognized
CONTEXT: SQL statement "ALTER TABLE some table ADD PARTITION partition_name
VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY'))"
edb-spl function inline_code_block line 44 at SQL statement
--
View this message in context: http://postgresql.1045698.n5.nabble.com/ALTER-TABLE-some-table-ADD-PARTITION-partition-name-VALUES-less-than-TO-DATE-variablex-DD-MM-YYYY-tp5801241.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Gerald Cheves | 2014-04-23 11:55:12 | Re: PostgreSQL 9.1 not connecting |
Previous Message | Andreas Kretschmer | 2014-04-23 09:13:34 | Re: PostgreSQL 9.1 not connecting |