I
try pgmail and that is well running ...
fo security, do not use attachment files with your mail ...
try pgmail, you need to use pl/tclu ...
Ben
Sai Hertz And Control Systems wrote:
Dear
Uzo ,
Hi,
does postgresql support the ability to email as in SQL Server? I want
to cr
El lun, 12-01-2004 a las 10:12, [EMAIL PROTECTED] escribió:
>
> Hi,
> /
>
> My SELECT STATEMENT :
>
> dwnc=> insert into cust_lo_dim
> dwnc-> (lo_no,lo_date,rcvdate,lo_status)
> dwnc-> select c.lono,c.lodate,c.rcvdate,c.status
> dwnc-> from custlo_temp c ;
> ERROR: column "lo_date" is
Hi I'm trying to update a table column with a pl/pgsql function and a trigger.
But I didn't managed to make it work so far.
Here's my function code :
CREATE FUNCTION public.calcul_impact() RETURNS opaque AS '
DECLARE
id_line integer;
quantity integer;
single_price real;
total_cost real;
a
Hi,
this all started because I wanted to install pltclu so that I could
gain access to pgmail using tcl. I have re-run the build and even
though I have specified --with-tcl as one of the components of the
build, tcl is not installed in the /lib directory. Has the tcl file
been renamed in the /l
Hi,
I have tried without any success to get this pgmail for tclu resolved.
Does anyone have or know of the same sort of function as pgmail but
supporting c, as this is one of the installed languages I have access
to under postgresql. So for instance:
CREATE FUNCTION sendemail(x,x)
LANGUAGE
beyaRecords - The home Urban music wrote:
> this all started because I wanted to install pltclu so that I could
> gain access to pgmail using tcl. I have re-run the build and even
> though I have specified --with-tcl as one of the components of the
> build, tcl is not installed in the /lib director
beyaRecords - The home Urban music <[EMAIL PROTECTED]> writes:
> I am running OS X 10.3.2
Last I checked, OS X had tcl but not tk, so you have to configure
--with-tcl --without-tk to get it to build pltcl.
Try again (and pay some attention to the error messages this time ;-))
Dear Uzo ,
Could anyone mail me the pltcl.so file so that using createlang pltclu
I can gain access to email facilities using pgmail?
I am running OS X 10.3.2
I am not sure if this happens in OS X you may do something equivalent of
su -c"gmake install-all-headers"
add the libs path to /etc/ld.
I know I can select from one table into a new table, but is
there a way to select from one table into an existing table
(aside from copying everything to a file, editing the file
and then copying from that file)? Without destroying existing
entries, of course...
I have an application where old r
- Original Message -
From: "Steve Wampler" <[EMAIL PROTECTED]>
To: "Postgres-SQL" <[EMAIL PROTECTED]>
Sent: Tuesday, January 13, 2004 18:23
Subject: [SQL] Copying rows between tables?
>
> I know I can select from one table into a new table, but is
> there a way to select from one table
On Tue, Jan 13, 2004 at 09:23:48AM -0700, Steve Wampler wrote:
>
> I know I can select from one table into a new table, but is
> there a way to select from one table into an existing table
> (aside from copying everything to a file, editing the file
> and then copying from that file)? Without des
The table is like this:
maxware=# \d test;
Table "public.test"
Column |Type | Modifiers
+-+---
a | timestamp without time zone |
b | integer |
=
The following inser
I've figured it out, that is using 'null as ' with the COPY
command.
Bing
> The table is like this:
>
>
> maxware=# \d test;
>Table "public.test"
> Column |Type | Modifiers
> +-+---
> a | timestamp
On Tue, 13 Jan 2004, Bing Du wrote:
> The table is like this:
>
>
> maxware=# \d test;
>Table "public.test"
> Column |Type | Modifiers
> +-+---
> a | timestamp without time zone |
> b | integ
Dear Steve Wampler
I have an application where old records are archived into
'archive' tables. Occasionally there is a need to copy
some of these old records into the 'active' table.
source_table(id: bigserial,uname: char,x1: char,x2: char,x3: char,x4: char)
dest_table(id: bigserial,uname: cha
Hi,
I am in the process of re-building postgresql 7.4.1, and on running
configure I get the following output, of interest to me is the error
message about ant even though it is installed in /library/ant, so i
don't know why it is complaining. Any ideas?:
% ./configure --with-perl --with-python
beyaRecords - The home Urban music wrote:
> I am in the process of re-building postgresql 7.4.1, and on running
> configure I get the following output, of interest to me is the error
> message about ant even though it is installed in /library/ant, so i
> don't know why it is complaining. Any ideas?
Here's the setup: I wanted to write a rule that would fire on an update
to one table, and do an update to another table, followed by a notify.
My first attempt wasn't acceptable to PG (7.3.4):
create rule "my_rule" as
on update to table_A
where new.col_A != old.col_A
do
(update table_B ...;
hello everyone,
Yes, yet agian i have a rather crazy idea,
go with me on this and hopefully it will make a bit
more sense than normal :)
Currently, i have a rather extensive application
that gets a lot of queries, i was wanting to track the
general 'usage' pattern overtime, but of
19 matches
Mail list logo
