Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
4 22 47
Newest
 Constituent
Impact
~429k people reached

Jul
9
comment How to find similar (but different) names with the same soundex value?
@MohamedAshrafAliB it's not a variable but a mandatory table alias for a subquery.
Jul
9
comment How to find similar (but different) names with the same soundex value?
Please give some examples that you'd like to find. How similar is similar?
Jul
8
comment move data folder and drive mysql centos
Would you mind to add an explanation about how this solves the issue?
Jul
7
comment Clob (Swift message) data in Oracle table
And what do you have so far?
Jul
7
comment How to print to console in SQL?
Maybe a SELECT 'hello world'? Other than that, I used a solution for something else here: dba.stackexchange.com/a/24850/6219
Jul
6
comment How to partition existing table in postgres?
@EvanAppleby DELETE FROM ONLY master_table is the solution.
Jul
6
comment How to partition existing table in postgres?
I second what @a_horse_with_no_name said. Otherwise, the first method is much easier and cleaner in my view.
Jul
6
comment How do I keep a postgres table up to date using instagrams api?
You will have to write a script, I'm afraid.
Jul
3
comment Mysql high cpu usage - cpanel
Why, is anything wrong?
Jul
3
comment Implication of owned schemas for a user having db_owner privilege
Where is SQL involved here? Would you mind to name the RDBMS and the GUI you are using?
Jul
3
comment Does PostgreSQL support online schema modification (DDL)?
Yes, the SET NOT NULL can be a pain, just like creating foreign keys (and maybe other operations, too).
Jul
3
comment Does PostgreSQL support online schema modification (DDL)?
To my understanding, adding a new column in MySQL means creating a temporary copy of the table, applying concurrent changes to it and then putting it into the place of the old one. In contrast, adding a new column in PostgreSQL is practically a change in the catalog - not online in the strict sense of the word, but if done carefully causing only minimal disturbance through the exclusive lock. So, from a practical point of view, postgres has been already there for quite a long time...
Jul
3
comment Like operator in postgresql
You forgot to show what you want to compare to what.
Jul
2
comment Postgres 9.1.6 Error index contains unexpected zero page at block 0
No, not really - it's just a habit of quite a few contributors here to point this out.
Jul
2
comment Postgres 9.1.6 Error index contains unexpected zero page at block 0
Do you plan to upgrade to something younger? There are five newer major versions since 8.3 (which does not get any security or other updates since quite a while).
Jul
2
comment PostgreSQL database connection time
I am not sure how this answers a question which is basically unclear at the moment (see my comment above). How do you get any information from pg_stat_activity about the time needed for opening a connection?
Jul
2
comment PostgreSQL database connection time
What do you mean exaclty? Who tries to connect where?
Jul
2
comment Sum of points and rank according to points
Do you really call your tables table1 and so on? Anyway, showing some example data and the wrong output (with the wrong query) could help a lot in getting an answer. Otherwise, it's just guesswork (already done by @JamesAnderson) to figure out what the odd behaviour can mean.
Jul
1
comment PostgreSQL becomes very slow after heavy utilization
If you don't restart the DB, does it stay around 4 tps? Or does it climb up to 56 slowly?
Jul
1
comment Is there a way to determine if a postgres function depends on a user-defined type?
@CraigRinger consider this: show check_function_bodies ; => on, but: CREATE FUNCTION a(p_a integer) RETURNS void LANGUAGE plpgsql AS $$ BEGIN PERFORM 'elekdsnj'::enumtype; END; $$; succeeds while the type enumtype does not exist.