Re: [GENERAL] Publishing my book

On 29 Jun 00, at 0:57, Bruce Momjian <[EMAIL PROTECTED]> wrote: > http://www.postgresql.org/docs/awbook.html Just curious.will the book always be available here, or will it be taken down once the printed version appears? --Ray. ---

[GENERAL] Regarding editor commands

Hi, What is the equivalent command of "Describe "of Oracle PLSQL editor in Postgres editor .

[GENERAL] Perl script for pg_dumpall?

I would like to write a Perl script that will run pg_dumpall, for backup purposes. I am hoping to run this script via the crontab nightly. My question is does anyone know of any resources that will assist me in the code for this script, or any examples of executing Postgres commands in a Perl scri

[GENERAL] Search engine down ?

Hi, I want to find information into your search engine for postgresql mailing list but I can't find any answer to my search. Typing SELECT or CURSOR or any other words in pgsql-general or pgsql-sql give me no output. Perhaps you have an indexation problem ? Regards

[GENERAL]

Dear PostgreSQL Expert, I'm looking for the help on the PostgreSQL installation matter. Could you give me such an advice or readdress me to some other experienced people? The problem is following. I got the PostgreSQL ver.7.0.2 from the Postgres site and compiled it on HP-UX machine under OS h

Re: [GENERAL] Nested transactions

On Mon, 26 Jun 2000, Andrea Aime wrote: > does postgres support nested transactions? No. -- Peter Eisentraut Sernanders väg 10:115 [EMAIL PROTECTED] 75262 Uppsala http://yi.org/peter-e/Sweden

[GENERAL] 2 phase commit abilities

Hi, I am currently in the process of evaluating DB solutions on Linux, and I need to know if it is possible to do 2-phases-commit with PosgreSQL. I would also need some ideas on performances, so if anybody can share anything n this subject, he/she is welcome !! Thanks in advance, Regar

Re: [GENERAL] disk backups

At 23:36 2/07/00 +1000, Martijn van Oosterhout wrote: > >Some version that came with redhat (6.5.x) (i didn't >install this machine). I'll grab it and see if it >works I'll need to put the 6.5 version on the FTP site first...

Re: [GENERAL] vacuumdb problem

Marcin Inkielman <[EMAIL PROTECTED]> writes: > NOTICE: FlushRelationBuffers(osoby, 228): block 223 is referenced > (private 0, global 1) > FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2 > this table is referenced in my db by a tree of FOREIGN KEYs. Hmm, I wonder whether th

Re: [GENERAL] pg_dumpall and check constraints

Philip Warner wrote: > At 11:33 1/07/00 +0200, Jan Wieck wrote: > > > >Was late for me too, and maybe the answer was too lazy. So > >let me give you an example of what I meant: > > > > About 5 mins after I hit the send button on my last message I realized the > error in my ways (again).

Re: [GENERAL] disk backups

Philip Warner wrote: > > At 23:34 1/07/00 +1000, Martijn van Oosterhout wrote: > > > >> Philip Warner needs alpha testers for his new version of pg_dump ;-). > >> Unfortunately I think he's only been talking about it on pghackers > >> so far. > > > >What versions does it work on? > > > > 6.5.x a

Re: [GENERAL] Announce: Testers needed for revised pg_dump/pg_restore

It's probably best to look in the directory: ftp://ftp.rhyme.com.au/pub/ for the latest version. Philip Warner| __---_ Albatross Consulting Pty. Ltd. |/ - \ (A.C.N. 008 659 498)

[GENERAL] vacuumdb problem

Hi! I have a problem with vacuumdb on one of my tables. (spiral:3)-[~]$vacuumdb -t osoby -v dziekanat NOTICE: --Relation osoby-- NOTICE: Pages 229: Changed 0, reaped 16, Empty 0, New 0; Tup 4427: Vac 5, Keep/VTL 0/0, Crash 0, UnUsed 70, MinLen 64, MaxLen 616; Re-using: Free/Avail. Space 18176/