Re: [SQL] debugging query to put message in pg logfile?

2004-03-04 Thread Tom Lane
george young <[EMAIL PROTECTED]> writes: > I've started putting debugging queries like: >select "opwin.py: committing step signoff" > in my app, just to have an entry in the postgres logfile. > Is there some cheaper (or more appropriate) sql statement that will show > up in the postgres log?

Re: [SQL] query optimization

2004-03-04 Thread Tom Lane
Charles Hauser <[EMAIL PROTECTED]> writes: > I have the following query which is running quite slow on our server and > was hoping someone would have suggestions how I might improve it. Have you vacuumed or analyzed these tables recently? The EXPLAIN numbers show that the planner thinks all the t

Re: [SQL] returning a recordset from PLpg/SQL

2004-03-04 Thread Radu-Adrian Popescu
Terence Kearns wrote: Tom Lane wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > >> On Tue, 2 Mar 2004, Terence Kearns wrote: >> >>> Well I haven't yet done anything because I couldn't get anything to >>> compile which returned SETOF RECORD.. > > > >> As a starting point, SETOF "RECORD" is dif

[SQL] debugging query to put message in pg logfile?

2004-03-04 Thread george young
[postgresql-7.4RC2, python-2.3.3, PyGreSQL-3.4, SuSE x86 Linux 8.2] I've started putting debugging queries like: select "opwin.py: committing step signoff" in my app, just to have an entry in the postgres logfile. These are especially helpful in tracking down what piece of code did a 'commit

[SQL] query optimization

2004-03-04 Thread Charles Hauser
All, I have the following query which is running quite slow on our server and was hoping someone would have suggestions how I might improve it. est3=>EXPLAIN SELECT clone.uniquename,clone.name,library.type,clone.clone_id est3-> FROM library,clone_aceg est3-> JOIN clone USING (clone_id) e

Re: [SQL] How to avoid (stop) a endless loop in a trigger

2004-03-04 Thread Oliver Elphick
On Thu, 2004-03-04 at 14:54, Rodrigo Sakai wrote: > Hi people, i have a problem here. > I'm doing a trigger that when a update occurs i need to do an update on the same > table (target table), but as known, it causes a endless loop whithin infinit > updates. So I need to stop the trigger af

[SQL] How to avoid (stop) a endless loop in a trigger

2004-03-04 Thread Rodrigo Sakai
Hi people, i have a problem here. I'm doing a trigger that when a update occurs i need to do an update on the same table (target table), but as known, it causes a endless loop whithin infinit updates. So I need to stop the trigger after it does the first update, is there any way? I t

Re: [SQL] sub-select parameter problem

2004-03-04 Thread Richard Huxton
On Thursday 04 March 2004 11:20, Philippe Lang wrote: [working query] > It works fine. Excellent! :-) Oh - there's more :-( > Now, I need to do something else: the parameter of my sub-select is also > a member of the table I'm selecting. > > SELECT > > tableA.field1, > tableA.field2, > > t

Re: [SQL] sub-select parameter problem

2004-03-04 Thread Christoph Haller
> > Hello, > > Imagine the following query: > > --- > SELECT > > tableA.field1, > tableA.field2, > =20=20 > tableB.field1, > tableB.field2, > > ( > SELECT tableC.field2 > FROM tableC > WHERE tableC.field1 =3D tableB.field1 - 1; >

Re: [SQL] Encoding bytea

2004-03-04 Thread Achilleus Mantzios
O kyrios Joe Conway egrapse stis Mar 3, 2004 : > Achilleus Mantzios wrote: > > > is there a way to encode a bytea in such a way that the resulting > > text stream be readily available (\\ escaped for unprintable chars) for > > usage in an insert statement? > > > > None of base64,hex,escape opti