Re: [HACKERS] UNIQUE not unique with inheritance (workaround?)

2003-02-08 Thread Oliver Elphick
On Sat, 2003-02-08 at 19:34, Samuel Sieb wrote: > Is there any workaround for this problem? I'm getting involved in a > project where inheritance is an incredibly useful feature, but the > non-unique issue could be a serious stumbling block. Is there any way > to work around it with a trigger

[HACKERS] UNIQUE not unique with inheritance (workaround?)

2003-02-08 Thread Samuel Sieb
Is there any workaround for this problem? I'm getting involved in a project where inheritance is an incredibly useful feature, but the non-unique issue could be a serious stumbling block. Is there any way to work around it with a trigger or something? ---(end of broad

Re: [HACKERS] function to return pg_user.usesysid

2003-02-08 Thread Kevin Brown
Neil Conway wrote: > On Fri, 2003-02-07 at 07:03, Dr. Ernst Molitor wrote: > > Hm, by the way, what about adding a function like current_userid to the > > core functionality of PostgreSQL? > > What exactly would this do that couldn't be done by just querying > pg_user directly? > > SELECT usesysi