Reputation
Next tag badge:
733/1000 score
223/200 answers
Badges
7 32 56
Newest
 Synonymizer
Impact
~596k people reached

18h
awarded  Synonymizer
1d
comment Source of error on psql data load
Is there only data in the dump or the tables thenselves, too? Could you show the relevant pieces belonging to either of those two tables?
1d
comment Source of error on psql data load
If the dump is ordered alphabetically, then the error is expected. By consistently, do you mean you always have the same data but the behaviour is different?
1d
revised Source of error on psql data load
deleted 1 character in body; edited tags
1d
revised Reset default value for many foreign keys in SQL Server
edited tags
1d
revised RDS crosstab: ERROR: permission denied for language c
added 40 characters in body
1d
comment pg_dump FATAL error - PostgreSQL 9.2
Your client seems to be unaware of that it's doing something - I guess the connection times out after a period of inactivity.
2d
comment Reject Specific Database PostgreSQL User Authentication
@NeilMcGuigan thanks for pointing it out - I've updated my answer.
2d
revised Reject Specific Database PostgreSQL User Authentication
added 577 characters in body
2d
comment Reject Specific Database PostgreSQL User Authentication
@Everlight so you want to prevent an OS user from logging into the DB completely? It sounds like you want to jail him - but then it's not a database administration issue.
Feb
10
answered Reject Specific Database PostgreSQL User Authentication
Feb
10
comment Importing CSV into multiple tables using PostgreSQL
@NeilMcGuigan Are you interested in posting an answer?
Feb
10
comment Importing CSV into multiple tables using PostgreSQL
And this is what the OP used to use, until they started having two tables...
Feb
10
revised Getting the next bigserial value in PostgreSQL
added 456 characters in body
Feb
10
comment Get rows from last insert statement by specific user
Are those users PostgreSQL roles, or stored in a self-defined user table?
Feb
9
comment How to view full blocking postgres queries?
How does this solve the truncation issue?
Feb
9
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?
Feb
9
revised Do Postgres GIN indexes need to be rebuilt periodically?
deleted 7 characters in body
Feb
9
revised Do Postgres GIN indexes need to be rebuilt periodically?
added 2 characters in body
Feb
9
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.