Reputation
14,635
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 28 54
Newest
 Yearling
Impact
~866k people reached

Nov
1
comment Postgresql 9.3: Add Unique constraint using an existing unique index
@AdamMatan: yes the ALTER TABLE needs an exclusive lock (although for only a short time). If you have uncommitted transactions, then those will block this. Check for sessions that have the state "idle in transaction" in pg_stat_activity
Oct
31
awarded  Notable Question
Oct
31
answered Postgresql 9.3: Add Unique constraint using an existing unique index
Oct
31
comment PostgreSQL buffer page size limitations - rebuild with larger size?
postgresql.1045698.n5.nabble.com/…
Oct
31
comment PostgreSQL buffer page size limitations - rebuild with larger size?
"This seems awfully small during the terabyte era" there have been numerous discussion about the block size. For regular DBMS this is a pretty good choice. Oracle defaults to the same value (but can be configured for other sizes). SQL Server uses 8k as - and won't let you change that. What kind of index are you trying to create? What is the problem the index is supposed to solve? Very often questions asking to workaround some limits can be solved by taking a different approach.
Oct
31
comment How to determine a schema version at runtime
You don't do "diffs" with such a tool. You just run the script and it will update the schema as necessary. Doing schema management through "diffs" is the wrong approach.
Oct
31
comment How to determine a schema version at runtime
Liquibase manages that in its own table. You just run the liquibase script and it manages everything. Do read the information on their website. It's all explained there
Oct
31
comment Using Case in SQL
Which DBMS are you using? Postgres? Oracle?
Oct
31
reviewed Approve Using Case in SQL
Oct
31
comment How to determine a schema version at runtime
We use Liquibase for this.
Oct
30
comment What does a high level overview of the logic backing database queries look like?
These are about Postgres, but many of it probably applies to other DBMS as well: postgresql.org/docs/current/static/overview.html and momjian.us/main/writings/pgsql/internalpics.pdf and this: neilconway.org/talks/executor.pdf and neilconway.org/talks/optimizer/optimizer.pdf
Oct
30
revised Is this a good case for multiple SQL Server instances on a VM?
There is no such thing as a "SQL instance"
Oct
30
revised HSQLDB 1.8: Trying to have the result table contain two records in each row and be sorted
edited tags
Oct
30
comment Way to test alerts for backups?
Which DBMS are you talking about? SQL is just a query language used by all relational DBMS, it's not a DBMS product.
Oct
30
comment Data Analysis with MongoDB or MySQL
You might interested in this and this
Oct
30
comment CTE works as expected, but not when wrapped into a function
Then maybe named parameters for SQL function were introduced later. I tested that with 9.3
Oct
30
comment CTE works as expected, but not when wrapped into a function
@Gob00st: then you are using quite an old Postgres version. Named parameters for SQL functions were introduced in 9.0 (the oldest officially supported version). If that really is the case you should start planing your upgrade now.
Oct
30
comment CTE works as expected, but not when wrapped into a function
Sorry, there was a copy and paste error in the SQL function. And the conversion to the array needed an explicit type cast.
Oct
30
revised CTE works as expected, but not when wrapped into a function
deleted 34 characters in body
Oct
30
revised CTE works as expected, but not when wrapped into a function
deleted 1 character in body