On Tue, Apr 12, 2005 at 01:04:20PM -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > What about the simple one of having a bool "pg_cast.castissystem"
> > column, or something similar?
>
> This one is sounding pretty good to me, though I'd be inclined to call
> it "castisbuil
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Apr 12, 2005 at 05:04:03PM -, Andrew - Supernews wrote:
>> Checking the OID might be sufficient if it were possible to make the OID
>> counter restart at some value known to be greater than any datlastsysoid,
>> rather than restarting at Boot
On Tue, Apr 12, 2005 at 05:04:03PM -, Andrew - Supernews wrote:
> On 2005-04-12, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> >> Well perhaps there is an even better solution?
> >
> > What about the simple one of having a bool "pg_cast.castissystem"
> > column, or something similar?
>
> Checkin
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> What about the simple one of having a bool "pg_cast.castissystem"
> column, or something similar?
This one is sounding pretty good to me, though I'd be inclined to call
it "castisbuiltin" or some such.
regards, tom lane
---
On 2005-04-12, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>> Well perhaps there is an even better solution?
>
> What about the simple one of having a bool "pg_cast.castissystem"
> column, or something similar?
Checking the OID might be sufficient if it were possible to make the OID
counter restart
On Tue, Apr 12, 2005 at 06:38:41PM +0200, Michael Paesold wrote:
> Alvaro Herrera wrote:
>
> >On Tue, Apr 12, 2005 at 08:39:09AM +0200, Michael Paesold wrote:
> >>Tom Lane wrote:
> >
> >>>The other possible solution that comes to mind is to invent the
> >>>notion that a cast has a specific owner (
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> But yes, schema-qualifying casts seems weird:
> '123'::someschema.user_type
> Is that even accepted by the grammar?
Yes, but it'd be taken as a qualification on the type name not the cast
per se. Offhand I'm not sure where we could even put a schema
Alvaro Herrera wrote:
On Tue, Apr 12, 2005 at 08:39:09AM +0200, Michael Paesold wrote:
Tom Lane wrote:
>The other possible solution that comes to mind is to invent the notion
>that a cast has a specific owner (which arguably it should have anyway)
>and then say that "system casts" are those whose
On Tue, Apr 12, 2005 at 08:39:09AM +0200, Michael Paesold wrote:
> Tom Lane wrote:
> >The other possible solution that comes to mind is to invent the notion
> >that a cast has a specific owner (which arguably it should have anyway)
> >and then say that "system casts" are those whose owner is the o
Tom Lane wrote:
Also, it would ideally be possible to deliberately create a new cast
that pg_dump would ignore --- you can do this for other object kinds
by creating them in the pg_catalog schema.
It's a little bit odd to think of casts as belonging to schemas,
since they don't have names in the no
Andrew - Supernews <[EMAIL PROTECTED]> writes:
> On 2005-04-12, Robert Treat <[EMAIL PROTECTED]> wrote:
>> One potential ugly way to do it would be to use the magical "last system
>> oid"
> That is what pg_dump does when talking to pre-7.2 databases. But it isn't
> entirely reliable because oid
On 2005-04-12, Robert Treat <[EMAIL PROTECTED]> wrote:
> One potential ugly way to do it would be to use the magical "last system oid"
> as a differentiator between those created by pg and those created by the
> user. It would be different for every version so that might be a problem.
That is
On Sunday 10 April 2005 19:10, Jim C. Nasby wrote:
> In working on the newsysviews project we've discovered that there's no
> definitive way to determine if a cast is a system cast (system as in
> part of postgresql/created by createdb) or not. What pg_dump does (and
> what we're doing now for lack
In working on the newsysviews project we've discovered that there's no
definitive way to determine if a cast is a system cast (system as in
part of postgresql/created by createdb) or not. What pg_dump does (and
what we're doing now for lack of a better solution) is any cast that
doesn't involve a u
14 matches
Mail list logo
