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
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
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
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
> >
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
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
// 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:
>
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.