[GENERAL] Bug in pg_dump/pg_dumpall handling of CONSTRAINTS?

1998-10-22 Thread Michael A. Koerber
When using "pg_dumpall" and a subsequent "psql -e" to rebuild the data base the process failed. The failure was due to the "pg_dumpall" (and "pg_dump") handling of CONSTRAINTS. Details are provided below. Is this a known bug? Is there a patch for it? tnx, mike --

[GENERAL] initdb v6.4 "pg_atoi" error

1998-12-01 Thread Michael A. Koerber
I can't get past the below error in the installation of v6.4. What to I do next? tnx mike - $ initdb initdb: using /usr/local/pgsql/lib/local1_template1.bki.source as input to create the template database. initdb: using /usr/local/pg

Re: [GENERAL] PostgreSQL & r-trees

1999-06-11 Thread Michael A. Koerber
> > I was looking for a DBMS that supports multidimensional index structures > like rectangles and points. During my search I found the link to the > PostgreSQL system. I have used the 'box' and 'line' objects in the past (ver 6.3 or so). The use was short lived...to determine if specific satell

Re: [GENERAL] Creating web images from postgres data

1998-10-30 Thread Michael A. Koerber SR
Note the use of the ':' for delimiting legends. Extra legend will be ignored. If there are not enough legends, the ones specified will be used. The remaining legends are then F defaults. =item B<-f out_file_base_name> creates output files F and F. By default, F are used. =item B<-q> is quiet mode. If specified, then the postscript files are generated but no screen output is shown. If not specified, then a screen output is displayed for 5 seconds, then the postscript file written. =back =head1 NOTES $Source: /home/mak/CVS/misc_util/pp,v $ $Author: mak $ $Date: 1998/08/12 19:01:55 $ $Revision: 1.5 $ Dr Michael A. Koerber MIT/LL Radar Imaging Techniques

Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible

1999-05-30 Thread Michael A. Koerber SR
I have had trouble on numerous occasions "undumping" a pg_dump. Below is a perl script that I use as a pipe for undumping...hope it helps .pg_undump. #!/usr/bin/perl -p # This script is a pipe that is used to break up PSQL dumps into pieces # that are more manageable by the postmaster.