Reputation
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
3 29 58
Newest
 Copy Editor
Impact
~1.0m people reached

52m
comment PostgreSQL 9.3 is not returning existing rows with Ruby on Rails or Squirrel
What exactly does "Content does not show anything" mean? Most of the time in cases like this the answer is: you are connected to different databases in Squirrel and Ruby
1h
comment PostgreSQL failed on Select
No need for a variable (at least not in this case) select data into data_list from some_table where PortNumber = (select alter_port from another_table where ...). Note that this will fail if the sub-select returns more than one row, but so would the select ... into
5h
comment Oracle 12c upgrade - from Oracle 11g
Why do you think the create user statement would be different?
16h
comment Postgres New trigger being blocked.
Check pg_stat_activity and pg_locks
17h
comment Is adding the join columns to a table a good practice to improve performance?
You might also want to tag this with the DBMS you are using (Postgres, Oracle). Different DBMS have different optimizers and will behave differently.
23h
comment Matching data in two tables
@ypercube: I know that, but it will not work as it is shown right now using o.Cust_ID.
23h
comment Calculating the percentage change from the previous row
There was a Value in the question, not a [Value]
23h
comment Oracle and execution plans
You don't need a procedure for that. Just run the select statement directly.
1d
comment Calculating the percentage change from the previous row
[value] is an invalid identifier ([ or ] or not allowed in an SQL identifier)
1d
comment Matching data in two tables
Your query will fail in Postgres: "column "c.cust_id" must appear in the GROUP BY clause or be used in an aggregate function"
2d
comment Postgres Dump and Restore on Linux Terminal
postgresql.org/docs/current/static/backup.html
Aug
23
comment Compacting a sequence in PostgreSQL
I have to agree with the others. A generated primary key has no meaning whatsoever. It's only sole purpose is to uniquely identify a row in a table. And it can do that regardless if the key's value is 5,42,3465 or 3623983987436. Renumbering those unique values is nonsense - they still are unique afterwards. So what did you gain? Nothing.
Aug
20
comment How does Postgres make its B-tree index?
Why do you think the wikipedia page describes the implementation of a Postgres B-Tree index and the way Postgres reads those indexes?
Aug
20
comment which option is wise to choose as a back end service mongodb or postgresSQL
Of course Postgres supports NoSQL: it has a very efficient key/value store and it has very efficient JSON support. enterprisedb.com/postgres-plus-edb-blog/marc-linster/…
Aug
20
comment Syntax error on JOIN
Please edit your question and add the exact error message you get. Being "new" isn't an excuse to not post the relevant information when it is asked for.
Aug
20
comment Oracle DB: Can one db file be shared between table space
If you are dropping the complete tablespace, you don't need to drop the data files because the option and datafiles for the drop tablespace will do that as well. So all you need is step #3
Aug
19
comment What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
But that will create the file on the server not on the client.
Aug
19
comment How does Postgres make its B-tree index?
log_1(2) has nothing to do with the block size. Postgres uses an 8kb block size. That's it. Nothing more, no formulas, no magic, no nothing. One block is 8kb there is nothing more to it. Where do you get the idea that the blocksize is (dynamically) calculated using log_1(2)?
Aug
19
comment What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
No need to install Postgres (although that is quite easy). But it's probably the easiest way to get the command line client psql. There are many other SQL clients for Postgres. Several of them also support exporting data into different formats: wiki.postgresql.org/wiki/…
Aug
19
comment Indexes are not created exactly as like mysql
If there are indexes missing then apparently your converted migration script didn't create them (or you didn't convert them properly so that an error occurred). Show us the script if you think they should be there.