First time here? Check out the FAQ!
1

Is there a specific version of PostgreSQL required?
 

What is the minimum version requirement for postgresSQL?

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
Evgeny's avatar
13.2k
Evgeny
updated 14 years ago
Benoit's avatar
875
Benoit
asked 14 years ago

Comments

see more comments

1 Answer

0

I've tested with 8.4.4, but 8.3 should do. With 8.2 it's possible to set up full text but probably it's not worth the effort.

use psql --version to find out what you've got.

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
Evgeny's avatar
13.2k
Evgeny
updated 14 years ago, answered 14 years ago
link

Comments

Just tried to import form a mysql dump (just the INSERT statements, not the table creates) and postgresql doesn't like the format. Maybe an importer is in order
Benoit's avatar Benoit (14 years ago)
try modifying instance of double ". I've seen a word about it online. Unfortunately I cannot spend time on this until tomorrow.
Evgeny's avatar Evgeny (14 years ago)
It actually looks like the tuples (123,'This is some text'), where the import expects ' to be escaped. I didn't think it was going to do that. Also, the dump output has some table locks which postgres doesn't like.
Benoit's avatar Benoit (14 years ago)
see more comments