Postgres Pro
Downloads
Home   >   mailing lists

Thread: Possible "off-topic"

Possible "off-topic"

From
Tulio Oliveira
Date:
Hi, ALL

I just install:

Postgres 7.0.2
Apache 1.3.14
PHP4
Over RedHat Linux 6.2
On a Notebook Toshiba Satellite Pro

It's working fine, but I have 2 problems.

1) The arrows-keys (up,down,left,right) don't work in PSQL prompt.
Instead this keys, it returns ^[[A  ,  ^[[B  ,  ^[[C  ,   ^[[D
And when I access the notebook from other machine via TELNET, the
BACKSPACE don't works too. (^H isntead).
It's very dificult edit tables and manage the database without this
keys.
Anyone know any configuration to adjust this ??


2) When I startup the X system, and runs Netscape from the same
notebook, the time to make de CONNECTION into Postgres is too slow. More
than 30 seconds....
But when I access the notebook via another machine, the connection is
fast.
Anyone know if the X system conflicts with POSTMASTER ?
I need make some presentations with this notebook.


Regards,

Tulio Oliveira




--
======================================================
AKACIA TECNOLOGIA
Desenvolvimento de sistemas para Internet
www.akacia.com.br

Re: Possible "off-topic"

From
François LODIER
Date:
Hi all,
happy new year ,
sorry to disturb you but I am trying to create a trigger but it doesn't seems to be working.
I have got a function called halloworld that takes one argument and I am trying to trigger it :
so I write somethig like :
CREATE TRIGGER helloworld_trigger AFTER INSERT
    ON data FOR EACH ROW
    EXECUTE PROCEDURE helloworld ( 'login' )
As I have a field named login in the data table.
and the response is :
CreateTrigger: function helloworld() does not exist

If any ne could help me it would be great.
Thanks
-- 
--------------------------------
François Lodier             .   _
.                         __     .
.                        ..     ...
zentak@agisphere.com      .  __  .
Ouais! Et pourquoi ??      ... .
---------------------------------
 

Re: Re: Possible "off-topic"

From
Zachary Beane
Date:
On Tue, Jan 02, 2001 at 05:01:56PM +0100, François LODIER wrote:
> Hi all,
>
> happy new year ,
>
> sorry to disturb you but I am trying to create a trigger but it doesn't seems to be working.
>
> I have got a function called halloworld that takes one argument and I am trying to trigger it :
>
> so I write somethig like :
>
> CREATE TRIGGER helloworld_trigger AFTER INSERT
>     ON data FOR EACH ROW
>     EXECUTE PROCEDURE helloworld ( 'login' )
>
> As I have a field named login in the data table.
>
> and the response is :
>
> CreateTrigger: function helloworld() does not exist
>
> If any ne could help me it would be great.

When triggers are called, they are invoked with no arguments. The
arguments listed in the "create trigger" statement are placed in the
array TG_ARGV[], which can be referenced inside your procedure.

Zach
--
xach@xach.com     Zachary Beane     http://www.xach.com/

Re: Possible "off-topic"

From
Tom Lane
Date:
Tulio Oliveira <mestredosmagos@marilia.com> writes:
> 1) The arrows-keys (up,down,left,right) don't work in PSQL prompt.
> Instead this keys, it returns ^[[A  ,  ^[[B  ,  ^[[C  ,   ^[[D
> And when I access the notebook from other machine via TELNET, the
> BACKSPACE don't works too. (^H isntead).

Sounds like you have messed-up terminal settings.  Check that the
TERM environment variable matches what you are using.

> 2) When I startup the X system, and runs Netscape from the same
> notebook, the time to make de CONNECTION into Postgres is too slow. More
> than 30 seconds....

Your local DNS setup is messed up, I think.  That sounds like a
nameserver timeout while trying to look up "localhost" (or whatever
you have PGHOST set to).  Bone up on configuring DNS; I imagine there's
a HOWTO for it out there.

Or you could just unset PGHOST.  But the DNS problem will affect more
than just Postgres, so I'd recommend attacking the problem not just
this symptom.

            regards, tom lane