Big 7.1 open items

On Tue, 13 Jun 2000, Bruce Momjian wrote:

Here is the list I have gotten of open 7.1 items:

bit type
inheritance
drop column
vacuum index speed
cached query plans

^^^^^^^^^^^^^^^^^

I have already down it and I send patch for _testing_ next week (or
later), but I think that not will for 7.1, but 7.2.

memory context cleanup
TOAST
WAL
fmgr redesign
encrypt pg_shadow passwords
redesign pg_hba.conf password file option
new location for config files

+ new ACL? (please :-)

BTW. --- really cool list.

Karel

On Tue, 13 Jun 2000, Bruce Momjian wrote:

Here is the list I have gotten of open 7.1 items:

encrypt pg_shadow passwords

This will be for 7.1? For some reason I thought it was being pushed
off to 7.2.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

Bruce Momjian <pgman@candle.pha.pa.us> el d�a Tue, 13 Jun 2000 05:05:53
-0400 (EDT), escribi�:

[...]

new location for config files

can I suggest /etc/postgresql ?

sergio

On Tue, 13 Jun 2000, Bruce Momjian wrote:

Here is the list I have gotten of open 7.1 items:

bit type
inheritance
drop column
vacuum index speed
cached query plans
memory context cleanup
TOAST
WAL
fmgr redesign
encrypt pg_shadow passwords
redesign pg_hba.conf password file option

Any details?

new location for config files

Are you referring to pushing internal files to `$PGDATA/global'?

--
Peter Eisentraut Sernanders v�g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden

On Tue, 13 Jun 2000, Sergio A. Kessler wrote:

Bruce Momjian <pgman@candle.pha.pa.us> el d���a Tue, 13 Jun 2000 05:05:53
-0400 (EDT), escribi���:

[...]

new location for config files

can I suggest /etc/postgresql ?

you can ... but everything related to postgresql has always been designed
not to require any special permissions to install, and /etc/postgresql
would definitely require root access to install :(

On Tue, 13 Jun 2000, The Hermit Hacker wrote:

On Tue, 13 Jun 2000, Sergio A. Kessler wrote:

Bruce Momjian <pgman@candle.pha.pa.us> el d���a Tue, 13 Jun 2000 05:05:53
-0400 (EDT), escribi���:

[...]

new location for config files

can I suggest /etc/postgresql ?

you can ... but everything related to postgresql has always been designed
not to require any special permissions to install, and /etc/postgresql
would definitely require root access to install :(

~postgres/etc ??

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

On Tue, 13 Jun 2000, Vince Vielhaber wrote:

new location for config files

can I suggest /etc/postgresql ?

you can ... but everything related to postgresql has always been designed
not to require any special permissions to install, and /etc/postgresql
would definitely require root access to install :(

~postgres/etc ??

You need root access to create a postgres user. What's wrong with just
keeping it in $PGDATA and making symlinks whereever you would prefer it?

--
Peter Eisentraut Sernanders v�g 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden

that one works ...

On Tue, 13 Jun 2000, Vince Vielhaber wrote:

On Tue, 13 Jun 2000, The Hermit Hacker wrote:

On Tue, 13 Jun 2000, Sergio A. Kessler wrote:

Bruce Momjian <pgman@candle.pha.pa.us> el d���a Tue, 13 Jun 2000 05:05:53
-0400 (EDT), escribi���:

[...]

new location for config files

can I suggest /etc/postgresql ?

you can ... but everything related to postgresql has always been designed
not to require any special permissions to install, and /etc/postgresql
would definitely require root access to install :(

~postgres/etc ??

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org

Vince Vielhaber <vev@michvhf.com> writes:

encrypt pg_shadow passwords

This will be for 7.1? For some reason I thought it was being pushed
off to 7.2.

I don't know of anything that would force delaying it --- it's not
dependent on querytree redesign, for example. The real question is,
do we have anyone who's committed to do the work? I heard a lot of
discussion but I didn't hear anyone taking responsibility for it...

regards, tom lane

On Tue, 13 Jun 2000, Tom Lane wrote:

Vince Vielhaber <vev@michvhf.com> writes:

encrypt pg_shadow passwords

This will be for 7.1? For some reason I thought it was being pushed
off to 7.2.

I don't know of anything that would force delaying it --- it's not
dependent on querytree redesign, for example. The real question is,
do we have anyone who's committed to do the work? I heard a lot of
discussion but I didn't hear anyone taking responsibility for it...

I offered to do the work and I have the md5 routine here and tested on
a number of platforms. But as I said, I thought someone wanted to delay
it until 7.2, if that's not the case then I'll get to it. There was also
a lack of interest in testing it, but I think we have most platforms
covered.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

On Tue, 13 Jun 2000, Ed Loehr wrote:

Vince Vielhaber wrote:

[...]

new location for config files

can I suggest /etc/postgresql ?

you can ... but everything related to postgresql has always been designed
not to require any special permissions to install, and /etc/postgresql
would definitely require root access to install :(

~postgres/etc ??

I would suggest you don't *require* or assume the creation of a postgres
user, except as an overridable default.

I *knew* somebody would bring this up. Before I sent that I tried to
describe the intent a few ways and just opted for simple. PostgreSQL
has to run as SOMEONE. Substitute that SOMEONE for ~postgres above.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

Vince Vielhaber wrote:

[...]

new location for config files

can I suggest /etc/postgresql ?

you can ... but everything related to postgresql has always been designed
not to require any special permissions to install, and /etc/postgresql
would definitely require root access to install :(

~postgres/etc ??

I would suggest you don't *require* or assume the creation of a postgres
user, except as an overridable default.

Regards,
Ed Loehr

The Hermit Hacker <scrappy@hub.org> writes:

new location for config files

can I suggest /etc/postgresql ?

you can ... but everything related to postgresql has always been designed
not to require any special permissions to install, and /etc/postgresql
would definitely require root access to install :(

Even more to the point, the config files are always kept in the data
directory so that it's possible to run multiple installations on the
same machine. Keeping the config files under /etc (or any other fixed
location) would destroy that capability.

regards, tom lane

Vince Vielhaber <vev@michvhf.com> writes:

do we have anyone who's committed to do the work? I heard a lot of
discussion but I didn't hear anyone taking responsibility for it...

I offered to do the work and I have the md5 routine here and tested on
a number of platforms. But as I said, I thought someone wanted to delay
it until 7.2, if that's not the case then I'll get to it.

Far as I can see, you should go for it.

regards, tom lane

Bruce Momjian <pgman@candle.pha.pa.us> writes:

Here is the list I have gotten of open 7.1 items:

There were a whole bunch of issues about the type system --- automatic
coercion rules, default type selection for both numeric and string
literals, etc. Not sure how to describe this in five words or less...

regards, tom lane

Here is the list I have gotten of open 7.1 items:

I thought that someone was working on
outer joins
better views (or rewriting the rules system, not sure what the direction was)
better SQL92 compliance
also, I think that at some time there was discussion about a better interface
for procedures, enabling them to work on several tuples. May be wrong though.

But if all, or just most, of the items on your list will be finished, it ought
to be a 8.0 release :-)

--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2582
Howitzvej 75 �ben 14.00-18.00 Email: kar@webline.dk
2000 Frederiksberg L�rdag 11.00-17.00 Web: www.suse.dk

Since there are several people interested in contributing, we should
list:

Support multiple simultaneous character sets, per SQL92

- Thomas

memory context cleanup
TOAST
WAL
fmgr redesign
encrypt pg_shadow passwords
redesign pg_hba.conf password file option
new location for config files

+ new ACL? (please :-)

BTW. --- really cool list.

Updated TODO.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

+ new ACL? (please :-)

Updated TODO.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026