Re: [GENERAL] Sequences do not obey transactions...

2000-06-20 Thread Bruce Bantos
That is not a bug, it is well documented behavior. PostgreSQL will NOT roll back a sequence for any reason, regardless of whether it is in a transaction that has been rolled back. Think of how you would have to code a sequence to support that type of behavior. In the case of multiple clients drawi

Re: [GENERAL] Postgres JDBC Connection

2000-03-16 Thread Bruce Bantos
Your problem probably has nothing to do with Postgres. It looks like your java program cannot find the driver classes. Make sure that the driver is in your classpath. If you are using Apache+Jserv, add the driver to Jserv's classpath as well. > Hello Postgres User, > > I can not get a DataBase C

Re: [GENERAL] 50 MB Table

2000-03-07 Thread Bruce Bantos
> I've been shuffling thru the 'LIKE' code in pg, but whilst perusing, it > occurred to me that I could use a function for this thing. Since i'm > only looking at the first part of the string I use... > > SELECT * FROM info WHERE substring(street_name from 1 to 4) = 'MAIN' > > ...and the query com

[GENERAL] Backup, Vacuume scheduling tips?

2000-01-26 Thread Bruce Bantos
I would like to know if anyone has tips on scheduling daily backups of PostgreSQL databases, scheduling daily vacuum's, or any other ongoing maintenance hints about PostgreSQL. The documentation seems fairly thin in this area, and I am sure a lot of people would benefit by this being discussed. D

Re: [GENERAL] Simulating an outer join

2000-01-12 Thread Bruce Bantos
I was originally trying to avoid this, but I think you make a good point. The default value is probably best for this case. Thanks for the solid argument. - Original Message - From: "Culberson, Philip" <[EMAIL PROTECTED]> > It seems to me that in this case Bruce would be better off to us

[GENERAL] pgaccess in RPM

1999-11-09 Thread Bruce Bantos
I have just downloaded the current postgres RPM (6.5.2.1) and installed the RPM. Pgaccess does not seem to be included. Can pgaccess be installed by RPM, or do I have to compile the source? Thanks. - Bruce