and loop to try the UPDATE again. END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); This coding assumes the unique_violation error is caused by the INSERT schema-qualified when they should be. • Widen COPY FROM’s current-line-number counter from 32 to 64 bits (David Rowley) This avoids two problems with input exceeding 4G lines: COPY FROM WITH HEADER would drop OIDs when creating a new TOAST entry. • Change ANALYZE’s algorithm for updating pg_class.reltuples (David Gould) Previously, pages not actually scanned by ANALYZE were assumed to retain their old tuple density

and loop to try the UPDATE again. END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); This coding assumes the unique_violation error is caused by the INSERT schema-qualified when they should be. • Widen COPY FROM’s current-line-number counter from 32 to 64 bits (David Rowley) This avoids two problems with input exceeding 4G lines: COPY FROM WITH HEADER would drop OIDs when creating a new TOAST entry. • Change ANALYZE’s algorithm for updating pg_class.reltuples (David Gould) Previously, pages not actually scanned by ANALYZE were assumed to retain their old tuple density

and loop to try the UPDATE again. END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); This coding assumes the unique_violation error is caused by the INSERT to produce a wrapping element. • Improve performance of pg_timezone_names view (Tom Lane, David Rowley) • Fix sloppy handling of corner-case errors from lseek() and close() (Tom Lane) Neither for output. • Use correct daylight-savings rules for POSIX-style time zone names in MSVC builds (David Row- ley) The Microsoft MSVC build scripts neglected to install the posixrules file in the timezone

PostgreSQL 9.2 Documentation

and loop to try the UPDATE again. END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); This coding assumes the unique_violation error is caused by the INSERT to produce a wrapping

element. • Improve performance of pg_timezone_names view (Tom Lane, David Rowley) • Fix sloppy handling of corner-case errors from lseek() and close() (Tom Lane) Neither for output. • Use correct daylight-savings rules for POSIX-style time zone names in MSVC builds (David Rowley) The Microsoft MSVC build scripts neglected to install the posixrules file in the timezone

PostgreSQL 9.1.24 Documentation

and loop to try the UPDATE again. END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); This example assumes the unique_violation error is caused by the Meskes) • Fix psql to sanely handle URIs and conninfo strings as the first parameter to \connect (David Fetter, Andrew Dunstan, Álvaro Herrera) This syntax has been accepted (but undocumented) for a long Notes • Reject duplicate column names in the referenced-columns list of a FOREIGN KEY declaration (David Rowley) This restriction is per SQL standard. Previously we did not reject the case explicitly, but

0 码力 | 2667 页 | 6.57 MB | 1 年前

3

PostgreSQL 9.1 Documentation

and loop to try the UPDATE again. END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); This example assumes the unique_violation error is caused by the Meskes) • Fix psql to sanely handle URIs and conninfo strings as the first parameter to \connect (David Fetter, Andrew Dunstan, Álvaro Herrera) This syntax has been accepted (but undocumented) for a long table. • Reject duplicate column names in the referenced-columns list of a FOREIGN KEY declaration (David Rowley) This restriction is per SQL standard. Previously we did not reject the case explicitly, but

0 码力 | 2836 页 | 6.62 MB | 1 年前

3

PostgreSQL 9.0 Documentation

nothing, and loop to try the UPDATE again END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); 39.7. Cursors Rather than executing a whole query at once, it is Meskes) • Fix psql to sanely handle URIs and conninfo strings as the first parameter to \connect (David Fetter, Andrew Dunstan, Álvaro Herrera) This syntax has been accepted (but undocumented) for a long table. • Reject duplicate column names in the referenced-columns list of a FOREIGN KEY declaration (David Rowley) This restriction is per SQL standard. Previously we did not reject the case explicitly, but

0 码力 | 2561 页 | 5.55 MB | 1 年前

3

PostgreSQL 9.0 Documentation

nothing, and loop to try the UPDATE again END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); 39.7. Cursors Rather than executing a whole query at once, it is Meskes) • Fix psql to sanely handle URIs and conninfo strings as the first parameter to \connect (David Fetter, Andrew Dunstan, Álvaro Herrera) This syntax has been accepted (but undocumented) for a long table. • Reject duplicate column names in the referenced-columns list of a FOREIGN KEY declaration (David Rowley) This restriction is per SQL standard. Previously we did not reject the case explicitly, but

0 码力 | 2401 页 | 5.50 MB | 1 年前

3

PostgreSQL 8.4 Documentation

nothing, and loop to try the UPDATE again END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); 38.7. Cursors Rather than executing a whole query at once, it is Don’t assume a subquery’s output is unique if there’s a set-returning function in its targetlist (David Rowley) This oversight could lead to misoptimization of constructs like WHERE x IN (SELECT y, generate_series(1 the preferred version of xsubpp to build PL/Perl, not necessarily the operating system’s main copy (David Wheeler and Alex Hunsaker) • Fix incorrect coding in contrib/dict_int and contrib/dict_xsyn (Tom

0 码力 | 2224 页 | 5.05 MB | 1 年前

3

PostgreSQL 8.4 Documentation

nothing, and loop to try the UPDATE again END; END LOOP; END; $$ LANGUAGE plpgsql; SELECT merge_db(1, ’david’); SELECT merge_db(1, ’dennis’); 38.7. Cursors Rather than executing a whole query at once, it is Don’t assume a subquery’s output is unique if there’s a set-returning function in its targetlist (David Rowley) This oversight could lead to misoptimization of constructs like WHERE x IN (SELECT y, generate_series(1 the preferred version of xsubpp to build PL/Perl, not necessarily the operating system’s main copy (David Wheeler and Alex Hunsaker) • Fix incorrect coding in contrib/dict_int and contrib/dict_xsyn (Tom

0 码力 | 2371 页 | 5.09 MB | 1 年前

3