TODO list updates
* 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
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 |/
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