[GENERAL] Abort state on duplicated PKey in transactions

2001-09-07 Thread Haroldo Stenger
Hi dear people, I'm not sure if this is for general or for hackers, but let's start here ;-) We are building a RAD tool (GeneXus) support, for PostgreSQL. A problem which arose, is that within a transaction, if one inserts on a table and the PK restriction is violated, the transaction aborts an

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

2000-06-20 Thread Haroldo Stenger
Haroldo Stenger wrote: > And I add one of my own: It is not really necessary to have continuity in nearly > all apps. Your question is valid anyhow, but ask yourself: How does Oracle > resolve this? How would I program it myself by hand? And there you'll understand > the issue d

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

2000-06-20 Thread Haroldo Stenger
st search engines on the pgsql web site are > broken. They either find nothing, no matter what search terms one enters, > or complain about not being able to find the needed tables (relations). > -- --+ Haroldo Stenger | [EMAIL PROTECTE

Re: [GENERAL] Revisited: Transactions, insert unique.

2000-04-24 Thread Haroldo Stenger
Ed Loehr wrote: > > Lincoln Yeoh wrote: > > > > Hi, > > > > Previously I wanted to ensure that I am inserting something unique into a > > table, the answer was to create a unique index on the relevant columns. > > > > But what if I don't want to get an error which would force a rollback? Say > >

Re: [GENERAL] Does error within transaction imply restarting it?

2000-04-16 Thread Haroldo Stenger
Peter Eisentraut wrote: > > Haroldo Stenger writes: > > > I seems that other DBMSs, don't care about erroneous statements within > > a transaction. Now, I have several paths to follow: 1) Hacking the > > backend ;-) > > If you're really brav

Re: [GENERAL] Postgresqlism & Vacuum?

2000-04-14 Thread Haroldo Stenger
Andrew Snow wrote: > > > Okay, this *used* to be a problem way way back, but I definitely don't > > vacuum my databases nightly ... most times I don't do it until something > > odd comes up that I figure that I may as well vacuum first to see if it > > makes a differnece ... > > vacuum'ng once a

Re: [GENERAL] PostgreSQL-JDBC correct URL

2000-04-12 Thread Haroldo Stenger
// The postgresql.jar must be in classpath > Class.forName(driverName); > > java.sql.Connection connection = > DriverManager.getConnection(DBURL,username,password); > > ... > > Cheers, Silvio > > On Mon, 10 Apr 2000, Haroldo Stenger wrote: >

[GENERAL] GeneXus & Postgres.

1999-09-16 Thread Haroldo Stenger
instead, under Linux. Do you think I'm too crazy if I tried to build an intermediate layer interfacing both against GeneXus & Postgres, on the server side, so that it's transparent to each other? I'll very much appreciate your help. -- Greetings, Haroldo Stenger from Uruguay, South America.