Re: [GENERAL] PHP or JSP? That is the question.

2004-03-23 Thread Guy Fraser
[EMAIL PROTECTED] wrote: It may be added to the Mark's points bellow that PHP has more libraries in the out of the box setup (like regular expressions) but PHP is interpreted (right?) while JSP is compiled: when I was making decision I have chosen JSP because of "compiled" criteria: I do like the

Re: [GENERAL] OID problem

2004-03-23 Thread Tom Lane
Patrick Hess <[EMAIL PROTECTED]> writes: > The only problem I have is related to this OID stuff -- I read a bit > about this and found a way to solve my initial problems by creating my > tables with "WITHOUT OIDS" -- works fine and CMS runs like on the > original plattform (even faster but that'

[GENERAL] OID problem

2004-03-23 Thread Patrick Hess
Hi there, I'm currently in the process of "porting" an enterprise CMS system which is targeting Weblogic/Oracle plattform to Tomcat/pgsql. As expected, pgsql does a great job in replacing Oracle esp. compared to mysql... The only problem I have is related to this OID stuff -- I read a bit abou

Re: [GENERAL] PHP or JSP? That is the question.

2004-03-23 Thread Ian Harding
I heartily second this opinion in favor of AOLServer. It, like tcl, is not sexy, but it works so well for web based PostgreSQL applications that a rational analysis of tools has to include it. In addition to Bas' comments, I would add that installation and configuration is effortless, it has

Re: [GENERAL] how to generate a sql file

2004-03-23 Thread Richard Huxton
On Tuesday 23 March 2004 09:11, spambox wrote: > Hi, > > i would like to generate a file of my sql sequences during a stored > process, i know it's possible but i dont' find the command. > Thx for the help Well, from psql \o will output results to a file. If it's the statements you want to recor

Re: [GENERAL] PHP or JSP? That is the question.

2004-03-23 Thread lnd
It may be added to the Mark's points bellow that PHP has more libraries in the out of the box setup (like regular expressions) but PHP is interpreted (right?) while JSP is compiled: when I was making decision I have chosen JSP because of "compiled" criteria: I do like the idea to catch as many bugs

Re: [GENERAL] Problems with pg_dumpall

2004-03-23 Thread Paul Thomas
On 23/03/2004 09:23 javier garcia - CEBAS wrote: Hi; I'm using postgres7.3.4 and I have tried to use pg_dumpall to copya a database from one computer to another. I remember I used it once with no problem, but now I've found a lot of error. pg_dumpall dumps all databases in a cluster. You want to us

[GENERAL] Problems with pg_dumpall

2004-03-23 Thread javier garcia - CEBAS
Hi; I'm using postgres7.3.4 and I have tried to use pg_dumpall to copya a database from one computer to another. I remember I used it once with no problem, but now I've found a lot of error. I've run the restore as the "postgres" superuser, and it seem that when a table exists previously, or a

[GENERAL] how to generate a sql file

2004-03-23 Thread spambox
Hi, i would like to generate a file of my sql sequences during a stored process, i know it's possible but i dont' find the command. Thx for the help ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgr

Re: [GENERAL] PHP or JSP? That is the question.

2004-03-23 Thread Bas Scheffers
> brought to my attention is that PHP is natively supported by Apache > and JSP requires a separate interpreter (Jakarta or whatever). There is more to life than Apache and there are much better Java solutions than Jakarta! If you want to go the Java way, do yourself a favour and use http://www.ori