TODO list updates

Started by Mark Hollomonover 25 years ago3 messages
#1Mark Hollomon
mhh@mindspring.com

* Disallow LOCK on view
change to
* -Disallow LOCK on view (Mark H)
well, at least when my patch is applied :)

* Allow SQL function indexes
This seems to work in the CVS code, or I have misunderstood:
CREATE TABLE t ( a int);
CREATE FUNCTION mod5(int) RETURNS int AS 'select $1 % 5' LANGUAGE 'sql';
CREATE INDEX sql_index ON t ( mod5(a) );

* Add ALTER TABLE command to change table ownership
Dibs on this.

--
Mark Hollomon
mhh@mindspring.com

#2Philip Warner
pjw@rhyme.com.au
In reply to: Mark Hollomon (#1)
Re: TODO list updates

At 10:19 7/09/00 -0400, Mark Hollomon wrote:

* Add ALTER TABLE command to change table ownership
Dibs on this.

Any chance of doing more than just tables? pg_dump does many \connect's to
set ownership of things appropriately. If there were appropriate ALTER
commands, then it's job would be simpler.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

#3Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Mark Hollomon (#1)
Re: TODO list updates

Thanks. TODO updated.

* Disallow LOCK on view
change to
* -Disallow LOCK on view (Mark H)
well, at least when my patch is applied :)

* Allow SQL function indexes
This seems to work in the CVS code, or I have misunderstood:
CREATE TABLE t ( a int);
CREATE FUNCTION mod5(int) RETURNS int AS 'select $1 % 5' LANGUAGE 'sql';
CREATE INDEX sql_index ON t ( mod5(a) );

* Add ALTER TABLE command to change table ownership
Dibs on this.

--
Mark Hollomon
mhh@mindspring.com

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  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