Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 23 48
Impact
~454k people reached

Jul
27
comment Reg: Default Privileges on PostgreSQL Schemas
I cannot tell for sure without seeing which role is a member of which other role. If dev1, dev2 and devN are all a member of table_creator, and the default privileges are set for table_creator and the tables are all created as table_creator, you'll get the desired effect.
Jul
27
comment Is it reasonable to mark all columns but one as primary key?
@rubik I wouldn't expect much overhead from uniqueness enforcement unless you modify your data very often. This is not what one expects with movies.
Jul
27
comment Is it reasonable to mark all columns but one as primary key?
Could you illustrate your point with a small example?
Jul
27
comment Very slow DELETE in PostgreSQL, workaround?
@Matthieu you mean disabling the trigger? No, that is completely unrelated to indexes. One has to be careful with constraints, though.
Jul
22
comment How to log custom messages from inside a PostgreSQL transaction?
That array construction is unnecessary complicated, why not simply use a ARRAY[my_dblink_name]?
Jul
22
comment Setting shared_buffers over 320 MB prevents Postgres from restarting
Yeah, @CraigRinger is right - that system is so old it already has grandchildren... Other than that, do you get an error message of some sort?
Jul
21
comment How to log custom messages from inside a PostgreSQL transaction?
This is in an interesting contrast to what I saw while using psql interactively: dba.stackexchange.com/a/23618/6219
Jul
21
comment Can I use OpenLDAP to authenticate users in Oracle?
@FredPetillot and when that page moves somewhere else or just stops being there, your answer will contain zero bits of information.
Jul
21
comment What is the best way to take backup for Remote DB Server
Please define what you exactly mean by backup here. Depending on the RDBMS, there might be several options, some are not doable via JDBC.
Jul
21
comment DB design for employee working hours constraints
These decisions are usually a function of how much data (eg how many employees) you have, how (often) you access this data, how fast the response should be and so on. Building the availability table shouldn't be that difficult - why not try it yourself?
Jul
20
comment RMAN error RMAN-06207,RMAN-06208,RMAN-06210,RMAN-06211,RMAN-06212,RMAN-06213,RMAN-06214
The OP clearly tells us they tried this already.
Jul
17
comment How would I make this query run faster in postgres
I'm voting to close this question as off-topic because it is crossposted and has an answer on SO
Jul
17
comment Group and order output into a single row
Look into the several questions tagged as pivot on this site.
Jul
17
comment Group and order output into a single row
How about the other commissions that may lie around?
Jul
17
comment How to suppress specific warnings in mysql error log when ignoring a table to replicate
You should add some flesh to your answer - like what you've stated in your comment.
Jul
17
comment MYSQL: Creating a table with same columns on remote machine
Why you don't simply connect to the remote DB from the local machine?
Jul
16
comment Grouping by sequential relationships with Postgres
@a_horse_with_no_name one can simply pick any node and find it's group, right?
Jul
16
comment Grouping by sequential relationships with Postgres
How do you find if a and b are related (member of the same group)? Alternatively, why is there a split between d and e?
Jul
16
comment Finding optimal indices, different query competing indices
I know it is no answer, but how do you squeeze 600 or 700 characters into a varchar(512)?
Jul
16
comment Having problems trying to back up a Postgres database from AWS RDS
Do you see this every time you start the dump?