[HACKERS] unsubscribe

2003-11-19 Thread John Liu
---(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: [HACKERS] Select distinct question ... complicated

2003-08-14 Thread John Liu
It's easier to create a simple pgsql function to do this ... johnl > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of The Pennant Shop > Sent: Wednesday, August 06, 2003 2:06 PM > To: [EMAIL PROTECTED] > Subject: [HACKERS] Select distinct question ... co

Re: [HACKERS] can't create database

2003-04-03 Thread John Liu
I already set the 2nd port for the new installation, otherwise, postmaster will not start up ... johnl > -Original Message- > From: Christoph Haller [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 11:05 AM > To: John Liu > Cc: [EMAIL PROTECTED] > Subject: R

[HACKERS] can't create database

2003-04-03 Thread John Liu
on one of the AIX4.3.3, the 7.1.3 pgsql is installed by root on the system, then I tried to install 7.3.1/or 7.3.2 under another non-root user, I can run make, make check, make install, postmaster can start without errors, but when I try to createdb, here're some errors - createdb emrxdbs ERROR:

Re: [HACKERS] 7.3.2 make failed on AIX4.3 using native c compiler

2003-04-02 Thread John Liu
s is at least "make check" hangs). Hopefully this post will help some AIX users. thanks for the helps. John Liu > -Original Message- > From: Peter Eisentraut [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 01, 2003 3:41 PM > To: John Liu > Cc: [EMAIL PROTECTED] > Su

[HACKERS] 7.3.2 make failed on AIX4.3 using native c compiler

2003-03-31 Thread John Liu
make[4]: Leaving directory `/emrxdbs/postgresql-7.3.2/src/backend/parser' cc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I../../../src/interfaces/libpq -I ../../../src/include -I/usr/local/include -DBINDIR=\"/emrxdbs/pgsql/bin\" - c -o pg_dump.o pg_dump.c 2681 |

[HACKERS] unsubscribe

2003-02-14 Thread John Liu
unsubscribe ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[HACKERS] poor performance of subquery in psql

2003-01-28 Thread John Liu
1. the following query is so slow, after 12 hours, I kill it - delete from doc where cdi in (select cdi from doc_b1); doc_b1 records = 4 doc records = 500 cdi are indexed in both table. 2. I rewrite the above task in plpgsql, it takes 10 secs to finish. why psql subquery is not smarter

Re: [HACKERS] createlang failed!

2003-01-23 Thread John Liu
) even template1 supports plpgsql. I've to run createlang --pglib=Dir --dbname=DB plpgsql. I guess it's me to make it messy. johnl > -Original Message- > From: Tom Lane [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 17, 2003 9:15 AM > To: John Liu > Cc: [EMAIL PRO

[HACKERS] createlang failed!

2003-01-17 Thread John Liu
When I run createlang plpgsql template1 on linux 7.3 (pg version 7.3.1), it failed - createlang plpgsql template1 ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed Can someone point me where could go wrong? thanks. johnl -

[HACKERS] 7.3.1 on linux

2003-01-14 Thread John Liu
createlang plpgsql template1 ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed is the above error normal in 7.3.1 on linux? thanks. johnl ---(end of broadcast)--- TIP 4: Don't 'kill

[HACKERS] clock sync

2003-01-09 Thread John Liu
How do I know the clock on the machine you're running on will be set to the same time as the clock on the database? how postgre handle this internal? thanks. johnl ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.pos

[HACKERS] table lock and record lock

2002-10-01 Thread John Liu
what's the default lock in pgsql? if I issued insert(copy)/or update processed on the same table but on different records the same time, how those processes will affect each other? thanks. johnl ---(end of broadcast)--- TIP 3: if posting/readin

[HACKERS] many idle processes

2002-07-31 Thread John Liu
I tried to understand what causes too many pgsql idle processes. Can postmaster automatically aged and cleaning up those unused idle process? Is there a catalog to track those psql processes - what their functions, who issues, etc.? thanks. johnl ---(end of broadcast)

[HACKERS] why?

2002-07-25 Thread John Liu
I've two queries - 1. emrxdbs=# explain select * from patient A where exists (select NULL from patient B where B.mrn=A.mrn and B.dob=A.dob and B.sex=A.sex and B.lastname=A.lastname and B.firstname=A.firstname group by B.mrn, B.dob, B.sex, B.lastname, B.firstname having A.patseq < max(B.patseq))

Re: [HACKERS] string cast/compare broken?

2002-07-12 Thread John Liu
There is no comparison of varchar to char in Oracle too. Scott provided cast cases are some unique features in psql, each database MAY handle those casting differently. In good design/application, char should be replaced by varchar type unless you know the exact bytes. It would be not bad idea t