[GENERAL] datatype for indexable char field larger than 256

2001-07-07 Thread Thomas T. Thai
i'm parsing DMOZ data files, and i need to store the path and later reference it to get the associated CatID to store for the parent of the child paths. however, some of the paths are larger than 500 chars. would a WHERE clause like this: ... WHERE path='top/this/really/long/500/char/path' w

[GENERAL] Re: A quick SUSE question...

2001-07-07 Thread Peter C. A. Bär
No such place, I am afraid. Valuable information can be found in the file README.rpm-dist in the download area for the source RPMs. However, I haven't been able to compile the source RPMs with all the options I want (and these are just the defaults, but there's a problem with the --with-ssl op

Re: [GENERAL] trigger: NEW/OLD-error or nothing happens

2001-07-07 Thread Joe Conway
> create function nac_viceversa() returns opaque as' > begin > NEW.minport := nacmin(OLD.sport,OLD.dport); > NEW.maxport := nacmax(OLD.sport,OLD.dport); > return NEW; > end; > 'language 'plpgsql'; > > create trigger nac_update after insert or update on traf > for each row execute procedure nac_vic

Re: [GENERAL] RedHat Open Database?

2001-07-07 Thread Ryan Mahoney
Read the message archives ;) -r At 06:30 PM 7/7/01 +, Dr. Evil wrote: >I saw an announcement somewhere that RedHat is working on its own Open >Database, based on PG. What do people think about this? > >---(end of broadcast)--- >TIP 2: you c

[GENERAL] RedHat Open Database?

2001-07-07 Thread Dr. Evil
I saw an announcement somewhere that RedHat is working on its own Open Database, based on PG. What do people think about this? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister You

Re: [GENERAL] Bad news for Open Source databases, acording to survey

2001-07-07 Thread Ryan Mahoney
This article appears to be a pretty weak opinion piece - the author has little understanding of PostgreSQL and the support infrastructure that exists. The article makes numerous references to mysql which is clearly the low end of the Open Source database market. Postgres is very close to wher

Re: [GENERAL] PostgreSQL perl / libpq.so.2 problem - again :(

2001-07-07 Thread Justin Clift
Hi all, Are you familiar with Symantec Ghost? The way I work I keep fresh installed versions of Mandrake 8.0, Win NT (with SP6a), Solaris 8.0 INTEL, etc, as compressed image files. When it comes time to build software on a "freshly installed" machine it takes just under 10 minutes to restore th

[GENERAL] RE: Bad news for Open Source databases, acording to survey

2001-07-07 Thread Ken Kachnowich
Sounds like some spin from Oracle, IBM or Mico$oft. Never trust what you read on the net (including THIS e-mail). >From personnel experience (never to be trusted either) I would say that Postgres experience is a good item to have on your resume. Ken > Here is an article saying open source d

[GENERAL] Re: [HACKERS] 2 gig file size limit

2001-07-07 Thread Lamar Owen
On Friday 06 July 2001 18:51, Naomi Walker wrote: > If PostgreSQL is run on a system that has a file size limit (2 gig?), where > might cause us to hit the limit? Since PostgreSQL automatically segments its internal data files to get around such limits, the only place you will hit this limit wil

[GENERAL] pg_dump error message

2001-07-07 Thread Joseph
Trying to do a dump I get this error: pg_dump -v database > backup -- last builtin oid is 1 -- reading user-defined types -- reading user-defined functions -- reading user-defined aggregates getAggregates(): SELECT failed. Explanation from backend: 'ERROR: Attribute 'aggtransfn1' not found '