Re: Default to TIMESTAMP WITH TIME ZONE? - Mailing list pgsql-hackers

From Isaac Morland
Subject Re: Default to TIMESTAMP WITH TIME ZONE?
Date
Msg-id CAMsGm5c3UPRhP0CpMEJXtg0rzFec35TG=wV0+L04p-9VBwks_g@mail.gmail.com
Whole thread Raw
In response to Re: Default to TIMESTAMP WITH TIME ZONE?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
An idea just occurred to me: a systematic way to provide this feature might be to support aliases for objects. So I could declare an alternate name for an object, something like:

CREATE ALIAS timestamp FOR TYPE timestamptz;

Which would mean that [current schema].timestamp would now be an alternate name for the built-in timestamptz object. There are other situations in which being able to define aliases would be handy, including schema migrations and probably other compatibility scenarios.

Of course I'm aware that this idea itself would need a lot of discussion and I'm not volunteering to implement it right now, but it might be a workable approach if aliases ever become a feature.

pgsql-hackers by date:

Previous
From: Jacob Champion
Date:
Subject: Re: [PATCH] test/ssl: rework the sslfiles Makefile target
Next
From: Tom Lane
Date:
Subject: Re: Worth using personality(ADDR_NO_RANDOMIZE) for EXEC_BACKEND on linux?