pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedAnyone seen this message?
6+ messages / 4 participants
[nested] [flat]
* Anyone seen this message?
@ 2007-07-12 19:04 Carol Walter <walterc@indiana.edu>
2007-07-12 19:18 ` Re: Anyone seen this message? Alvaro Herrera <alvherre@commandprompt.com>
2007-07-13 19:01 ` Re: Anyone seen this message? Srinivas Kotapally <ksrinivas@bisil.com>
0 siblings, 2 replies; 6+ messages in thread
From: Carol Walter @ 2007-07-12 19:04 UTC (permalink / raw)
To: pgsql-admin
Hello, Everyone,
You've been really helpful it the past; I sure hope someone knows
this one. When I try to describe the tables of one of my users the
system returns the message as follows:
"column i.indisvalid does not exist"
It doesn't give any other info. Has anyone seen this message, and
more importantly, what do I do about it.
Thanks so much,
Carol
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Anyone seen this message?
2007-07-12 19:04 Anyone seen this message? Carol Walter <walterc@indiana.edu>
@ 2007-07-12 19:18 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-07-12 19:44 ` Re: Anyone seen this message? Ned Wolpert <ned.wolpert@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Alvaro Herrera @ 2007-07-12 19:18 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Carol Walter wrote:
> Hello, Everyone,
>
> You've been really helpful it the past; I sure hope someone knows this one.
> When I try to describe the tables of one of my users the system returns
> the message as follows:
> "column i.indisvalid does not exist"
> It doesn't give any other info. Has anyone seen this message, and more
> importantly, what do I do about it.
Don't use a mismatching psql version with the server version.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Now I have my system running, not a byte was off the shelf;
It rarely breaks and when it does I fix the code myself.
It's stable, clean and elegant, and lightning fast as well,
And it doesn't cost a nickel, so Bill Gates can go to hell."
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Anyone seen this message?
2007-07-12 19:04 Anyone seen this message? Carol Walter <walterc@indiana.edu>
2007-07-12 19:18 ` Re: Anyone seen this message? Alvaro Herrera <alvherre@commandprompt.com>
@ 2007-07-12 19:44 ` Ned Wolpert <ned.wolpert@gmail.com>
2007-07-12 19:53 ` Re: Anyone seen this message? Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ned Wolpert @ 2007-07-12 19:44 UTC (permalink / raw)
To: pgsql-admin
Let me ask a further question for clarification on this point, just to
be sure... though I'm going to bet I know the answer... just want to
be sure.
In my current production environment, the PostgreSQL database server
is the latest, 8.2.4. The apps that communicate with it are planned
to be running on stock CentOS5 servers, with the default 8.1.x (8.1.9)
client libraries. So, not only is psql 8.1.9 (which I don't use on
that server) but the libpq.so is from the 8.1.9 install. Apache 2.2
package uses the DBDriver module from the apr-util that was installed
from CentOS, and we are planning to connect it to our PostgreSQL
server. Is that a 'bad thing' considering the libpq.so is a different
major version?
In the case of Java JDBC drivers, is this also a problem? (Using the
JDBC driver from the 8.1 release against the 8.2 server)
And thanks for clarification.
On 7/12/07, Alvaro Herrera <alvherre@commandprompt.com> wrote:
>
> Don't use a mismatching psql version with the server version.
>
--
Virtually, Ned Wolpert
http://www.codeheadsystems.com/blog/
"Settle thy studies, Faustus, and begin..." --Marlowe
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Anyone seen this message?
2007-07-12 19:04 Anyone seen this message? Carol Walter <walterc@indiana.edu>
2007-07-12 19:18 ` Re: Anyone seen this message? Alvaro Herrera <alvherre@commandprompt.com>
2007-07-12 19:44 ` Re: Anyone seen this message? Ned Wolpert <ned.wolpert@gmail.com>
@ 2007-07-12 19:53 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-07-12 21:40 ` Re: Anyone seen this message? Ned Wolpert <ned.wolpert@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Alvaro Herrera @ 2007-07-12 19:53 UTC (permalink / raw)
To: Ned Wolpert <ned.wolpert@gmail.com>; +Cc: pgsql-admin
Ned Wolpert escribió:
> In my current production environment, the PostgreSQL database server
> is the latest, 8.2.4. The apps that communicate with it are planned
> to be running on stock CentOS5 servers, with the default 8.1.x (8.1.9)
> client libraries. So, not only is psql 8.1.9 (which I don't use on
> that server) but the libpq.so is from the 8.1.9 install. Apache 2.2
> package uses the DBDriver module from the apr-util that was installed
> from CentOS, and we are planning to connect it to our PostgreSQL
> server. Is that a 'bad thing' considering the libpq.so is a different
> major version?
No. It is only a problem for psql because it uses some queries that
assume things about the system catalogs (for example psql 8.2 assumes
that pg_index.indisvalid exists, which it doesn't on 8.1).
Did you win the bet?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Anyone seen this message?
2007-07-12 19:04 Anyone seen this message? Carol Walter <walterc@indiana.edu>
2007-07-12 19:18 ` Re: Anyone seen this message? Alvaro Herrera <alvherre@commandprompt.com>
2007-07-12 19:44 ` Re: Anyone seen this message? Ned Wolpert <ned.wolpert@gmail.com>
2007-07-12 19:53 ` Re: Anyone seen this message? Alvaro Herrera <alvherre@commandprompt.com>
@ 2007-07-12 21:40 ` Ned Wolpert <ned.wolpert@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Ned Wolpert @ 2007-07-12 21:40 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
This is one bet I'm glad to lose. :-)
Alvaro Herrera wrote:
> Ned Wolpert escribió:
>
>> In my current production environment, the PostgreSQL database server
>> is the latest, 8.2.4. The apps that communicate with it are planned
>> to be running on stock CentOS5 servers, with the default 8.1.x (8.1.9)
>> client libraries. So, not only is psql 8.1.9 (which I don't use on
>> that server) but the libpq.so is from the 8.1.9 install. Apache 2.2
>> package uses the DBDriver module from the apr-util that was installed
>> from CentOS, and we are planning to connect it to our PostgreSQL
>> server. Is that a 'bad thing' considering the libpq.so is a different
>> major version?
>
> No. It is only a problem for psql because it uses some queries that
> assume things about the system catalogs (for example psql 8.2 assumes
> that pg_index.indisvalid exists, which it doesn't on 8.1).
>
> Did you win the bet?
>
- --
Virtually,
Ned Wolpert <ned.wolpert@gmail.com> ACF63C1E
An idea is something you have; an ideology is something that has you.
-Morris Berman
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGlp+92nkMaKz2PB4RAp0iAJ9jUJPlExZSf1y0XHsQAfS9rTBWjwCeNDzS
TNS8x8Bf4Wu1BSjBH+CdJnE=
=9hq3
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Anyone seen this message?
2007-07-12 19:04 Anyone seen this message? Carol Walter <walterc@indiana.edu>
@ 2007-07-13 19:01 ` Srinivas Kotapally <ksrinivas@bisil.com>
1 sibling, 0 replies; 6+ messages in thread
From: Srinivas Kotapally @ 2007-07-13 19:01 UTC (permalink / raw)
To: 'Carol Walter' <walterc@indiana.edu>; pgsql-admin
I think this is a user/ table permission issue.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]
On Behalf Of Carol Walter
Sent: Thursday, July 12, 2007 3:04 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Anyone seen this message?
Hello, Everyone,
You've been really helpful it the past; I sure hope someone knows this one.
When I try to describe the tables of one of my users the system returns the
message as follows:
"column i.indisvalid does not exist"
It doesn't give any other info. Has anyone seen this message, and more
importantly, what do I do about it.
Thanks so much,
Carol
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2007-07-13 19:01 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-12 19:04 Anyone seen this message? Carol Walter <walterc@indiana.edu>
2007-07-12 19:18 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-07-12 19:44 ` Ned Wolpert <ned.wolpert@gmail.com>
2007-07-12 19:53 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-07-12 21:40 ` Ned Wolpert <ned.wolpert@gmail.com>
2007-07-13 19:01 ` Srinivas Kotapally <ksrinivas@bisil.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox