Re: overriding current_timestamp - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: overriding current_timestamp
Date
Msg-id 77434680-D54C-4BA5-83A1-B2F1D4B74E1A@justatheory.com
Whole thread Raw
In response to Re: overriding current_timestamp  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: overriding current_timestamp  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
On Feb 27, 2012, at 4:29 AM, Peter Eisentraut wrote:

>> I create a "mock" schema, add the function to it, and then put it in the search_path ahead of pg_catalog.
>
> That doesn't work for current_timestamp and similar built-in functions,
> because they are always mapped to the pg_catalog schema.

I use it for NOW() all the time.

David



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgstat documentation tables
Next
From: "David E. Wheeler"
Date:
Subject: Re: overriding current_timestamp