Re: [GENERAL] Versioning control in PostgreSQL?

2003-11-01 Thread elein
There is an example and discussion of implementing history tracking of updates to a table. It includes the discussion of the update rule technique as well. See http://www.varlena.com/GeneralBits/38.php elein [EMAIL PROTECTED] On Tue, Oct 28, 2003 at 11:43:44AM +, Alex Page wrote: > I haven'

Re: [GENERAL] [SQL] connectby

2003-11-01 Thread George Essig
> I use postgresql 7.2.3 > How can I use connectby ?? > > Must I install files ? or packages ? or it is recommanded to upgrade dataserver ? For recent versions of PostgreSQL, go into the contrib/tablefunc directory and see the readme file for how to install. I downloaded PostgreSQL 7.2.3 and the

Re: [GENERAL] regular backups - super user

2003-11-01 Thread Bruno Wolff III
On Fri, Oct 31, 2003 at 15:48:31 -0600, Stuart Johnston <[EMAIL PROTECTED]> wrote: > > If your users always connect through TCP/IP then you can set local > connections to not use passwords but I'm pretty sure there is no way to > configure this just for the postgres user (I wish you could). I

Re: [GENERAL] regular backups - super user

2003-11-01 Thread Joshua D. Drake
Hello, Your pg_hba.conf controls the authentication model for your machine. One way to handle this is to have the database on a local machine and allow anything local (not localhost/127.0.0.1) to be of type trust. You should only do this if you trust the people that have access to shell acco

Re: [GENERAL] grant all to database inheritence

2003-11-01 Thread Bruno Wolff III
On Mon, Oct 27, 2003 at 16:58:50 -0500, Dave Cramer <[EMAIL PROTECTED]> wrote: > I have a challenge to be able to grant all to the database, and then > have subsequent tables accessible by all users. Granting access to a database does specifically what the documentation says it does, which does

Re: [GENERAL] database speed

2003-11-01 Thread Network Administrator
Quoting Doug McNaught <[EMAIL PROTECTED]>: > "Chris Stokes" <[EMAIL PROTECTED]> writes: > > > >The REINDEX is needed because VACUUM doesn't free up index space in > > >some circumstances. 7.4 (currently in late beta) will fix this. > > > > Sorry Doug, > > > > Yes I am doing a vacuum regularly

Re: [GENERAL] Best Perl Option?

2003-11-01 Thread Network Administrator
Quoting David Busby <[EMAIL PROTECTED]>: > List, > Which of the may Perl Modules on CPAN should I use for PostgreSQL. I'd > prefer the fastest/most up to date module. Which is it or do I have to dig > through them all? > > > David Busby > Systems Engineer > [EMAIL PROTECTED] > > > --