Re: [BUGS] Duplicate primary key record

2003-11-16 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > On Sun, 16 Nov 2003, Joel Jacobson wrote: >> oid | xmin| xmax| userid | balance | reservedbalance | >> modificationdate >> -+---+---+-+--+-+-- >> 2080463 | 248152344 |

Re: [BUGS] Duplicate primary key record

2003-11-16 Thread Gaetano Mendola
Joel Jacobson wrote: No, I have never run REINDEX on any table. However, I have done many VACUUM FULL ANALYZE on the complete database. Yes, once I had this also due to a vacuum: http://archives.postgresql.org/pgsql-admin/2003-04/msg00407.php I decreased the vacuum frequency :-( Regards Ga

Re: [BUGS] Duplicate primary key record

2003-11-16 Thread Stephan Szabo
On Sun, 16 Nov 2003, Joel Jacobson wrote: > Hi Stephan, > > Thanks for a quick reply. > > pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024; >oid | xmin| xmax| userid | balance | reservedbalance | > modificationdate > -+---+---+-

Re: [BUGS] Duplicate primary key record

2003-11-16 Thread Joel Jacobson
No, I have never run REINDEX on any table. However, I have done many VACUUM FULL ANALYZE on the complete database. Citerar Gaetano Mendola <[EMAIL PROTECTED]>: > This happen a few time to me too and I solved not running anymore > each night a REINDEX on the table. I posted this problem in the > p

Re: [BUGS] Duplicate primary key record

2003-11-16 Thread Gaetano Mendola
Joel Jacobson wrote: Hi Stephan, Thanks for a quick reply. pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024; oid | xmin| xmax| userid | balance | reservedbalance | modificationdate -+---+---+-+--+-+---

Re: [BUGS] RC2 will not make check on OSX 10.3

2003-11-16 Thread John Griffiths
I am certainly not an expert in OSX, but many Unix variants have to have the changes made in the conf directories; then the kernel has to be rebuilt AND the environment rebuilt. It is not a one step process on all Unix variants. I don't know for sure, but rebuilding the environment after maki

Re: [BUGS] Duplicate primary key record

2003-11-16 Thread Joel Jacobson
Hi Stephan, Thanks for a quick reply. pbs=# SELECT oid,xmin,xmax,* FROM UserBalances WHERE UserID = 1002024; oid | xmin| xmax| userid | balance | reservedbalance | modificationdate -+---+---+-+--+-+-- 2080

Re: [BUGS] 7.5devel - duplicate error message

2003-11-16 Thread Dennis Bjorklund
On Sun, 16 Nov 2003, Kris Jurka wrote: > > It should only be one error. > > Is there any chance you started the postmaster in the background and then > started psql on the same terminal so you get one error reported to the > server and one to the client? There is a very big chance that I did :-)

Re: [BUGS] 7.5devel - duplicate error message

2003-11-16 Thread Kris Jurka
On Sun, 16 Nov 2003, Dennis Bjorklund wrote: > In current cvs I get > > dennis=# CREATE FUNCTION foo () returns int AS 'select a;' language 'sql'; > ERROR: column "a" does not exist > ERROR: column "a" does not exist > > It should only be one error. Is there any chance you started the postmas

[BUGS] 7.5devel - duplicate error message

2003-11-16 Thread Dennis Bjorklund
In current cvs I get dennis=# CREATE FUNCTION foo () returns int AS 'select a;' language 'sql'; ERROR: column "a" does not exist ERROR: column "a" does not exist It should only be one error. -- /Dennis ---(end of broadcast)--- TIP 7: don't for