Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint pg_description_o_c_o_index

2006-02-09 Thread Martijn van Oosterhout
On Thu, Feb 09, 2006 at 10:24:38AM +0530, surabhi.ahuja wrote: thank u so much for the help. ok i ll tell u how i arrived at this problem. this i was using just for testing purpose on my local m/c i had deleted rows in a table, and had searched and found the following: snip and did

[GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint pg_description_o_c_o_index

2006-02-08 Thread surabhi.ahuja
i am trying to install postgresql-8.0.1 i am now trying to do /usr/local/pgsql/bin/initdb -D data/ however this is what i get: The files belonging to this database system will be owned by user "surabi".This user must also own the server process. The database cluster will be initialized with

Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates

2006-02-08 Thread Richard Huxton
surabhi.ahuja wrote: i am trying to install postgresql-8.0.1 Why? The most recent release for 8.0 is 8.0.6 and you're clearly compiling from source, so why have you deliberately chosen an old release? i am now trying to do /usr/local/pgsql/bin/initdb -D data/ I'd specify an absolute path

Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint pg_description_o_c_o_index

2006-02-08 Thread surabhi.ahuja
Title: Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint pg_description_o_c_o_index actually i had a version existing earlier. guess it was installed from an rpm.. so ther are binaries like postmasterinside /usr/bin itself and after i installed

Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates

2006-02-08 Thread Richard Huxton
surabhi.ahuja wrote: actually i had a version existing earlier. guess it was installed from an rpm.. so ther are binaries like postmaster inside /usr/bin itself and after i installed /8.0.1, ther are binaries even in /usr/local/pgsql/bin. how should i uninstall the whole thing and begin a

Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint pg_description_o_c_o_index

2006-02-08 Thread surabhi.ahuja
Title: Re: [GENERAL] loading pg_description ... FATAL: duplicate key violates unique constraint pg_description_o_c_o_index thank u so much for the help. ok i ll tell u how i arrived at this problem. this i was using just for testing purpose on my local m/c i had deletedrows in a table