[GENERAL] userguide example fixes

1998-09-17 Thread Gene Selkov, Jr.
Because new keywords have been added since the original manuals were written, some of the examples may not work any longer, such as this: (in the files known to me as userguide.ps or admin.html) > This query lists all binary operators. > > SELECT o.oprname AS binary_op, >

[GENERAL] Backup up database

1998-09-17 Thread Brian
I am wanting to make a nightly dump/backup of our database in case something happens to it. I'll probably run the backup right before I vacuum each night. Is their a command I can type that will dump the entire database, complete with relations and data, so that if something did happen to it, It

Re: [GENERAL] PostgreSQL capacity ?

1998-09-17 Thread Wim Ceulemans
>Hi, I have been checking out the PostgreSQl project and I should say I'm >surprised the incredible work developers and others have done. Now I >would like to know if there is some document which can light me to >evalute the capacity of PostgreSQL. You can find a really up-to-date comprehensive

[GENERAL] PostgreSQL capacity ?

1998-09-17 Thread Gerardo Gallardo
Hi, I have been checking out the PostgreSQl project and I should say I'm surprised the incredible work developers and others have done. Now I would like to know if there is some document which can light me to evalute the capacity of PostgreSQL. I got a friend who should start an information syste

[GENERAL] Re: NOTICE: _outNode: don't know how to print type 715

1998-09-17 Thread Jose' Soares
Hi all, PostgreSQL gives me a strange message when I try to create a table with a NOT NULL column. drop table prova; DROP create table prova( campo1 INTEGER ); CREATE drop table prova; DROP create table prova( campo1 INTEGER NOT NULL ); NOTICE:

[GENERAL] ORDER BY, LIKE !!?

1998-09-17 Thread rex
Hi, I have : - a table with more than 2.000.000 records. It looks like this : +--+--+- --+ | Field| Type |Length | +--+--