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
.
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
.
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
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.
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. -
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
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
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
[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
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
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
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
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
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
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
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
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
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
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]>:
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
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
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
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
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
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
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-
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
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
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
***
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
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
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
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
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
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
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
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
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
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
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
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
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-
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
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
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
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
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
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
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
--
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
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
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:
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
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
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
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.
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
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
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
59 matches
Mail list logo
