Hi,
Help me please to resolve the problem:
Just After commiting transaction - writing ,say 90 rows,I try to select
the same 90 rows - and get wrong set of rows (some of them: 1-2 replaced
by unknown data). But after 10-20 seconds the result of selecting
the neccessary 90 rows return right
Hi,
After about 2 month of greate work, my database (running under
PG 8.01 on Win2000) very slow.Reindexing all tables, Vacuum Full,Freeze
and Analyze didn't help(i did it from pg_admin III).
But after dropdb and pg_restore it become fast again.
(The same database -both very small , about 50
Hi, pgsql-general.
Explain me please the difference between
Vacuum full and Vacuum freeze
--
Have a nice day!
go mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi there
I have much problems with wierd locking too. I thing
that it problem is connected with localisation - when
i update a problem row (which have text fields) with
any different text data in text fields - all locks
dissapper. I hope this info can help to solve this bug
(because in PG
8.0.3 in my winxp with sp2 or sp1 in two
cases the simple SQL comand with BDE result Error: Bad field type.
DBC I go select * from usuarios and i go normally
DBC I go select nome, codigo from usuarios i go Error: Bad field type.
DBC What is this??
DBC Thanks
DBC Dario
--
Ñ óâàæåíèåì,
Èãîðü
Hi !
Im running PG 7.23 now with text fields in CP866.
I tried to restore dump from 7.23 into PG 8.01 with
following settings :
- initdb --locale ru_RU
- createdb -E ALT.
all works great , but sort order in text fields is wrong
People, help pls to megrate to PG 8.01 properly
Thanks,
Hi All!
While restoring PG7.23 dump into PG 8.01 database
(pg_restore -Fc -d a3 -v arz3.test.dat) i got error:
pg_restore: ERROR: invalid byte sequence for encoding UNICODE: 0xfc3535
CONTEXT: COPY mytable, line 9, column post3: 55146/23.12.04
pg_restore: [archiver (db)]
Hi
Tell me please what does it mean the next hint:
TIP 7: don't forget to increase your free space map settings
where can i read about this settings?
--
Igor
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi
tell me please what is the best way for replication now?
(in pgAdmin hint i read The rserv project in PostgreSQL's contrib directory
can be used for Master - Slave replication.
but PG8.0 docs there is string:Removed contrib/rserv: obsoleted by various
separate projects)
Thanks!
--
Hi!
Tell me please is there any way to dump data from current session
(instead of using pg_dump) ?
igor mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
On Mon, Apr 04, 2005 at 11:18:08AM +0400, go wrote:
Tell me please is there any way to dump data from current session
(instead of using pg_dump) ?
MF What exactly are you trying to do? Will COPY (or psql's \copy) do
MF what you want?
---(end of broadcast
?
--
gomailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi, pgsql-general.
Tell me please, how to update a set of rows using order-
something like :
update my_table set counter1=nextval('my_seq') order by counter2 ;
--
Regards,
Igor mailto:[EMAIL PROTECTED]
---(end of
Hi All!
Tell me please - is there any script for conversion MySQL dump
file into PostgreSQL ?
Thanks!
Igor.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your
14 matches
Mail list logo