[HACKERS] unsubscribe

---(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

[HACKERS] can't create database

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

Re: [HACKERS] can't create database

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: Re: [HACKERS] can't create

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

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] Subject: Re: [HACKERS] 7.3.2 make failed on AIX4.3 using native c compiler John Liu writes: make[4]: Leaving

[HACKERS] unsubscribe

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

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!

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 PROTECTED] Subject: Re: [HACKERS] createlang failed

[HACKERS] createlang failed!

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

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

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?

[HACKERS] table lock and record lock

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

[HACKERS] many idle processes

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

[HACKERS] why?

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?

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