[GENERAL] postgresql reference application

2001-09-12 Thread Eric Kolve
Does anyone know of some good open source applications that are using postgresql well? I am interested in studying schema and physical design of some well thought out applications. Any suggestions would be helpful. thanks, eric ---(end of broadcast)

[GENERAL] getting inherited table name

2001-09-06 Thread Eric Kolve
In the pgsql tutorial two tables are created capitals inherits cities. When you do SELECT * FROM cities, you get both capitals and cities. Is there anyway to get get the name of the table so I could possibly know the 'type' it was? Or should this be maintained as a separate column 'city_type' t

[GENERAL] internet week article

2001-09-04 Thread Eric Kolve
http://www.internetweek.com/reviews01/rev090301.htm I would be most interested to here this lists response to the following paragraph. Though much of the specifics of the benchmark are left out, so tuning could very much of been an issue. Database performance is a key issue for most busines

[GENERAL] many junction tables

2001-09-04 Thread Eric Kolve
I was wondering if anyone has a solution to the following problem. I have a few tables similar to the following. person_table city_table company_table If I want to associate a person with a one or more cities. I need to create a city_persons table that contains just the primary keys of bo