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
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
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
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
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 split the
--- 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
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
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, tom
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
--- 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 (assuming that
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
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
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
Leonel
Hi
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 option,
--- 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 there's a
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 wrote:
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/
PostgreSQL
--- 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 to
--- 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 confused
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
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
--- 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?
22 matches
Mail list logo