[GENERAL] (no subject)

hello ,all: It's known that some database system such as Oracle,Sysbase can support the Two-Phase Commit that postgreSQL cann't. I want to make the postgreSQL cooperate with other database under a transaction manager so that we can deal with distributed transactions. Now I met some ques

Re: [GENERAL] How to get seq after insert]

> On Wed, 14 Apr 1999, Michael Davis wrote: > > > The safest way is to select the nextval('seq_name') and then insert using > > this value. > > I understand, I just thought something like, I do the insert, and then > grab the value with: > > $insertid = $sth->{'insertid'}; The OID is returned

RE: [GENERAL] How to get seq after insert

On Wed, 14 Apr 1999, Michael Davis wrote: > The safest way is to select the nextval('seq_name') and then insert using > this value. I understand, I just thought something like, I do the insert, and then grab the value with: $insertid = $sth->{'insertid'}; assuming field "insertid" was the on

RE: [GENERAL] How to get seq after insert

The safest way is to select the nextval('seq_name') and then insert using this value. -Original Message- From: Brian [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 14, 1999 2:59 PM To: [EMAIL PROTECTED] Subject:[GENERAL] How to get

[GENERAL] Regression test core dumps

I am installing 6.4.2 on a new PII 350 with 128MB RAM, plenty of disk space and Red Hat 5.2. I have been using 6.4.0 on a similar machine for a while now. It seems to be failing when running the regression tests. I seem to be getting a core dump. There are core files left in both /usr/src/pgsq

[GENERAL] How to get seq after insert

I have a sequence in a table that increments upon insert. After doing the insert, is their a way (function maybe?) to get the sequences value without having to do another select? Brian - Brian Feeny (BF304) [EMAIL PROTECTED] 318-222-2

Re: [GENERAL] user-defined aggreaget functions

Oops - Stupid mistake. I thought i had filtered put all of the nulls and blank entries from the source table, but I hadn't. Of course the match doesn't work on a blank entry. the user-defined aggregate functions do work properly, and as expected. Sorry to trouble everyone. -- Karl DeBissc

[GENERAL] user-defined aggreaget functions

is it possible to use more than one user-defined aggregate function in a single SELECT? I have defined a function uid2int in pltcl to convert a string to an integer representation. CREATE FUNCTION uid2int4 (bpchar) RETURNS int4 AS ' regexp {([A-Z]*)0*([0-9]+)([A-Z]*)} $1 match pre num pst if

Re: [GENERAL] Re: [HACKERS] Gregorian Calendar

Hi Thomas, Thomas Lockhart ha scritto: > > I have a question about dates. > > The Gregorian reform of calendar skiped 10 days on Oct, 1582. > > This reform was accepted by Great Britain and Dominions (including > > what is now the USA) only in 1752. > > If I insert a date that doesn't exist Post

Re: [GENERAL] Would this project be of interest to anyone?

James Thompson wrote: > > I've been working on a new project using Postgresql and wanted a little > public input on it. You may want to take a look at Zope (www.zope.org) It's a Python based, GPLed web/object infrastructure thing. Think of it as a cross between PHP/ColdFusion and a persistent

Long - More info on project Was Re: [GENERAL] Would this project beof interest to anyone?

On Wed, 14 Apr 1999, Wim Ceulemans wrote: > Why not use Java in stead of SWIG - TCL/TK - PHP? Or is java not free in > your opinion? > No, I really don't have a problem with the freeness(?) of java. I like my stuff being under the GPL, but I'm not a fanatic about it. Whatever it takes to get

Re: [GENERAL] Would this project be of interest to anyone?

Although still very new it is worth to keep a look out for the Cygnus GCJ compiler. This is a java frontend to EGCS. Still no AWT, SWING and some other stuff but the first release is out and patches are already being submitted. Regaards Lincoln Spiteri On Wed, 14 Apr 1999, [EMAIL PROTECTED] wro

Re: [GENERAL] Would this project be of interest to anyone?

On Wed, 14 Apr 1999, Wim Ceulemans wrote: > Why not use Java in stead of SWIG - TCL/TK - PHP? Or is java not free in > your opinion? IMHO, Java is still too slow to use in a full application :( And is still a relatively moving target (ie. FreeBSD doesn't support Java 2 yet, as is the case for a

[GENERAL] WebDB

I've made a CGI script can insert, update and delete rows in a table. It started as a project directed towards a specific table, but I soon realized that it is possible to do a generic CGI script to handle any table. So I've done that. Now I want someone to test it. Notice however that it is stil

Re: [GENERAL] Would this project be of interest to anyone?

Why not use Java in stead of SWIG - TCL/TK - PHP? Or is java not free in your opinion? Regards Wim Ceulemans - [EMAIL PROTECTED] Nice Software Solutions - http://www.nice.be Eglegemweg 3, 2811 Hombeek - Belgium Tel +32(0)15 412953 - Fax +32(0)15 412954 > >I've been working on a new project usin