Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Pavel Golub
Hello, Pavel. You wrote: PS> Hello PS> Can we implement REGROLE type, that simplify role name <-> oid transformations? +1 from me. My old wish. PS> Regards PS> Pavel -- With best wishes, Pavel mailto:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing

[HACKERS] Temporal features in PostgreSQL

2012-12-25 Thread Vlad Arkhipov
Hi all, Currently I'm working on a large enterprise project that heavily uses temporal features. We are using PostgreSQL database for data storage. Now we are using PL/pgSQL trigger-based and application-based solutions to handle with temporal data. However we would like to see this functiona

Re: [HACKERS] Event Triggers: adding information

2012-12-25 Thread Dimitri Fontaine
Robert Haas writes: >> That's a good idea. I only started quite late in that patch to work on >> the ObjectID piece of information, that's why I didn't split it before >> doing so. > > That's fine. I've committed that part. I think the remainder of the > patch is really several different feature

Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Tom Lane
Pavel Stehule writes: > Can we implement REGROLE type, that simplify role name <-> oid > transformations? Why? It's not any more complicated than it is for the other object types that lack REGxxx pseudotypes. Generally speaking, we've only bothered with pseudotypes for the cases where lookup i

Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Pavel Stehule
Hello 2012/12/25 Pavel Golub : > Hello, Pavel. > > You wrote: > > PS> Hello > > PS> Can we implement REGROLE type, that simplify role name <-> oid > transformations? > > +1 from me. My old wish. I started implementation. I found a two points, that should be solved before. we operate over roles

Re: [HACKERS] Event Triggers: adding information

2012-12-25 Thread Dimitri Fontaine
Robert Haas writes: >> Also, keep in mind we want the ObjectID in all CREATE, ALTER and DROP >> statements, so my current patch is still some bricks shy of a load… (I >> added ObjectID only in the commands I added rewrite support for, apart >> from DROP). > > I shall rely on you to provide those b

Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Pavel Stehule
2012/12/25 Tom Lane : > Pavel Stehule writes: >> Can we implement REGROLE type, that simplify role name <-> oid >> transformations? > > Why? It's not any more complicated than it is for the other object > types that lack REGxxx pseudotypes. Generally speaking, we've only > bothered with pseudot

Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Tom Lane
Pavel Stehule writes: > * We can reduce to half lot of functions \df has_* (84 functions) Not without breaking existing queries. A function taking regrole might look like it substitutes for one taking a text-string user name as long as you only pass literal constants to it, but as soon as you pa

Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Pavel Stehule
2012/12/25 Tom Lane : > Pavel Stehule writes: >> * We can reduce to half lot of functions \df has_* (84 functions) > > Not without breaking existing queries. A function taking regrole might > look like it substitutes for one taking a text-string user name as long > as you only pass literal consta

Re: [HACKERS] proposal: regrole type?

2012-12-25 Thread Pavel Stehule
2012/12/25 Pavel Stehule : > Hello > > 2012/12/25 Pavel Golub : >> Hello, Pavel. >> >> You wrote: >> >> PS> Hello >> >> PS> Can we implement REGROLE type, that simplify role name <-> oid >> transformations? >> >> +1 from me. My old wish. > > I started implementation. I found a two points, that sho