Is Postgresql 9.2.2 supported in the latest version 6.3

Hi

Is the latest version of sql assistant supporting Postgresql version 9.2.2 ?

Tried and it not working, any special setting to configure.
Thank you

Hi,

Do you mean the database server or pgAdmin too? What specifically isn't working for you? Have you tried it with Notepad or Notepad++ and the same database server, if yes, have it worked for you?

Thanks.

Hi Sysop

Sorry for not being clear with my question.

I am referring to pgAdmin that come with Postgresql version 9.2.2.
Tried a trial copy and intellisense don't seem to be working on the
pgAdmin

Notepad is also not working for me.

Please advise

Did you enable Notepad as a target for PostgreSQL in SQL Assistant options? If yes, when you type word SELECT in Notepad, do you get the Connect prompt?

Just in case, do you run 32-bit or 64-bit version of Notepad? (if not sure check in the Task manager if the process has *32 at the end of the image name. You should try with 32-bit version of Notepad)

Hi SysOp

Yes, tried using Notepad (64 bit as I running Windows 7 64bits OS),
didn't get any connect prompt. How do I run the 32bit Notepad ?

Thank you

Hi,

Please try installing Notepad++ on your Windows system. You can get it here http://sourceforge.net/projects/notepad-plus/
It is a 32-bit application and so it should be compatible with SQL Assistant. In SQL Assistant options please change Notepad++ target option to be a target for PostgreSQL. After the installation and changing Options, start Notepad++, type SELECT keyword then press space bar, when prompted enter your database connection parameters. if that works, righ-click and check if function in the SQL Assassinat menu branch work for you. If they do, then the issue is with your pgAdmin version or something else. Verify, you are running 32-bit version of pgAdmin.

Thanks.

Hi Sysop

Thank for the Notepad++ link, it working on my system.

However my pgadmin for Postgresql is not working.
Is it due to pgadmin as 64bit application that is not supported by sql assistant ?

My system is running Win 7 64 bit OS, so postgresql installer require 64 bit installer,
hence pgadmin is also a 64bit application.

Anyway to solve or fix this pgadmin issue?

Hi,

SQL Assistant is a 32-bit application (we need to run it on all sorts of systems) and so it can work with 32-bit editors and development tools only (not to be confused with 64-bit database servers) . So unfortunately you won't be able to use it with 64-bit version of pgAdmin. What you can do is to install 32-bit version of pgAdmin and that should work fine. As far as I know, standalone pgAdmin installations are available for download from http://www.pgadmin.org/download/