[GENERAL] Setting configuration parameter to role and propagating it to users

2011-02-04 Thread asia123321
Hi, I have following issue: I have several users with one role (and may have new users with the same role in the future so the role creation is justified). So I created: ALTER ROLE MY_ROLE SET search_path='my_schema'; But after doing it my_user (either existing or newly created) still cannot see

Re: [GENERAL] Update existing system explicit cast to make it implicit

2011-01-31 Thread asia123321
"Tom Lane" napisał(a): > asia123...@op.pl writes: > > I am trying to use bit(1) datatype with existing application that used int > > datatype before. > > So I tried to create implicit cast that will allow me not to make code > > modifications and wanted to create implicit cast "int2bit", but it

Re: [GENERAL] Update existing system explicit cast to make it implicit

2011-01-31 Thread asia123321
"Tom Lane" napisał(a): > asia123...@op.pl writes: > > I am trying to use bit(1) datatype with existing application that used int > > datatype before. > > So I tried to create implicit cast that will allow me not to make code > > modifications and wanted to create implicit cast "int2bit", b

[GENERAL] Update existing system explicit cast to make it implicit

2011-01-31 Thread asia123321
Hi, I am trying to use bit(1) datatype with existing application that used int datatype before. So I tried to create implicit cast that will allow me not to make code modifications and wanted to create implicit cast "int2bit", but it turned out that there is already system cast. Unfortunately t