Re: [GENERAL] LDAP configuration problem

2006-12-28 Thread Wenjian Yang
ne 78, is host all all 0.0.0.0 0.0.0.0 ldap://dc.domain.com/dc=domain,dc=com/DOMAIN\ Since the previous email, I had the same problem on another FC6 x86_64 box. Thanks. Wenjian On 12/29/06, Magnus Hagander <[EMAIL PROTECTED]> wrote: Wenjian Yang wrote: > Hi, > > I've ju

Re: [GENERAL] LDAP configuration problem

2006-12-29 Thread Wenjian Yang
en "ldap" But after download the source, recompile with "--with-ldap", it worked perfectly. I wonder if this could be built in the rpm as the default in the future. Thanks and happy new year. Wenjian On 12/29/06, Magnus Hagander <[EMAIL PROTECTED]> wrote: Wenjian Yan

[GENERAL] Postgres 8.2.3 or 8.1.8?

2007-03-29 Thread Qiao Yang
Hi, We plan to upgrade our database from 7.4.11 to 8.x. It seems that both 8.1 and 8.2 branches are maintained. Which one is more stable? 8.1.18 or 8.2.3? 8.1 or 8.2 branch in general? We are trying to settle with one so we don't have to upgrade for a while. Thank you in advance for your answers,

[GENERAL] MAX() across partition tables

2006-06-13 Thread Qiao Yang
Hi, In Postgres 8.1, MAX() was rewritten to use index backward search without doing seq_scan. This achieves a huge performance gain. But I found that when I use MAX() on a partitioned table, it reverses back to the old seq_scan plan. Wouldn't it be more efficient to get MAX() from each partition t

[GENERAL] best ways to handle large matrix data

2006-08-02 Thread Wenjian Yang
Hi, this maybe a more general question and not limited to postgresql.We are generating some matrix like data, e.g. one object will have a fixed number 10 values, and we have currently 300 objects. We can visualized the data as a 10 by 300 matrix, and each object/column has an identifier, ea

[GENERAL] Column is a computation

2015-03-10 Thread Vang P yang
the _calc part more or less is just a flag? Vang P. Yang Advanced Planning Tech, Inc. West Salem, WI 54669 (608) 786-1215 --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com

[GENERAL] How to convert MS SQL functions to pgSQL functions

2016-12-31 Thread Yogi Yang 007
der = G.accountGroupId)) INSERT INTO @table_variable (accountGroupId) ( SELECT accountGroupId FROM GroupInMainGroupP) Return END I need to convert this code to pgSQL. Please help. Thanks, Yogi Yang

[GENERAL] ERROR: cannot execute nextval() in a read-only transaction

2011-05-11 Thread Dae-man Yang
I upgrade postgresql from 8.4.2 to 9.0.4. But I have one problem. The Error message 'cannot execute nextval() in a read-only transaction' Please help me. [Version 8.4.2] DEVDB=# select version(); version -

[GENERAL] How to retrive List of Tables in a Database using...

2010-03-24 Thread Yogi Yang 007
. Structure of a Table TIA Yogi Yang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to retrieve List of Tables in a Database using...

2010-03-25 Thread Yogi Yang 007
Hello, Thanks everyone for your help. I really appreciate it. Yogi Yang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] How to express categorized items in relational tables

1999-05-12 Thread Doo Suk Yang
yours. === Science is the game we play with God to find out what his rules are. --- Doo Suk Yang Research Scientist Voice: 82-42-866- LG Chemical Ltd. Research Park Biotech Research Instit

Re: [GENERAL] How to express categorized items in relational tables

1999-05-17 Thread Doo Suk Yang
what I looked for. :-) Thank you, thank you so much. > > I'm not sure. Is that what you mean? > > Doo Suk Yang wrote: > > > Thank you for your answer. It is going to be working. > > > > BTW, when inserting a parents category I had to go through two steps; > >

Re: [GENERAL] Gnome-DB

1999-06-11 Thread Doo Suk Yang
God to find out what his rules are. --- Doo Suk Yang Research Scientist Voice: 82-42-866- LG Chemical Ltd. Research Park Biotech Research Institute I

[GENERAL] code making rule?

1999-06-11 Thread Doo Suk Yang
comed. Sincerly, === Science is the game we play with God to find out what his rules are. --- Doo Suk Yang Research Scie

<    1   2