Log into PostgreSQL using psql and run the help command:
"\h create trigger".
See also:
http://www.postgresql.org/users-lounge/docs/6.5/postgres/sql-createtrigger.htm
HTH,
Poul L. Christiansen
On Sun, 25 Mar 2001, [iso-8859-1] Mohamed ebrahim wrote:
> Hi
> I am an user of postgresql. I wan
Hi
I am an user of postgresql. I want to do some
manipulation on table and i want to do some java stuff
after inserting a row into table(i.e like sending
email). I want to fire the trigger to do this after
the insertion took place. I know how to insert into
the table but i want to know that it
From: "Mohamed ebrahim" <[EMAIL PROTECTED]>
> Hi,
>
> I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention. I want to know how to do
> this. If anyone knows ho
Folks -
> On other DBMSes there could be a difference, especially if the DBMS
> has
> performance problems with variable-length fields.
For example ... MS-SQL Server 7.0 requires 2 extra bytes to store the
length of a string for VARCHAR. Thus, CHAR(3) takes 3 bytes (roughly)
and VARCHAR(3) take
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Mon, 26 Mar 2001, Jack wrote:
> According to user guide, both Raise Notice & Raise Exception will write
> message to database lo
At least
raise exception will abort the transaction but
raise notice does not.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.stbernard.com
www.ipinc.com
On Mon, 26 Mar 2001, datactrl wrote:
> According t
On Mon, 26 Mar 2001, Jack wrote:
> According to user guide, both Raise Notice & Raise Exception will write
> message to database log. Which system table is the database log about?
It's actually generally on either STDERR or sent to syslog depending
on configuration.
> By the way what is the di
You'll probably want something like null::varchar (or other appropriate
type) for the nulls. It's trying to grab the type from the first
select and can't figure the type out for the null. (Technically
speaking, it's probably supposed to be CAST(NULL AS VARCHAR) to
be technically sql complient,
According to user guide, both Raise Notice & Raise Exception will write
message to database log. Which system table is the database log about?
By the way what is the difference between Raise Notice & Raise Exception?
Jack
---(end of broadcast)--
Hey all.
I've a questoin on embedded SQL. This is more a c question, i know, but i'm
going to ask anyway hoping there's another c developer looking who might be
able to help me out.
Thing is, I'm trying to declare a struct in the embedded SQL part in my
program, but the preprocessor complains ab
Thanks Cedar, Jan, and Andy.
Actually the setup is something like this...
There are two remote servers-remoteA and remoteB.
The table of remoteA needs to be sychronized with the
table of remoteB all the time (well, there could be an interval).
remoteB will *publish* every changes and remoteA is *
Hi there, having problems with the following:
On Postgresql (on Linux)
I have 3 tables:
1)employee
firstname
lastname
initials
2)has_title
initials
title
3)has_trade
initials
trade
Now, what I would like is to get a list of all employees with all their titles and
trades - employees can have
According to user guide, both Raise Notice & Raise Exception will write
message to database log. Which system table is the database log about?
By the way what is the difference between Raise Notice & Raise Exception?
Jack
---(end of broadcast)-
> Grant writes:
> > I have a message board. Where users can send each other messages. I
> > doubt I will ever get 2147483647 messages, but I want to make sure I
> > never get an error where the message isn't sent.
>
> Think about loads. If your users are going to be posting 10
> messages/second,
"Peter J. Schoenster" <[EMAIL PROTECTED]> writes:
> On 22 Mar 2001, at 10:05, Tom Lane wrote:
>> There is *no* performance advantage of CHAR(n) over VARCHAR(n).
> I wonder if this question of char/varchar is postgresql specific or
> rdbms in general.
It's definitely RDBMS-specific. My comment
> I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention. I want to know how to do
> this. If anyone knows how to do this please mail me. i
> will be ever thankfu
Mohamed ebrahim writes:
> I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention.
Use a cron job.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.o
On Sat, 24 Mar 2001, Mohamed ebrahim wrote:
> I am a user of postgresql. I want to know that it
> is possible to call a jsp file in postgre
> command.Please help me to know how to call a jsp file.
What do you mean 'call a JSP file'? A JSP file is parsed and compiled by
something like Jasper
On Sat, Mar 24, 2001 at 10:50:31PM -0800, Mohamed ebrahim wrote:
> Hi,
>
> I am a user of postgresql. I want to know that it
> is possible to call a jsp file in postgre
> command.Please help me to know how to call a jsp file.
You need a Servlet container to process jsp files and Post
Hi,
I am a user postgresql. I want to update a table
automatically when we reach monthend. i.e i want to
update some table on 31 of every month automatically
without any user attention. I want to know how to do
this. If anyone knows how to do this please mail me. i
will be ever thankfull to h
Hi all ,
I tried to do a select statement below :
select * from homeuser order userid
limit 5;
However it did not working ,it display all the records in the
database.
You all have any ideas how to use limit clause ??
Thanks weetat
---
On 22 Mar 2001, at 10:05, Tom Lane wrote:
> There is *no* performance advantage of CHAR(n) over VARCHAR(n).
> If anything, there is a performance lossage due to extra disk I/O
> (because all those padding blanks take space, and time to read).
>
> My advice is to use CHAR(n) when that semanticall
Hi,
I am a user of postgresql. I want to know that it
is possible to call a jsp file in postgre
command.Please help me to know how to call a jsp file.
Thank you
Ebrahim
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://
On Thu, Mar 22, 2001 at 07:14:51AM -0500,
Joel Burton <[EMAIL PROTECTED]> wrote:
>
> Is there a function for substring replacement?
[snip]
> Am I missing anything? Has anyone already solved this?
I asked a similar question about a month ago, and got someone to add doing
sed like string repl
On Sat, Mar 24, 2001 at 11:36:56PM -0500, Tom Lane allegedly wrote:
> Mathijs Brands <[EMAIL PROTECTED]> writes:
> > How about being able to recompile them (keeping the SQL around in the
> > system catalogs)? Doesn't Oracle allow you to do something like that?
>
> That's another possibility. It'
Tom Lane wrote:
> Andrew Perrin <[EMAIL PROTECTED]> writes:
> > But I'm intrigued: what is it that causes this? Is it *my*
> > recreating the view on which the other views depend,
>
> Yes. You dropped and recreated the view --- the new version may have
> the same name but it's not the same OID, s
26 matches
Mail list logo
