pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Amit Langote <amitlangote09@gmail.com>
Cc: John Naylor <john.naylor@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Justin Pryzby <pryzby@telsasoft.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: assert pg_class.relnatts is consistent
Date: Fri, 14 Feb 2020 12:13:01 -0300
Message-ID: <20200214151301.GA6618@alvherre.pgsql> (raw)
In-Reply-To: <CA+HiwqGnoqzr6kWfzS56FxhT49iZXZF_susVNHwUHoLrK=v8pw@mail.gmail.com>

I propose this more concise coding for AddDefaultValues,

	# Now fill in defaults, and note any columns that remain undefined.
	foreach my $column (@$schema)
	{
		my $attname = $column->{name};
		my $atttype = $column->{type};

		# Skip if a value already exists
		next if defined $row->{$attname};

		# 'oid' and 'relnatts' are special cases. Ignore.
		next if $attname eq 'oid';
		next if $attname eq 'relnatts';

		# This column has a default value.  Fill it in.
		if (defined $column->{default})
		{
			$row->{$attname} = $column->{default};
			next;
		}

		# Failed to find a value.
		push @missing_fields, $attname;
	}

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





view thread (20+ messages)  latest in thread

Message-ID: <20200214151301.GA6618@alvherre.pgsql>
Permalink:  ../20200214151301.GA6618@alvherre.pgsql/
Also on:    postgresql.org/message-id/20200214151301.GA6618@alvherre.pgsql

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: alvherre@2ndquadrant.com, amitlangote09@gmail.com, john.naylor@2ndquadrant.com, tgl@sss.pgh.pa.us, pryzby@telsasoft.com
  Subject: Re: assert pg_class.relnatts is consistent
  In-Reply-To: <20200214151301.GA6618@alvherre.pgsql>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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