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
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
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 ?
>
>
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
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
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
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
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
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
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
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
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
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
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-
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
_
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
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
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)--
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])
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,
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/
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
22 matches
Mail list logo