Re: [ADMIN] mysql to pgsql

2000-02-18 Thread Nikolay Mijaylov
Hya 1. Dump data from Mysql mysqldump > x 2. Open x joe x (or vi x) Look tables create data, fix types (such int(11) -> integer, etc) Remove all Mysql comments, unfortunately pg, cant support comments, they begins with # if i

[ADMIN] Backend Error

2000-02-18 Thread Sameer Anja
Hi- I get the following error when trying to access data from a text field. The contents are huge and postgres does not crash, but my query is aborted... Backend message type 0x44 arrived while idle -sam The full err is as below... fsdkfs \. pqWait() -- connection not open PQendcopy: resetting

Re: [ADMIN] Backend Error

2000-02-18 Thread Sameer Anja
Hi- some more info... this is postgres 6.5 on Redhat linux 6.1.. installed through RPMs -sam --- Sameer Anja <[EMAIL PROTECTED]> wrote: > Hi- > > I get the following error when trying to access data > from a text field. The contents are huge and > postgres > does not crash, but my query is abo

[ADMIN] Postgresql Limits with PHP query

2000-02-18 Thread Daniele Medri
Hi, i'm not updated about latest versions of Postgresql, but this is my question: I use postgresql on web based applications with php. Are there limits again over 8k for query submit? I remember that putting a big text (over 8k) i receive errors.. and someone tell me to re-compile from sources w

Re: [ADMIN] mysql to pgsql

2000-02-18 Thread Dirk Heinrichs
On Don, 17 Feb 2000, Bob Zoller wrote: >I'm trying to make the switch from mysql to pgsql, but I'm having trouble >figuring out how to transfer my databases over! I tried doing a dump in >mysql and then importing that into pgsql, but I got *tons* of errors.. I >searched the list archives and docs

Re: [ADMIN] mysql to pgsql

2000-02-18 Thread Ross J. Reedstrom
One correction: On Fri, Feb 18, 2000 at 11:23:49AM +0200, Nikolay Mijaylov wrote: > Hya > > Remove all Mysql comments, unfortunately pg, cant support > comments, > they begins with # if i not mistake pgsql supports SQL standard comments. A comment is intr

[ADMIN] Backup of db with large objects.

2000-02-18 Thread M . Mazurek
Hi, pg_dump doesn't support large objects, I haven't found any advise how to do it in doc neither in FAQ. How an I to backup a db with large objects without losing my data? mazek