Could anyone please help me to get rid of following error? I want to set the
'ishuman' column based on the value of 'ID' column but it is not allowing me
to do so. Any alternatives?
techdb= CREATE TABLE Users (
ID INTEGER,
isHumanBOOLEAN NOT NULL
1:20 AM, Jignesh Shah wrote:
Could anyone please help me to get rid of following error? I want to set
the 'ishuman' column based on the value of 'ID' column but it is not
allowing me to do so. Any alternatives?
Use a BEFORE trigger to set it.
--
Craig Ringer
:) I realized that. Thanks.
On Thu, Apr 22, 2010 at 6:53 PM, Greg Sabino Mullane g...@turnstep.comwrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I have written following trigger and trying to improve the performance by
using prepared query everytime. I have used spi_prepare
++
5 | 196552 | 2010-04-22 09:30:10.509326
(1 row)
techdb=#
Could anyone please help me out here.
Thanks,
Jignesh
On Wed, Apr 21, 2010 at 9:04 PM, Andreas Kretschmer
akretsch...@spamfence.net wrote:
Jignesh Shah jignesh.shah1...@gmail.com wrote:
Hi All,
I
I got it resolved. I just need to put below statement into single quote
instead of double quote. :)
my $query ='INSERT INTO log_table(id) SELECT $1 EXCEPT SELECT id FROM
log_table WHERE id = $1;';
Thanks,
Jignesh
On Thu, Apr 22, 2010 at 2:02 PM, Jignesh Shah jignesh.shah1...@gmail.comwrote
Hi,
I have written following trigger and trying to improve the performance by
using prepared query everytime. I have used spi_prepare to prepare the query
and $_SHARED global hash to persist the prepared plan but it doesn't seem to
work. Though $query will be same always in following trigger, it
Hi All,
I have written below trigger and applied on the table but it is giving
syntax error when it gets invoked. Could you please help me what is wrong? I
have given complete details here:
*my trigger function:*
**
CREATE OR REPLACE FUNCTION techdb_logtable_trigger()
RETURNS trigger AS
$BODY$
I don't think you can do it. You have to parse the string you got from
pg_namespace to get the current user's permissions.
On Thu, Apr 1, 2010 at 11:09 AM, dipti shah shahdipti1...@gmail.com wrote:
Hi,
I ran below command to list out all privileges of objects if mydb schema.
Actually, I
Hi, I have created below function. I am checking return value of
has_schema_privilege by using flag=f. I think this is not strong way to
make a check because if in future f becomes false my stored procedure
will work improper.
Could you tell me is there any other robust way to make sure that
Hi,
could you tell me what could be the issue in below command. I could see that
there is an option for changing OWNER of function but not sure why it is
giving this error.
techdb=# ALTER FUNCTION test_create() SET OWNER TO masanip;
ERROR: unrecognized configuration parameter owner
techdb=#
Hi,
Is there any way to get the set of permissions list assigned to user? I want
to know whether user has create table permissions on particular schema or
not?
Thanks in advance,
Jack
techdb=#
Thanks,
Jack
On Wed, Feb 24, 2010 at 11:51 AM, A. Kretschmer
andreas.kretsch...@schollglas.com wrote:
In response to Jignesh Shah :
Hi,
could you tell me what could be the issue in below command. I could see
that
there is an option for changing OWNER of function but not sure why
Thanks :) I am going crazy at times.
On Wed, Feb 24, 2010 at 12:04 PM, Frank Heikens frankheik...@mac.comwrote:
Skip the SET-keyword:
ALTER FUNCTION test_create() OWNER TO masanip;
Regards,
Frank
Op 24 feb 2010, om 07:14 heeft Jignesh Shah het volgende geschreven:
Hi,
could you
Hello All,
I have been writing a function with SECURITY DEFINER enabled. Basically, I
am looking for ways to override the users SET option settings while
executing my function to prevent the permissions breach. For example, to
override SET search_path, I am setting search path in my function
to original
settings.
It would be really helpful if you could elaborate your response.
Thanks guys.
Jack
On Mon, Feb 22, 2010 at 8:05 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jignesh Shah wrote:
I have been writing a function with SECURITY DEFINER enabled.
Basically, I am looking
Jignesh Shah jignesh.shah1...@gmail.com:
Thanks a ton Laurenz and Pavel for your responses but I really didn't
follow
you. I am not master in PostGreSQL yet. Could you please give me some
example?
Basically, I want to know how many such SET options I should reset before
executing my
Hello All,
I have created role database-users and inserted some of users inside it.
Could you tell me which query to use for listing out those users name? I
went through pg_users, pg_group but no luck.
CREATE ROLE database-users
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
CREATE ROLE dbuser1
Exactly the same!
Thanks a ton.
On Fri, Feb 19, 2010 at 3:58 PM, Magnus Hagander mag...@hagander.netwrote:
2010/2/19 Jignesh Shah jignesh.shah1...@gmail.com:
Hello All,
I have created role database-users and inserted some of users inside
it. Could you tell me which query to use
Hi,
I know how to set the permissions for tables. Could anyone tell me how to
restrict people accessing and creating schemas? Also, is it possible to
restrict language permissions? Suppose I want only few users should use C
language and for rest of users it should be missing. How can I restrict
Hi,
Could any one please tell me what is statement ID of table? How to get it
and in which scenarios it can be helpful? Any documentation or example about
statement ID would also really helpful for me.
Thanks,
Jignesh
, A. Kretschmer
andreas.kretsch...@schollglas.com wrote:
In response to Jignesh Shah :
Hi,
Could any one please tell me what is statement ID of table?
There isn't such ID, but every table has an OID, an Object Identifier.
How to get it and
The (hidden) column oid of pg_class contains
21 matches
Mail list logo