Dear Sirs,
Apologizes, if this is a duplicate question.
Would like to request you to share your valuable inputs on this. I would
like to know the PostgreSQL registry entries when we install it through
apt-get/yum/rpm. I mean, when we install the EnterpriseDB PostgreSQL one
click installer, it
On Mon, Apr 15, 2013 at 01:21:55PM +0530, dinesh kumar wrote:
Would like to request you to share your valuable inputs on this. I would
like to know the PostgreSQL registry entries when we install it through
apt-get/yum/rpm. I mean, when we install the EnterpriseDB PostgreSQL one
click
Yuriy Rusinov wrote:
I have to put some C-language functions onto postgresql server 9.2. These
functions are used GSL
software library http://www.gnu.org/software/gsl/. In Makefile for these
functions I wrote LD_FLAGS =
... -lgsl, On some source-based Linux distributions such as gentoo
I can't understand what is going on with my PostgreSQL server. For
some reason after I GRANT my role 'carlos' to the 'dba' group role, I
lose the ability to login. I've reset the password over and over for
'carlos' and even reversing the grant doesn't remedy the
authentication failure. The logs
I found error in my DB - sequence for column id had value less SELECT
max ( id ) FROM table0 (sequence throwed unique violation exception
too). I set valid value for sequence and issue was resolved.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Mon, Apr 15, 2013 at 7:30 AM, Carlos Mennens carlos.menn...@gmail.comwrote:
I can't understand what is going on with my PostgreSQL server. For
some reason after I GRANT my role 'carlos' to the 'dba' group role, I
lose the ability to login. I've reset the password over and over for
'carlos'
I'm doing this all in psql.
Example:
CREATE ROLE carlos LOGIN CREATEDB CREATE ROLE REPLICATION;
Then set password \password carlos
Now I create the ROLE:
CREATE ROLE dba NOLOGIN;
So now I have two roles:
-carlos = user role
-dba = group role
I can login just fine as 'carlos' now with no
On 04/15/2013 09:10 AM, Carlos Mennens wrote:
I'm doing this all in psql.
Example:
CREATE ROLE carlos LOGIN CREATEDB CREATE ROLE REPLICATION;
I going to assume you actually did:
CREATE ROLE carlos LOGIN CREATEDB CREATEROLE REPLICATION;
otherwise it would fail on the second CREATE ROLE.
Adrian Klaver adrian.kla...@gmail.com writes:
On 04/15/2013 09:10 AM, Carlos Mennens wrote:
That's the end of 'carlos' being able to login. What am I doing wrong?
Unfortunately I do not have a 9.1.x instance handy. I tried the above on
9.0.x and everything worked.
Works for me on 9.1.9,
Hi,
is there a way to clear the session state of sequence values fetched by
currval(regclass)? DISCARD ALL doesn't seem to do it.
eg. (w/ pg 9.2.4)
test=# CREATE SEQUENCE foo_seq;
CREATE SEQUENCE
test=# SELECT nextval('foo_seq');
-[ RECORD 1 ]
nextval | 1
test=# SELECT currval('foo_seq');
-[
On 04/15/2013 02:42 PM, Nigel Heron wrote:
Hi,
is there a way to clear the session state of sequence values fetched by
currval(regclass)? DISCARD ALL doesn't seem to do it.
eg. (w/ pg 9.2.4)
test=# CREATE SEQUENCE foo_seq;
CREATE SEQUENCE
test=# SELECT nextval('foo_seq');
-[ RECORD 1 ]
nextval
I dropped both roles (Carlos DBA) from the database and I will show
you exactly what I'm doing:
postgres=# \du
List of roles
Role name | Attributes | Member of
On 04/15/2013 07:29 PM, Carlos Mennens wrote:
I dropped both roles (Carlos DBA) from the database and I will show
you exactly what I'm doing:
postgres=# \du
List of roles
Role name | Attributes | Member of
On Tue, Apr 9, 2013 at 3:05 AM, Eduardo Morras
emorr...@yahoo.esjavascript:_e({}, 'cvml', 'emorr...@yahoo.es');
wrote:
On Mon, 8 Apr 2013 10:40:16 -0500
Shaun Thomas stho...@optionshouse.com javascript:_e({}, 'cvml',
'stho...@optionshouse.com'); wrote:
Anyone else?
If his db has low
14 matches
Mail list logo