Reputation
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 29 58
Newest
 Caucus
Impact
~984k people reached

Jul
20
comment Limiting read access in postgres to few rows
This will be possible with the upcoming 9.5 through "row level security": postgresql.org/docs/9.5/static/sql-createpolicy.html
Jul
20
comment Using an UPDATE trigger to populate Eastings and Northings in PostgreSQL
Yes, that's possible - but you need to provide more details. At least the create table statement for your table.
Jul
20
comment How to full text search worked with special character like “of”?
Added sql-server tag based on the usage of [..]
Jul
17
comment Sending a database dump
@Vérace: because the real problem is to send a large amount of sensitive data to someone. The fact that this is a database dump is not relevant for this question and thus it has nothing to do database administration. The problem would be the same if the data was a 1.5 GB list of credit card numbers or other personal information.
Jul
17
comment why update a table take so long on oracle
I wonder why the redo size for the NOT IN solution is so much bigger than for the not exists solution.
Jul
17
comment why update a table take so long on oracle
Which Oracle version were you using for that test?
Jul
17
comment DBA responsibilities: should they include suggesting a database engine for a new project?
I personally can't see any reason to choose MySQL instead of Postgres. Postgres has more features, is more reliable and has much more development momentum than MySQL.
Jul
17
comment Sending a database dump
Which DBMS are you using? (And this question doesn't really have to do anything with database administration)
Jul
17
comment how to get tag record with its descriptor from pi database?
Which DBMS are you using?
Jul
16
comment IF EXIST before many insertions in PostgreSQL?
Just run the insert and handle the error in your program.
Jul
16
comment Grouping by sequential relationships with Postgres
@deszo: no I don't think so because there are self referencing nodes (=loops) in the data. There is e.g. a row with name=b and related=b
Jul
16
comment Grouping by sequential relationships with Postgres
If you can't determine the start of the graph even without SQL, there is no way this can be done with SQL.
Jul
16
comment Grouping by sequential relationships with Postgres
And how do you know what the starting node of the graph is?
Jul
15
comment How to make postgresql SUM to be more accurate on large amount of floating point data?
floating-point-gui.de
Jul
15
comment PostgreSQL window functions very slow on big table
wiki.postgresql.org/wiki/Slow_Query_Questions
Jul
14
comment Why is my PostgreSQL ORDER BY case-insensitive?
Unfortunately Postgres uses the collation implementation from the OS which makes this kind of behaviour OS dependent (which I personally consider a bug - a DBMS should behave identical regardless of the OS). So this boils down to differences in the system libraries between Debian and OSX
Jul
14
comment SELECT in trigger function in two tables
You are passing a string constant SELECT ... to the trigger function, not the result of a SELECT statement. You need to move that select into the trigger function, you can't dynamically pass parameters like that.
Jul
14
comment SELECT in trigger function in two tables
Show us the definition of the ins_function()
Jul
14
comment Metaphone / Soundex Dictionary
Which DBMS are you using? Postgres? Oracle?
Jul
13
comment Efficient structure for querying membership in many-to-many relationship where tableA has ONLY the indicated members from tableB?
Please show us the create table statement for the tags table.