On Mon, Oct 31, 2011 at 03:29, Remy Blank <[email protected]> wrote:
> Are you sure about [10864]? The quoting was introduced explicitly in:
>
>  http://trac.edgewall.org/changeset/8382
>
> So it looks like the quoting is necessary at least in some cases. Could
> this be a 8.x vs. 9.x thing with PostgreSQL?

Hmm, I uses PostgreSQL 8.1.23. The backup test failed without [10864].
I'll test with other versions later.


jun66j5@gotanda:2095$ PYTHONPATH=$PWD
TRAC_TEST_DB_URI='postgres://tracuser:[email protected]/tractest'
python2.4 trac/db/tests/functional.py
E
======================================================================
ERROR: Testing backup
----------------------------------------------------------------------
Traceback (most recent call last):
  File "trac/db/tests/functional.py", line 12, in runTest
    backup_file = env.backup()
  File "/home/jun66j5/src/trac/edgewall/0.12-stable/trac/env.py", line
493, in backup
    return DatabaseManager(self).backup(dest)
  File "/home/jun66j5/src/trac/edgewall/0.12-stable/trac/db/api.py",
line 180, in backup
    return connector.backup(dest)
  File 
"/home/jun66j5/src/trac/edgewall/0.12-stable/trac/db/postgres_backend.py",
line 186, in backup
    msg=to_unicode(errmsg.strip())))
TracError: pg_dump failed: pg_dump: specified schema ""tractest"" does not exist

----------------------------------------------------------------------
Ran 1 test in 7.116s

FAILED (errors=1)
jun66j5@gotanda:2096$ pg_dump --version
pg_dump (PostgreSQL) 8.1.23

jun66j5@gotanda:2100$ pg_dump -h 127.0.0.1 -n '"tractest"' -Fc -f
tractest.dmp -U tracuser tractest
Password:
pg_dump: specified schema ""tractest"" does not exist

jun66j5@gotanda:2101$ pg_dump -h 127.0.0.1 -n 'tractest' -Fc -f
tractest.dmp -U tracuser tractest
Password:
jun66j5@gotanda:2102$ echo $?
0

-- 
Jun Omae <[email protected]> (大前 潤)

-- 
You received this message because you are subscribed to the Google Groups "Trac 
Development" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/trac-dev?hl=en.

Reply via email to