Re: [GENERAL] Disappearing Records

2005-11-02 Thread Rory Browne
Thanks guys for your suggestions, but the problem turned out to be my lack of experience(with PostgreSQL), combined with a bug in our PHP Code. Coming from a MySQL background, I assumed that if you "select x from y", then y would be the name of a table. It turned out that in the case that y was ac

[GENERAL] Disappearing Records

2005-11-01 Thread Rory Browne
Hi all What is the first thing you would do, when you find that your system has been losing information? Information is there at one stage, and later it's not. I tried checking the logs, but there isn't a delete or drop there anywhere, nor anything else that seems relevent. I tried googling for v