Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Greg Toombs wrote: >> What disaster do you foresee? Is that version unstable? > Yes. There are known, unfixed bugs, and architectural problems that > cannot be fixed. We abandoned maintenance of the 7.1 branch in 2001. 7.2 was the first version that

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Greg Toombs
Hoookay. I'm currently negotiating with IX Webhosting to upgrade their prehistoric software. Fellows, consider this a word of warning that, if they don't upgrade, anyone wanting to use this host will be stuck with PostgreSQL 7.1.3. If they do upgrade, I'll happily revoke this warning. Anyway, t

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Alvaro Herrera
Greg Toombs wrote: > What disaster do you foresee? Is that version unstable? Yes. There are known, unfixed bugs, and architectural problems that cannot be fixed. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. --

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Greg Toombs
What disaster do you foresee? Is that version unstable? Tom Lane wrote: Greg Toombs <[EMAIL PROTECTED]> writes: After reading a few more methods of doing things, I went with the simplest one, as 1. time is of the essence, and 2. I'm stuck with PostgreSQL 7.1 on the server I have t

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Tom Lane
Greg Toombs <[EMAIL PROTECTED]> writes: > After reading a few more methods of doing things, I went with the > simplest one, as 1. time is of the essence, and 2. I'm stuck with > PostgreSQL 7.1 on the server I have to develop for. Egad. *Please* do not tell us you are intending to use 7.1 for prod

Re: [SQL] A form of inheritance with PostgreSQL

2007-03-12 Thread Greg Toombs
Hello, and thank you to Steven and everyone else that submitted input on this issue. After reading a few more methods of doing things, I went with the simplest one, as 1. time is of the essence, and 2. I'm stuck with PostgreSQL 7.1 on the server I have to develop for. I set the primary key of

Re: [SQL] Installing with libs of postgresql-libs

2007-03-12 Thread Jorge Godoy
<[EMAIL PROTECTED]> writes: > Could someone tell me what libs are packed in the rpm below ? > postgresql-libs-8.2.3-1PGDG.i686.rpm If it is somewhere accessible through HTTP: rpm -qpl http://url-to-it/postgresql-libs-8.2.3-1PGDG.i686.rpm If it is local: rpm -qpl postgresql-libs-8.2.3-1PGDG.i68

[SQL] Installing with libs of postgresql-libs

2007-03-12 Thread ezequias
Hi list, Could someone tell me what libs are packed in the rpm below ? postgresql-libs-8.2.3-1PGDG.i686.rpm We are concerned about the problem of compatibility with Oracle and we prefer to check all the libs to not put the Oracle system down. I think it is just a metter of rpm -qa postgre

Re: [SQL] how to use a date range in a join

2007-03-12 Thread Andreas Kretschmer
chester c young <[EMAIL PROTECTED]> schrieb: > trying to do something like > > select d.day, >c.name > from [dates between day1 and day2] d > left join c.some_table; > > but cannot figure out what to put into the brackets. Perhaps something like this: test=# select curre

[SQL] how to use a date range in a join

2007-03-12 Thread chester c young
trying to do something like select d.day, c.name from [dates between day1 and day2] d left join c.some_table; but cannot figure out what to put into the brackets. Finding fabulous fare