Re: [SQL] postgres 8 data directory other then default?

Thank you for all the help. I was able to get system up (8.0 RPMS, not a build of 8.0.1) I installed to the normal /var/lib/pgsql/data directory. I did an initdb on the pgdata drive initdb /pgdata/data This created a data folder on that drive set. I used the instructions below for linking my wal

[SQL] Constraint doesn't see a currently insertet record

Hi, yes that's my problem. I've got a table and I put lots of contraints on it so that data stays consistent. One constraint calls a fcn to do some kind of count() over that table but it omits the 'to be inserted record'. What to do? concrete problem: Suppose a table i | tel | status | ... ..|

Re: [SQL] postgres 8 data directory other then default?

Joel Fradkin wrote: I am trying to use a different drive for the data. I have edited postgres.conf to point to the new location, but I get the error /pgdata/PG_VERSION is missing. Do I have to do a initdb? When I try an initdb it says it is not empty. (has lost and found folder in it). Create a sub

Re: [SQL] append fields for *where...*

Johnny C wrote: I have the following tables: TABLE A month | year | item | num 1 2005 myitem 003 TABLE B num| date | descr 003 02-01-2005 blahblah 003 01-01-2005 toratora I am trying to come up with