[GENERAL] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?

2000-09-23 Thread Philip Warner
Two routines do eccentric things when they can't find required supporting data: pg_get_userbyid returns 'unknown (UID=)' when the UID does not exist. pg_get_viewdef returns 'Not a view' when passed a non-existant or non-view table it also signals errors when the underlying metadat

[HACKERS] psql's \d functions broken for views in current sources

2000-09-23 Thread Tom Lane
psql has some problems with views in current CVS: \d doesn't show views, and if you do \d on a specific view, it doesn't identify it as a view and doesn't show the view definition rule. I assume this breakage is from the recent RELKIND_VIEW change; probably psql didn't get updated to know about t

Re: [HACKERS] type design guidance needed

2000-09-23 Thread Tom Lane
>> Bruce, is that the case? Do you really have it documented? If so, >> where? > src/backend/utils/cache/syscache.c BTW, it occurs to me that the real reason adding a syscache is invasive is that the syscache routines accept parameters that are integer indexes into syscache.c's cacheinfo[] arr

Re: [HACKERS] type design guidance needed

2000-09-23 Thread Bernard Frankpitt
Hi Brook, It seems to me that the answer depends on how much effort you want to put in to it. Brook Milligan wrote: > > I am working on designing some new datatypes and could use some > guidance. > It seems that there are several alternative approaches, and I am > seeking some guidance

Re: [HACKERS] type design guidance needed

2000-09-23 Thread Brook Milligan
It'd be useful to know more about your measurement scales. Evgeni remarks that for his applications, units can be broken down into simple linear combinations of fundamental units --- but if you're doing something like converting between different device-dependent color spaces, I ca

Re: [HACKERS] [patch,rfc] binary operators on integers

2000-09-23 Thread Marko Kreen
On Fri, Sep 22, 2000 at 12:26:45PM -0400, Tom Lane wrote: > Marko Kreen <[EMAIL PROTECTED]> writes: > > 1) Precedence. I quite nonscientifically hacked in gram.y, > >and could not still make it understand expression '5 # ~1' > >nor the precedence between '&' and '|#'... > >At the mome