Re: lug-bg: От MySQL към PostgreSQL
- Subject: Re: lug-bg: От MySQL към PostgreSQL
- From: Nikola Antonov <nikola@xxxxxxxxxxxx>
- Date: Sun, 23 Jan 2005 12:39:14 +0200
- Organization: Linux For Bulgarians
On Sunday 23 January 2005 12:16, Огнян Кулев wrote:
> --compatible=ansi? ;-) И ако това не стане, по-добре прати тук
> конкретните грешки. Да не би кирилицата да е проблем?
>
> Поздрави,
> оги
Не става. Кодировката на таблиците е cp1251. Грешките, които излизат при
импорт чрез psql, са от този тип:
---cut---
sql:ezcontents.sql:833: ERROR: syntax error at or near ""phpbb_vote_desc"" at
character 13
psql:ezcontents.sql:834: ERROR: syntax error at or near "," at character 172
psql:ezcontents.sql:835: ERROR: syntax error at or near "UNLOCK" at character
1
psql:ezcontents.sql:842: ERROR: syntax error at or near "EXISTS" at character
15
psql:ezcontents.sql:850: ERROR: syntax error at or near "(" at character 58
psql:ezcontents.sql:858: ERROR: syntax error at or near
""phpbb_vote_results"" at character 13
psql:ezcontents.sql:859: ERROR: syntax error at or near "," at character 55
---cut---
Базата данни, в която се импортват таблиците, е празна. Това "EXISTS" нямам
обяснение защо се появява.
--
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--
Attachment:
pgpM7gaXdKeDG.pgp
Description: PGP signature
|