12,760 reputation
12049
bio website
location Munich
age
visits member for 3 years, 7 months
seen 2 mins ago

May
21
reviewed Reject About creating a View With additional coumns (that are not in the table)
May
21
comment Analize Query in MySQL Server 5.1
I don't think MySQL exposes that value in the execution plan
May
21
revised Analize Query in MySQL Server 5.1
edited tags
May
21
revised Restricting Insert and Update to functions
added 765 characters in body
May
21
answered Restricting Insert and Update to functions
May
21
reviewed Approve Problem in Nested Query
May
21
revised Problem in Nested Query
added 22 characters in body
May
20
revised Best way to Design Key,value pairs in relational database?
deleted 5 characters in body
May
20
comment PostgreSQL replication with fsync disabled?
Turning off fsync does not mean WAL is not written, it's still written - just not in a reliable way.
May
20
revised Optimise complex query
edited tags
May
19
comment Postgres 9.3 64 Bit Windows 7 and 64 bit Postgres install - cleared password no longer connects
There is no such thing as a "server password" in Postgres. And Postgres doesn't need a password to start unless you mis-configured the Windows service that runs Postgres.
May
19
revised Postgres 9.3 64 Bit Windows 7 and 64 bit Postgres install - cleared password no longer connects
added 15 characters in body
May
19
comment Which is better MAX function or ORDER BY column_name DESC with LIMIT 1
What does the execution plan say?
May
19
comment Does MySQL guarantee atomic upgrade from read lock to write lock?
Why would a primary key "quadruple" the size of the table?
May
17
revised How to select the latest record of each hour in a day
edited tags
May
17
comment SQL query to find all parent records where all child records have a given value (not just some)
The syntax of the statement you have show is invalid for Postgres (dreaded backticks, invalid use of group by). That looks more like you are working with MySQL
May
17
comment Set up Firebird with shared storage?
One database can only be accessed by a single database server. SuperClassic, SuperServer is irrelevant here as it only defines how the server process internally works. Databases should never be stored on a shared filesystem.
May
17
comment Set up Firebird with shared storage?
@WorajedtS: using a single shared storage for multiple database instances is certainly not possible in Postgres (and I don't think it's possible in Firebird either) so I don't understand what exactly you want to do. Of course you can store the database files on a SAN (although it's probably not a good idea) but that can still be accessed only by a single server process.
May
17
revised SQL query to find all parent records where all child records have a given value (not just some)
Use link to "current" version of the manual
May
17
awarded  Yearling