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

Jul
1
comment which role-permission database design?
In this form nothing will prevent you having an action of 'nunvbfb n! vnjkvfk@' for the section 'jiojh nfuhn y748jkl tj'. Or anything else. You should at least create a table for sections and an other for actions. (In the structure you mentioned first, a permission would be a section-action pair in your terminology, I think. Then it is coupled to the given roles.)
Jun
28
comment Maintain stable data in a database
Can you turn off autocommit? When committed, you can't roll back anymore.
Jun
28
comment Need help to design model with multiple rights
It is good that you answered your own question. You could as well accept it :)
Jun
28
comment Maintain stable data in a database
Normally benchmarking is done with rolling back all changes after the run is finished, that is, the last statement of the test script is ROLLBACK;. Of course, you have to write BEGIN; as the very first one.
Jun
27
comment how to count primary key of one table inanother table?
And what php has to do with this question?
Jun
26
comment How can I speed up PgAdmin III Queries?
Have you tried to compare the time needed with that of psql? I think this difference is a result of displaying the results, over which the user has no real influence...
Jun
26
comment Convert units of measurement
I remember an at least two level recursive CTE. I think I first calculated the sums with the smallest unit which turned up in the list for the given substance then converted it to the biggest unit still having non-zero integer part.
Jun
26
comment Convert units of measurement
@mustaccio I had the exact same problem at my previous place, on a very production system. There we had to calculate the amounts used in a food delivery kitchen.
Jun
24
comment How to enable SSL in MySQL on Windows?
OK, let's see once more. What do you try (which commands do you issue)? What do you get (error messages, output etc.) We don't have the crystal ball delivered yet (shameless plagiarism here!)
Jun
24
comment Secure the jdbc and remote MySQL(windows) server connection
And what is the difference between the two?
Jun
24
comment How to enable SSL in MySQL on Windows?
'it's not working' is not an error message (or error description) of any sort. Could you be a bit more specific please? Probably adding the relevant configuration values and how do you try to connect would help a lot.
Jun
21
comment Dynamic Oracle Pivot_In_Clause
That must be some client strangness. Try to fiddle around with its preferences.
Jun
21
comment What are safe characters to use in SQL Server Full Text Search?
I think you want to add some queries you've tried. Without them your question is somewhat cryptic. (You can edit your own posts anytime.)
Jun
21
comment Can a database detect that data is out of sequence if each datapoint has a sequential ID
Why not simply check this before insertion? It will be a relatively simple query, I guess. But you won't find a builtin solution for this.
Jun
21
comment Can a database detect that data is out of sequence if each datapoint has a sequential ID
There are at least one country in the world where the invoice numbers issued by a company must be contiguous (and in order). Which does not make sense, I admit.
Jun
21
comment General tool to load dump files
Now how does this answer the question? Oracle/SQL Server dumps into PostgreSQL, that was it.
Jun
20
comment How do I find my current SCN?
I don't know how the old answers missed the soft limit (which is mentioned in the article linked by Nick) - so it is a good idea for adding the missing detail.
Jun
20
comment Issues starting Postgres server
How did you installed the DB server?
Jun
19
comment Which is better: more rows or more columns in a student attendance table?
As a starter: if you expect people to spend time with your problem, please try to spend time on phrasing it properly. Check my edit: 'stud' is an English word but have you checked its meaning, for example? Similarly, since characters are cheap nowadays, you had better naming your columns without shortened forms - they only will disturb you or somebody else at a later point.
Jun
19
comment Trying to find the last time that a value has changed
Adding a point to Martin's comment: you are on the safe side if you ever post tested code only. An easy way can be going to sqlfiddle.com if you are away from your usual playground.