Re: Fwd: Proposal: variant of regclass - Mailing list pgsql-hackers

From Marti Raudsepp
Subject Re: Fwd: Proposal: variant of regclass
Date
Msg-id CABRT9RBq-JSQU_wnDPUyGpjSXXo1N5zC1Xc8wkxv1xqhW38ujQ@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: Proposal: variant of regclass  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On Sun, Mar 23, 2014 at 7:57 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> Anyone has any objection for this behaviour difference between
> usage of ::regclass and to_regclass()?

No, I think that makes a lot of sense given the behavior -- if the
object is not there, to_regclass() just returns NULL. It doesn't
require the object to be present, it should not create a dependency.

This allows you to, for example, drop and recreate sequences while
tables are still using them.

Regards,
Marti



pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: jsonb status
Next
From: Bruce Momjian
Date:
Subject: Re: jsonb status