Menu

#736 Export default timezone is incorrect

Git
closed-fixed
nobody
PostgreSQL (42)
5
2021-02-08
2020-01-28
azz
No

Table:

CREATE TABLE public.test(
    id int,
    created_at timestamp DEFAULT timezone('UTC'::text, now())
);

export via Adminer contain error:

-- Adminer 4.7.5 PostgreSQL dump

DROP TABLE IF EXISTS "test";
CREATE TABLE "public"."test" (
    "id" integer,
    "created_at" timestamp DEFAULT timezone('UTC'))
) WITH (oids = false);

TRUNCATE "test";

-- 2020-01-28 12:10:30.620718+00

Discussion

  • azz

    azz - 2020-01-28

    The same bug while edit table structure: default value is timezone('UTC'))

     
  • Jakub Vrána

    Jakub Vrána - 2020-01-31
    • status: open --> open-accepted
     
  • Jakub Vrána

    Jakub Vrána - 2021-02-08
    • status: open-accepted --> closed-fixed
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.