Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Sun, 16 Nov 2003, Joel Jacobson wrote:
>> oid | xmin| xmax| userid | balance | reservedbalance |
>> modificationdate
>> -+---+---+-+--+-+--
>> 2080463 | 248152344 |
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
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
> -+---+---+-
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
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
-+---+---+-+--+-+---
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
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
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 :-)
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
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
10 matches
Mail list logo