Errata

The order of the numbered list goes "1, 3, 2, 4, 5" instead of in order, with no real reason given for why 3 comes before 2.

Note from the Author or Editor:
Thanks. Committed correction

Improve of in-memory sort operations by as much as 20%. Could be changed to either

1. Improvement of in-memory sort operations by as much as 20%.
or
2 Improved in-memory sort operations by as much as 20%.

Note from the Author or Editor:
Already corrected in latest draft

2 sentence. You can new persist data into frequently used views to avoid making repeated retrieval calls for slow queries.

new should be now

Note from the Author or Editor:
already corrected

Missing word. assuming you can even locate someone willing to the work, should read assuming you can even locate someone willing to do the work.

Note from the Author or Editor:
already corrected

Last line has the word Server spelled as Servaer

Note from the Author or Editor:
already corrected

The sentence "If you think of the database as being a county, schemas would bee the individual states"
I believe you meant country, not county

Note from the Author or Editor:
Will be fixed in next release

"Both SQL Servaer[sic] and Oracle have sequence objects"

From PDF copy obtained 7/21/14

Note from the Author or Editor:
Fixed in draft. Should show in next draft release.

One spacing error observed on Preface | xii

No space after quotation mark observed, excerpted:

cool �Eureka!"stuff

And in the original text, marked by **** after instance:

'This book is geared at demonstrating the unique features of PostgreSQL that make it
stand apart from other databases, as well as how to use these features to solve real world
problems. You�ll learn how to do things you never knew were possible with a database.
Aside from the cool �Eureka!"stuff,**** we will also demonstrate bread-and-butter tasks,
such as how to manage your database, how to set up security, troubleshoot performance,
improve performance, and how to connect to it with various desktop, command-line,
and development tools.'

Three comma spacing errors observed on Preface | xi

Space before comma observed, excerpted:

1. With CREATE EXTENSION , you
2. postgis spatial extension , and

And in the original text, marked by **** after instance

'If building your own types and functions is not your thing, you have a wide variety of
built-in data types, such as JSON introduced in 9.2, and extensions that provide more
types to choose from. Many of these extensions are packaged with PostgreSQL distros.
PostgreSQL 9.1 introduced a new SQL construct, CREATE EXTENSION, which allows you
to install the many available extensions with a single SQL statement for each in a specific
database. With CREATE EXTENSION ,**** you can install in your database any of the aforementioned
PL languages and popular types with their companion functions and operators,
like hstore key-value store, ltree hierarchical store, postgis spatial extension ,**** and
countless others. For example, to install the popular PostgreSQL key-value store type
and its companion functions and operators, you would type:'

No space around comma observed, excerpted:

3. can run,see �Extensions

And in the original text, marked by **** after instance

'In addition, there is an SQL command you can run,see**** �Extensions and Contribs� on
page 26 for list of available and installed extensions.'

Note from the Author or Editor:
Should be mostly fixed now in our manuscript. I think some were caused by things we thought were spaces but rally unprintable characters when it came to pdf gen so just retyped the space in.

"Don�t Givie[sic] Full Administrative Rights to the Postgres System
(Daemon) Account"

spurious letter 'i' before the e of 'Give'.

Note from the Author or Editor:
Hmm not seeing it in 2nd edition. We might have fixed it since last run since I do recall seeing that typo and fixing it.