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