[GENERAL] MySQL dump

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

[GENERAL] Help pls with UPDATE

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

Re: [GENERAL] winxp with 8.0.3 postgresql

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 -- Ñ óâàæåíèåì, Èãîðü

Re: [GENERAL] Weird lock or bug maybe?

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

[GENERAL] Vacuumdb question

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

[GENERAL] Database became very slow(Help PLS)

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

[GENERAL] Wrong select results after transaction (HELP PLS)

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

[GENERAL] How to dump data from database?

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

Re: [GENERAL] How to dump data from database?

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

Re: [GENERAL] How to dump data from database?

? -- gomailto:[EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] rserv question

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! --

[GENERAL] free space map settings

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

[GENERAL] pg_restore error

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)]

[GENERAL] Locale problem

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,