Re: [GENERAL] postgresql replication

2005-05-04 Thread Richard Welty
cally duplicating a large database, it's generally the wrong answer. you should probably focus on single master/multi slave setups, there are useful solutions in that space. richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking Java, PHP

Re: [HACKERS] [GENERAL] Adding Reply-To: to Lists configuration ...

2004-11-29 Thread Richard Welty
ning internet mailing lists since 1985 -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security --

Re: [GENERAL] Front Ends

2004-11-26 Thread Richard Welty
my current contracting gig (at the firm which handles NYS and much NYC tax processing on an outsourced basis.) so yes, i'd say you can make this sort of stuff work well in production. richard -- Richard Welty [EMAIL PROTECTED] Averill

Re: [GENERAL] Lionel Lauer 58 Gore Street Fitzroy, Victoria Australia 3065

2004-11-11 Thread Richard Welty
't worry about it. the lists are being "k00ked". ignore it while the list administrator takes the necessary actions. anything that doesn't make sense is almost certainly a spoofed mail sent by our friendly neighborhood k00k. richard -- Richard Welty

Re: [GENERAL] PostgreSQL 8.0 Feature List?

2004-08-12 Thread Richard Welty
On Thu, 12 Aug 2004 14:36:13 -0400 Vivek Khera <[EMAIL PROTECTED]> wrote: > >>>>> "RW" == Richard Welty <[EMAIL PROTECTED]> writes: > RW> i'm quite experienced in C and Java, so it's going to be in one of > RW> those two. any comments

Re: [GENERAL] PostgreSQL 8.0 Feature List?

2004-08-11 Thread Richard Welty
d reportedly flakey) variant on tcl. i'm quite experienced in C and Java, so it's going to be in one of those two. any comments from anyone on the language choice? sigh, richard -- Richard Welty [EMAIL PROTECTED] A

Re: [GENERAL] Anyone using pgreplicator?

2004-04-29 Thread Richard Welty
nality point of view, it's closer to what i want than any of the others, but it's been frustrating as hell to try and get going. richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592

Re: [GENERAL] I want to use postresql for this app, but...

2004-02-12 Thread Richard Welty
context of OpenBSD) that seems apropos: "Free means free" richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix, Linu

Re: [GENERAL] fsync = true beneficial on ext3?

2004-02-08 Thread Richard Welty
ls only filesystem metadata, > not the contents of files. by default, it journals everything, but you can set it to journal metadata only, i think with the mount option data=writeback. do a "man mount" and look for ext3 options for details on the data= option. richard -- Richard Welty

Re: [GENERAL] sql insert function

2004-01-12 Thread Richard Welty
7; LANGUAGE SQL; i do believe you need to double up the single quotes inside the function body, e.g. (''$1'',$2,''$3'',$4,$5); otherwise, the quote before the $1 ends up terminating the function body. richard -- Richard Welty

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-28 Thread Richard Welty
On Fri, 28 Nov 2003 22:19:51 -0500 (EST) Richard Welty <[EMAIL PROTECTED]> wrote: > On Fri, 28 Nov 2003 18:33:37 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote: > > I know we have updated our license in the past, particularly to remove > > the advertizing c

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-28 Thread Richard Welty
gree that the OpenBSD interpretation is pretty severe, but in light of the current legal shenanigans with respect to some other open source projects, i think there is some merit to the severity. richard -- Richard Welty [E

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-28 Thread Richard Welty
On Fri, 28 Nov 2003 17:58:19 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote: > OK, where did you get this wording? Is this something Berkeley released > as one of their versions of the BSD license. yes, i believe that it originally came from the Berkeley lawyers. richard -- R

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-28 Thread Richard Welty
On Fri, 28 Nov 2003 17:23:56 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote: > Richard Welty wrote: > > but you can consult with the attorneys for the Regents. they have > > changed the license at times, and have passed those changes on > > to other BSD license

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-28 Thread Richard Welty
ent Group is, though. it might end up meaning each individual, if it's not an actual corporation. there's no substitute for an informed legal opinion on this subject. is one available? richard -- Richard Welty [EMAIL PROTECTED] Averill Park Net

Re: [GENERAL] [ADMIN] Misplaced modifier in Postgresql license

2003-11-28 Thread Richard Welty
to the trouble to talk to the IP lawyers for the Regents, you may find that you can easily get permission to migrate the license to the current "BSD License". richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networ

Re: [GENERAL] embedded postgresql + C++ IDE

2003-11-17 Thread Richard Welty
#x27;t really integrated; i find myself editing C++, saving it, and going to a shell window to run the makefile, which isn't nearly as slick as when i do java development in the IDE. richard -- Richard Welty [EMA

Re: [GENERAL] Porting Code to Postgresql

2003-10-15 Thread Richard Welty
ldn't make a difference; in php, the condition on a for() should be at the top of the loop anyway. richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix

Re: [GENERAL] Porting Code to Postgresql

2003-10-15 Thread Richard Welty
ome versions of the php->postgresql interface, while( $row = pg_fetch_object( $result, $row)) { ... } will error at the last row instead of returning a false value. you need to do: $count = pg_numrows( $result); for( $i = 0; $i < $count; $i++){ $row = pg_fetch_ob

Re: [GENERAL] Humor me: Postgresql vs. MySql (esp. licensing)

2003-10-08 Thread Richard Welty
speed and community > support, as well as ACID support. you should also cite conformity to standards. MySQL is significantly different from SQL standards in a number of regards. not that any are fully conformant, but there are spots where MySQL is seriously "out there&

Re: [GENERAL] PostgreSQL versus MySQL

2003-09-22 Thread Richard Welty
iscussion to offtopic. i've done this for my mailing list server, with good results. of course, rocketry discussions are welcome on [EMAIL PROTECTED], but you'll have to put up with motorheads discussing politics, religion, linux, unix, and SCO (topics which are not always distinguishable fro

Re: [GENERAL] library version problem, 7.3.2, php, redhat linux

2003-09-12 Thread Richard Welty
On Fri, 12 Sep 2003 07:21:19 +0100 (BST) "Nigel J. Andrews" <[EMAIL PROTECTED]> wrote: > On Thu, 11 Sep 2003, Richard Welty wrote: > > > [Thu Sep 11 16:17:25 2003] [notice] caught SIGTERM, shutting down > > PHP Warning: Unable to load dynamic library '/u

[GENERAL] library version problem, 7.3.2, php, redhat linux

2003-09-12 Thread Richard Welty
on't remember php having these issues. so why would php->postgresql access be working on the 7.1 system but not the 8.0 system? thanks, richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7

Re: [GENERAL] move to usenet?

2003-08-20 Thread Richard Welty
now, but is there an easy way > to make Outlook 2000 (not Express) bottom post? there are these powerful tools called mice and arrow keys. i find that they work quite well if you want to bottom post in outlook. cheers, richard -- Richard Welty [E

Re: [GENERAL] indices and cidr/inet type

2003-08-14 Thread Richard Welty
On Tue, 05 Aug 2003 18:46:47 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Richard Welty <[EMAIL PROTECTED]> writes: > > hmmm. where should i go looking for sample code implementing operator > > classes as an example? > > contrib. Specifically, I'd suggest l

Re: [GENERAL] indices and cidr/inet type

2003-08-14 Thread Richard Welty
On Tue, 05 Aug 2003 15:09:00 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Richard Welty <[EMAIL PROTECTED]> writes: > > what type of index is recommended when the dominant lookup on a field > is > > '' << ipblock > > I don't think we have

[GENERAL] indices and cidr/inet type

2003-08-05 Thread Richard Welty
hat type of index is recommended when the dominant lookup on a field is '' << ipblock where the ipblock column is of type cidr? thanks, richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking

Re: [GENERAL] varchar, text and cidr

2003-08-04 Thread Richard Welty
On Mon, 04 Aug 2003 20:07:18 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > Richard Welty <[EMAIL PROTECTED]> writes: > > On Mon, 04 Aug 2003 18:07:49 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > >> You don't have to. See CREATE CAST. > > > cool

[GENERAL] 7.3.4 rpms?

2003-07-28 Thread Richard Welty
ing at building & using dbmirror and it needs to be built in contrib with a source where ./configure has been run. i'm more than a little concerned about getting all the flags to ./configure set right. richard -- Richard Welty [EMAIL PROTECTED]

Re: [GENERAL] How to encrypt data in Postgresql

2003-07-25 Thread Richard Welty
ut this is kind of OT for a postgresql list now... richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

Re: [GENERAL] Are you frustrated with PostgreSQL

2003-07-15 Thread Richard Welty
On Tue, 15 Jul 2003 08:42:27 -0400 (EDT) Richard Welty <[EMAIL PROTECTED]> wrote: > i've played with dbvisualizer, found it useful, then found > that for one particular combination of versions (postgresql & dbvis) it > wouldn't show me all tables. ok, that didn'

Re: [GENERAL] Are you frustrated with PostgreSQL

2003-07-15 Thread Richard Welty
s some significant limitations. and what with the LGPL-GPL licensing change for MySQL 4.1.x, i am tending to recommend that my clients running MySQL consider their transistion strategies to some other product. > > 5. How often do your PostgreSQL run into problem or cra

Re: [GENERAL] Is Postgres broken in Red Hat 9?

2003-07-08 Thread Richard Welty
blem. you can either learn enough about iptables/ipchains to punch a hole, but to make sure that it will solve the problem, try shutting the whole think down first: sudo /etc/rc.d/init.d/ipchains stop sudo /etc/rc.d/init.d/iptables stop after that, see if the network client

[GENERAL] IPv6 data type

2003-07-01 Thread Richard Welty
an IPv6 data type is on the todo list, but it looks like it's been there a while. is there any work being done on this, and is there an ETA? i have a project that could use it, but if it wasn't coming soon (say in 7.4), i can work around it. it'd just be nice and all that. ric

Re: [GENERAL] [pgsql-advocacy] interesting PHP/MySQL thread

2003-06-22 Thread Richard Welty
pport bundled in their core is very important to them. richard -- Richard Welty [EMAIL PROTECTED] Averill Park Networking 518-573-7592 Unix, Linux, IP Network Engineering, Security

[GENERAL] postgresql rpms and jdbc

2001-10-16 Thread Richard Welty
a really quick question: are the postgresql 7.1.3 rpms compiled with jdbc support, or do i need to build from source to get jdbc to work? thanks, richard ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED

Re: [GENERAL] WWW interface for postgres

2001-10-16 Thread Richard Welty
On Tue, 16 Oct 2001 19:41:26 +0900 Karen Ellrick <[EMAIL PROTECTED]> wrote: > Meanwhile, my first question is still valid - it's a spooky feeling to see > your own domain name show up, married with someone else's username, as a > return address on a message that you know neither you (nor anyone el