Re: [ADMIN] Installation of postgre DBD is easy without RMP

2000-05-24 Thread Lamar Owen
On Mon, 22 May 2000, Hans Poo wrote: > Just a little complaint... ¿Why not to include the full perl portable (i > mean DBI) development kit in Postgres? ... sorry about this, i know it's > free but... DBD::Pg is under either the GNU GPL or the Artistic License -- GPL is not compatible with the BS

[ADMIN] ERROR PARSER: parse error at or before 'constraint'

2000-05-24 Thread joe briggs
Hello, When I try to import a data base from one Linux box to another ( cat db.out | psql dbname ), I get an error: ERROR PARSER: parser error at or before 'constraint'. The source box was Linxu 6.1 with PostgreSQL 7.0 manually installed. The target box has been the same configuration, but also

Re: [ADMIN] select distinct inet bug

2000-05-24 Thread Bruce Momjian
Fixed in PostgreSQL 7.0, which was just released. > Hie all , > > I've already post a similar messages but i don't see it into the > mailing list so ... > Look at the following : > > test=> create table ip_table (addr inet); > CREATE > test=> insert i

[ADMIN] PostgreSQL Mailing Lists ...

2000-05-24 Thread The Hermit Hacker
NOTE: Four new Developer related mailing lists have been created!! == Last Modified May 24th, 2000

[ADMIN] Postgres-7.0 dying

2000-05-24 Thread hal Lynch
Got a bit of a problem here?! I just upgraded to Postgres-7.0 I am getting the error shown below consistantly, not always in the same place in the database build script. When I installed 7.0 I did not migrate my data. Instead I chose to rebuild all databases (6) and all tables (> 40) from scratch

[ADMIN] Re: [PORTS] Re: [BUGS] port v7.0 to SGI-IRIX-6.5.7/64

2000-05-24 Thread Peter Eisentraut
On Mon, 22 May 2000, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> 2- configure badly guesses the type of the 3rd argument to accept(). it > >> decided it should be size_t (unsigned int on IRIX) while accept on IRIX > >> takes an int. > > > Again, a suggested change? This is

[ADMIN] select distinct inet bug

2000-05-24 Thread Loïc TREGOUËT
    Hie all ,     I've already post a similar messages but i don't see it into the mailing list so ... Look at the following : test=> create table ip_table (addr inet); CREATE test=> insert into ip_table values ('10.10.10.10'); INSERT 1403913 1 test=> insert in

[ADMIN] postgres-7.0 dying

2000-05-24 Thread hal Lynch
Got a bit of a problem here?! I just upgraded to Postgres-7.0 I am getting the error shown below consistantly, not always in the same place in the database build script. When I installed 7.0 I did not migrate my data. Instead I chose to rebuild all databases (6) and all tables (> 40) from scratch

[ADMIN] Installation of postgre DBD is easy without RMP

2000-05-24 Thread Hans Poo
I get tired of fighting with DBD, libpq and all that stuf, after all what i really care is making sofware I tried everything... Things will go fast if you go to: http://forteviot.symbolstone.org/cgi/dbi/moduledump?module=DBD::Pg and then download from CPAN the version what you want (the las

[ADMIN] inet type , select distinct troubles

2000-05-24 Thread Loïc TREGOUËT
    Hie all ,       I've a big database ( 2M rows ) and i use the inet type for ip address .     for example :     test=>create table ip_table (i int4 , addr inet );     CREATE     The i do a lot of inserts in my database , with Perl/DBI . (Note i use AutoCommit=off for performance) :     tes