Alt+Tab key combination catching can be achieved through a slight configuration change in your NX Client session.

In the NX Client GUI -> Advanced tab…
Check the Grab the keyboard when the client has focus

If your Dell Laptop has a backlit keyboard and suddenly doesn’t get illuminated anymore, then it’s probably a setting you need to turn on.

Unless you have customized your Shortcuts, Fn + F7 should bring up the Dell Control Point. You will need to have the Dell Device Control Point driver installed.

Fn + F7

Then browse to System and Devices -> System Features -> Keyboard backlight is set to Enabled/Disabled. Use the Toggle button to change it.

Say you want to open up PGSQL so an external client can access it, maybe make some JDBC calls from a different machine etc. you will need to slightly modify some config files

• vi /opt/local/pgsql/data/postgresql.conf
• Change listen_addresses = ‘*’
• vi /opt/local/pgsql/data/pg_hba.conf
• Search for something like
  • host all all 127.0.0.1/32 md5
• Add a new line below
  • host all all 10.4.5.6/32 trust
  • Note 10.4.5.6 is the IP address of the client you want to connect from
• Restart pgsql process /etc/init.d/postgresql restart

After opening up PostgreSQL to accept connections from the outside world and using SQLExplorer as a client, I noticed that if there was a SQL Syntax error or any problem with a SQL, any following SQL statement would come back with

ERROR: current transaction is aborted, commands ignored until end of transaction block

Simple fix for me was to rollback the transaction

rollback

It’s likely that my client was somehow starting a BEGIN transaction and since the query wasn’t valid, the transaction didn’t end so had to manually rollback.

So you want to populate a new column in MySQL with fake dates?

Here’s how to add a new datetime column in SQL

alter table city_new add column mytime datetime;

Here’s how to populate it with fake timestamps data

update city_new set mytime = select from_unixtime(
unix_timestamp(‘2009-01-01 01:00:00’)+floor(rand()*31536000)
);

Here’s a more generic formula

select from_unixtime(
unix_timestamp( ‘start timestamp’)
+floor(rand()* (max interval in seconds) )
);

One of the several eclipse errors.

Could not open the editor: Resource is out of sync with the file system

Easy fix (that worked for me) is to select the Project and hit F5 or Right Click and click Refresh.
Simply refreshing the particular resource did not work.

Usually happens when some files are edited outside of eclipse.