Skip site navigation (1) Skip section navigation (2)

Problem with psql backward compatibility

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Problem with psql backward compatibility
Date: 2009-07-19 19:18:36
Message-ID: 200907191918.n6JJIav09150@momjian.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
I thought we wanted psql to be able to connect to older databases and
report \d values properly.  I see 8.4 psql \d is not working for
sequences in 8.3 databases:

	$ psql regression
	psql (8.4.0, server 8.3.7)
	WARNING: psql version 8.4, server version 8.3.
	         Some psql features might not work.
	Type "help" for help.
	
	regression=> \d serialtest_f2_foo
	ERROR:  column "start_value" does not exist
	LINE 2:        start_value, increment_by,

The new 8.4 seqeuence "start_value" is the problem.  Should I fix this
or does someone else want to tackle it?

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-07-19 21:00:43
Subject: pgsql: Rewrite GEQO's gimme_tree function so that it always finds a
Previous:From: Dean RasheedDate: 2009-07-19 19:18:26
Subject: Re: WIP: Deferrable unique constraints

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group