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
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
> 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
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
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
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