[SQL] design resource

2008-06-05 Thread Edward W. Rouse
I was wondering if there were any resources that have some table designs for common problems. Since that isn't very clear I will give an example. We have an internal app from years back that needs to be updated. One of the problems is that when it was originally created, the company only had US

Re: [SQL] design resource

2008-06-05 Thread Craig Ringer
Edward W. Rouse wrote: I was wondering if there were any resources that have some table designs for common problems. Since that isn't very clear I will give an example. We have an internal app from years back that needs to be updated. One of the problems is that when it was originally created,

Re: [SQL] Problems with a Query between 7.3 and 8.2

2008-06-05 Thread Holm Tiffe
sathiya moorthy wrote: > add_missing_from = on > > Simple, just turn on the above option in postgresql.conf > > and restart postgres service. :-) This fixes all my Problems... Aregardless of this I've fixed all queries in the meantime. Thanks guys, Holm -- Technik Service u. Hande