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

Jul
23
comment insert or update on table “ aaa” violates foreign key constraint
Please add the create table statements for both tables and the insert statements for the server table and the statement that generates the error. I'm almost 100% certain that Postgres is right and you are simply missing something obvious. I have never seen a Postgres be wrong with these error messages.
Jul
22
comment Oracle instant client
The JDBC driver does not need any installation at all. And it also does not need an Oracle client. All you need to do is to copy the driver's jar file to the client where the Java program is running.
Jul
22
comment PostgreSQL - what do tms and mt mean in a SELECT query?
For future reference: the relevant chapter in the manual is in "Chapter 7 - Queries". In there it's in the section "Select lists/Column labels": postgresql.org/docs/current/static/…
Jul
21
comment Oracle ODBC Driver, Tables and Columns Remarks
I don't know about ODBC, but the JDBC driver needs to be explicitly told to return column remarks (using a connection property named remarksReporting)
Jul
21
comment PostgreSQL visibility of records changes from other transaction inside the current one
What you are seeing is the result of the "READ COMMITTED" isolation level. It seems that you want the isolation level REPEATABLE READ (or even SERIALIZABLE)
Jul
21
comment How to name a new table storing location at which transaction occurred
I just wanted to point out that for some DBMS (especially those that follow the SQL standard) FooBar will be stored as FOOBAR and thus the camel casing doesn't really make sense because it's lost
Jul
20
comment How to name a new table storing location at which transaction occurred
"Pascal casing" is not such a good idea FooBar and FOOBAR are the same names in (standard) SQL. snake_case should be preferred.
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?