Original 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, Ju
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.
-
> > 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 al
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 askin
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 bo
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 databa
Of Andrew Sullivan
> Sent: 27 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 woul
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
> sepa
age-
> 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:
>
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
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 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 b
> 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 goa
Best Regards,
Fotis
> -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:3
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,
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,
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 fi
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 rewritte
D]
> [mailto:[EMAIL PROTECTED] On Behalf Of Forums @
> Existanze
> 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
> solv
s
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of George Weaver
> Sent: 23 June 2006 15:38
> To: Forums @ Existanze
> Cc: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> Hi Fotis,
&
> 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 th
lumns).
Regards,
George
- Original Message -
From: "Forums @ Existanze" <[EMAIL PROTECTED]>
To:
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 "generi
pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> > 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
> 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 recons
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 pos
c: pgsql-sql@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
A
D]] On Behalf Of Forums @
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 s
PROTECTED] On Behalf Of Forums @
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 f
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
TED]>
To: <[EMAIL PROTECTED]>
Sent: 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
On Mon, 3 May 2004, H.J. Sanders wrote:
>
> 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).
Just FYI, this probably belongs on admin, but no biggie.
I sta
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 av
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 an
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:
su
On Thursday 08 January 2004 13:59, beyaRecords - The home Urban music wrote:
> 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 auto
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
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;
Hi,
how can I get the first and last day of a week given the year and the
week number ???
example
week 3 of 2003 starts in Jan 12th and ends on Jan 18th.
how to know the last two values given the year and the number of week ?
thanks.
Best Regards.
--
Luis Magaña.
Gnovus Networks & Software
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
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 curre
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
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.
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]
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 broadcast)-
44 matches
Mail list logo
