Thread: pgAdmin 6.5.0 Released

I have just released pgAdmin 6.5.0 at:

http://www.pgadmin.freeserve.co.uk/

For those that don't know, pgAdmin is a freeware administration package for
PostgreSQL that runs under Win95/98/NT. Check out the website for more
details.

Enhancements/updates include:

1) Modified the logon dialogue so that it now remembers the last username
you used. For the first use, the default is the Windows username shifted to
lowercase. 

2) Modified the Create Trigger dialogue to only allow the creation of
triggers on tables owned by the current user. 

3) Views can no longer be seen in the Table Browser or anywhere else where
table names are listed. 

4) Fixed a bug where Null Descriptions for object could cause an error. 

5) Add View browser and creation dialogues. 

6) Fixed a bug where access to modify/create users could be denied for all
accounts if the ODBC driver Bools As Char option was not set. 

7) Changed the Migration Wizard's Type Map defaults for dbNumeric dbSingle,
dbDouble to float4, float4 and float8 respectively. 

8) Updated to use PostgreSQL v6.5 system table structure. 

9) Implemented new 'About Box' with links to the Primary Website and the
author's email address. 
10) Designed a new splash screen. 


Regards,

Dave.

--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!  

Hi!

Sorry for posting this simple question....

I'm just new to postgres and i'm using PERL interface to access my
databases.  I just want to know how can i check or get the status if my
query command has no errors.

     $dbh = Pg::connectdb("dbname=MMS");

How do i check if there's no error connecting to my database MMS?

     $sth = $dbh->exec("select syskey from syskey where syskey =                          '$syskey'");     $sth =
$dbh->exec("insertinto syskey values('$syskey', '$value',                     '$desc')");     $sth = $dbh->exec("delete
fromsyskey where val='test'");
 

How to i check if my select, insert and delete statement has no error?

Thanks...

George 

---------------------------------------------------------------------
|   George P. Esperanza                    e-mail : george@laguna.net |
|   Laguna Internet                        phone  : (049) 545-2358    |
|   6 East Arcade Calamba Trade Center                                |
|   Calamba, Laguna                                                   |
---------------------------------------------------------------------

> Hi!
>
> Sorry for posting this simple question....
>
> I'm just new to postgres and i'm using PERL interface to access my
> databases.  I just want to know how can i check or get the status if my
> query command has no errors.
>
>       $dbh = Pg::connectdb("dbname=MMS");
>
> How do i check if there's no error connecting to my database MMS?
>
>       $sth = $dbh->exec("select syskey from syskey where syskey =
>                            '$syskey'");
>       $sth = $dbh->exec("insert into syskey values('$syskey', '$value',
>                       '$desc')");
>       $sth = $dbh->exec("delete from syskey where val='test'");
>
> How to i check if my select, insert and delete statement has no error?
>

All of these questions can be answered by typing:
  man Pg

and reading the text.

Cheers...james

>
> Thanks...
>
> George
>
>  ---------------------------------------------------------------------
> |   George P. Esperanza                    e-mail : george@laguna.net |
> |   Laguna Internet                        phone  : (049) 545-2358    |
> |   6 East Arcade Calamba Trade Center                                |
> |   Calamba, Laguna                                                   |
>  ---------------------------------------------------------------------