Re: [HACKERS] Need feedback: GeneXus will support PostgreSQL

2001-09-13 Thread Horst Herb
On Thursday 13 September 2001 15:34, Ryan Mahoney wrote: What is it? 8) is it middleware? Is it pre-built applications? I'm confused! It is sort of an application framework and builder. IMHO not very useful, as it does not support any real world programming language apart from Java

[HACKERS] ERROR: Cannot insert a duplicate key into a unique index

2001-09-13 Thread Haller Christoph
[HACKERS] ERROR: Cannot insert a duplicate key into a unique index I'm working on a C code application using loads of insert commands. It is essential to distinguish between an error coming from a misformed command or other fatal reasons and a duplicate key. In either case, the

Re: [HACKERS] count of occurences PLUS optimisation

2001-09-13 Thread Haller Christoph
Adam, try this select distinct job_num, count (job_num) from search_record group by job_num ; don't worry about an ordered list - group by does it for you. Regards, Christoph HACKERS: see the end of this message about a possible optimisation for ORDER BY+LIMIT cases (the normal use of

Re: [HACKERS] ERROR: Cannot insert a duplicate key into a

2001-09-13 Thread Ryan Mahoney
Error codes would be excellent! -r In our PHP app, we are also forced to parse error messages to get that kind of information. Register my vote for error codes (Tom Lane style...) Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com).

Re: [HACKERS] Need feedback: GeneXus will support PostgreSQL

2001-09-13 Thread Stephan Szabo
On Thu, 13 Sep 2001, Horst Herb wrote: On Thursday 13 September 2001 15:34, Ryan Mahoney wrote: What is it? 8) is it middleware? Is it pre-built applications? I'm confused! It is sort of an application framework and builder. IMHO not very useful, as it does not support any real world

Re: [HACKERS] Need feedback: GeneXus will support PostgreSQL

2001-09-13 Thread Haroldo Stenger
(On-topic since GeneXus' people decision of supporting PG.) Horst Herb wrote: On Thursday 13 September 2001 15:34, Ryan Mahoney wrote: What is it? 8) is it middleware? Is it pre-built applications? I'm confused! It is sort of an application framework and builder. IMHO not very

Re: [HACKERS] Need feedback: GeneXus will support PostgreSQL

2001-09-13 Thread Haroldo Stenger
Ryan Mahoney wrote: What is it? 8) is it middleware? Is it pre-built applications? I'm confused! Genexus is a VRAD tool, database oriented. You code in a mix of graphical forms, and plain code. The code combines logic paradigm, event oriented programming, and imperative code. There is a

[HACKERS] Proposed installation dir change

2001-09-13 Thread Peter Eisentraut
I would like to do the following: Put the dynamically loadable shared objects for the language handlers (language handlers being the only shared objects we install by default) into a private subdirectory '$(libdir)/postgresql'. The default directory where the backend looks for shared objects

Re: [HACKERS] ERROR: Cannot insert a duplicate key into a unique

2001-09-13 Thread Rachit Siamwalla
Count me in for error codes. You can just see part of the code i'm using to deal with the problem (some of the error messages changed from 7.0 to 7.1 -- i had to fix that): def parseError(self, errval): # first compile all the exceptions. Ideally we don't have to compile #

Re: [HACKERS] Index location patch for review (more pgbench resul

2001-09-13 Thread Mikheev, Vadim
Moving the test to a system with SCSI disks gave different results. There is NO difference between having the indexes on the same disk or different disk with the data while running pgbench. So I leave it up to you guys as to include the patch or not. I do believe that even if performance

Re: [HACKERS] Escaping strings for inclusion into SQL queriesh

2001-09-13 Thread Bruce Momjian
Patch applied. Thanks. Joe Conway [EMAIL PROTECTED] writes: I found a problem with PQescapeString (I think). Since it escapes null bytes to be literally '\0', the following can happen: 1. User inputs string value as null byte## where ## are digits in the range of 0 to 7. 2.

Re: [HACKERS] ERROR: Cannot insert a duplicate key into a unique index

2001-09-13 Thread Christopher Kings-Lynne
In our PHP app, we are also forced to parse error messages to get that kind of information. Register my vote for error codes (Tom Lane style...) Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Haller Christoph Sent: Thursday, 13 September

Re: [HACKERS] count of occurences PLUS optimisation

2001-09-13 Thread Thurstan R. McDougle
HACKERS: see the end of this message about a possible optimisation for ORDER BY+LIMIT cases (the normal use of LIMIT?) Adam wrote: I help run a job database and have a table of search records. I want a query that will return the top 10 jobs by search frequency. I'm familiar with ORDER BY