Re: [ADMIN] disable auto-commit

2000-10-26 Thread John McKown
Well, you could start a transaction. But the record will be deleted once you do a COMMIT. Is that what you want? If you want some way to "delete" an entry, but then to later "undelete" it, there really isn't a way. I have heard of other systems where things were "logically deleted", but recoverabl

Re: [ADMIN] Multiple users, same DB

2000-09-12 Thread John McKown
On Tue, 12 Sep 2000, Jeremy Buchmann wrote: > Does anyone know how to create a postgresql user that can read/write to an > existing database? I have used createuser, but it never asks if I want the > new user to have access to an existing DB. When I connect to a DB with that > new user, I can't

Re: [ADMIN] same postmaster, different directory? V7.0.2

2000-09-11 Thread John McKown
On Mon, 11 Sep 2000, Brian Horan wrote: > Howdy, I was wondering if anyone can help me, I'm running Postgres > version 7.0.2, > and I have several existing databases in /var and wanted to put one in > /home, because of disk space. > > my only problem is that It will not let me do so, no matter w