Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joe
Sent: 27 June 2006 15:15
To: Andrew Sullivan
Cc: pgsql-sql@postgresql.org
Subject: Re: Fwd: [SQL] Start up question about triggers
Andrew Sullivan wrote:
On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
Sent: 26 June 2006 17:43
To: pgsql-sql@postgresql.org
Subject: Re: Fwd: [SQL] Start up question about triggers
On Mon, Jun 26, 2006 at 04:59:26PM +0300, Forums @ Existanze wrote:
Hello again,
The problem
On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote:
I looked into slony, I have a question though, how would I go about
controlling slony via a jdbc driver? See this whole problem has arisen
because for some reason my client wants to keep to separate databases in two
separate
June 2006 14:40
To: pgsql-sql@postgresql.org
Subject: Re: Fwd: [SQL] Start up question about triggers
On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote:
I looked into slony, I have a question though, how would I go about
controlling slony via a jdbc driver? See
Andrew Sullivan wrote:
On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote:
I looked into slony, I have a question though, how would I go about
controlling slony via a jdbc driver? See this whole problem has arisen
because for some reason my client wants to keep to separate
On Tue, Jun 27, 2006 at 02:48:38PM +0300, Forums @ Existanze wrote:
Hello again andrew,
Actually man I do need to be able to write to both databases, and keep them
synchronized, and all this because of the recurring xenofobia for technology
Then sorry, but this can't be done out of the box
On Tue, Jun 27, 2006 at 08:14:34AM -0400, Joe wrote:
But with file-based log shipping (see
http://linuxfinances.info/info/logshipping.html) one could write a Java
app to control when the updates are applied.
Well, sure. I mean, if you decide first, I'll use Java, and then
start asking
Actually man I do need to be able to write to both databases, and keep them
synchronized, and all this because of the recurring xenofobia for technology
Then sorry, but this can't be done out of the box by anything. You
have all manner of race conditions here.
Doesn't PGcluster allow
Richard Broersma Jr wrote:
I thought that Mammoth replicator might support synchronous masters
but it appears to be an Asynchronous system like Slony.
http://www.commandprompt.com/products/mammothreplicator
You are right, Mammoth Replicator is asynchronous single master, just
like Slony.
--
On Fri, Jun 23, 2006 at 10:29:33PM -0500, Aaron Bono wrote:
What I really cannot find is a way to _dynamically_ in the trigger ask what
COLUMNS are in OLD and NEW. If we had:
All of the columns, of course. When the tuple is UPDATEd, even if
you did not mention some columns in your UPDATE,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
Sent: 26 June 2006 13:43
To: pgsql-sql@postgresql.org
Subject: Re: Fwd: [SQL] Start up question about triggers
On Fri, Jun 23, 2006 at 10:29:33PM -0500, Aaron Bono wrote:
What I really cannot
The problem is not tracking WHAT changed, this can be done, as we have
discussed in this thread, the problem is how to replicate the necessary
commands that will alter a mirror database to reflect what has been changed,
sequencially and in the order that it has occurred.
If your finial goal
On Mon, Jun 26, 2006 at 04:59:26PM +0300, Forums @ Existanze wrote:
Hello again,
The problem is not tracking WHAT changed, this can be done, as we have
discussed in this thread, the problem is how to replicate the necessary
commands that will alter a mirror database to reflect what has been
On Mon, 2006-06-26 at 08:59, Forums @ Existanze wrote:
Hello again,
The problem is not tracking WHAT changed, this can be done, as we have
discussed in this thread, the problem is how to replicate the necessary
commands that will alter a mirror database to reflect what has been changed,
On Mon, Jun 26, 2006 at 10:38:06AM -0500, Scott Marlowe wrote:
I bet it would be possible to hack pgpool to do this. Just have it
shoot all the queries that come in to it at the normal database, AND at
a text file or something like that.
Now you're back to the same problem: it doesn't tell
to create the
necessary queries, or I could do it generically :-)
Best Regards,
Fotis
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard
Broersma Jr
Sent: 23 June 2006 08:10
To: Aaron Bono; pgsql-sql@postgresql.org
Subject: Re: Fwd: [SQL
).
Regards,
George
- Original Message -
From: Forums @ Existanze [EMAIL PROTECTED]
To: pgsql-sql@postgresql.org
Sent: Friday, June 23, 2006 2:15 AM
Subject: Re: Fwd: [SQL] Start up question about triggers
Hello again aaron,
Im really interested in the part where you say generic trigger
Im really interested in the part where you say generic trigger can you
give me some tips? As to how I will go about that? I had already read the
links that Richard gave, I new I could get the values like that. So right
now I will have to create a trigger for each of my tables to create the
15:38
To: Forums @ Existanze
Cc: pgsql-sql@postgresql.org
Subject: Re: Fwd: [SQL] Start up question about triggers
Hi Fotis,
If you end up having to create a solution for each of the 80
tables, you may want to check out the following (may also
give you addtional ideas for what you're
Sent: 23 June 2006 18:49
To: pgsql-sql@postgresql.org
Subject: Re: Fwd: [SQL] Start up question about triggers
Hello again,
First of all thank you all for your effort in helping me
solve this problem.
George's link seems like a complete auditing framework for a
database, so I will look
On Fri, Jun 23, 2006 at 06:48:49PM +0300, Forums @ Existanze wrote:
Then there exist a TG_QUERY parameter that we could use to get the actual
query ran by a user, so if I ran the imaginary query
Which actual query? By the time the trigger fires, the query might
already have been rewritten, I
Andrew Sullivan [EMAIL PROTECTED] writes:
On Fri, Jun 23, 2006 at 06:48:49PM +0300, Forums @ Existanze wrote:
Then there exist a TG_QUERY parameter that we could use to get the actual
query ran by a user, so if I ran the imaginary query
Which actual query? By the time the trigger fires, the
This is why I was searching for good meta data.Here is a thought. If your trigger has the OLD and NEW, is there a way to get a list of fields from OLD and NEW? If TG_RELNAME is the name of the table, could you just ask PostgreSQL what the columns are in that table, iterate through those columns,
Hello
all,
I know that this
question may be really simple, but I have decided to ask here due to fact that I
don't know how to search for this on google or on the docs.
I created a trigger
fuction which updates a specific row in some table A. Is it possible to retain
the query that was
ExistanzeSent: 22 June 2006 12:19To:
pgsql-sql@postgresql.orgSubject: [SQL] Start up question about
triggers
Hello
all,
I know that this
question may be really simple, but I have decided to ask here due to fact that
I don't know how to search for this on google or on th
:
pgsql-sql@postgresql.orgSubject: [SQL] Start up question about
triggers
Hello
all,
I know that this
question may be really simple, but I have decided to ask here due to fact that
I don't know how to search for this on google or on the
docs.
I created a
trigger
@postgresql.orgSubject: Re: [SQL]
Start up question about triggers
Why not just create a history table and have the trigger copy the
data out of the table into the history table with a time stamp of the
change. Then you don't need the query.For exampleTable
Aa_id,a_value1, a_value2Table
I did some research and can't even find a way to get meta data in a trigger.In a trigger, is there a way to inspect OLD and NEW to see what columns are there and see what has changed? If so, you may not be able to grab the actual query but you could create a generic trigger that reconstructs a
I did some research and can't even find a way to get meta data in a trigger.
In a trigger, is there a way to inspect OLD and NEW to see what columns are
there and see what has changed? If so, you may not be able to grab the
actual query but you could create a generic trigger that
: Monday, May 03, 2004 10:36 PM
Subject: [SQL] start
Hello list.
I have difficulties starting the postmaster automatically at boot time
(everything I tried is done by 'root').
Can someone give me an example for LINUX (SUSE 8).
Many thanks.
Henk Sanders
Hello list.
I have difficulties starting the postmaster automatically at boot time
(everything I tried is done by 'root').
Can someone give me an example for LINUX (SUSE 8).
Many thanks.
Henk Sanders
---(end of broadcast)---
TIP 8: explain
H.J. Sanders wrote:
I have difficulties starting the postmaster automatically at boot
time (everything I tried is done by 'root').
Can someone give me an example for LINUX (SUSE 8).
Maybe you would rather want to download the binary packages, which take
care of that. RPMs for SuSE are
I am running postgresql 7.4.1 on OS X 10.3 and am having to manually
start-up postgresql using /usr/local/pgsql/bin/postmaster -i -D
/usr/local/pgsql/data.
Is there a script available which will enable me to automate this
process, so that postgres loads up at startup?
Uzo
Look at /etc/
beyaRecords - The home Urban music wrote:
Kaloyan,
thanks for reply. Still finding my way around the unix environment so
could you tell me where the file you mention is situated?
On 8 Jan 2004, at 13:24, Kaloyan Iliev Iliev wrote:
This is what I have in my rc.local on FreeBSD:
Hi,
I've found my own answer... this is in case somebody needs it someday,
it seems that works properly in PG 7.3, one function gives the start of
the week and the other one the end:
CREATE OR REPLACE FUNCTION weekstart(int4,int4)
RETURNS TIMESTAMP
AS'
DECLARE
year ALIAS FOR $1;
How do I get the start and end date of the present week?
Is this possible?
For example this week
Start = Sept. 22
End = Sept. 28
Thank you very much.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Thu, Sep 26, 2002 at 18:56:46 +0800,
John Sebastian N. Mayordomo [EMAIL PROTECTED] wrote:
How do I get the start and end date of the present week?
Is this possible?
For example this week
Start = Sept. 22
End = Sept. 28
The following advice will work on 7.3. For 7.2.2 and
How about:
select now() - date_part( 'DOW', now()) as starts_on,
now() -date_part( 'DOW', now()) + 6 as ends_on;
John Sebastian N. Mayordomo wrote:
How do I get the start and end date of the present week?
Is this possible?
For example this week
Start = Sept. 22
End = Sept. 28
On Thu, Sep 26, 2002 at 11:55:48 -0400,
Jean-Luc Lachance [EMAIL PROTECTED] wrote:
How about:
select now() - date_part( 'DOW', now()) as starts_on,
now() -date_part( 'DOW', now()) + 6 as ends_on;
That won't work in 7.3.
The following works in both 7.2 and 7.3:
area= select
Does any one know what is the reason not to put this logic into date_trunc () function?
It seems to work with pretty much *any* unit imaginable, *except* for 'week'...
Dima
Bruno Wolff III wrote:
On Thu, Sep 26, 2002 at 11:55:48 -0400,
Jean-Luc Lachance [EMAIL PROTECTED] wrote:
How about:
When you create a SEQUENCE, you are allowed to specify a START. Is
there a way to specify a START if you use a serial type in a CREATE
TABLE statement?
I'm envisioning something like:
CREATE TABLE foo ( foo_idserial ( 101 ) );
---(end of
41 matches
Mail list logo