Re: [ADMIN] Postgresql book

2003-09-05 Thread Kaarel
I want to buy a book for postgresql administration but i do not know which one. Can anybody suggest me one? You might also want to see http://www.postgresql.org/docs/awbook.html and http://www.commandprompt.com/ppbook/book1.htm for not so recent but still useful books. Kaarel

[ADMIN] Blob Data type in postgres ?

2003-09-05 Thread Somasekhar Bangalore
Hi , I would like tocreate a table with blob as a datatype.I found that postgres doesn't have a datatype called BLOB. Is there any equivalent data type for this or a short cut ? I appreciate if some one can help me in this regard. Thank you all, Regards, Somasekhar Bangalore Principal

Re: [ADMIN] Blob Data type in postgres ?

2003-09-05 Thread Andreas Schmitz
have a look at bytea regards -andreas On Friday 05 September 2003 12:41, Somasekhar Bangalore wrote: Hi , I would like to create a table with blob as a datatype.I found that postgres doesn't have a datatype called BLOB. Is there any equivalent data type for this or a short cut ? I

Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

2003-09-05 Thread Ang Chin Han
Marc G. Fournier wrote: okay, first off ... what URL? I've been working on, and testing, archives all week, and altho getting things down below a 2min search appears to be near impossible (anyone know something *better* then mnogosearch that will handle 250k URLs and growing ... ? we tried

Re: [ADMIN] Blob Data type in postgres ?

2003-09-05 Thread Jouneau Luc
As far as I am concerned, I think that lobs are managed in postgres with oid. Create your table like this : CREATE TABLE table_of_lobs ( title varchar(100), content_reference oid); content_reference is a handler on lobs data contained in specials postgres system tables called Toast. Create

Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

2003-09-05 Thread Robert Treat
Personally I'd like to see effort go into getting fts.postgresql.org back up and going; I've always had better results searching their. Robert Treat On Thu, 2003-09-04 at 14:38, Marc G. Fournier wrote: k, try the search engine now ... I just found a 'missing index' on one of the critical

Re: [ADMIN] age of statistics

2003-09-05 Thread colin roald
Quoth colin roald [EMAIL PROTECTED]: Is there a way to query the database to find out how old the current table statistics are? That is, when the ANALYZE command was last run on a given table? It seems like there ought to be a table somewhere in pg_catalog I can't find it in the PostgreSQL

Re: [ADMIN] Problem under Cygwin after Cygwin update

2003-09-05 Thread Thomas Wegner
Hello, the problem is nor longer a problem. Now run fine. I forget to deinstall ipc-daemon v1. After i do this an install the ipc-daemon2 as service, all run fine! -- Thomas Wegner Thomas Wegner [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED] Hello, today i updated my cygwin

Re: [ADMIN] Postgresql book

2003-09-05 Thread Chris Lowth
Giannis Vrentzos [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hi all. I want to buy a book for postgresql administration but i do not know which one. Can anybody suggest me one? Thanks Gvre Try http://www.lowth.com/books/browse/postgresql for a list of the top seller

Re: [ADMIN] Postgresql book

2003-09-05 Thread Giannis Vrentzos
Tom Van den Brandt wrote: Giannis Vrentzos wrote: Hi all. I want to buy a book for postgresql administration but i do not know which one. Can anybody suggest me one? Thanks Gvre Postgresql by DouglasDouglas has been very usefull to me... Thanks a lot. Gvre ---(end

Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

2003-09-05 Thread Marc G. Fournier
On Fri, 5 Sep 2003, Robert Treat wrote: Personally I'd like to see effort go into getting fts.postgresql.org back up and going; I've always had better results searching their. As far as I know, the database side is ready for them, and Teodor has the information, but I suspect that beta is

Re: [ADMIN] YOUR SITES SEARCH FEATURE DOES NOT WORK!

2003-09-05 Thread Marc G. Fournier
check the archive search now and let me know if you find it still doesn't work ... On Fri, 5 Sep 2003, Ang Chin Han wrote: Marc G. Fournier wrote: okay, first off ... what URL? I've been working on, and testing, archives all week, and altho getting things down below a 2min search appears

Re: [ADMIN] [GENERAL] How can I set postmaster as a service

2003-09-05 Thread shreedhar
It is RHLinux 7.3. - Original Message - From: Reid Thompson [EMAIL PROTECTED] To: shreedhar [EMAIL PROTECTED] Sent: Friday, September 05, 2003 6:49 PM Subject: RE: [GENERAL] How can I set postmaster as a service what operating system reid -Original Message- From:

Re: [ADMIN] LOCK has IGNORED on trigger.

2003-09-05 Thread Bruno Wolff III
On Thu, Sep 04, 2003 at 13:59:21 +0700, Yudha Setiawan [EMAIL PROTECTED] wrote: Dear Expert, I got a trouble with LOCK on my table (Inquery table). I've put the LOCK (using select bla.bla for update) on trigger(trigger insert) of Table_A. It's work properly. when i tried insert into

Re: [ADMIN] Postgresql book

2003-09-05 Thread Randall Perry
The O'Reilly book is good. That and the manuals should be all you need -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Development/Promotion Mac Consulting/Sales http://www.systame.com/ ---(end of broadcast)--- TIP 1: subscribe

Re: [ADMIN] age of statistics

2003-09-05 Thread Tom Lane
colin roald [EMAIL PROTECTED] writes: It seems like there ought to be a table somewhere in pg_catalog with a date in it, but I can't find it. That's because there isn't one ... regards, tom lane ---(end of broadcast)---

[ADMIN] Slackware

2003-09-05 Thread Sidar Lopez
Where can I get PostgreSQL for Slackware 9. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [ADMIN] Postgresql book

2003-09-05 Thread Al Hulaton
On Fri, 2003-09-05 at 08:50, Randall Perry wrote: The O'Reilly book is good. That and the manuals should be all you need I personally use the O'Reilly book (you can even search it on our site, although it covers pgsql 7.1), Bruce Momjian's book and the techdocs in the /doc directory. -- Best,

[ADMIN] New file system based on Postgres

2003-09-05 Thread Mendola Gaetano
http://developers.slashdot.org/article.pl?sid=03/09/05/1241235mode=threadtid=131tid=137tid=189tid=198 Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[ADMIN] How can I set postmaster as a service

2003-09-05 Thread shreedhar
How can I set postmaster (database on) as a service and set it while system booting if self? Regards Sreedhar Bhaskararaju ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster