hi,
this may also related to interface list. but also trigger, so, I post it to
general list.
I want to know if it is possible to let perl program (using dbi) get
info (esp. error info) from the triggers (in PL/pgSQL).
thanks!!!
Kai
_
It is possible. But I do not know how :-) I Know it because PL/pgSQL
can do it, and spi/C can do more than PL/pgSQL.
in the doc, seems a lot stuff on spi (server programming interface ?).
also, since the syntax of PL/pgSQL is not difficult at all, it can
serve as the psudo-code for most purpose,
if in doubt, memory first -- although it depends your app and hits.
processor/disk: check your cpu use.
amy
>From: Michael <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: [GENERAL] Hardware optimising
>Date: Thu, 26 Aug 1999 11:19:39 +0100
>
>Hi
>
>I am about to
Oliver, or/and, Gary, and all other experts,
I studied this design:
1) inheritance and trigger: since "person" and "person-address" relationship
already has triggers, why "organization" and "individual" still need
triggers with "person-address"?
2) "person-address" is the relationship between "
no direct support yet. but you can use triggers. you can find the
trigggers in c in the source's contri/refin.c , also, you can find
them in the source's test directory (file name like triggers.sql(?)).
this question is asked n-times (n>=20 (?)). So, in this listing,
also the novice listing, sear
"Oliver Elphick" wrote:
>I don't think that triggers can be inherited automatically. That is why I
>did it that way. The implementation of inheritance still needs a lot of
>work in PostgreSQL.
thanks for the info.
>The refint trigger is to make sure that the address record exists before
>the pe
hi, all experts there,
I'm studying the example in postgresql-6.5.1/src/pl/plpgsql/test.
I do not understand why we need "do delete/insert instead of update if name
changes". Is it ONLY for the test, or, there is some
reason for doing that in practical use?
I cut/paste part of it below.
Thanks
hi, all experts there,
it's me again :-)
I'm studying the example in postgresql-6.5.1/src/pl/plpgsql/test.
I have another question: why do we need to "Set backlink to empty string if
NULL value given"? is it JUST a test, or, some reasons to
do that in general?
Thanks!!!
amy
#
>I can answer least 50% on all of your question only after reading the
>"programmer's guide",
>one night,( and was also doin' a Postgres+Apache+PHP installation in
>parallel).
>So did you rtfm?
OK, I understand you are smart! BTW, what is "rtfm" ;-)
> > the difference between PL/pgSQL and tcl (no
Jeff, Bryan, Teodor:
thank you all so much!!!
one related/furthur question:
>0. LOCK TABLE IN EXCLUSIVE MODE
this is what I'm concerned. Now, the "shutdown" a table gracefully
is solved. How about the whole postmaster (in some other situation),
how can I shut it down GRACEFULLY (i.e., I know tha
hi, all experts there, greetings!
Just minutes ago, my boss found out one of the attributes in a
table is too short (varchar 64 for url), we need to make
it wider to 85 A.S.A.P. Seems that alter table can not do it.
So, I used pg_dump, (how to do it gracefully?) immediately drop the table,
shutd
>We still don't know if Postgresql can do it, do we?
no, we do not know ;-)
anybody there please?
amy
__
Get Your Private, Free Email at http://www.hotmail.com
greetings, all experts & newbies there!!!
my questions are all related with data warehouse indexing:
1) does PG support bitmap index?
2) can PG use multiple indices with in ONE query? so that we do not
need to make multiple attribute indices (composite indices).
3) can PG actually do Cartesia
be a hacker to do this. BTW, SQL server 7 can do them,
why PG can not :-)
amy
>From: "amy cheng" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: [GENERAL] data mart indexing support?
>Date: Thu, 23 Sep 1999 06:58:01 PDT
>
>greetings, all experts & newbi
the problem is that I can not even dump!
also, our system admin just upgrade the OS (linux5.x -> 6.x).
thanks
amy
>From: Aaron Holtz <[EMAIL PROTECTED]>
>To: amy cheng <[EMAIL PROTECTED]>
>Subject: Re: [GENERAL] ERROR: nodeRead: Bad type 0
>Date: Mon, 27 Sep 1999 1
hi, this is kind of emergent!
we are in the process of decision making. Is there an true64 on
alpha port?
thanks in advance!!
amy
__
Get Your Private, Free Email at http://www.hotmail.com
forgive my ignorance. why "multi-resultset, multi-level transaction" SP is
so important? no work-around? I rememeber there were some discussion on
multiple-return-value-function in the past. My impression is that they are
not that crucial and usually can
find rather simple work-arounds.
>Fr
hi, there,
I use two serial type fields within one table, seems psql does not
like it: it override the first one with the second one! Why? (seems to me
quite often if I do not want to normize it too much) or
something else?
here is the table:
create table tmpschedule
(
schedid serial,
o more research/testing on this.
>From: Howie <[EMAIL PROTECTED]>
>Reply-To: Howie <[EMAIL PROTECTED]>
>To: amy cheng <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: [GENERAL] stored procedure revisited
>Date: Wed, 13 Oct 1999 17:29:29 + (GMT)
>
IL PROTECTED]
>Subject: Re: [GENERAL] stored procedure revisited
>Date: Wed, 13 Oct 1999 15:52:28 -0700
>
>amy cheng wrote:
> >
> > C is good, and in a sense, for OSS we should encourage more C
>"scripting"
> > and "hacking" than script scripting. (per
try:
insert into ip values ('10.20.30.40');
>From: soundar rajan <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: [GENERAL] cidr and inet
>Date: Thu, 21 Oct 1999 12:15:03 -0700 (PDT)
>
>Hi all,
>
>I created two tables with CIDR and inet data values
>separately. I was not able to insert value
>create table test (
> proposetime datetime not null default 'now()',
>)
>
>
>At 10:07 PM 10/25/99, Lincoln Yeoh wrote:
>>At 01:05 PM 25-10-1999 PDT, amy cheng wrote:
>> >hi, there,
>> >
>> >I'm using:
>> >
>> >c
I'm considering to persuade my boss in making the scheduler project I'm
doing as a GPL, just like the accounting one. any ideas?
>From: Thomas Good <[EMAIL PROTECTED]>
>To: Carsten Huettl <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: [NOVICE] next steps
>Date: Fri,
hi, there,
I'm using select from 2 tables (join). the key fields are not the
same type (char and varchar). result: psql got disconnected. I tried
several times, then, I make the type the same. then, it works.
now, although not urgent, I'm still curious: is it a bug or,
I did not install PG right
then, why use int, isn't char better? (almost no need for batch).
>From: Herouth Maoz <[EMAIL PROTECTED]>
>To: "Shawn T. Walker" <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: [GENERAL] Auto Ordering
>Date: Mon, 1 Nov 1999 17:57:13 +0200
>
>At 20:41 +0200 on 27/10/1999, Stuart Rison w
sure. PG's datetime and timespan are the best, even better than Okle! there
are "now", "current_date" etc. see the doc and archive of this
list (search datetime).
Just a remind: unless you really want "date" (nobody need to save disk for
that reason!), use datetime/timespan.
>From: Edouard D
and there are some work-arounds in the archive of this mailing list.
basically use a temporary table.
>From: Alain TESIO <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Edouard DESSIOUX <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: Re: [GENERAL] Alter table possibility
>Date: Tue, 9 Nov
27 matches
Mail list logo
