[HACKERS] about postgresql-7.3.2 rpm
Hello,all. I have downloaded the 7.3.2 rpm. I use rpm -i to install the rpm. When I want to regenerate a new 7.3.2 rpm, I use 'rpm -ba postgresql-7.3.2.specs' in /usr/src/redhat/SPECS. It show errors. It seem perl5 don't exist in the /postgresql7.3.2-root/usr/bin/lib/. After that I change the define perl 1 to 0 in spec file, It then can work properly. I wonder where to get perl5 package to make it whole? Thank you very much. Jinqiang Han ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] The document
Hello In the document of postgresql I always see such text '\ref{where_clause} '. But I wonder how can I see the graphics. In the DocBook software? Thank you in advance. Jinqiang Han
[HACKERS] about table function
hello, Joe Conway. it seems the crosstab function you write in contrib/tablefunc can't work. it saids that A column definition list is required for functions returning RECORD. How can i make it work? thank you very much best regard, Jinqiang Han ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] about data type id
hello, Is there a function that I can get type id from type name, such as from 'text' to 25, 'int' to 23. thanks in advance. Jinqiang Han ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] who can help me?
Hi, all hackers, I can startup database using command "/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data". But when I debug it using gdb and set args -D /usr/local/pgsql/data, it can't startup database. it says; FATAL: Database "postgres" does not exist in the system catalog. Is there any difference between them? Thanks a lot. Jinqiang Han ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[HACKERS] inquiery
hello, what is RIR rules in Rewriter? What RIR means? Thank you very much. Jinqiang Han ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] inquiry
hello, I have read the source code of postgres.c. Two strang things I can't understand. Souce code of Postgres.c: .. Foreach(parsetree_list的元素parsetree){ //In what situation here will be many parsetrees? … (List *)querytree_list = pg_analyze_and_rewrite(parsetree); foreach(querytree_list中的每个querytree){ //In what situation here will be many querytrees? Who can tell me the reason? Thank you very much Jinqiang Han ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] inquiry
hi,Bruce Momjian I think you are wrong. multiple query in a string, such as ""SELECT;SELECT" will invoke pg_execute_query_string twice, It won't generate two parsetree. === 2003-03-26 10:20:00 您在来信中写道:=== >Jinqiang Han wrote: >> hello, >> >> I have read the source code of postgres.c. Two strang things I can't understand. >> Souce code of Postgres.c: >> .. >> Foreach(parsetree_list的元素parsetree){ //In what situation here will be many >> parsetrees? >> … > >You can send multiple queries in a single string, "SELECT;SELECT". > >> (List *)querytree_list = pg_analyze_and_rewrite(parsetree); >> foreach(querytree_list中的每个querytree){ //In what situation here will be >> many querytrees? > >A RULE may have additional queries to fire. > >> >> Who can tell me the reason? >> Thank you very much >> >> Jinqiang Han >> >> >> ---(end of broadcast)--- >> TIP 5: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faqs/FAQ.html >> > >-- > Bruce Momjian| http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup.| Newtown Square, Pennsylvania 19073 > >. = = = = = = = = = = = = = = = = = = = = ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] PITR in 7.4
hi, Tom and Momjian Is PITR also delayed to 7.5?Right? 3x Jinqiang Han [EMAIL PROTECTED] 2003-08-05 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] win32 porting in 7.4
hi, Tom and Momjian I wonder if 7.4 will have win32 porting? I checkout source from cvs. I only find win32 makefile for client. Jinqiang Han [EMAIL PROTECTED] 2003-08-05 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[HACKERS] why postgresql is so slow?
hello, all. I have a table about 2 million rows. when I run "select * from table1" in psql, it will take me about 10 minutes to get the result. I wonder if postgresql can immediately return result like db2. After that I create a index on a column named id. The time executing "selct * from table1 where id=10" in psql is much faster than that of executing "select * from table1 where id <10" in psql. why? By the way I'm using postgresql 7.3. Who can tell me the reason. 3x. Jinqiang Han ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings