Re: [GENERAL] PERFORM statement inside procedure

you're having problems with, along with the version of Postgres in use. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] FUNCTION problem

if not strictly necessary) to make it unambiguous to the parser, as well as easier for humans to read. I think it's good advice all around. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 8: explain analyze is your

Re: [GENERAL] Wich hardware suits best for large full-text indexed

Diogo Biazus wrote: Bill Moran wrote: Diogo Biazus wrote: Hi folks, SNIP Does anyone has an idea of a more cost eficient solution? How to get a better performance without having to invest some astronomicaly high amount of money? This isn't hardware related, but FreeBSD 5 is not a particularly

Re: [GENERAL] Wich hardware suits best for large full-text indexed

... it speeds things up noticably. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [GENERAL] CREATE TEMP TABLE

tmp_table1, append a unique number to the name each time you create the temp table. Hope this helps. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [GENERAL] partial VACUUM FULL

scott.marlowe wrote: On Tue, 23 Mar 2004, Tom Lane wrote: Bill Moran [EMAIL PROTECTED] writes: Was this true for some previous version? I could have swore I read somewhere that vacuum_mem had to be set high enough or vacuum wouldn't be able to clean everything up (aside from anything locked

Re: [GENERAL] sequential scan when using bigint value

to BIGINT. Otherwise, I can't imagine why you would be looking for a BIGINT in an INT field. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [GENERAL] Relation xxxxx does not exist - more info

are running on windows2k Valter -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do

[GENERAL] Shouldn't B'1' = 1::bit be true?

educated on? Why does int 1 cast to binary 0? This is Posgres 7.4.1. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] Shouldn't B'1' = 1::bit be true?

Stephan Szabo wrote: On Wed, 3 Mar 2004, Bill Moran wrote: Am I missing something here? agelis=# select B'1'::int; int4 -- 1 (1 row) agelis=# select 1::bit; bit - 0 (1 row) agelis=# select B'1'=1; ?column? -- f (1 row) Last I checked, binary 1 and integer 1 were equal

Re: [GENERAL] Question on stored functions

); create function returns2strings() returns demotype as ' declare rval demotype; begin rval.value1 := ''some string''; rval.value2 := ''some other string''; return rval; end; ' language 'plpgsql'; -- Bill Moran Potential Technologies http://www.potentialtech.com

Re: [GENERAL] PostgreSQL insert speed tests

7.4.1 is so slow under heavy work? Is there a way to speed up inserts without eliminating indexes? What about concurrent inserts (cocurrent spare test program execution) into the same table? It did not work. -- Bill Moran Potential Technologies http://www.potentialtech.com

[GENERAL] field must appear in the GROUP BY clause or be used in an aggregate function?

a difference of interpretation? -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] compartmentalizing users

. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [GENERAL] field must appear in the GROUP BY clause or be used

John Sidney-Woollett wrote: Bill Moran said: I've hit an SQL problem that I'm a bit mystified by. I have two different questions regarding this problem: why? and how do I work around it? The following query: SELECT GCP.id, GCP.Name FROMGov_Capital_Project GCP, WHERE

Re: [GENERAL] PostgreSQL on XFS experiences?

, it works reliably. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Problems with plpgsql and FOR loops

have any suggestions on how to convince the parser to interpret the loop correctly? This is a MAJOR holdup for me right now, and I'm on a tight schedule, so any help will be a life-saver! I've been unable to subscribe to the list, so please include me in your reply directly. -- Bill Moran Potential

Re: [GENERAL] Problems with plpgsql and FOR loops

Tom Lane wrote: Bill Moran [EMAIL PROTECTED] writes: Some of the plpgsql functions I've created work fine on 7.4, but fail on 7.3.4. Specifically, when I use a FOR var IN select LOOP loop with a LONG select statement, it works fine on 7.4, but bonks with missing .. at end of SQL expression

Re: [GENERAL] SCO Extortion

of finding (and, usually pushing) its limits, I've been most happy with it ... -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] Returning large select results from stored procedures

Richard Huxton wrote: On Thursday 15 January 2004 15:02, Bill Moran wrote: I'm having a little trouble understanding how to do something. I assume I'm just missing it in the documentation, so a pointer to relevent docs would be as welcome as a direct answer. I have a project in which I'll need

Re: [GENERAL] error creating sql function

-- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

<    4   5   6   7   8   9