can someone with pg provide a fix for this?<br><br>-g.<br><br><div class="gmail_quote">On Dec 17, 2007 4:24 PM, Reid Thompson <<a href="mailto:Reid.Thompson@ateb.com">Reid.Thompson@ateb.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
>From current repo...<br>Looks like the select for the sequence has double quotes that shouldn't be there<br><br>rthompso@raker ~ $ ruby simplePG.rb<br> INFO: Og uses the Postgresql store.<br>DEBUG: Og manageable classes: [SimpleTest]
<br>DEBUG: CREATE TABLE "ogsimpletest" ("date" text, "ts" text, "oid" serial PRIMARY KEY) WITHOUT OIDS<br>DEBUG: SELECT * FROM "ogsimpletest" LIMIT 1<br>DEBUG: SELECT nextval('"ogsimpletest"_oid_seq')
<br>ERROR: DB error ERROR: invalid name syntax<br>, [SELECT nextval('"ogsimpletest"_oid_seq')]<br>ERROR: /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/adapter/postgresql.rb:119:in `exec'
<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/adapter/postgresql.rb:119:in `query_statement'<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/store/sql.rb:572:in `query'
<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/adapter/postgresql.rb:152:in `insert'<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/store/sql.rb:102:in `og_insert'<br>
/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/store.rb:94:in `save'<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/model.rb:69:in `save'<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/manager.rb:118:in `with_store'
<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/model.rb:68:in `save'<br>simplePG.rb:36<br>/home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/store/sql.rb:615:in `handle_sql_exception': Og::StoreException (Og::StoreException)
<br> from /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/store/sql.rb:575:in `query'<br> from /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/adapter/postgresql.rb:152:in `insert'
<br> from /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/store/sql.rb:102:in `og_insert'<br> from /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/store.rb:94:in `save'
<br> from /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/model.rb:69:in `save'<br> from /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/manager.rb:118:in `with_store'
<br> from /home/rthompso/src/repo.nitroproject.org/script/lib/../../og/lib/og/model.rb:68:in `save'<br> from simplePG.rb:36<br><br>_______________________________________________<br>Nitro-general mailing list
<br><a href="mailto:Nitro-general@rubyforge.org">Nitro-general@rubyforge.org</a><br><a href="http://rubyforge.org/mailman/listinfo/nitro-general" target="_blank">http://rubyforge.org/mailman/listinfo/nitro-general</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><a href="http://gmosx.me.gr">http://gmosx.me.gr</a><br><a href="http://joy.gr">http://joy.gr</a><br><a href="http://cull.gr">http://cull.gr</a><br><a href="http://nitroproject.org">
http://nitroproject.org</a><br><a href="http://phidz.com">http://phidz.com</a><br><a href="http://joyerz.com">http://joyerz.com</a>