6,040 reputation
31331
bio website
location Berlin, Germany
age 38
visits member for 2 years, 2 months
seen 6 hours ago

Dec
16
comment database timestamp
Timestamp in which RDBMS? And please remove the   strings from your question. You can format your table as code (with the {} button above), so you will have a fixed with font and easy table formatting. If you need help in this, please tell.
Dec
16
comment What program should I use to open .db3 files?
Is it much different from SQLite Editor the OP mentioned?
Dec
15
comment Optimal way to ignore duplicate inserts?
I think not trying to insert duplicates at all is the best solution to your problem. Check for existence of the given key value like INSERT ... SELECT /* not VALUES! */ ... WHERE ...
Dec
15
comment Issues with a Table having 120 fields in mysql
Just out of curiosity: what sort of data do you plan to store in this table?
Dec
15
comment How to aggregate datapoints in a table?
What RDBMS do you use? The specifics depend on it. And what should be the ordering?
Dec
12
comment How to split a string to and get info from another table in mysql
Oh, my bad, somehow I thought this is for SQL Server. My problem (not very serious though :) is that those UNIONs are ugly and repeated three times.
Dec
12
comment How to split a string to and get info from another table in mysql
Isn't there a better way to set up numer table? A CTE if nothing else helps, for exapmle?
Dec
11
comment Which MySQL storage engine is the most similar to ARCHIVE when that is not available?
Just out of curiosity: what do you want to use this for?
Dec
11
comment Foreign key of multiple tables
Life is risky...
Dec
11
comment PgAdmin III - How to connect to database when password is empty?
Let's add that the original question was about a Windows system.
Dec
11
comment Can't connect to a PG database from MicroOLAP, but can connect from SSH?
You shouldn't accept an answer which does not solve your problem. Instead, when you discover the real solution, post it as an answeer yourself and accept it.
Dec
10
comment Can't connect to a PG database from MicroOLAP, but can connect from SSH?
Any improvement on this?
Dec
10
comment pg_dump freezes on windows service application
If you make an answer with the necessary information extracted from that post, you will earn at least 1 upvote :)
Dec
10
comment pg_dump freezes on windows service application
One thing I can think of is running from the application it does not see a variable that is present in the shell.
Dec
10
comment Foreign key of multiple tables
Normally there is no foreign_key column in a table. Instead, you can add two separate columns with the names company_id and contact_id and store the respective ids in those.
Dec
10
comment pg_dump freezes on windows service application
How do you call pg_dump.exe? The parameters passed to it and possibly the caller environment would be interesting. From what you described so far, it can be anything (waiting for password is a usual suspect).
Dec
10
comment Use data in a tablespace to populate another postgres database instance without actually inserting
Manually updating system tables is thought to be very bad idea. With a bit of luck you can corrupt your database beyond repair.
Dec
9
comment Inherit audit columns and triggers
You can do ALTER TABLE my_table INHERIT audit. Furthermore, in a DELETE trigger you don't have NEW, update the affected row instead with the timestamp and RETURN NULL.
Dec
7
comment How do I set and get custom database variables?
You have to first define the variables in postgresql.conf. AFAIK this requires restarting PostgreSQL, so you can't do that from SQL.
Dec
7
comment Can't connect to a PG database from MicroOLAP, but can connect from SSH?
on @ypercube's comment: leave SSH tunneling as it is now and try to set localhost as host instead of arka.foi.hr.