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

May
15
comment How to GRANT/REVOKE user permissions for user on Firebird 1.5?
Regarding the documentation fragmentation: if I want to find out if a feature is present in V2.5, do I need to search the language reference update for Firebird 1.0 and 1.5 and 2.0 and 2.5 or is it sufficient to only look into the update for 2.5? Are the "update manuals" cumulative?
May
15
comment Unable to grant permission on table
Then I'll repeat my question: "Did you create that account yourself? If yes how and with which privileges?" - just because a user is called root, doesn't mean he has any special privileges
May
15
comment Unable to grant permission on table
@Greenonline: no, you don't need root access to the database server. You don't even need shell access to the database server - you only need to be able to connect to the Postgres server using a SQL tool (e.g. psql)
May
15
comment Unable to grant permission on table
What do you mean with root user? By default there is no user named "root" in Postgres. Did you create that account yourself? If yes how and with which privileges?
May
14
comment Memory usage on select for large number of rows
It doesn't matter where psql runs - it's still a "client" to the server. Does this also happen when you use the \o command to write the output to a file? In that case psql "knows" that you don't need to display the data, maybe it takes retrieves the data more efficiently then.
May
14
comment Memory usage on select for large number of rows
Which process exactly gets killed? The psql process or the Postgres backend process for your connection? I guess the client (psql) buffers the result somehow (or forces the backend process to do so) When you use copy the data is never transferred to the client (the psql program) because this is all done on the server side.
May
13
comment Why does the CBO eliminate `distinct` and not `group by` in this query?
Unrelated, but: you shouldn't be using analyze table any more. The recommended way is to use dbms_stats.gather_table_stats() because that will create different (better?) statistics.
May
12
comment How to create Postgres DB with case insensitive collation
There is no such option. But maybe you can use citext data type: postgresql.org/docs/current/static/citext.html
May
12
comment What's the greatest value for postgres maintenance_work_mem?
There is a 2GB limit on Windows (even for 64bit), which does not apply to Linux: postgresql.org/message-id/…
May
11
comment Compact Spool file from Sqlplus
Different encodings maybe (multi-byte vs. single-byte)? Different line endings? How many rows does the output contain?
May
10
comment Is it possible to access column by index instead of it's name/alias in query?
No, that's not possible
May
8
comment what is the most simple and easiest way to backup and restore on oracle 11g?
DataPump: docs.oracle.com/cd/E11882_01/server.112/e22490/…
May
7
comment Which major database platforms support TTL?
I agree with Spörri: partitioning is your best option - to purge the data you just drop the partition.
May
7
comment Replace value using several criteria in another table
Which DBMS are you using? Please add the appropriate tag.
May
7
comment Delete using a composite key
According to the SQL standard you need parentheses around the columns: where (COLUMN1, COLUMN2) IN (...) but I don't think SQL server supports this.
May
7
comment How to migrate a database from SQL server to Oracle?
What is a "pls"?
May
7
comment I want to start the Postgres database
It doesn't "hang". From the manual: "By default postgres starts in the foreground" - so your command starts it in the foreground and thus your console is "blocked". It's better to use pg_ctl to start it in the background or use the wrapper script provided by your Linux distribution (e.g. service postgresql start)
May
6
comment How to atomically replace table data in PostgreSQL
If you use delete instead of truncate it will be slower, but without blocking readers. How many rows do you need to delete?
May
6
comment Is there any point in specifying the precision and scale of a number for a foreign key?
I did read the the link and I'm surprised. It apparently has something to do how an expression is evaluated. Just wanted to add that a number column does not have a fixed size - similar to the way e.g. a varchar works.
May
5
comment Is there any point in specifying the precision and scale of a number for a foreign key?
number is a variable length data type. So x1 will take up to 21 bytes. If you store the number 42, it will take exactly the same space in x1 and x1