[HACKERS] about postgresql-7.3.2 rpm

[Jinqiang Han]

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

[Jinqiang Han]

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

[Jinqiang Han]

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

[Jinqiang Han]

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?

[Jinqiang Han]

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

[Jinqiang Han]

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

[Jinqiang Han]

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

[Jinqiang Han]

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

[Jinqiang Han]

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

[Jinqiang Han]

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?

[Jinqiang Han]

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