We have addressed all the open issues for 8.1 except for auto-vacuum,
which Alvaro is working on, so I think we are ready for a feature freeze
on July 1.

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

* Bruce Momjian (pgman@candle.pha.pa.us) wrote:
> We have addressed all the open issues for 8.1 except for auto-vacuum,
> which Alvaro is working on, so I think we are ready for a feature freeze
> on July 1.

Bruce,

I'd really like to see role support added into 8.1. I've sent Alvaro
and Tom versions of the patch in the past and I was planning on
submitting it to -patches soon. There's a few remaining issue but I
don't think they'll take very long to clean up; I've just been
unfortunately pretty busy lately. I'm hopeful that I'll be able to
spend some time on it this week and next week to hopefully address at
least the remaining issues on my list.

Lookups need to do multi-level role resolution (for owner and other
ACL areas)
(Not very hard, and mostly isolated to the acl code)
Need to implement per-backend role-member cacheing
(Not very hard, basically same kind of way pg_namespace does
schema_path)
Support 'grant <role> to <role>'
(Shouldn't be too difficult, mainly just parser work)
Support 'with admin option'
(Somewhat difficult, but not necessary for the same functionality we
have today)
Support 'granted by'
(Not very hard, just parser work really)
Fix other parsers (ecpg, etc) based on updates to backend/parser.
(Worked on this some already, should be done real soon now)
Distinguish 'create role' permissions from 'superuser'?
(Not sure if this makes sense)

Modify \du, \dg to use new tables
(They work already using the backwards-compat views, just would be
nice to update them to the new schema).
? Add \dr, \dm
(Should be easy and would be nice I think, though perhaps not
required)

Add documentation for CREATE ROLE/etc
Document new system catalogs (pg_authid, pg_auth_members)
(Documentation updates)

There are views for pg_shadow/pg_group and things seem to be happy
with them. CREATE USER/CREATE GROUP work more-or-less as expected.
An interesting side-effect is that if you do 'create group' and then
look in the 'group' table you don't see the group till you actually
put users in it. Not entirely sure if anything actually depends on
that (You can, after all, still grant rights to the role which was
created by CREATE GROUP, and do ALTER GROUP on it, etc).

Thanks,

Stephen

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCt//VrzgMPqB3kigRAkmVAJ0a0oCP4uUWU3u7mTdw6LyZE0cQdwCfe qpP
cdDIEN7oAYg8YTb31lg1pCw=
=tW5l
-----END PGP SIGNATURE-----

Stephen Frost <sfrost@snowman.net> writes:
> I'd really like to see role support added into 8.1. I've sent Alvaro
> and Tom versions of the patch in the past and I was planning on
> submitting it to -patches soon. There's a few remaining issue but I
> don't think they'll take very long to clean up; I've just been
> unfortunately pretty busy lately. I'm hopeful that I'll be able to
> spend some time on it this week and next week to hopefully address at
> least the remaining issues on my list.

Stephen, it is not going to be acceptable to sit on that patch until
June 30 --- there are other things depending on it. If you don't have
time for it now, send in what you have so that someone else can pick up
the ball.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > I'd really like to see role support added into 8.1. I've sent Alvaro
> > and Tom versions of the patch in the past and I was planning on
> > submitting it to -patches soon. There's a few remaining issue but I
> > don't think they'll take very long to clean up; I've just been
> > unfortunately pretty busy lately. I'm hopeful that I'll be able to
> > spend some time on it this week and next week to hopefully address at
> > least the remaining issues on my list.
>
> Stephen, it is not going to be acceptable to sit on that patch until
> June 30 --- there are other things depending on it. If you don't have
> time for it now, send in what you have so that someone else can pick up
> the ball.

Sorry, I thought that's what I had been doing when sending to
you/Alvaro/-hackers earlier.. I'll send in what I've got and I guess
see what happens. I'm planning on still working on it when I have time
available so if someone else picks it up to work on it, please let me
know so we can coordinate.

Thanks,

Stephen

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFCuB8yrzgMPqB3kigRAilsAJ0b2MT56Nke+9eScCER7Z dimG4T+gCcDd6c
B8lEQ3muvdJERq0Ly2C34cU=
=K7Wu
-----END PGP SIGNATURE-----

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> We have addressed all the open issues for 8.1 except for auto-vacuum,

Aside from the other stuff people mentioned, I have these things on
my to-look-at list:

* Fix pg_dump to be able to dump large objects in text dumps

* Fix inherited constraints (per discussion around 5/20)

* Fix reporting of table/column numbers for cursors (per DeSoi, 4/9)

* statement_timeout does not behave very reasonably for V3 messages

And I'd really like to see pg_role and shared dependencies get in...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Bruce Momjian wrote:

>We have addressed all the open issues for 8.1 except for auto-vacuum,
>which Alvaro is working on, so I think we are ready for a feature freeze
>on July 1.
>
>
>

FYI - plperl status.

I am trying to get the following 2 items done by feature freeze:
.. convert returned perl array to pg array (see patch recently sent for
discussion)
.. validator function

The remaining memory issue we have is where plperl does a huge select
via SPI. Abhijit Menon-Sen was working on this but is stumped on how to
proceed (see his previous message). We have a patch from CommandPrompt
which apparently improves the situation, although it doesn't solve the
basic problem. If we don't make progress with Abhijit's work, I will
look at working that up by July 1.

There is also the tiny patch to trap lexical warnings I submitted not
long ago still outstanding.

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

I'll do my best to submit bitmap index AM patch next week for your review.


--

Victor Y. Yegorov

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Andrew Dunstan wrote:
> There is also the tiny patch to trap lexical warnings I submitted not
> long ago still outstanding.

OK, I missed that one. I see it at:

http://archives.postgresql.org/pgsql...6/msg00280.php

However, I don't see the new regession files attached to that URL.
Would you repost please?

--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> We have addressed all the open issues for 8.1 except for auto-vacuum,
> which Alvaro is working on, so I think we are ready for a feature freeze
> on July 1.

FWIW, I'm still working on column-level triggers, but the July 1st deadline
should not be a problem.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200506211841
http://biglumber.com/x/web?pk=2529DF...9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFCuJe+vJuQZxSWSsgRAkSnAKDhwsRXoupe1DhHGgCYrq uimK9CJQCgz1K5
/nHRvPxNs+41vxs7G9ngvW4=
=C+M3
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Jun 21, 2005, at 1:03 PM, Bruce Momjian wrote:


> We have addressed all the open issues for 8.1 except for auto-vacuum,
> which Alvaro is working on, so I think we are ready for a feature
> freeze
> on July 1.
>

I'm hoping to add documentation and regression tests for interval-
>day over the next couple of days and have that ready for 8.1 as well.

Michael Glaesemann
grzm myrealbox com




---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings