13,065 reputation
12151
bio website
location Munich, Bavaria
age
visits member for 3 years, 8 months
seen 1 min ago

Jan
3
comment Writing Conditions in Left join sql
A where clause on the "right" table effectively turns the outer join into an inner join.
Jan
2
comment Having troubles creating table SQL
You should really stay away from quoted identifiers. In the long run they are much more trouble than they are worth it.
Jan
2
comment Unexpectively slow data loading into Oracle
Don't commit after each row. That is going to be terribly slow. 4 million rows should work just fine in a single transaction. Why aren't you using sqlldr? There is nothing faster when it comes to bulk loading. And why are you using such an outdated Oracle version?
Jan
1
comment Trying to copy a schema using impdp
Does this help: arjudba.blogspot.de/2011/03/… and moreajays.com/2013/03/…
Jan
1
comment unable to insert row at id, but row does not exist
Please show us the create table statement for the product_product table.
Dec
31
comment Postgres Enable TCP/IP Connection
There is probably a networking issue between your laptop and the server. Can you connect to Postgres when you run psql on the centos server?
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
Oracle (the database) will never create a name like "Relationship143" on its own. It was probably one of your tools that did this. Anyway: as it stands, your answer is simply wrong in the context of the original question.
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
See here for an example: sqlfiddle.com/#!4/27ee6/1
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
The you created the constraints using double quotes, e.g: alter table ... add constraint "Relationship143" ... "Relationship143" is indeed a different name than RELATIONSHIP143. But "RELATIONSHIP143" and RELATIONSHIP143 are identical
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
A quoted identifier where all characters are upper case is identical to the same name without quotes (because Oracle stores all un-quoted identifiers in upper case).
Dec
24
comment Cannot drop nonexistent constraint and cannot create it either
No it will not work. Your statement is exactly the same statement the first statement in the question: ALTER TABLE A_DUP_CALLE DROP CONSTRAINT A_DUP_CALLE_UK1;
Dec
23
comment Which replication technique to use?
That pretty much only leaves Bucardo as your only choice (or BDR but that is still in beta if I'm not mistaken) wiki.postgresql.org/wiki/…
Dec
23
comment Unable to connect to Oracle from SQL Developer
Can you post the JDBC URL that SQL Developer is using? This could also be a firewall issue.
Dec
23
comment Unable to connect to Oracle from SQL Developer
@AhmadAbuhasna: the tnsnames.ora is not used by SQL Developer as it uses the JDBC thin driver (at least by default).
Dec
22
comment How to Select the First (or last) entry for a specific day
Regarding window functions: there is a tutorial in the manual:: postgresql.org/docs/current/static/tutorial-window.html identifiers are case-insensitive in SQL. So AttendanceREcords is the same name as AttendanceRecords or attendancerecords. The SQL standard requires all (unquoted) identifiers to be stored in UPPERCASE. Postgres chose to store them all in lowercase.
Dec
21
comment How to create a temporary table using VALUES in PostgreSQL
from the docs: "CREATE TABLE AS is functionally similar to SELECT INTO. CREATE TABLE AS is the recommended syntax"
Dec
21
comment Possible to get log file with only statements sent to Postgres from my app (and not from psql prompt)?
If you specify an application name when you connect, you can add that application name to the log entry.
Dec
21
comment How to create a temporary table using VALUES in PostgreSQL
select .. into to create a new table is an old non-standard way of doing this and is only supported for backward compatibility. Using the standard compliant create table as should be preferred.
Dec
21
comment Are CTEs multithreaded?
Postgres does not run any statement multithreaded. That includes CTEs The "concurrently" is probably only there to indicated that there is no inherent order how they are processed
Dec
20
comment Table-based custom type does not verify check constraints
Why not simply use a plain foreign key instead of defining a table as the attribute of another table (I didn't even know this was possible).