Re: [HACKERS] Status of index location patch

2001-09-15 Thread Jim Buttafuoco
Yes that is exactly what I am going to do for 7.3 (had trouble adding tblNode to pg_class so I stopped for now...) > > Can you explain how I would get the tblNode for an existing database > > index files if it doesn't have the same OID as the database entry in > > pg_databases. > > Well, keepi

Re: [HACKERS] Status of index location patch

2001-09-15 Thread Vadim Mikheev
> Can you explain how I would get the tblNode for an existing database > index files if it doesn't have the same OID as the database entry in > pg_databases. Well, keeping in mind future tablespace implementation I would add tblNode to pg_class and in pg_databases I'd have defaultTblNode and ind

Re: [HACKERS] Status of index location patch

2001-09-15 Thread Jim Buttafuoco
Vadim, I guess I am still confused... In dbcommands.c resolve_alt_dbpath() takes the db oid as a argument. This number is used to "find" the directory where the data files live. All the patch does is put the indexes into a "db oid"_index directory instead of "db oid" This is for tables snpr

Re: [HACKERS] Status of index location patch

2001-09-15 Thread Chamanya
On Saturday 15 September 2001 03:03, Jim Buttafuoco wrote: > Just wondering what is the status of this patch. Is seems from comments > that people like the idea. I have also looked in the archives for other > people looking for this kind of feature and have found alot of interest. Can we have a

Re: [HACKERS] Status of index location patch

2001-09-14 Thread Vadim Mikheev
> Just wondering what is the status of this patch. Is seems from comments > that people like the idea. I have also looked in the archives for other > people looking for this kind of feature and have found alot of interest. > > If you think it is a good idea for 7.2, let me know what needs to be

[HACKERS] Status of index location patch

2001-09-14 Thread Jim Buttafuoco
All, Just wondering what is the status of this patch. Is seems from comments that people like the idea. I have also looked in the archives for other people looking for this kind of feature and have found alot of interest. If you think it is a good idea for 7.2, let me know what needs to be cha