Re: [HACKERS] ALTER RENAME and indexes

2001-10-06 Thread Brent Verner
On 06 Oct 2001 at 20:13 (-0400), Rod Taylor wrote: | Of course, in 7.1 foreign key constraints become rather confused when | you rename columns on them. | | create table parent (id serial); | create table child (id int4 references parent(id) on update cascade); | alter table parent rename column

[HACKERS] [patch] ALTER RENAME and indexes

2001-10-06 Thread Brent Verner
The attached patch works for my case... regression=# create table test (id serial, col1 varchar(64)); NOTICE: CREATE TABLE will create implicit sequence 'test_id_seq' for SERIAL column 'test.id' NOTICE: CREATE TABLE/UNIQUE will create implicit index 'test_id_key' for table 'test' CREATE regres

Re: [HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Marc G. Fournier
Down server, been rebooted ... On Sat, 6 Oct 2001, Matthew Kirkwood wrote: > On Sat, 6 Oct 2001, Larry Rosenman wrote: > > > If I try: > > cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login > > I get a time out > > Moi aussi. I can't reach www.postgresql.org either. > > It doesn't seem obviously

Re: [HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [011006 14:28]: > If I try: > cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login > I get a time out This is fixed, and I needed to add a /projects before the /cvsroot. > > If I go to the cvs repository checkout link on > developer.postgresql.org > I get the fol

Re: [HACKERS] ALTER RENAME and indexes

2001-10-06 Thread Brent Verner
On 05 Oct 2001 at 10:18 (-0400), Brent Verner wrote: | On 05 Oct 2001 at 09:46 (-0400), Tom Lane wrote: | | Brent Verner <[EMAIL PROTECTED]> writes: | | > 'ALTER TABLE tbl RENAME col1 TO col2' does not update any indices that | | > reference the old column name. | | | | It doesn't need to; the in

Re: [HACKERS] Patch for fixing a few memory leaks

2001-10-06 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: >>> Tom, I want to notice that initGISTstate is called for every inserting >>> value (for each row). I think it's not good, because this function >>> called 'fmgr_info' 7 times. 'fmgr_info' call a >>> 'load_external_function' with execution of sequence sea

Re: [HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Rene Pijlman
On Sat, 6 Oct 2001 14:14:23 -0500, you wrote: >If I try: >cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login >I get a time out Same here an hour ago, but it seems to be fixed now. Regards, René Pijlman <[EMAIL PROTECTED]> ---(end of broadcast)--- T

Re: [HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Matthew Kirkwood
On Sat, 6 Oct 2001, Larry Rosenman wrote: > If I try: > cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login > I get a time out Moi aussi. I can't reach www.postgresql.org either. It doesn't seem obviously to be a routing problem. Matthew. ---(end of broadcast)--

[HACKERS] anoncvs and CVS link off developers.postgresql.org

2001-10-06 Thread Larry Rosenman
If I try: cvs -d :pserver:[EMAIL PROTECTED]:/cvsroot login I get a time out If I go to the cvs repository checkout link on developer.postgresql.org I get the following: Not Found The requested URL /TODO/docs/stylesheet.css was not found on this server. Can someone fix these issues? LER --

Re: [HACKERS] psql not showing triggers

2001-10-06 Thread Bruce Momjian
[ There is text before PGP section. ] > -- Start of PGP signed section. > While playing around with trying to add foreign keys to the > \d table display in psql, I noticed that tableinfo.triggers > is not used once it is set. I think it is meant to go here: > > /* count triggers */ >

[HACKERS] psql not showing triggers

2001-10-06 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 While playing around with trying to add foreign keys to the \d table display in psql, I noticed that tableinfo.triggers is not used once it is set. I think it is meant to go here: /* count triggers */ if (!error && tableinfo.hasrules) as