Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ; - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ;
Date
Msg-id lj8bms$jru$1@ger.gmane.org
Whole thread Raw
In response to ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ;  (jagadishk <jagadishkantubugata@yahoo.com>)
Responses Re: ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ;
List pgsql-novice
Tree view 
jagadishk, 23.04.2014 13:13:
> 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

Since when does Postgres support ALTER TABLE ... ADD PARTITION ?

pgsql-novice by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ;
Next
From: jagadishk
Date:
Subject: Re: ALTER TABLE some table ADD PARTITION partition_name VALUES less than (TO_DATE('variablex', 'DD/MM/YYYY')) ;