Get new column value using PostgreSQL sequence and serial column and keep referential integrity

<?xml version="1.0" encoding="UTF-8"?>
<scenario>
     <name>Get new column value using PostgreSQL sequence and serial column and keep referential integrity</name>
     <script>posgres_keys</script>
     <allow>EXTRACT_LOAD</allow> 
     <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>

<tasks>
           <task>
              <name>create_sequecne</name>
              <connection>dest</connection> 
              <class>com.toolsverse.etl.core.task.common.SqlTask</class>
              <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
              <sql>
                  CREATE SEQUENCE seq_config_property;
              </sql>
              <onexception action="ignore"/>
           </task>  
     
           <task>
              <name>drop_table</name>
              <connection>dest</connection> 
              <class>com.toolsverse.etl.core.task.common.SqlTask</class>
              <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
              <sql>
                  drop table config_property_serial;
              </sql>
              <onexception action="ignore"/>
           </task>  
     
           <task>
              <name>create_table</name>
              <connection>dest</connection> 
              <class>com.toolsverse.etl.core.task.common.SqlTask</class>
              <driver>com.toolsverse.etl.driver.postgres.PostgresDriver</driver>
              <sql>
                 create table config_property_serial
                 (
                      CP_NUM	SERIAL PRIMARY KEY,
                      NAME	VARCHAR(255),
                      DESCRIPTION	VARCHAR(255),	
                      DEFAULT_VALUE	VARCHAR(3000)	
                 )      
              </sql>
           </task>     
      </tasks>

<sources>
          <source>
               <name>config_property</name>
               <extract>
                    <sql>select config_property.*, config_property_num as cfg_prop_num from config_property</sql>
               </extract>
          </source>
          <source>
               <name>config_property_serial</name>
               <extract>
                    <sql>select CONFIG_PROPERTY_NUM as cp_num, name, description, default_value from config_property</sql>
               </extract>
          </source>
          
          <source>
               <name>config_value</name>
               <extract>
                    <sql>select * from config_value</sql>
               </extract>
          </source>
          <source>
               <name>second_config_value</name>
               <extract>
                    <sql>select config_property_num as con_prop_num, value from config_value</sql>
               </extract>
          </source>

<source>
               <name>config_value_serial</name>
               <extract>
                    <sql>select config_property_num as cp_num, value from config_value</sql>
               </extract>
          </source>          
          
     </sources>
     <destinations>
          <destination>
               <name>config_property_serial</name>
               <metadata>yes</metadata>
               <load>
                   <variables>
                        
                       <CP_NUM type="INTEGER" function="getSerial" /> 
                   </variables>
               </load>
          </destination>

<destination>
               <name>config_property_test</name>
               <source>config_property</source>
               <metadata>yes</metadata>
               <load>
                   <variables>
                       
                       <CONFIG_PROPERTY_NUM function="getPk" sequence="seq_config_property" />
                       <CFG_PROP_NUM include="false" />
                   </variables>
               </load>
          </destination>

<destination>
               <name>config_property_two</name>
               <source>config_property</source>
               <metadata>yes</metadata>
               <load>
                   <variables>
                       <CONFIG_PROPERTY_NUM include="false" />
                       
                       <CFG_PROP_NUM function="getPk" sql="{CONFIG_PROPERTY_NUM} + 10000" />
                   </variables>
               </load>
          </destination>
          
          <destination>
               <name>config_value_test</name>
               <source>config_value</source>
               <metadata>yes</metadata>
               <load>
                   <variables>
                       <CONFIG_PROPERTY_NUM function="getFk" />
                   </variables>
               </load>
          </destination>

<destination>
               <name>second_config_value</name>
               <metadata>yes</metadata>
               <load>
                   <variables>
                        
                       <CON_PROP_NUM function="getFk" field="CFG_PROP_NUM" />
                   </variables>
               </load>
          </destination>

<destination>
               <name>config_value_serial</name>
               <metadata>yes</metadata>
               <load>
                   <variables>
                       <CP_NUM function="getFk" />
                   </variables>
               </load>
          </destination>

</destinations>
</scenario>