Re: [ADMIN] SQL Commands

2000-12-04 Thread Anthony E. Greene
On Thu, 30 Nov 2000, Greg Thompson wrote: >SQL Commands (such as ALTER TABLE) no longer >appear to be available in "Online version of user" at > >http://www.postgresql.org/devel-corner/docs/index.html > >Where can I find this documentation? man l alter_table Tony -- Anthony E. Greene <[EMAIL PR

Re: [ADMIN] SQL Commands

2000-12-04 Thread Peter Eisentraut
Greg Thompson writes: > SQL Commands (such as ALTER TABLE) no longer > appear to be available in "Online version of user" at > > http://www.postgresql.org/devel-corner/docs/index.html > > Where can I find this documentation? http://www.postgresql.org/devel-corner/docs/postgres/reference.htm --

Re: [ADMIN] SQL Commands

2000-12-04 Thread Brian Horan
Greg Thompson wrote: > > SQL Commands (such as ALTER TABLE) no longer > appear to be available in "Online version of user" at > > http://www.postgresql.org/devel-corner/docs/index.html > > Where can I find this documentation? you can access it via the client, psql. \h ALTER TABLE -- ,~,

[ADMIN] SQL Commands

2000-12-04 Thread Greg Thompson
SQL Commands (such as ALTER TABLE) no longer appear to be available in "Online version of user" at   http://www.postgresql.org/devel-corner/docs/index.html   Where can I find this documentation?

Re: [ADMIN] Where are the downloads for the the supported Windows NT

2000-12-04 Thread eschmid+sic
On Tue, Nov 28, 2000 at 05:03:38PM +0100, Annett Katzschner wrote: > I read that PostgreSQL run also on NT but I could not find the downloadfiles. Where >I have to look for? It's only available for version 7.0. I have looked at my nearest FTP server at the Fachhochschule Esslingen and there it

Re: [ADMIN] Redundant databases/real-time backup

2000-12-04 Thread hamptone
Thanks for the tips Ragnar...although I wish you would explain more about FIFO. The only thing that rings a bell on this is First In First Out from the inventory chaper of my accounting textbook. - Original Message - From: "Ragnar Kjørstad" <[EMAIL PROTECTED]> To: "root" <[EMAIL PROT

Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

2000-12-04 Thread Dana Hudes
there are 2 Perl interfaces to Postgres. Pg and DBD::Pg . They are different. DBD has a prereqisite of DBI. CPAN installation works even easier than RPM if you allow it to follow prerequisites it will download and install eerything needed to satisfy the dependencies.

Re: [ADMIN] Implementing mod_perl, Perl 5.004, and Postgres

2000-12-04 Thread Jimi Thompson
root wrote: > I'll do you one better. Here it is: > > On Thu, 30 Nov 2000, you wrote: > > > > I am posting this because it will probably help someone else out. There are about >a zillion different > > flavors of the Pg.pm. This has proven to be a real hair-puller for me and I am >hoping this

[ADMIN] How do I insert data into a table within a table

2000-12-04 Thread Stan Raby
-- As I understand it when you create a table in postgres that it is automatically a type. Therefore you can then the declare an attribute of this type in another table e.g create table person ( first_name char(20), second_name char(20) ); create table couple ( man person, woman p

[ADMIN] Where are the downloads for the the supported Windows NT

2000-12-04 Thread Annett Katzschner
Hello, I read that PostgreSQL run also on NT but I could not find the downloadfiles. Where I have to look for? Thanks Annett ___ Alles unter einem Dach: Informationen, Fun, E-Mails. Bei WEB.DE: http://web.de Die große W

[ADMIN] ERROR: cannot find attribute 1 of relation pg_temp

2000-12-04 Thread Vladimir Sakhovsky
Hi, When I vacuuming database I'm getting this error: $vacuumdb --analyze mydatabase ERROR: cannot find attribute 1 of relation pg_temp.13435.0 vacuumdb: database vacuum failed on mydatabase How this can be fixed? I'm running on RadHat 6.2, Postgresql-6.5.3-6. Any help would be appreciated,