Trigger should be the last solution. This used to be working but I think
with latest postgresql upgrade, this stopped working. Might be someone
around here knows whats going on here.
Thanks,
Jignesh
On Fri, May 28, 2010 at 11:00 PM, Craig Ringer
wrote:
> On 29/05/2010 1:20 AM, Jignesh S
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
DEFAUL
:) I realized that. Thanks.
On Thu, Apr 22, 2010 at 6:53 PM, Greg Sabino Mullane wrote:
>
> -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 to prepare
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 p
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 wrote:
> Thanks Anrea
| txtime
++
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 wrote:
>
&g
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 wrote:
> Hi,
>
> I ran below command to list out all privileges of objects if "mydb" schema.
> Actually, I want to know what are
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
Thanks :) I am going crazy at times.
On Wed, Feb 24, 2010 at 12:04 PM, Frank Heikens wrote:
> 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 geschreve
OWNER TO user1;
ERROR: unrecognized configuration parameter "owner"
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 cou
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
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=#
T
>> set work_mem to '1MB'
>> set search_path = 'public';
Thanks for the example Pavel. I understood it. Are there any other SET
options except above that I need to set to prevent security breach?
Thanks,
Jack
On Mon, Feb 22, 2010 at 11:41 PM, Pavel Stehule
ed 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 wrote:
> Jignesh Shah wrote:
> > I have been writing a function with SECURITY DEFINER enabled.
> > Basically, I am looking for
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 bef
Exactly the same!
Thanks a ton.
On Fri, Feb 19, 2010 at 3:58 PM, Magnus Hagander wrote:
> 2010/2/19 Jignesh Shah :
> > Hello All,
> >
> > I have created role "database-users" and inserted some of users inside
> it. Could you tell me which query to use for list
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 "dbuse
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
pe
06 PM, 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.
>
>
>
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
21 matches
Mail list logo
