itech9

SELECT relname, tgname, usename 
 FROM ( 
     pg_trigger JOIN pg_class ON (tgrelid = pg_class.oid) 
               JOIN pg_proc ON (tgfoid = pg_proc.oid) 
               JOIN pg_user ON (relowner = pg_user.usesysid) 
) 
WHERE tgisinternal = FALSE [ and usename = 'user' ]

From: http://stackoverflow.com/questions/134845/href-for-javascript-links-or-javascriptvoid0

When building a link that has the sole purpose to run JavaScript code, is it better to

<a href="#" onclick="myJsFunc();">Link</a>

or

<a href="javascript:void(0)" onclick="myJsFunc();">Link</a>

?

— This site is VERY useful :

http://viewsonic-gtablet-for-dummies.webs.com/

— Rooting (rooted android) with ClockworkMod info here:

http://www.addictivetips.com/mobile/root-and-install-clockworkmod-recovery-on-android-viewsonic-g-tablet/

and here:

http://forum.xda-developers.com/showthread.php?t=865245

— The installation of ClockworkMod from sdcard did not work.

When I booted the tablet in recovery mode, it was stuck at 3 parrots.

— The next 2 steps (NVFlash and ROM installation) require a Windows driver to be
installed (from SystemUSB.zip). On Windows 7 (Windows7, Win7) the Device panel
looks like this:

— Installed NVFlash, followed the info here:

www.slatedroid.com/topic/17150-recovery-nvflash-full-restore-using-either-11-or-12-based-images-g-tablet/

— Than, I tried to install the ROM with info from here:

http://forum.xda-developers.com/showthread.php?t=1031250

Using this download ..

VEGAn-GE-7.0.0-RC1-Harmony-signed.zip (107300001 bytes)

From here:

http://vegantab.gojimi.com/downloads/

When I ran the install from cwm, I got this error:

>> assert failed: getprop(“ro.product.device) == “harmony” || getprop(“ro.build.product”)

I found this comment, applied the fix to the script and re-zipped the folder..

>> I just extracted the META-INFO/com/google/updater-script, removed the first two lines, and replaced it. Then it installed correctly.

Well, the comment above was not exactly right.. it installed without
an error but it never booted.. was stuck at 3 parrots..

— I revisited the page and noticed a 7.1 — with the assert fixed!

VEGAn-GE-7.1.0-smb_a1002-BL-1.2-fixed_assert.zip (111426199)

From here:

http://vegantab.gojimi.com/2011/08/26/vegan-tab-gingeredition-7-1-0-for-bootloaders-1-1-and-1-2/

(Easy to miss on the page.. search the page for “Direct Download for BOOTLOADER” ..)

— Installed it and it works great!