Re: [ADMIN] GUI ERD/ERM tools?

2010-11-12 Thread Dinesh Bhandary
I've used eclipse with clay (plugin) in the past and it is good. It is free. Dinesh On Nov 12, 2010 06:46 AM, Thomas Kellerer wrote: >Lou Picciano, 12.11.2010 15:40: >>Friends, >> >>This question from our users keeps coming up... >> >>What tools are each of you using for ERD ERM? pgAmin's Gra

Re: [ADMIN] auto vacuum question

2010-11-12 Thread Joshua D. Drake
On Fri, 2010-11-12 at 11:44 -0800, Dinesh Bhandary wrote: > Hi All - > > I am working to tune the auto vacuum in 8.4 and 8.2. I am finding that > some of the tables are not getting vacuumed even though they exceed > analyze/vacuum threshold. Do you know where auto vacuum process looks to > get

[ADMIN] auto vacuum question

2010-11-12 Thread Dinesh Bhandary
Hi All - I am working to tune the auto vacuum in 8.4 and 8.2. I am finding that some of the tables are not getting vacuumed even though they exceed analyze/vacuum threshold. Do you know where auto vacuum process looks to get the number of rows deleted/updated/inserted? pg_stat_user_tables have

Re: [HACKERS] [ADMIN] locales and encodings Oh MY!

2010-11-12 Thread mark
On Fri, Nov 12, 2010 at 12:03 PM, Tom Lane wrote: > Robert Haas writes: >>> With how similar straight C and en_US.UTF8 are it was suggested to me, >>> by persons who are far more C knowledgeable then I in my office, that >>> this is something the PG community could "fix" . A "fix" being so that >

Re: [HACKERS] [ADMIN] locales and encodings Oh MY!

2010-11-12 Thread Tom Lane
Robert Haas writes: >> With how similar straight C and en_US.UTF8 are it was suggested to me, >> by persons who are far more C knowledgeable then I in my office, that >> this is something the PG community could "fix" . A "fix" being so that >> "col LIKE 'foo%' " could use btree indexes in locales

Re: [HACKERS] [ADMIN] locales and encodings Oh MY!

2010-11-12 Thread Robert Haas
> With how similar straight C and en_US.UTF8 are it was suggested to me, > by persons who are far more C knowledgeable then I in my office, that > this is something the PG community could "fix" . A "fix" being so that > "col LIKE 'foo%' " could use btree indexes in locales like en_US.UTF8 > (and pr

Re: [ADMIN] GUI ERD/ERM tools?

2010-11-12 Thread Dinesh Bhandary
I've used eclipse with clay ( plugin) in the past, it is pretty good. And it is free,. Dinesh On 11/12/2010 8:07 AM, Mark Felder wrote: On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano wrote: What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but do

Re: [ADMIN] Trigger: Column Update

2010-11-12 Thread Ricardo Bayley
Will do that then Thanks Guillaume 2010/11/12 Guillaume Lelarge : > Le 12/11/2010 18:37, Ricardo Bayley a écrit : >> Hi, >> >> I am wondering if there is a way to identify which columns have been >> modified. Is there some sort of TG_TABLE_NAME, which states the >> modified columns ? > > Nope.

Re: [ADMIN] locales and encodings Oh MY!

2010-11-12 Thread Kevin Grittner
mark wrote: > A "fix" being so that "col LIKE 'foo%' " could use btree indexes in > locales like en_US.UTF8 (and probably some others). How about specifying an opclass?: http://www.postgresql.org/docs/current/interactive/indexes-opclass.html -Kevin -- Sent via pgsql-admin mailing list (p

Re: [ADMIN] Trigger: Column Update

2010-11-12 Thread Guillaume Lelarge
Le 12/11/2010 18:37, Ricardo Bayley a écrit : > Hi, > > I am wondering if there is a way to identify which columns have been > modified. Is there some sort of TG_TABLE_NAME, which states the > modified columns ? Nope. You should check yourself. > Or should we check this ourselves doing something

Re: [ADMIN] GUI ERD/ERM tools?

2010-11-12 Thread Viktor Bojović
On Fri, Nov 12, 2010 at 3:40 PM, Lou Picciano wrote: > Friends, > > This question from our users keeps coming up... > > What tools are each of you using for ERD ERM? pgAmin's Graphical Query > Builder is helpful, but doesn't address the need. > > Can any of you recommend specific tools, preference

[ADMIN] Trigger: Column Update

2010-11-12 Thread Ricardo Bayley
Hi, I am wondering if there is a way to identify which columns have been modified. Is there some sort of TG_TABLE_NAME, which states the modified columns ? Or should we check this ourselves doing something like OLD.columnA != NEW.columnA ? Regards Ricardo -- Sent via pgsql-admin mailing lis

Re: [ADMIN] GUI ERD/ERM tools?

2010-11-12 Thread Mark Felder
On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano wrote: What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need. I'm not a database guru and I'm not 100% clear on "ERD ERM", but I will try to help anyway :) I used to w

Re: [ADMIN] locales and encodings Oh MY!

2010-11-12 Thread mark
On Fri, Nov 12, 2010 at 12:45 AM, Gabriele Bartolini wrote: > Hi Mark, > > Il 12/11/10 03:31, mark ha scritto: >> >> I have listed what I think I will be doing with regards to initdb. if >> anyone >> sees problems with the following mixture during my dump ->  init-> >>  restore I >> would be most

Re: [ADMIN] GUI ERD/ERM tools?

2010-11-12 Thread Thomas Kellerer
Lou Picciano, 12.11.2010 15:40: Friends, This question from our users keeps coming up... What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need. Can any of you recommend specific tools, preferences, etc? Regards, Lou Picciano

[ADMIN] GUI ERD/ERM tools?

2010-11-12 Thread Lou Picciano
Friends, This question from our users keeps coming up... What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need. Can any of you recommend specific tools, preferences, etc? Regards, Lou Picciano

[ADMIN] FW: How to replicate postgresql 8.2.9 on two servers on using linux fedora core 7.

2010-11-12 Thread Aimé Mukuma
Please, can you help me to "replicate postgresql 8.2.9 on using Linux Fedora core 7".The problem is to replicate the postgresql database on master server to a slave server in using postgresql 8.2.9 on Linux fedora core 7.I need your help, please. From: aime.muk...@hotmail.fr To: vili0...@gmail