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 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 appreciate if some one can help me in this regard.   Thank you all, Regards, Somasekhar Bangalore Princip

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

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 ht/Di

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 Postgre

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 cygwi

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

[ADMIN] postgres

2003-09-05 Thread pandeysamant sinha
After starting the postgresql service how to enter into it and make a database.how to create a user. when i am giving createuser its working but not with CREATE USER .please make me understand the architecture of postgres. also we are migrating from the oracle to postgres. how to go about it.an

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 Douglas&Douglas has been very usefull to me... Thanks a lot. Gvre ---(end o

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 b

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 app

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-

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

[ADMIN] unsubscribe

2003-09-05 Thread Rodrigo De la Peña
[ADMIN] unsubscribe _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---(end of broadcast)--- TIP 2: you can g

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 a

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/1241235&mode=thread&tid=131&tid=137&tid=189&tid=198 Regards Gaetano Mendola ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/

[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