search

AnatolyUss / nmig

NMIG is a database migration tool, written in Node.js and highly inspired by FromMySqlToPostgreSql.
GNU General Public License v3.0
451 stars 83 forks source link

current_timestamp() not working as default value of field in Postgresql #95

Closed proset-dev-central closed 2 years ago

proset-dev-central commented 2 years ago

In a migration from mysql to postgres when a column in mysql has default of current_timstamp() an error is produced due to the fact that in postgres the syntax is current_timestamp without parenthesis. Or the equivalent is now() with parenthesis

AnatolyUss commented 2 years ago

Thanks for pointing that out! I'll fix it asap.

On Fri, Apr 15, 2022, 1:57 PM proset-dev-central @.***> wrote:

In a migration from mysql to postgres when a column in mysql has default of current_timstamp() an error is produced due to the fact that in postgres the syntax is current_timestamp without parenthesis. Or the equivalent is now() with parenthesis

— Reply to this email directly, view it on GitHub https://github.com/AnatolyUss/nmig/issues/95, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADHR7NYY6ZWDUQ47TDXDQ73VFFDRZANCNFSM5TQF64TA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

AnatolyFromPerion commented 2 years ago

Finally fixed!

proset-dev-central commented 2 years ago

Thanks!

Proset

From: Anatoly Khaytovich @.> Sent: Thursday, July 21, 2022 11:25 AM To: AnatolyUss/nmig @.> Cc: proset-dev-central @.>; Author @.> Subject: Re: [AnatolyUss/nmig] current_timestamp() not working as default value of field in Postgresql (Issue #95)

Finally fixed!

— Reply to this email directly, view it on GitHub https://github.com/AnatolyUss/nmig/issues/95#issuecomment-1191255476 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ANCNOI37QNEPUMMHG6DDTMDVVEJOJANCNFSM5TQF64TA . You are receiving this because you authored the thread. https://github.com/notifications/beacon/ANCNOI3WYYK7CPEVAXXWJB3VVEJOJA5CNFSM5TQF64TKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOI4AR3NA.gif Message ID: @. @.> >