Re: [GENERAL] How to create c language in postgresql database. Thanks.

Hi Albe, Thanks. I will study it. Regards. Grace At 2012-06-14 15:33:07,"Albe Laurenz" wrote: >leaf_yxj wrote: >> Thanks for your answers. I really appreciate it. Although I don't >understand the whole things you guys >> mentioned to me. I think maybe I should do it by myself. I need to

Re: [GENERAL] How to create c language in postgresql database. Thanks.

Hi Tom, Thanks. You guys are right. I check the database. The C programm is there. - but why our application team keep ask me to give them the superuser privileges to create the C function. Should they use the superuser to create the C function. if yes , why they need it? Thanks. Regar

Re: [GENERAL] How to debug the performance issues via which system catalog.Thanks.

Hi Steve, This is a very good website. We use the postgresql 8.2. there may be a little different. It's very useful to me. Thanks. Regards. Grace At 2012-05-18 03:02:41,"Steve Crawford" wrote: >On 05/17/2012 11:54 AM, leaf_yxj wrote: >> I know we can know the currenct activity via pg_s

Re: [GENERAL] How to write a script to analyze and vacuum all the tables in the system catalog?Thanks.

Hi Steve, Thanks for your reply. My Postgresql version is 8.2. I amn't sure we have the autovacuum job running or not? How can I check it ? Thanks. Grace At 2012-05-18 02:53:15,"Steve Crawford" wrote: >On 05/17/2012 11:30 AM, leaf_yxj wrote: >> Hi Guys. Please help me about this. >>

Re: [GENERAL] Limit the normal user to see system catalog or not??? And create privilege???

Hi Super Guys, Thanks. I learned a lot. It's very good for me to know that. Regards. Grace At 2012-05-03 07:15:29,"Bruce Momjian" wrote: >On Wed, May 02, 2012 at 04:03:01PM -0700, Adrian Klaver wrote: >> On 05/02/2012 11:42 AM, Bruce Momjian wrote: >> > On Wed, Mar 28, 2012 at 01:54:58

Re: [GENERAL] Re: How to insert random character data into tables for testing purpose. THanks.

Hi Bruce, Thanks. I tried. It works. Regards. Grace At 2012-05-03 07:14:21,"Bruce Momjian" wrote: >On Wed, May 02, 2012 at 11:03:47AM -0700, leaf_yxj wrote: >> Hi Andreas, >> >> Thanks a lot. >> >> I tried those following , they work. >> >> 1) insert into test values ( generate_series(

Re: [GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.

Hi Chris, Actually I only want to test ODBC. But I didn't have any idea to test. We have pgsqlodbc installed, but I don't how to test it. Please give me some clue. Thanks. Grace At 2012-05-01 03:54:36,"Chris Curvey" wrote: >you want psql not isql. On Mon, Apr 3

Re: [GENERAL] Test ODBC connection failed. Pleae help me to take a look. Thanks.

Hi Scott, I amn't farmiliar with isql. Why I said isql is because that I did some research. they said something related to isql. No matter it's isql or psql. 1)How can I test the odbc function? 2) what's isql, in which circumstances , we use isql. Thanks. Regards. Grace At 2012-05-01

Re: [GENERAL] how to set up automatically startup database when the server boot or reboot.

David, Thanks for your reminder. My database version is 8.2.15. And My os platform is Linux 5.5. Thanks I really appreciate it. Grace At 2012-04-27 22:36:51,"David Johnston" wrote: >PostgreSQL runs on numerous operating systems. If you do not specify which >one you are using, as well as h