[HACKERS] NOTICE: Child itemid in update-chain marked as unused...

2001-08-01 Thread V. M.
sometimes i'm getting: NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag during a simple "vacuum", db is online. pg version 7.1, on debian linux kernel 2.4. what's the problem? thanks, valter m. _

[HACKERS] Child itemid in update-chain marked as unused - can't continue repair_frag

2001-07-12 Thread V. M.
lindo=# vacuum analyze; NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS NOT THE SAME AS HEAP' (4). Recreate the index. NOTICE: Index probably_good_banner_myidx1: NUMBER OF INDEX' TUPLES (1) IS NOT THE SAME AS HEAP' (4). Recreate the index. NOTICE: Chi

[HACKERS] Postgresql.exe 7.1 for M$ OS

2001-05-04 Thread V. M.
Where i can find a wonderful installer for postgres 7.1 on our windows2000 advanced servers ? We use postgres on linux systems, But... I'm not able to find on the net a binary for Postgres 7.1. I don't want to compile, i want a simple installer. windows machines are 200 Million, if you'll make

[HACKERS] CVSup not working!

2001-05-03 Thread V. M.
cvsup -L 2 postgres.cvsup Parsing supfile "postgres.cvsup" Connecting to postgresql.org Cannot connect to postgresql.org: Connection refused Will retry at 22:31:23 -- # This file represents the standard CVSup distribution file # for the PostgreSQL ORDBMS project #

Re: [HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: [HACKERS] Re: unanswered: Schema Issue >Date: Thu, 26 Apr 2001 14:42:31 -0400 (EDT) > >On Thu, 26 Apr 2001, V. M. wrote: > > > ok for serials, now i can extract from psql (\

Re: [HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
read it, but i can determine only the related tables and not the fields of these tables that are related. valter >From: Joel Burton <[EMAIL PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: [HACKERS] Re: unanswered: Schema Issu

[HACKERS] Re: unanswered: Schema Issue

2001-04-26 Thread V. M.
ok for serials, now i can extract from psql (\d tablename). But i'm not able to extract foreign keys from the schema. >From: Joel Burton <[EMAIL PROTECTED]> >To: "V. M." <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED] >Subject: Re: unanswered: Schema Issue

[HACKERS] unanswered: Schema Issue

2001-04-26 Thread V. M.
I want to extract tables schema information, i've looked at src/bin/psql/describe.c but i cannot determine the datatype 'serial' and 'references' from pg_*, i understand that triggers are generated for serial and references, so how i can understand from my perl application the full schema ? tha

[HACKERS] Schema Issue

2001-04-25 Thread V. M.
I want to extract tables schema information, i've looked at src/bin/psql/describe.c but i cannot determine the datatype 'serial' and 'references' from pg_*, i understand that triggers are generated for serial and references, so how i can understand from my perl application the full schema ?

[HACKERS] Postgresql, HA ?, Monitoring.

2001-04-19 Thread V. M.
Dear Hackers, i'm using 7.1 in a production environment, porformace is very good, you've made a vesy good job. But there are problems, sometimes backend "failed to start": (mandrake 7.2, mod_perl 1.24, apache 1.3.14, Apache::DBI) (deadlock_timeout=2000 max_connections=300) DBI->connect(dbname