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

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
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
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
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
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
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.
Feb
9
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.
Feb
8
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?
Feb
8
comment dummyuser creating users
Which (R)DBMS system are you on?
Feb
8
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.
Feb
8
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
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
comment Index has no gain vs normal query
Please post the EXPLAIN (ANALYZE, BUFFERS) output, both without the index and with it. EXPLAIN only shows the planner estimates, which might be very different from reality.
Feb
4
comment Schema Design for multiple many-to-one relationships. of which exactly one should exist
Why nullable columns and multiple FKs are a problem? And how many B-like tables you expect to have in the long run?