[GENERAL] Install pgbench on the client server.Please helps thanks.

Currently we use the postgresql database verion 8.2.15. And We want to install the pgbench on the client server. I don't have any idea which pgbench version is compatible with 8.2.15 and How to install it on Linux server and Sun solaries server. Please helps thanks. -- View this message in cont

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

[hidden email]> >> wrote: >>> >>> On 06/12/12 11:25 AM, leaf_yxj wrote: >>>> >>>> Thanks. You guys are right. I check the database. The C programm is >>>> there. >>>> - but why our application team keep ask me to g

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

how often do your programmers change them? Grace commends : they tried to SAS to create lot of models. So I amn't sure about this issues. But John, thanks a lot for your answers. Thanks. Regards. Grace At 2012-06-13 03:27:45,"John R Pierce [via PostgreSQL]" wrote: O

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

n R Pierce [via PostgreSQL]" wrote: On 06/12/12 12:04 PM, leaf_yxj wrote: > So can I ( the superuser) do it by myself and how can I do it? the devs would give you the .dll/.so file, and a .sql scrap to do the install. you'd put the .so/.dll in an appropriate place, and run the .sql scra

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

Hi John, one more question: so it's one time jobs or it need keep doing. Thanks. Grace At 2012-06-13 02:48:20,"John R Pierce [via PostgreSQL]" wrote: On 06/12/12 11:25 AM, leaf_yxj wrote: > Thanks. You guys are right. I check the database. The C programm is > t

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

John, So can I ( the superuser) do it by myself and how can I do it? Thanks. Grace At 2012-06-13 02:48:20,"John R Pierce [via PostgreSQL]" wrote: On 06/12/12 11:25 AM, leaf_yxj wrote: > Thanks. You guys are right. I check the database. The C programm is > there. -

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. Regards.

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

. Regards. Grace At 2012-06-13 02:14:06,"John R Pierce [via PostgreSQL]" wrote: On 06/12/12 9:53 AM, leaf_yxj wrote: > I need to create c language in the postgresql database. I only know to > create as follows. > > Create language c ; > to clarify what tom said, you

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

. Regards. Grace At 2012-06-13 01:35:49,"Raymond O'Donnell [via PostgreSQL]" wrote: On 12/06/2012 17:53, leaf_yxj wrote: > I need to create c language in the postgresql database. I only know > to create as follows. > > Create language c ; > > > Is there

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

I need to create c language in the postgresql database. I only know to create as follows. Create language c ; Is there anything else I need to do before I create the C language? Thanks. Regards. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-create-c

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

Thanks. Steve At 2012-05-18 02:54:36,"Steve Crawford [via PostgreSQL]" wrote: On 05/17/2012 11:30 AM, leaf_yxj wrote: > Hi Guys. Please help me about this. > > For postgres database, it looks like we need analyze and vacuum all the > tables periodly. I need to write

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

Thanks Steve. At 2012-05-18 03:04:02,"Steve Crawford [via PostgreSQL]" wrote: On 05/17/2012 11:54 AM, leaf_yxj wrote: > I know we can know the currenct activity via pg_stat_activity. What's else > you guys use to debug. > And for some times back, how can we check th

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

I know we can know the currenct activity via pg_stat_activity. What's else you guys use to debug. And for some times back, how can we check the activities? Thanks. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-debug-the-performance-issues-via-which-syste

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

Hi Guys. Please help me about this. For postgres database, it looks like we need analyze and vacuum all the tables periodly. I need to write a script which can be executed in crontab. I don't have any clues about that. I only know the command : analyze tablename; vacuum tablename; Please helps.

[GENERAL] Re: How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks

At 2012-05-05 01:37:50,"Adrian Klaver-3 [via PostgreSQL]" wrote: On 05/04/2012 10:23 AM, leaf_yxj wrote: > I tried test the ODBC driver. I failed and I was told I should install the > odbc driver manager to configure the ODBC driver first, then I can test the > ODBC drive

[GENERAL] Re: How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks

Hi Adrian, Thanks. I tried to understand how the ODBC driver works. Is that true that there should be some odbc driver manager and otherwise the ODBC driver can't work properly. Our ODBC driver is installed on linux 5.7 for the informatic use. Before we deploy the informatic, we want to test the

[GENERAL] How to know there is any ODBC Driver installed in the Linux redhat 5.7 server? Thanks

I tried test the ODBC driver. I failed and I was told I should install the odbc driver manager to configure the ODBC driver first, then I can test the ODBC drive. And the following ODBC driver were installed on my server : psqlodbc-08.02.0400 psqlodbc-08.03.0400 psqlodbc-09.00.0200 psqlodbc-0

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

Hi Andreas, Thanks a lot. I tried those following , they work. 1) insert into test values ( generate_series(1,1000), md5(random()::text)); 2) create table t_random as select s, md5(random()::text) from generate_Series(1,5) s; Thanks. Regards. Grace -- View this message in context:

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

Hi Guys, I want to insert the random character data into tables for testing purpose. I created a table as follows : create table test ( id int, b char(100)); I need to insert 10 rows into this table. I know how to insert generate_series into coloumn ID. But I don't how to insert the Random

[GENERAL] How to insert random character data into tables.

-- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-insert-random-character-data-into-tables-tp5680962.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

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

Hi Guys: I installed this odbc driver :psqlodbc-08.02.0400 and datadirect-x_xx. I want to test this two things work or not. Please give me some idea. Thanks. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/Test-ODBC-connection-failed-Pleae-help-me-to-take-a-loo

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

These odbc drivers (psqlodbc-08.02.0400 psqlodbc-08.03.0400 psqlodbc-09.00.0200 psqlodbc-08.02.0500 psqlodbc-08.04.0200) were installed. But I can't fine where the odbc.ini. After I set up my .odbc.ini. And setup the driver and driver manager environment variables, I still can't get the isql com

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

Hi Guys, I got the support from Greenplum. I will give a feedback to everybody after I test. Thanks. They told me to add in /etc/rc.d. -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-set-up-automatically-startup-database-when-the-server-boot-or-reboot-tp5670442p

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

My os is redhat linux 5.5. And My database is greenplum 4.2.1( postgresql 8.2.15). I will take a look about the init.d directory. Thanks. Guys. Any opinion is welcome. Please help. -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-set-up-automatically-startup-data

[GENERAL] Re: 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 -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-set-up-automatically-startup-database-when-the-server-boot-or-reboot-tp5670442p56

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

e you are using, as well as how you went about installing PostgreSQl, no one is going to be able to help you. The PostgreSQL version would probably help as well. David J. On Apr 27, 2012, at 10:26, leaf_yxj <[hidden email]> wrote: > My company want to setup automatically startup d

[GENERAL] How to get the all the activities running during specific time range.Thanks!Plese help!

I was asked to run a report to my boss all the activities running during a specific time range. I want to create a script to run it. I know I can query from pg_stat_activity for my previous postgres version. But I can't find this system table in 8.2.15. Please help. Thanks. Regards. Grace. -- Vie

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

My company want to setup automatically startup database. For oracle database, there is a bullitin script and configuration of auto start when the server boot or reboot? Hi Guys, Please help. Thanks. Regards.Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-set-

[GENERAL] how to list all the schema and the privileges which is granted to users.THanks.

how to list all the schema and the privileges which is granted to users.THanks. I know how to list all the objects privileges : \dp But I don't know how to list the schema's privileges?? Thanks. Regards. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-lis

[GENERAL] Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

Thanks Guys. I wrote this function in a specific schema and granted to the dba users only. Thanks. Problem solved. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Questions-of-the-privileges-to-use-the-pg-cancel-backend-and-pg-terminate-backend-function-Thanks-tp5618129p

[GENERAL] Re: Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

Hi Aaron: thanks. I tried the security definer. it works well as follows : CREATE FUNCTION kill_process(integer) RETURNS boolean AS 'select pg_cancel_backend($1);' LANGUAGE SQL SECURITY DEFINER; One more question about this function : if non-super user get the execute this function, he/her w

[GENERAL] Questions of the privileges to use the pg_cancel_backend and pg_terminate_backend function. Thanks.

Hi Guys. I got one problem. I need to give some of the non-super users( kind of dba) to get the privileges to can cancel other users's query, DML. After I granted the execute on pg_cancel_backend and pg_terminate_backend function to them, they still get the error message as follows when they call

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

Hi John, Thanks for your reply. Just to confirm : so truncate table means the space will be reclaim for reuse ??? Thanks. Grace At 2012-04-04 02:01:59,"John R Pierce [via PostgreSQL]" wrote: On 04/03/12 10:49 AM, leaf_yxj wrote: > --- I amn't sure what's diffe

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

really need this function. AFAIK since 8.4 postgres has TRUNCATE privilage on Table http://www.postgresql.org/docs/9.1/static/sql-grant.html this is not the same as DELETE so, I think it is enough to grant this privilage to user Regards, Bartek 2012/4/3 leaf_yxj <[hidden email]> Tom, Tha

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

ber since when, but 9.X has this option. Another thing: Do You really need this function. AFAIK since 8.4 postgres has TRUNCATE privilage on Table http://www.postgresql.org/docs/9.1/static/sql-grant.html this is not the same as DELETE so, I think it is enough to grant this privilage to user R

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

Tom, Thanks. I found out the key issue it. It's because the truncate command can't have the "cascade". For the other people reference. The right funcitons are : *** CREATE OR REPLACE FUNCTION truncate_t (IN tablename text) RETURNS VOID

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

Adrian, Thanks. Even I try use '' to quote the character. I still get the error as follows : rrp=> truncate table t1; TRUNCATE TABLE rrp=> select truncate_t('t1'); ERROR: table "t1" does not exist Thanks. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/Please-he

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

Alban, Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Please-help-me-to-take-a-look-of-the-erros-in-my-functions-Thanks-tp5613507p5615244.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-g

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

Bartek, Thanks. The reason I use the cursor is that I want to check the table is in the pg_tables or not, If it exists, the function will execute successfully, if not, it will raise the message that the table doesn't exist. For the schema part, I assume the people has set the search_path to that

[GENERAL] Re: Please help me to take a look of the erros in my functions. Thanks.

*** CREATE OR REPLACE FUNCTION truncate_t (IN tablename text) RETURNS VOID AS $$ BEGIN EXECUTE 'TRUNCATE TABLE ' || quote_ident(tablename) || 'CASCADE;'; EXCEPTION WHEN undefined_table THEN RAISE EXCEPTION 'Tab

[GENERAL] Please help me to take a look of the erros in my functions. Thanks.

I tried to create function to truncate table 1) when the user call the function just specify the tablename 2) the user can use the function owner privilege to execute the function. But I got the errors as follows. Please help me to take a look. Thanks. Regards. Grace -- function : CREA

[GENERAL] How to check the role has been granted to which role. Help me to double check . Thanks.

I want to check the role has been granted to which role. In my working environment, the all the normal is assigned to role group. when i issue dp, it only give me the role group privilege. So I need to check which user is in which user group. THe following is my sql to do that. Is there anybody ha

[GENERAL] Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.

I think they don't care about the grantee. they only care about the users ( for example the application team user, develop team user) and the privileges they have. Thanks. Guys. Grace -- View this message in context: http://postgresql.1045698.n5.nabble.com/double-check-the-role-has-what-s-kind-o

[GENERAL] Re: how to pass the function caller's parameter to inside the function. syntax error at or near "$1"

merlin : Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/how-to-pass-the-function-caller-s-parameter-to-inside-the-function-syntax-error-at-or-near-1-tp5601045p5606816.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-

[GENERAL] Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.

Hi Albe, My bosses ask me to list 1)all the users and the roles associated with the users. 2) all the users and the privileges associated with that users. Thanks. Regards. Grace At 2012-03-30 16:07:08,"Albe Laurenz *EXTERN* [via PostgreSQL]" wrote: leaf_yxj wrote: > My

[GENERAL] Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks.

at 7:49 PM, leaf_yxj <[hidden email]> wrote: > Hi All friends. Thanks for you guys reply my questions. You helps me a lot. > THank you billions. Another help. THanks. > > After I create table and roles. I want to double check I grant the proper > privileges to the users. I can &g

[GENERAL] double check the role has what's kind of the privilege? And the same for the objects. Thanks.

Hi All friends. Thanks for you guys reply my questions. You helps me a lot. THank you billions. Another help. THanks. After I create table and roles. I want to double check I grant the proper privileges to the users. I can use \dp and \z command to check the objects privilege. I can user pg_aut

[GENERAL] Re: system catalog privilege and create privilege ??? how to control them?? thanks

Thank you very much!!! I really appreicate it. Grace At 2012-03-29 16:18:23,"Albe Laurenz *EXTERN* [via PostgreSQL]" wrote: leaf_yxj wrote: > For oracle, the normal user can't see all the system catalog. but for > postgresql, it looks like all the user can see the system

[GENERAL] system catalog privilege and create privilege ??? how to control them?? thanks

For oracle, the normal user can't see all the system catalog. but for postgresql, it looks like all the user can see the system catalog. Should we limit the user read privilege to system catalog? In oracle, the system privilege has create table, create view,create function. For postgresql datab

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

For oracle, the normal user can't see all the system catalog. but for postgresql, it looks like all the user can see the system catalog. Should we limit the user read privilege to system catalog? In oracle, the system privilege has create table, create view,create function. For postgresql datab

[GENERAL] Re: how postgresql passes the parameter to the function. syntax error near or at "$1".

ic SQL in these cases. CREATE OR REPLACE FUNCTION foo(tablename text, value text) RETURNS void AS $$ BEGIN EXECUTE 'insert into ' || quote_ident(tablename) || ' VALUES($1)' USING value; END; $$ LANGUAGE plpgsql Regards Pavel Stehule 2012/3/28 leaf_yxj <[hidden email]>:

[GENERAL] how postgresql passes the parameter to the function. syntax error near or at "$1".

I want to create a function which use to truncate the table specified by the caller. I very confused how postgresql pass this parameter into the function : as a superuser to execute : 1) create or replace function d() returns void as $$ analyze; $$ language sql; - this works when i iss

[GENERAL] how to pass the function caller's parameter to inside the function. syntax error at or near "$1"

I want to create a function which use to truncate the table specified by the caller. I very confused how postgresql pass this parameter into the function : as a superuser to execute : 1) create or replace function d() returns void as $$ analyze; $$ language sql; - this works when i issue s

[GENERAL] what's difference between vacuum analyze and analyze?

I was asked to write a security definer function to make other user can issue vacuum and analyze command? Friends in this community said vacuum doesn't work inside the function or multi command. How about analyze. I know vacuum is something much like oracle shrink which is used to reorganize the s

Re: [GENERAL] postgresql commit.

Hi Andrew, Thanks. I got it. Regards. Grace At 2012-03-27 12:36:18,"Andrew Sullivan-8 [via PostgreSQL]" wrote: On Mon, Mar 26, 2012 at 06:22:20PM -0700, leaf_yxj wrote: > Oracle database, the other user can't see the uncommited data, for > postgresql 8.2 , it look

[GENERAL] create one function to let other user execute vacuum command. got such an error.

create one function to let other user execute vacuum command. got such an error. Please help. Thanks. Regards . Grace rrp=> create function vacuum_f ( tablename char(100)) Returns char(100) AS $$ vacuum tablenam

[GENERAL] postgresql commit.

Oracle database, the other user can't see the uncommited data, for postgresql 8.2 , it looks like once you issue insert , the other user will automatically see new record. was it wrong? I am pretty new to postgresql? Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.co

[GENERAL] postgresql 8.2 security definer is a built-in function. very confused??

the security definer is built-in function, or I need create security definer first, then user call it. How it works? I am pretty new in Postgresql. Please help. Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-8-2-security-definer-is-a-built-in-functio

[GENERAL] Re: postgresql 8.2 security definer is a built-in function. very confused??

I am very confused after I read the guide as follows. It means I only need to set the search_path to make the pg_temp as the last entry. or I need configure search_path and at the same time, I need create the security definer? Is thers anybody help me? Thank you very much. I really appreciate i