Ask Your Question
1

Is there a specific version of PostgreSQL required?

asked 2010-10-29 16:54:57 -0500

Benoit gravatar image Benoit flag of United States
865 22 8 31

updated 2010-10-31 21:40:20 -0500

Evgeny gravatar image Evgeny flag of Chile
11074 50 84 182
http://askbot.org/

What is the minimum version requirement for postgresSQL?

delete close flag offensive retag edit

1 Answer

Sort by ยป oldest newest most voted
0

answered 2010-10-29 17:00:55 -0500

Evgeny gravatar image Evgeny flag of Chile
11074 50 84 182
http://askbot.org/

updated 2010-10-31 21:41:53 -0500

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.

link publish delete flag offensive edit

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 ( 2010-11-01 09:39:39 -0500 )edit
try modifying instance of double ". I've seen a word about it online. Unfortunately I cannot spend time on this until tomorrow. Evgeny ( 2010-11-01 09:53:33 -0500 )edit
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 ( 2010-11-01 13:34:32 -0500 )edit

Your answer

Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Reliable Askbot Hosting

Create your Q&A site at askbot.com. Managed Askbot hosting at just $15/mo. Dedicated hosting, support contracts, consulting services.

create your Q&A site
30 days free trial

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2010-10-29 16:54:57 -0500

Seen: 65 times

Last updated: Oct 31 '10