Ok, that did it. All fixed up and upgraded to 8. The command for
gentoo to rebuild WITH the pg-hier patch is (for those that might see
this question again):
# USE="pg-hier" emerge "=postgresql-7.4.7-r2" -vD # or whatever latest
7.x version is at that time.
Backup the data, etc. Then whe
On Sat, 4 Jun 2005 09:25 am, Alvaro Herrera wrote:
> On Fri, Jun 03, 2005 at 05:55:36PM -0500, Gerald D. Anderson wrote:
[snip]
>
> I guess your build with the "use flag" wasn't successful. I think you
> have two choices:
>
> 1. really build with the patch installed, and dump your data using tha
Hrm, well, proof's in the pudding I guess. I went back and rebuilt with
pg-hier after reading this and I'm seeing the results you expect, seems
to be working. I don't know what I did yesterday, but I wasn't paying
attention somewhere. Currently working on backing up a test db, then
will try
On Fri, Jun 03, 2005 at 05:55:36PM -0500, Gerald D. Anderson wrote:
> Ok, you're over my head now so I'm just going to post the results in the
> hope that something clicks. Here ya go:
Ok, I diff'ed both and guess what:
("a" is your output, "b" is mine)
07:19 drizzt ~ 0$ diff a b
38c38
< :lim
Ok, you're over my head now so I'm just going to post the results in the
hope that something clicks. Here ya go:
({QUERY :commandType 1 :querySource 0 :canSetTag true :utilityStmt <>
:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable
({RTE :alias {ALIAS :aliasname *OLD* :col
On Fri, Jun 03, 2005 at 06:48:06AM -0500, Gerald D. Anderson wrote:
> Yup, was just going to respond this morning. It isn't enabled by
> default (at least in the ebuilds I've looked at). I've built it with
> pg_hier and without pg_hier and get the same results either way : /
> Might there be
Yup, was just going to respond this morning. It isn't enabled by
default (at least in the ebuilds I've looked at). I've built it with
pg_hier and without pg_hier and get the same results either way : /
Might there be some other cause for this? Or even a dirty fix if this
is what it is?
G
On Fri, 3 Jun 2005 12:38 am, Tom Lane wrote:
> "Gerald D. Anderson" <[EMAIL PROTECTED]> writes:
> > So, the plot thickens. Is there somewhere I can go tweak a few bytes to
> > make it think it's 7.3?
>
> No. That's not what you want anyway; you want a late 7.4 build, just
> one without the hier
"Gerald D. Anderson" <[EMAIL PROTECTED]> writes:
> So, the plot thickens. Is there somewhere I can go tweak a few bytes to
> make it think it's 7.3?
No. That's not what you want anyway; you want a late 7.4 build, just
one without the hierarchical-queries patch. I dunno enough about Gentoo
to s
Ok, well it looks like Richard owes Tom a lunch, or that's my best guess
anyway. I am running Gentoo, as far as that particular patch, I'm
unsure, but if it's installed by default then yes. So, I've pulled down
the earliest ebuild I can get which is 7.3.6. Get it installed and go
to start it
Richard Huxton writes:
> Yep - I'm guessing it's an issue with an array (group membership?) in
> pg_user.
No, I'll bet lunch that Alvaro fingered the correct culprit: either
addition or subtraction of that darn hierarchical-query patch. It
changes the on-disk representation of view rules in a w
Gerald D. Anderson wrote:
data # pg_dump -Fc -f blah.txt -tforums_auth forums22 -uUser
name: postgres
Password:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of
input node
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHE
On Wed, Jun 01, 2005 at 10:24:25AM -0500, Gerald D. Anderson wrote:
> Greetings!
>
> At some point, I'm not even sure when, I apparently had a bad upgrade on
> one of my production databases. I'm in a situation now where I've got
> my back up against a wall and not sure what to do. The problem
data # pg_dump -Fc -f blah.txt -tforums_auth forums22 -u
User name: postgres
Password:
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: did not find '}' at end of
input node
pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE
usesysid = datdba) as d
Gerald D. Anderson wrote:
Greetings!
At some point, I'm not even sure when, I apparently had a bad upgrade on
one of my production databases. I'm in a situation now where I've got
my back up against a wall and not sure what to do. The problem is, I'm
receiving this message frequently:
did
Greetings!
At some point, I'm not even sure when, I apparently had a bad upgrade on
one of my production databases. I'm in a situation now where I've got
my back up against a wall and not sure what to do. The problem is, I'm
receiving this message frequently:
did not find '}' at end of inp
16 matches
Mail list logo
