Re: [GENERAL] Automating backup

2006-02-06 Thread Neil Dugan
Richard Sydney-Smith wrote: Hi Doug. Many users are haphazard in their approach until the machine fails and then they expect to be pulled from the poo. Done it too many times. I now will get the application to enforce an additional integrity check. It must be backed up or else! Seems futile

Re: [GENERAL] License question[VASCL:A1077160A86]

2005-10-12 Thread Neil Dugan
On Thursday 06 October 2005 08:34, Jim C. Nasby wrote: > On Wed, Oct 05, 2005 at 04:14:03PM -0400, Andrew Sullivan wrote: > > On Wed, Oct 05, 2005 at 09:49:06PM +1000, Neil Dugan wrote: > > > If I was to develop a 'C' project that only used the libpg.so library > &g

Re: [GENERAL] License question[VASCL:A1077160A86]

2005-10-05 Thread Neil Dugan
On Wednesday 05 October 2005 06:41, Aaron Glenn wrote: > On 10/4/05, Welty, Richard <[EMAIL PROTECTED]> wrote: > > Aaron Glenn wrote: > > >Completely incorrect. You can do whatever you like with PostgreSQL; > > >you just can't sue anyone when things go south. > > > > _and_ you need to preserve the

Re: [GENERAL] help me pls

2005-09-19 Thread Neil Dugan
On Monday 19 September 2005 07:08 am, Sean Davis wrote: > On 9/19/05 12:02 AM, "suresh ramasamy" <[EMAIL PROTECTED]> wrote: > > thanks for the info Devrim, > > > > by the way i'm newbie, i have followed the steps in the documentation for > > compiling and installation. I'm using FC4. ./cofigure c

Re: [GENERAL] Asychronous database replication

2005-09-18 Thread Neil Dugan
On Friday 16 September 2005 07:28 am, John DeSoi wrote: > On Sep 15, 2005, at 9:54 PM, Greg Stark wrote: > > If you need data to propagate from the clients back to the server > > then things > > get more complicated. Even then you could side step a lot of > > headaches if you > > can structure the

Re: [GENERAL] [SQL] dynamically loaded functions

2005-07-20 Thread Neil Dugan
On Wed, 2005-07-13 at 10:24 -0700, TJ O'Donnell wrote: > > > > It sounds like you need to link gnova.so against the other shared > > objects so the runtime linker can find them. For examples, see the > > Makefiles used by contributed modules like dblink, xml2, and a few > > others that link a

Re: [GENERAL] funny update, say update 1, changed 2 records.

2005-06-11 Thread Neil Dugan
On Sat, 2005-06-11 at 13:29 -0400, Tom Lane wrote: > Neil Dugan <[EMAIL PROTECTED]> writes: > > I have been having some trouble with a particular table view. An UPDATE > > command is not only changing the applicable record it is also creating a > > new record as well

[GENERAL] funny update, say update 1, changed 2 records.

2005-06-11 Thread Neil Dugan
I have been having some trouble with a particular table view. An UPDATE command is not only changing the applicable record it is also creating a new record as well. wholesale=# select * from accounts_supplier; id | name | contact | addr| addr2 | town | postcode | s

Re: [GENERAL] table synonyms

2005-05-28 Thread Neil Dugan
On Tue, 2005-05-24 at 19:48 +0200, Tino Wildenhain wrote: > Am Dienstag, den 24.05.2005, 13:49 -0300 schrieb [EMAIL PROTECTED]: > > It will be a very pleasant idea. Although I am > > an application developer I don't know if I have > > enough knowledge to do that. Do you know how could > > I help t

Re: [GENERAL] PostgreSQL still for Linux only?

2005-03-10 Thread Neil Dugan
On Thu, 2005-03-10 at 16:19 +, Tope Akinniyi wrote: > Hi all, > --- cut --- > > I sought Windows replication tool for and could not get. I checked > PgFoundry and the one there put a banner and said NOT FOR WINDOWS. > Then I said is this PostgreSQL for Windows a joke? That prompted > my p

Re: [GENERAL] possible bug with compound index.

2005-02-13 Thread Neil Dugan
On Sun, 2005-02-13 at 20:40 -0800, Stephan Szabo wrote: > On Mon, 14 Feb 2005, Neil Dugan wrote: > > > I am using PostgreSQL 7.4.7 > > I have a table with serveral fields two of these are a serialno > > (bigserial) and name(varchar). I have created two indexs on these &

[GENERAL] possible bug with compound index.

2005-02-13 Thread Neil Dugan
I am using PostgreSQL 7.4.7 I have a table with serveral fields two of these are a serialno (bigserial) and name(varchar). I have created two indexs on these fields. 1) on name 2) on name,serialno if I use the command 'select * from table order by name limit 1' everything is OK if I use th

Re: [GENERAL] find next in an index

2005-02-13 Thread Neil Dugan
On Sun, 2005-02-13 at 01:24 -0500, Greg Stark wrote: > Neil Dugan <[EMAIL PROTECTED]> writes: > > > Hi, > > I am trying to find out how to get the next record according to a > > particular index. > > I have a table with a name field and a serial field. The n

Re: [GENERAL] find next in an index

2005-02-12 Thread Neil Dugan
On Sat, 2005-02-12 at 21:47 -0600, Bruno Wolff III wrote: > On Sun, Feb 13, 2005 at 14:03:02 +1100, > Neil Dugan <[EMAIL PROTECTED]> wrote: > > Hi, > > I am trying to find out how to get the next record according to a > > particular index. > > I have a table

[GENERAL] find next in an index

2005-02-12 Thread Neil Dugan
Hi, I am trying to find out how to get the next record according to a particular index. I have a table with a name field and a serial field. The name field isn't unique so I made an index on name(varchar) & serialno(bigserial). I also have an index just on 'name'. I am having trouble working out