Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 42
Newest
 Revival
Impact
~346k people reached

Mar
11
comment Centos 7, Postgresql Failed to Read Permission Data Directory in mounted Partition
You are missing some permissions. postgres must have rwx access down to the data/ directory, I mean on all direrctories up to /run/.
Mar
11
revised Centos 7, Postgresql Failed to Read Permission Data Directory in mounted Partition
added 87 characters in body
Mar
10
revised COMMIT after EXPLAIN ANALYZE of a read-only query
added 575 characters in body
Mar
10
answered COMMIT after EXPLAIN ANALYZE of a read-only query
Mar
6
comment Create/copy new superuser from an existing one
The thing is that if super1 has some user-specific settings, those are not inherited this way.
Mar
6
revised Create/copy new superuser from an existing one
added 11 characters in body; edited title
Mar
6
answered Get table name by foreign key
Mar
6
comment Get table name by foreign key
Got to psql, issue \d your_table and look up the referenced table's name. If you set \set ECHO_HIDDEN on beforehand, you'll get a bunch of queries that produce the output, those you can reuse in your own discovery script.
Mar
6
revised Pgpool II : unable to read message length between two network interfaces
added 9 characters in body
Mar
6
comment query to find all dblink()
@ErwinBrandstetter yes, that was clear, but what I saw was that even SQL functions don't observe the dependency on the dblink extension's functions...
Mar
5
comment Table with both primary key and unique key
Not sure what that person means about SQL Server, but in PostgreSQL there is no such thing. Apart from this, +1 for @a_horse_with_no_name
Mar
5
comment Storing historical data in DB vs on disk
What are your typical retrieval queries?
Mar
4
comment How can I tell which client process owns a particular Unix domain socket connection?
Do you know what are the suspects? Or who runs all those local processes/applications that open connections to Postgres? And, I guess, there is no such thing something 'owns' a connection. Even more, in the future you may want to set the application_name in the connection strings, so you can identify the culprit easier.
Mar
3
comment Using psql with string variable that has two periods
Why do you use varchar(255)? Why not varchar(256), or, even better, unlimited varchar ortext?
Mar
3
revised Using psql with string variable that has two periods
added 72 characters in body; edited title
Mar
3
reviewed Close SQL error: Unknown column in 'where clause'
Mar
3
comment SQL error: Unknown column in 'where clause'
Also, you should read the opening warning at php.net/manual/en/function.mysql-query.php
Mar
3
reviewed Close wild card for entry id mysql
Mar
3
comment Random unguessable primary key which preserves correct order
Why do you have the requirement of being orderable? To me it seems that you want to combine too much into the PK. For identifying a given row, a UUID is more than enough, for ordering one usually uses a creation timestamp or something else that has real meaning.
Mar
3
comment PostgreSQL operator uses index but underlying function does not
@ErwinBrandstetter interesting. I can confirm it trying the same with some other operators and their implementing functions, too.