Search Postgresql Archives

Re: Old/New

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Saturday 23 January 2010 7:51:28 am Bob Pawley wrote:
> I havn't been able to find documentation on how to use \d. When I open the
> psql interface (through either port ) it asks for a password but doesn't
> allow any entry of a password.

That would depend on the settings in pg_hba.conf, whether you have passwords 
enabled for the connection or not. I am not sure what you either port? Are you 
referring to the port address and the local socket?

>
> However, after my last e-mail to you, I came across something interesting -
> at least to me.
>
> I use pg_admin scripts to modify triggers.
>
> Looking through pg_admin at all of the triggers on the p_id.processes table
> I just happened to click on the trigger we have been discussing and then
> clicked its refresh button.
>
> Using the same update statement and the same After Update trigger that
> inserted two rows into p_id.devices it now inserted only one row and that
> row was the correct row.
>
> I don't know enough about the interaction between the unrefreshed copy of a
> trigger held by pg_admin and the updated trigger installed in the server to
> comment - however there does seem to be a connection of which I wasn't
> aware.

Can't help you there I don't use pgAdmin.

>
> Bob
>



-- 
Adrian Klaver
adrian.klaver@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux