pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Anyone seen this message?
6+ messages / 4 participants
[nested] [flat]

* Anyone seen this message?
@ 2007-07-12 19:04  Carol Walter <walterc@indiana.edu>
  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:18  Alvaro Herrera <alvherre@commandprompt.com>
  parent: Carol Walter <walterc@indiana.edu>
  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:44  Ned Wolpert <ned.wolpert@gmail.com>
  parent: 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:53  Alvaro Herrera <alvherre@commandprompt.com>
  parent: 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 21:40  Ned Wolpert <ned.wolpert@gmail.com>
  parent: Alvaro Herrera <alvherre@commandprompt.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-13 19:01  Srinivas Kotapally <ksrinivas@bisil.com>
  parent: Carol Walter <walterc@indiana.edu>
  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