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

2004-12-02 Thread Jim Seymour
Chris Green <[EMAIL PROTECTED]> wrote: > > On Thu, Dec 02, 2004 at 01:59:07AM -0500, Greg Stark wrote: > > > > > > (On that note I would dearly love to get rid of the stupid "[GENERAL]" > > "[HACKERS]" etc tags? ... [snip] > > > I absolutely agree I hate the damn things with a passion. >

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

2004-11-29 Thread Jim Seymour
Chris Green <[EMAIL PROTECTED]> wrote: > > On Sun, Nov 28, 2004 at 07:34:28PM -0400, Marc G. Fournier wrote: > > > > What is the general opinion of this? I'd like to implement it, but not so > > much so that I'm going to beat my head against a brick wall on it ... > > > Personally I'm against

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

2004-11-28 Thread Jim Seymour
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > > What is the general opinion of this? I'd like to implement it, but not so > much so that I'm going to beat my head against a brick wall on it ... The procmail rules I set up for each mailing list to which I subscribe sets Reply-To to the mail

Re: [GENERAL] off Topic: Looking for a good sql query

2004-11-25 Thread Jim Seymour
Jamie Deppeler <[EMAIL PROTECTED]> wrote: > > Hi, > > This post is a bit off topic im looking a good sql book can someone give > me a recommendation? I was pleased with... The Practical SQL Handbook Third Edition Judith S. Bowman, Sandra L. Emerson, & Marcy Darnovsky Addison-Wesley Developers

Re: [GENERAL] pg_dumpall + restore = missing view

2004-11-23 Thread Jim Seymour
"Thomas F.O'Connell" <[EMAIL PROTECTED]> wrote: > > For the record, you shouldn't have needed to do a dump restore between > 7.4.1 and 7.4.6 should you? IIRC, it was 7.4.1 -> 7.4.2 that required either that or some manual fixing-up. Jim ---(end of broadcast)

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Jim Seymour
"\"Marc G. Fournier From\"@svr1.postgresql.org"@linxnet.com: <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] (Jim Seymour) writes: > > >Here's another factoid for you. When a new big-8 newsgroup is > >approved, an "official"

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Jim Seymour
Tom Lane <[EMAIL PROTECTED]> wrote: > [snip] > > Personally I think Marc should have waited awhile longer to see whether > the news.groups process would produce a positive vote, but that's just > my own $0.02. That's the way *I* would've preferred to see it handled. Then again: *I* was lookin

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Jim Seymour
"Gary L. Burnore" <[EMAIL PROTECTED]> wrote: > [snip] > > It's ok. Mysql's better anyway. Was that absolutely necessary? Jim ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Jim Seymour
Patrick B Kelly <[EMAIL PROTECTED]> wrote: > [snip] > > Marc appears to be the only one NOT making this situation worse. Appearances can be deceiving--particularly when you're unfamiliar with the territory. > Let's > review. Si

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Jim Seymour
"Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > [I had written] > > > > Did you warn the proponent of comp.databases.postgresql.* that you were > > going to do this? Did you read any of the arguments for and against a > > completely separate hierarchy that were posted to the RFD thread in > > new

Re: [GENERAL] Upcoming Changes to News Server ...

2004-11-23 Thread Jim Seymour
"Marc G. Fournier" <[EMAIL PROTECTED]> wrote: > > > Due to recent action by Google concerning the comp.databases.postgresql.* > hierarchy, we are going to make some changes that should satisfy just > about everyone ... over the next 24hrs or so, traffic *to* > comp.databases.postgresql.* from

Re: [GENERAL] Bug in queries ??

2004-11-23 Thread Jim Seymour
"Joost Kraaijeveld" <[EMAIL PROTECTED]> wrote: > > Hi all, > > > I have three questions about 1 table > > CREATE TABLE public.logs > ( > rule_name varchar(32) NOT NULL, > bytes int8 NOT NULL, > pkts int8 NOT NULL, > hostname varchar(100), > that_time int4 NOT NULL > ) WITH OIDS; > >

Re: [GENERAL] pgEdit public beta for Macintosh and Windows

2004-11-19 Thread Jim Seymour
John DeSoi <[EMAIL PROTECTED]> wrote: > > The first public beta for pgEdit is now available ... [snip] > > * Cross platform and easy to install > > pgEdit is a native application for both Macintosh and Windows. That's what you call "cross-platform," eh? >

Re: [GENERAL] "q" with psql display paging dumps out of psql

2004-11-15 Thread Jim Seymour
Tom Lane <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] (Jim Seymour) writes: > > I recently upgraded from 7.4.2 to 7.4.6 and have run into a new > > problem. As frequently as not, maybe even most times, when I "q" out > > of paging the output of a quer

[GENERAL] "q" with psql display paging dumps out of psql

2004-11-15 Thread Jim Seymour
Hi, Environment: SunOS 5.7 Generic_106541-29 sun4u sparc SUNW,UltraSPARC-IIi-Engine Postgresql-7.4.6 Build config: --with-java --enable-thread-safety gcc version 3.3.1 less-381 readline-4.3 $ echo $PAGER /usr/local/bin/less $ echo $LESS -e I recently

Re: [GENERAL] Where are all the users?

2004-08-06 Thread Jim Seymour
Kay-Uwe Genz <[EMAIL PROTECTED]> wrote: > > Hi @ all, > > I want to reference the User-ID PG use as an FOREIGN KEY in a tabel of > my DB. But I saw that pg_user is a view. Where are the information I > need? Maybe you could \d the view and find out? *But* you have to have the proper permissi

Re: [GENERAL] How to use as Functional Index to be used as Primary KEY

2004-08-02 Thread Jim Seymour
Janning Vygen <[EMAIL PROTECTED]> wrote: > [snip] > > Thanks to Tom and Peter for your answers. I will design my table without a > primary key and use my unique index instead of a primary key. As this unique > key is the same as a primary key i dont see the reason why postgresql > should't ext

Re: [GENERAL] mirroring data on different drives?

2004-07-29 Thread Jim Seymour
Steve <[EMAIL PROTECTED]> wrote: > > Someone please please help me :-( [snip] Relax, Steve. The people helping-out on PostgreSQL mailing lists are in 24 timezones, have real jobs (for which they actually get paid), are all volunteers (for which they don't get paid), may be going to school, t

Re: [GENERAL] no value fetch

2004-07-28 Thread Jim Seymour
Stephan Szabo <[EMAIL PROTECTED]> wrote: > > > On Tue, 27 Jul 2004, BRINER Cedric wrote: > > > hi, > > > > Imagine that I have the following table where ts_sent is a timestamp(0) > > > > select * from notification; > > to_used| ts_sent | from > > -

Re: [GENERAL] Sql injection attacks

2004-07-25 Thread Jim Seymour
Bill Moran <[EMAIL PROTECTED]> wrote: > [snip] > > Simply put: > 1) If the untrusted value is a string, using a proper escape sequence should >make it safe. > 2) If the untrusted value is not a string, then it should be tested for >proper value (i.e. if it should be a number, it should be

Re: [GENERAL] installation: cc and gcc how to?

2004-07-17 Thread Jim Seymour
=?iso-8859-1?q?Nilabhra=20Banerjee?= <[EMAIL PROTECTED]> wrote: > > > Thanks a lot.. This much is enough for meIf I get > some time afterwards I go thru it again But I am > still curious to know about the CFlags variable..what > are the other values it can take. The pgsql tarball include

Re: [GENERAL] Do we need more emphasis on backup?

2004-07-11 Thread Jim Seymour
Doug McNaught <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] (Jim Seymour) writes: > > > Oh, if you're accepting punctuation nits ;), in most cases, the comma > > should come after "but," not before it. So your sentence should read > > "P

Re: [GENERAL] Do we need more emphasis on backup?

2004-07-11 Thread Jim Seymour
t before it. So your sentence should read "PostgreSQL will run on almost any hardware but, if you are..." If you wanted to mention other issues to consider, you might include: > > ------- > > Jim Seymour

Re: [GENERAL] Do we need more emphasis on backup?

2004-07-06 Thread Jim Seymour
Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > On Tue, Jul 06, 2004 at 08:32:15AM -0400, Jim Seymour wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> wrote: > > > > Should I add an FAQ discussing hardware selection and the importance of > > > reliab

Re: [GENERAL] Do we need more emphasis on backup?

2004-07-06 Thread Jim Seymour
Bruce Momjian <[EMAIL PROTECTED]> wrote: > > pgman wrote: > > Jim Seymour wrote: [snip] > > > > > > My position is that your data is only as reliable as your hardware, > > > period. [snip] > > > > There is a basic misconception that

Re: [GENERAL] Do we need more emphasis on backup?

2004-06-23 Thread Jim Seymour
Tom Lane <[EMAIL PROTECTED]> wrote: > [snip] > > We do need to point out that you're only as reliable as your last > backup. I'm not sure exactly where to say this. [snip] > Hmph. Backups are for mitigation against a catastrophic failure destroying or corrupting main storage. And even then:

Re: [GENERAL] [HACKERS] Release 7.4.3 branded

2004-06-15 Thread Jim Seymour
Tom Lane <[EMAIL PROTECTED]> wrote: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Release is scheduled for Monday. > > I'd like to remind people that the pre-release tarball is available from > the ftp servers under /pub/stable_snapshot ... I find nothing under pub/stable_snapshot. I do fi

Re: [GENERAL] perl access

2004-06-14 Thread Jim Seymour
Tom Allison <[EMAIL PROTECTED]> wrote: > > I'm stuck on something stupid. > > I'm trying to use perl to open up a database handle and I can't find the > right database dsn string. > > my $data_source = "dbi:Pg:mydatabase"; > my $username = "mydatebasereader"; > my $auth = "secret"; > > my $dbh

Re: [GENERAL] Prevent users from creating tables

2004-06-08 Thread Jim Seymour
"Campano, Troy" <[EMAIL PROTECTED]> wrote: > > Hello, > I'm trying to set up PostgreSQL for proof of concept according to our > standards. > I need to create a user for database01 that has the ability to create > any objects they want. > They can create tables, views, indexes, etc. > > Then I n

Re: [GENERAL] Multiple databases on seperate drives/file systems?

2004-06-08 Thread Jim Seymour
"Scot L. Harris" <[EMAIL PROTECTED]> wrote: > [snip] > > Yes I have tried it without quoting the PGDATA2. Same result. > > I have also tried the full path but the flag is apparently not set to > allow that. > > Besides the error I am getting it appears to me that postmaster would > not be able

Re: [GENERAL] set autocommit TO FALSE on postgres 7.4

2004-05-03 Thread Jim Seymour
> > Dear Friends > > As Subject > > How to resolve, since i use with out problem on postgresql 7.3 Don't know, being as I know I've turned off autocommit within Perl, and I'm *fairly* sure I've done so playing around with psql, and it&

Re: [GENERAL] [OT] Tom's/Marc's spam filters?

2004-04-22 Thread Jim Seymour
o accomplish this. But, again, your backup MX is probably doing no more for you than causing you to agonize over which different way to break the mail system or irritate unwitting, innocent 3rd parties ;). Better to just rid yourself of the backup MX, IMO. -- Jim Seymour

Re: [GENERAL] ident authentication problem

2004-04-22 Thread Jim Seymour
> > Jim Seymour wrote: > > Karsten Hilbert <[EMAIL PROTECTED]> wrote: > >>If you follow this sage advice you'll open up your financial > >>data to anyone happening to have an account on the machine in > >>question. Anyone. Not just people wh

Re: [GENERAL] Basix for Data General / Basix for Sco Unix

2004-04-15 Thread Jim Seymour
operating system, IIRC. I actually was nearly a UniVerse DBA. Until the company for which I worked at the time ran out of money before finishing the deployment of their new ERP system. Took classes at a place called JES. -- Jim Seymour| Spammers sue anti-spammers: [EMAIL PROTECTE