Reputation
11,863
Next tag badge:
733/1000 score
223/200 answers
Badges
7 32 55
Newest
 Revival
Impact
~593k people reached

1m
answered Unexpected table created by running store procedure with integer OUT parameter
1h
comment Get rows from last insert statement by specific user
Are those users PostgreSQL roles, or stored in a self-defined user table?
1h
comment Getting the next bigserial value in PostgreSQL
nextval() works in the scenario you describe.
12h
comment How to view full blocking postgres queries?
How does this solve the truncation issue?
12h
comment Reject Specific Database PostgreSQL User Authentication
So A and B are OS users? What do you mean by 'configuring that file creates tons of security issues'? Are you sure that the .pgpass files are owned by the respective owners (how does this solve your issue anyway? -W will override a wrong stored PW) and the permissions are 0600, at most?
17h
revised Do Postgres GIN indexes need to be rebuilt periodically?
deleted 7 characters in body
17h
revised Do Postgres GIN indexes need to be rebuilt periodically?
added 2 characters in body
18h
comment search pgadmin for column
It would possibly easier for you to figure this out from the source you have - some sort of mapping must be there.
19h
comment What's the difference between group roles and login roles?
It must be some design issue/bug - I was wondering myself. Such issues are the reasons why I am exclusively using psql and normal SQL statements for everything.
22h
revised Best way to transfer millions of rows from one database to other
deleted 47 characters in body; edited tags; edited title
1d
comment How to create unique index for both cases
You should ask database questions in a database language :) Why would you create two tables for the same sort of data? Or you mean rows there? Finally, does your requirement mean that if there is a message (or whatever you store there) from A to B, B cannot answer to A?
1d
comment dummyuser creating users
Which (R)DBMS system are you on?
1d
comment Why can I drop table when logged in as not owner?
Please show the output from \dt+ droppable_table and \du non_postgres_user, issued from psql.
1d
answered What's the difference between group roles and login roles?
1d
comment Why default db privilleges are not applied on a new schema?
Please connect to your DB using psql and show the output of \ddp, as well as \dp problematic_table
2d
revised PostgreSQL - is it possible to use a plpgsql function in a bash script?
added 84 characters in body
Feb
6
comment pgAdmin is extremely slow on any remote operation
Does it always hang?
Feb
6
comment How to verify disk hit by a query
How do you distinguish between the blocks read from disk or from the OS cache?
Feb
5
awarded  Revival
Feb
5
revised PostgreSQL - is it possible to use a plpgsql function in a bash script?
added 105 characters in body