Is it possible to set the column default to LOCALTIMESTAMP using Liquibase and PostgreSQL?
===

I'd like to have a column on a table of type TIMESTAMP WITH TIME ZONE but have it default to the time the row was inserted. We use Liquibase so I'd like to accomplish this using the standard Liquibase syntax.

I would expect that would look like:

    <changeSet author="chuck" id="2012-07-24.1">
        <addColumn tableName="foo">
        	<column name="createdOn" type="timestamp" defaultValue="LOCALTIMESTAMP">
        	    <constraints nullable="false"/>
        	</column>
        </addColumn>
    </changeSet>

This generates the SQL:

    ALTER TABLE foo ADD "createdOn" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT 'LOCALTIMESTAMP';

I can modify this statement and remove the single quotes around LOCALTIMESTAMP and it will execute in psql.

    ALTER TABLE foo ADD "createdOn" TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT LOCALTIMESTAMP;

Has anyone else encountered this with Liquibase and PostgreSQL? I could rewrite this as a <sql> statement as a workaround but wanted to try and do this the Liquibase way.

