--- On Sat, 12/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> There's always the source code:
> src/backend/utils/adt/ri_triggers.c
Thanks. I will do my best and give it a try :-)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> Does any documentation exist that I could spend some time reading that
> explains detail the cooperation between triggers on the two tables?
There's always the source code:
src/backend/utils/adt/ri_triggers.c
regards, tom
--- On Sat, 12/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> No, the purpose is to support foreign-key triggers. FK
> constraints are
> implemented via cooperating triggers on the two tables, and
> each trigger
> has to be able to look at the other table.
Sorry Tom, I guess I am still a bit co
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> So is the purpose of knowing the reference_table OID, is that it helps to
> generalize the logic of the CONSTRAINT TRIGGERS?
No, the purpose is to support foreign-key triggers. FK constraints are
implemented via cooperating triggers on the two ta
--- On Sat, 12/22/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> It doesn't. That table OID is just stored for the
> trigger function
> to use if it wants to.
I see. I was thinking that the FROM clause of the Constraint Trigger would
allow tuple modifications from either the ON table or FROM table
Glyn Astill wrote:
> What about the "postgres: startup process" ? Should this always be
> visibile on a system reading WALs? Nobody has answered that yet.
Yes. In fact it is the only process that reads WAL.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreS
Hi Artis,
I'm using debian. We discovered another postgres on the network was
trying to connect.
What about the "postgres: startup process" ? Should this always be
visibile on a system reading WALs? Nobody has answered that yet.
Glyn
--- Artis Caune <[EMAIL PROTECTED]> wrote:
> Glyn Astill wrot
> --- Original Message ---
> From: Chuck <[EMAIL PROTECTED]>
> To: "Dave Page" <[EMAIL PROTECTED]>
> Sent: 22/12/07, 19:21:21
> Subject: Re: [GENERAL] installation on Mac OS X 10.5.1
>
> Yes, thanks for the reminder. I'm using this as a private in-house
> database for about 5 people. If
Glyn Astill wrote:
> FATAL: the database system is starting up
> FATAL: the database system is starting up
> FATAL: the database system is starting up
>
>
> As far as I know theres nothing else trying to connect.
I think you are using FreeBSD, and default pg_ctl flags in rc.d contains
"-w" o
On 20 Gru, 16:37, [EMAIL PROTECTED] ("Leonel Nunez") wrote:
> you can leave the instalation as is , and create a tablespace in
> /dane/postgresql and create your databases in the NEW tablespace
>
> take a look at
> :http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html
>
> Leone
how to update the pg version 8.1.3 to 8.1.10? should i backup and drop my
database , or delete the /usr/local/pgsql directory?
--
View this message in context:
http://www.nabble.com/update-pg-question--tp14451672p14451672.html
Sent from the PostgreSQL - general mailing list archive at Nabble.co
At 7:08 PM + 12/22/07, Dave Page wrote:
> --- Original Message ---
From: Chuck <[EMAIL PROTECTED]>
To: Dave Page <[EMAIL PROTECTED]>
Sent: 22/12/07, 18:51:09
Subject: Re: [GENERAL] installation on Mac OS X 10.5.1
Thanks. If I take this approach will it be straightforward to up
> --- Original Message ---
> From: Chuck <[EMAIL PROTECTED]>
> To: Dave Page <[EMAIL PROTECTED]>
> Sent: 22/12/07, 18:51:09
> Subject: Re: [GENERAL] installation on Mac OS X 10.5.1
>
> Thanks. If I take this approach will it be straightforward to upgrade
> from one beta to the next (ass
At 11:03 AM + 12/22/07, Dave Page wrote:
Chuck wrote:
Hello,
What is the best way to install PostgreSQL on Mac OS X 10.5.1?
Or, perhaps I should ask is there a preferred way to PostgreSQL on Mac OS X?
Well I can't say this (or any other) is a 'preferred' way, but you
might want to try th
Richard Broersma Jr <[EMAIL PROTECTED]> writes:
> How does a Constraint Trigger react to a referenced table when the constraint
> is created implementing the FROM clause?
It doesn't. That table OID is just stored for the trigger function
to use if it wants to.
regards, t
Hi,
when a warm standby "slave" database is being maintained, what is the
best way to keep the WAL archive files from cluttering up the disk?
According to
http://www.postgresql.org/docs/8.2/interactive/warm-standby.html it
seems to me that one could either initiate periodic backups (stop PITR
--- On Sat, 12/22/07, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
> > Should it return some sort of value? Should it raise
> an exception?
>
> The latter.
Thanks Michael!
Regards,
Richard Broersma Jr.
---(end of broadcast)---
TIP 4: Have you
On Fri, 21 Dec 2007 08:19:08 +
Richard Huxton <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo wrote:
> > The default property (that is actually made by several fields) in
> > my case is not completely homogeneous with the others, because it
> > has a double meaning.
> > It is cleaner to spl
On Dec 21, 2007, at 15:19 , Bryan Wilkerson wrote:
I've implemented in my model code but it has some deadlock issues
and I really strongly have believed all along that this belongs in
the db anyway. Implementing the above with triggers is a tricky
problem because the trigger would key off
On Dec 21, 2007, at 13:12 , Richard Broersma Jr wrote:
What is the proper way for the function of a constraint trigger to
signal where or not referential integrity was compromised?
Should it return some sort of value? Should it raise an exception?
The latter.
Michael Glaesemann
grzm sees
Chuck wrote:
Hello,
What is the best way to install PostgreSQL on Mac OS X 10.5.1?
Or, perhaps I should ask is there a preferred way to PostgreSQL on Mac
OS X?
Well I can't say this (or any other) is a 'preferred' way, but you might
want to try the EnterpriseDB Postgres installer if you're w
On 22 dec 2007, at 06.56, Chuck wrote:
What is the best way to install PostgreSQL on Mac OS X 10.5.1?
Or, perhaps I should ask is there a preferred way to PostgreSQL on
Mac OS X?
Is a disk image installer fine? Or, is it better to compile all the
components?
I've always installed from so
22 matches
Mail list logo
