11,197 reputation
11843
bio website
location Munich
age
visits member for 3 years, 2 months
seen 39 mins ago

8h
comment Can a connection's prepared statements be altered by Postgres's admin functionality?
@CraigRinger but you would need to manipulate the memory of the process that uses the prepared statement. Not something you can do from SQL and probably very hard to do "from the outside"
8h
comment Can a connection's prepared statements be altered by Postgres's admin functionality?
No, I don't think that is possible.
10h
comment sqlplus: ORA-01017 logon denied from one host but OK from another
Does ping host1 reveal the same IP address on both hosts?
10h
comment Gap in autoincrement column when using “insert into … union …”
Again: this does not matter.
10h
comment Gap in autoincrement column when using “insert into … union …”
So what? The value of a (generated) primary key is completely meaningless and therefor gaps in those values are completely meaningless. "Please advise to remove this gap." - nothing to advise because there is nothing you need to do.
10h
comment Postgres Order By
"SELECT DISTINCT, ORDER BY expressions must appear in select list" means that the expression (= the column) on which you want to sort has to appear in the select list. It does not mean you need to put the order by operator into the select list.
14h
comment Give every user 3 default 'bookmark' entries
"Is inserting 3 records for all users a design flaw?" - I wouldn't see that as a design flaw. Btw: which DBMS are you using?
15h
comment Why does dropping a MVIEW trigger a full refresh?
@Raj: thanks, after doing some more tests, I came up with the came conclusion.
16h
comment Files - in the database or not?
You might be interested in this: research.microsoft.com/apps/pubs/default.aspx?id=64525 a research by Microsoft that shows that storing blobs in the database is actually faster than in the file system (for some sizes of blobs at least). This is in line with my tests that showed that for medium sized blobs (< ~1MB) e.g. Postgres is also faster than a filesystem. For Oracle it's about the same performance but I haven't tested the new securefile storage format yet (but they claim it's faster than the old storage format)
1d
comment How to create an oracle dump(.dmp) file using Toad?
You can use dbms_datapump from any SQL client
1d
comment Connect to Postgresql 9.2 from Eclipse Data Tools Platform
What's unclear about "database "database" does not exist"
1d
comment Why does dropping a MVIEW trigger a full refresh?
@PaulWhite: hmm, I cannot log in on meta (clicking on "Log in" simply does nothing) and when I click on "Ask Question" (without logging in) I get an error message (in the browser) that the website redirects my request so that it can never be finished.
1d
comment Does READ UNCOMMITTED have the same effect as AUTOCOMMIT=1?
Which DBMS are you using? Not all actually support "read uncommitted"
2d
comment Formal name for functions that use the OVER clause
@JackDouglas: "window functions" is what the SQL standard uses.
2d
comment Checking whether two tables have identical content in PostgreSQL
This will not detect the case when EmpDtl2 has less rows than EmpDtl1 and all existing rows do exist in EmpDtl1.
Jul
29
comment Index that is not used, yet influences query
Does the output of the plan change if you enable the verbose mode using: explain (analyze true, verbose true) ...?
Jul
29
comment PL/pgSQL function or rCTE to detect depth of relations between two tables
You might want to take a step back, post the structures of the tables involved and the actual problem that you want to solve. Maybe there is a way to do that efficiently with a single SQL statement
Jul
29
comment PL/pgSQL function or rCTE to detect depth of relations between two tables
You are mixing explicit joins and implicit joins in the recursive part of your CTE: FROM ebenen, buchstelle bst JOIN ... Don't do that. That creates a cartesian product between ebenen and buchstelle. I'm pretty sure that's not what you intended
Jul
29
comment PL/pgSQL function or rCTE to detect depth of relations between two tables
Did you try a recursive CTE?
Jul
27
comment MySQL CHAR(500)?
Again: did you do any testing that confirms your assumption? I would very much doubt that you'd be able to measure a difference.