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 and the rest was my own stuff would I

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 copyright

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 completes

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 against

[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 |

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. I think it's because your UPDATE

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 the

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 post -

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 name field isn't unique so I made an index

[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

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 fields. 1) on name 2

[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

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 with a name field and a serial field. The name