[GENERAL] Transations in postgres

1999-07-09 Thread Roberto Moreda
I'm using Postgres 6.4/Linux with Java/Windows as client. When I do a transaction for update and I shutdown the client before commit/rollback, then the tables used in the transaction are still locked. How can avoid this? Is there any mechanism that rollbacks the

Re: [GENERAL] July 1999 issue of Sys Admin

1999-07-09 Thread Thomas Good
On Wed, 7 Jul 1999, Kaare Rasmussen wrote: > > The July issue of sys admin has a feature on Perl for DBAs. > > This is actually better coverage than you get in most perl > > > Shall I fax you a copy? > > Yes, please :-) I could do that...of course, Kaare, you'd have to buy me a pint. I hope to

Re: [GENERAL] Does Apache has PostgreSQL module?

1999-07-09 Thread Dustin Sallings
On Thu, 8 Jul 1999, Albert Chen wrote: # I know there is a ApacheMysql module. Has ApachePostgres module? What exactly are you wanting to accomplish? -- SA, beyond.com My girlfriend asked me which one I like better. pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTEC

Re: [GENERAL] getting val of serial field after insert

1999-07-09 Thread Christian Rudow
Jim Archer wrote: > I have been inserting records into a table using the SQL insert statement > via the perl5 Pg module. One of the field types is serial, and I have been > trying to figure out how to get the value that was assigned in the field as > a result of the insert. The serial typed field

Re: [GENERAL] just little BUG

1999-07-09 Thread Jonathan davis
>[Charset iso-8859-1 unsupported, filtering to ASCII...] >> hello all >> >> normaly a UNIQUE PRIMARY KEY is unique but >> when you use a heritage, you can insert a duplicate key > >I assume you mean inheritance. > >Can you send us a little test sample please? > >-- hello all this is th