Re: [ADMIN] Inheritance in Postgresql ?

2009-12-16 Thread ABBAS SHAKEEL
Thanks Richard Broersma for the presentation. Its really nice and explains advantages and disadvantages in a nice way. On Wed, Dec 16, 2009 at 8:13 PM, Richard Broersma < richard.broer...@gmail.com> wrote: > On Tue, Dec 15, 2009 at 11:33 PM, ABBAS SHAKEEL > wrote: > > > I feel relatively clear w

Re: [ADMIN] identify referential integrity triggers unassociated with foreign key constraints

2009-12-16 Thread Tom Lane
Bill MacArthur writes: > We started using Postgres back around 7.1. We've done dump and reloads to get > us up to where we are now at 8.1. > Over time it would seem that the guts of foreign key constraints have > changed, for the better. Soon we want to move to the latest version, > but in the p

[ADMIN] identify referential integrity triggers unassociated with foreign key constraints

2009-12-16 Thread Bill MacArthur
Hello, We started using Postgres back around 7.1. We've done dump and reloads to get us up to where we are now at 8.1. Over time it would seem that the guts of foreign key constraints have changed, for the better. Soon we want to move to the latest version, but in the process, I would like to

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-16 Thread Richard Broersma
On Tue, Dec 15, 2009 at 11:33 PM, ABBAS SHAKEEL wrote: > I feel relatively clear with this concept and i stopped my mind as well from > comparing inheritance concept with JAVA  by saying that  inheritance concept > in humans, in JAVA and in Postgres is different in many aspects. > I would like to

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009-12-16 Thread Brian Modra
2009/12/16 Su, Alan : > GUI front end is nice to have but not required. We. have a system that > collects network speed information in mill seconds from different hubs and > this infor is stored on various Postgre tables. Throughout the day or at end > of the day, I need to run a process/job tha

[ADMIN] password authentication failed

2009-12-16 Thread Sam Jas
I am newbee for Bucardo. Whenever i am trying to add database or try to look into show all command. It shows me following error. Connecting to database 'bucardo' as user 'bucardo' DBI connect('dbname=bucardo;port=5433','bucardo',...) failed: FATAL:  password authentication failed for user "buc

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009-12-16 Thread Su, Alan
GUI front end is nice to have but not required. We. have a system that collects network speed information in mill seconds from different hubs and this infor is stored on various Postgre tables. Throughout the day or at end of the day, I need to run a process/job that will summarize these speed d