On 5/25/14, 11:44 AM, Andres Freund wrote:
Hi,
On 2014-05-23 08:23:57 -0600, Jeff Ross wrote:
UDB=# \x
Expanded display is on.
UDB=# SELECT attrelid::regclass, attname, attnum, attlen, *
FROM pg_attribute
WHERE attrelid = 'masterairportlist'::regclass
ORDER BY attnum ASC;
UDB=#
[ RECORD 1
On 5/23/14, 7:36 AM, Andres Freund wrote:
Any chance you could, *before* you create the toast table, do a:
SELECT attrelid::regclass, attname, attnum, attlen, *
FROM pg_attribute
WHERE attrelid = 'a'::regclass
ORDER BY attnum ASC;
Where 'a' is replaced by the affected table?
Greetings,
On 5/23/14, 7:21 AM, Bruce Momjian wrote:
On Thu, May 22, 2014 at 09:20:38AM -0600, Jeff Ross wrote:
I just tested ALTER TABLE in 8.4 and it does create a toast table for
this case in 9.4:
CREATE TABLE test (x CHAR(10));
ALTER TABLE test ALTER COLUMN x TYPE CHAR(8000);
I
On 5/21/14, 2:37 PM, Bruce Momjian wrote:
On Wed, May 21, 2014 at 04:23:34PM -0400, Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
On Wed, May 21, 2014 at 10:56:59AM -0600, Jeff Ross wrote:
Yes, using 9.3's pg_dump of 8.4 and applying it to both an 8.4 and a
9.3 cluster
On 5/21/14, 9:13 AM, Bruce Momjian wrote:
On Wed, May 21, 2014 at 09:11:05AM -0600, Jeff Ross wrote:
-- For binary upgrade, set heap's relfrozenxid
UPDATE pg_catalog.pg_class
SET relfrozenxid = '1944'
WHERE oid = 'contact_email'::pg_catalog.regclass;
-- For binary upgrade, set toast's
and it
restored with psql to 9.3.4 with no issues but the overall migration
will really be too big to go this route.
Any ideas?
Thanks!
Jeff Ross
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
On 5/20/14, 2:22 PM, Bruce Momjian wrote:
On Tue, May 20, 2014 at 12:59:31PM -0600, Jeff Ross wrote:
Removing support functions from new cluster ok
Copying user relation files
/var/lib/postgresql/8.4/main/base/4275487/4278965
Mismatch of relation OID in database FNBooking