On 5/4/07, Tom Lane [EMAIL PROTECTED] wrote:
There are several obvious things wrong with that (eg, psql cannot read
-Fc format dumps) so I suppose it's an editorialization on what you
really typed.
right, what i posted was a typo, what i ran did not have the -Fc
Perhaps the problem is hidden
On 5/4/07, Tom Lane [EMAIL PROTECTED] wrote:
Well, I loaded and dumped and reloaded this schema in 8.1 without any
problem, so I'm still baffled.
oh, and the machine that i created the dump on and the machine i
loaded the dump on are both Fedora Core 6 that report:
$ postgres --version
On 5/4/07, Tom Lane [EMAIL PROTECTED] wrote:
Mike Frysinger [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] 0 ~]$ psql -d gforge5 -f gforge.schema
...
psql:gforge.schema:31: ERROR: could not access file
$libdir/tsearch2: No such file or directory
You don't have tsearch2 installed in the new
On 4/20/07, Tom Lane [EMAIL PROTECTED] wrote:
Hmph. It should pretty much just work ... and there is *definitely* not
any update command visible in the source code.
i dug deeper (like i should have in the first place) and the UPDATEs
are ok ... they're inside of functions which get triggered
On 4/20/07, Tom Lane [EMAIL PROTECTED] wrote:
Mike Frysinger [EMAIL PROTECTED] writes:
$ pg_dump -F c -s -d database-server mydb mydb.schema
$ psql -d mydb mydb.schema
error about users_idx not existing
pg_dump -Fc does not produce a file that psql can read directly.
Is the above really
On 4/20/07, Tom Lane [EMAIL PROTECTED] wrote:
Mike Frysinger [EMAIL PROTECTED] writes:
i was experimenting with using pg_dump/pg_restore and pg_dump/psql ...
when using psql to import, i didnt use -Fc ... but the errors were the
same regardless of whether i used pgsl or pg_restore ;(
Well