Comments (5)
Sorry it cut off the end of the postgres log I'll just give you the last query:
2011-11-23 08:17:32 MST LOG: 00000: duration: 0.046 ms statement: BEGIN
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST LOG: 00000: duration: 1.453 ms statement: SELECT nspname AS schema, conname AS name,
pg_encoding_to_char(c.conforencoding) AS source_encoding,
pg_encoding_to_char(c.contoencoding) AS dest_encoding,
conproc AS function, condefault AS default,
obj_description(c.oid, 'pg_conversion') AS description
FROM pg_conversion c
JOIN pg_namespace n ON (connamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, conname
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST LOG: 00000: duration: 0.028 ms statement: ROLLBACK
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST LOG: 00000: duration: 0.017 ms statement: BEGIN
2011-11-23 08:17:32 MST LOCATION: exec_simple_query, postgres.c:1095
2011-11-23 08:17:32 MST ERROR: 42703: column "prsnamespace" does not exist at character 391
2011-11-23 08:17:32 MST LOCATION: transformColumnRef, parse_expr.c:766
2011-11-23 08:17:32 MST STATEMENT: SELECT nspname AS schema, prsname AS name,
prsstart::regproc AS start, prstoken::regproc AS gettoken,
prsend::regproc AS end, prslextype::regproc AS lextypes,
prsheadline::regproc AS headline,
obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname
from pyrseas.
A couple of questions: What version of Postgres are you using? Second, could you please connect to the database with psql, issue the following query and let me know what happens:
SELECT nspname AS schema, prsname AS name,
prsstart::regproc AS start, prstoken::regproc AS gettoken,
prsend::regproc AS end, prslextype::regproc AS lextypes,
prsheadline::regproc AS headline,
obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;
Also, it appears you're using the head from the GitHub master repo. Maybe you want to switch to branch r0.4 or tag r0.4.1, which doesn't have the TEXT SEARCH code that it's still being worked on.
from pyrseas.
Actually I installed it using pip:
Metadata-Version: 1.0
Name: Pyrseas
Version: 0.4.1
Summary: Framework and utilities to upgrade and maintain databases
Home-page: http://www.pyrseas.org/
Author: Joe Abbate
Author-email: [email protected]
License: BSD
Description: =======
Pyrseas
=======
Pyrseas provides a framework and utilities to upgrade and maintain a
relational database. Its purpose is to enhance and follow through
on
the concepts of the Andromeda Project <http://www.andromeda-project.org/>
_.
Pyrseas currently includes the dbtoyaml utility to create a `YAML
<http://yaml.org/>`_ description of a PostgreSQL database's tables,
and the yamltodb utility to generate SQL statements to modify a
database to match an input YAML specification.
Pyrseas is distributed under the BSD license.
Platform: OS-independent
Classifier: Development Status :: 3 - Alpha
Classifier: Environment :: Console
Classifier: Environment :: Web Environment
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Information Technology
Classifier: Intended Audience :: System Administrators
Classifier: License :: OSI Approved :: BSD License
Classifier: Natural Language :: English
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: SQL
Classifier: Topic :: Database :: Front-Ends
Classifier: Topic :: Software Development :: Code Generators
Classifier: Topic :: Software Development :: Version Control
My postgres version is:
Postges 9.1.1
And the query is:
cos=> SELECT nspname AS schema, prsname AS name,
prsstart::regproc AS start, prstoken::regproc AS gettoken,
prsend::regproc AS end, prslextype::regproc AS lextypes,
prsheadline::regproc AS headline,
obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;
schema | name | start | gettoken | end | lextypes | headline | description
--------+------+-------+----------+-----+----------+----------+-------------
(0 rows)
cos=>
On Wed, Nov 23, 2011 at 9:00 AM, Joe Abbate <
[email protected]
wrote:
A couple of questions: What version of Postgres are you using? Second,
could you please connect to the database with psql, issue the following
query and let me know what happens:SELECT nspname AS schema, prsname AS name, prsstart::regproc AS start, prstoken::regproc AS gettoken, prsend::regproc AS end, prslextype::regproc AS lextypes, prsheadline::regproc AS headline, obj_description(p.oid, 'pg_ts_parser') AS description FROM pg_ts_parser p JOIN pg_namespace n ON (prsnamespace = n.oid) WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema') ORDER BY nspname, prsname;Also, it appears you're using the head from the GitHub master repo. Maybe
you want to switch to branch r0.4 or tag r0.4.1, which doesn't have the
TEXT SEARCH code that it's still being worked on.
Reply to this email directly or view it on GitHub:
#10 (comment)
from pyrseas.
So i took you sugestion:
sudo pip uninstall pyrseas
and
git checkout v0.4.1
sudo python setup.py install
ran it on the offending db with no problems
On Wed, Nov 23, 2011 at 10:13 AM, Chet Henry [email protected]:
Actually I installed it using pip:
Metadata-Version: 1.0
Name: Pyrseas
Version: 0.4.1
Summary: Framework and utilities to upgrade and maintain databases
Home-page: http://www.pyrseas.org/
Author: Joe Abbate
Author-email: [email protected]
License: BSD
Description: =======
Pyrseas
=======Pyrseas provides a framework and utilities to upgrade and maintain
a
relational database. Its purpose is to enhance and follow through
on
the concepts of theAndromeda Project <http://www.andromeda-project.org/>
_.Pyrseas currently includes the dbtoyaml utility to create a `YAML <http://yaml.org/>`_ description of a PostgreSQL database's
tables,
and the yamltodb utility to generate SQL statements to modify a
database to match an input YAML specification.Pyrseas is distributed under the BSD license.
Platform: OS-independent
Classifier: Development Status :: 3 - Alpha
Classifier: Environment :: Console
Classifier: Environment :: Web Environment
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Information Technology
Classifier: Intended Audience :: System Administrators
Classifier: License :: OSI Approved :: BSD License
Classifier: Natural Language :: English
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python
Classifier: Programming Language :: SQL
Classifier: Topic :: Database :: Front-Ends
Classifier: Topic :: Software Development :: Code Generators
Classifier: Topic :: Software Development :: Version ControlMy postgres version is:
Postges 9.1.1And the query is:
cos=> SELECT nspname AS schema, prsname AS name,
prsstart::regproc AS start, prstoken::regproc AS gettoken,
prsend::regproc AS end, prslextype::regproc AS lextypes,
prsheadline::regproc AS headline,
obj_description(p.oid, 'pg_ts_parser') AS description
FROM pg_ts_parser p
JOIN pg_namespace n ON (prsnamespace = n.oid)
WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema')
ORDER BY nspname, prsname;
schema | name | start | gettoken | end | lextypes | headline |
description--------+------+-------+----------+-----+----------+----------+-------------
(0 rows)cos=>
On Wed, Nov 23, 2011 at 9:00 AM, Joe Abbate <
[email protected]wrote:
A couple of questions: What version of Postgres are you using? Second,
could you please connect to the database with psql, issue the following
query and let me know what happens:SELECT nspname AS schema, prsname AS name, prsstart::regproc AS start, prstoken::regproc AS gettoken, prsend::regproc AS end, prslextype::regproc AS lextypes, prsheadline::regproc AS headline, obj_description(p.oid, 'pg_ts_parser') AS description FROM pg_ts_parser p JOIN pg_namespace n ON (prsnamespace = n.oid) WHERE (nspname != 'pg_catalog' AND nspname != 'information_schema') ORDER BY nspname, prsname;Also, it appears you're using the head from the GitHub master repo.
Maybe you want to switch to branch r0.4 or tag r0.4.1, which doesn't have
the TEXT SEARCH code that it's still being worked on.
Reply to this email directly or view it on GitHub:
#10 (comment)
from pyrseas.
I'm afraid that I'll have to repackage the 0.4.1 release on PyPI (and elsewhere). I see that it includes pyrseas/dbobject/textsearch.py, whereas that's not present in the Git repo tag. Thanks for raising this issue.
from pyrseas.
Related Issues (20)
- ALTER SEQUENCE OWNER comes before CREATE TABLE HOT 3
- SSL Connection to remote database HOT 3
- datacopy CSV with null trailing columns not importing with -u HOT 7
- CREATE EXTENSION statements in the change script HOT 5
- [Contribution] Docker support HOT 2
- Sequences processing doesn't skip schemas defined with '-N' option. HOT 3
- dbtoyaml fails when dealing with extension-owned triggers/functions HOT 7
- Multiline Strings (source: |2) Output Unstable HOT 5
- Enable Github Discussions HOT 2
- Fails to Install: Error: pg_config executable not found HOT 5
- Error Using dbtoyaml With Supabase Schema HOT 67
- dbtoyaml Fails When PG Password Has Spaces (Improper Escaping) HOT 1
- Convert .travis.yml to GH Actions
- Fold pgdbconn back into Pyrseas HOT 1
- Key error when converting aggregate to YAML HOT 4
- plv8 to extension and fix reserved words in the primary key HOT 5
- Add REFERENCING tables in trigger HOT 3
- Support columns GENERATED AS (x) STORED HOT 2
- Support --revert for tables HOT 4
- the yamltodb tool is not placing the names of schemas, tables and columns in double quotes HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pyrseas.