Re: [BUGS] Bug #880: COMMENT ON DATABASE depends on current

2003-01-27 Thread Rod Taylor
> > I tend to think that the functionality to give comments to databases > > should either be redone to work right (for example by storing the comment > > in a global table (but think about the encoding problems)) or be ripped > > out. Right now the feature to give a comment to a database you pres

Re: [BUGS] Bug #880: COMMENT ON DATABASE depends on current database

2003-01-27 Thread Bruce Momjian
Peter Eisentraut wrote: > Bruce Momjian writes: > > > Do we have psql -l to connect to all the databases to collect comments? > > I guess we could _try_ to connect to as many databases as possible, but > > it seems a little overly complex to me. What do others think? > > I tend to think that the

Re: [BUGS] Bug #880: COMMENT ON DATABASE depends on current database

2003-01-27 Thread Peter Eisentraut
Bruce Momjian writes: > Do we have psql -l to connect to all the databases to collect comments? > I guess we could _try_ to connect to as many databases as possible, but > it seems a little overly complex to me. What do others think? I tend to think that the functionality to give comments to dat

Re: [BUGS] Bug #880: COMMENT ON DATABASE depends on current database

2003-01-26 Thread Bruce Momjian
Bhuvan A wrote: > > Long Description PostgreSQL has mechanism for commenting databases. > > Database comments can by read by obj_description(oid), psql \l+ command > > use it. Database comments should be global, but they are not, when we do > > \l+ on one database, and then on other, results will b

Re: [BUGS] Bug #880: COMMENT ON DATABASE depends on current

2003-01-24 Thread Rod Taylor
On Fri, 2003-01-24 at 06:16, Bhuvan A wrote: > > Long Description PostgreSQL has mechanism for commenting databases. > > Database comments can by read by obj_description(oid), psql \l+ command > > use it. Database comments should be global, but they are not, when we do > > \l+ on one database, and

Re: [BUGS] Bug #880: COMMENT ON DATABASE depends on current database

2003-01-24 Thread Bhuvan A
> Long Description PostgreSQL has mechanism for commenting databases. > Database comments can by read by obj_description(oid), psql \l+ command > use it. Database comments should be global, but they are not, when we do > \l+ on one database, and then on other, results will be different. I > conside