<DT><A HREF="http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?subject=schema&server=localhost%3A5432%3Aallow&database=vegbien&schema=public" name="__http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?subject=schema&server=localhost%3A5432%3Aallow&database=vegbien&schema=public" ADD_DATE="1362008923" ICON_URI="http://vegbiendev.nceas.ucsb.edu/phppgadmin/images/themes/default/Introduction.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://vegbiendev.nceas.ucsb.edu/phppgadmin/images/themes/default/Introduction.png" style="margin-right: 0.5em;"/>vegbiendev</A><a name="__vegbiendev" href="#__vegbiendev" style="margin-left: 0.5em;">&para;</a>

            <DT><a name="data management" href="#data management"><H3 ADD_DATE="1382474141">data management</H3></a>

            <DL><p>

                <DT><A HREF="http://en.wikipedia.org/wiki/Data_management_plan" name="http://en.wikipedia.org/wiki/Data_management_plan" ADD_DATE="1382473829" ICON_URI="http://bits.wikimedia.org/favicon/wikipedia.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bits.wikimedia.org/favicon/wikipedia.ico" style="margin-right: 0.5em;"/>Data management plan - Wikipedia, the free encyclopedia</A><a name="Data management plan - Wikipedia, the free encyclopedia" href="#Data management plan - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;By deciding on an archive ahead of time, the data collector can format data during collection to make its future submission to a database easier&quot;

"It also allows the data collector to direct requests for data to the database, rather than address requests individually"

"Funding agencies are beginning to require data management plans as part of the proposal and evaluation process"

"management and preservation costs may be considerable, depending on the nature of the project"

                <DT><A HREF="http://www.nsf.gov/bfa/dias/policy/dmpfaqs.jsp" name="http://www.nsf.gov/bfa/dias/policy/dmpfaqs.jsp" ADD_DATE="1382474080" LAST_CHARSET="windows-1252"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>US NSF - About: Data Management &amp; Sharing Frequently Asked Questions (FAQs)</A><a name="US NSF - About: Data Management &amp; Sharing Frequently Asked Questions (FAQs)" href="#US NSF - About: Data Management &amp; Sharing Frequently Asked Questions (FAQs)" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;Usually, preserving the data in its most raw form is desirable, although data derivatives and products can also be preserved&quot;

"The expectation is that all data will be made available after a reasonable length of time"

"One standard of timeliness is to make the data or samples accessible immediately after publication"

"It is NSF’s strong expectation that investigators will share with other researchers, at no more than incremental cost and within a reasonable time, the primary data, samples, physical collections and other supporting materials created or gathered in the course of work under NSF grants"

            </DL><p>

            <DT><a name="databases" href="#databases"><H3 ADD_DATE="1346355036">databases</H3></a>

                <DT><a name="relational" href="#relational"><H3 ADD_DATE="1382496134">relational</H3></a>

                    <DT><a name="modeling" href="#modeling"><H3 ADD_DATE="1382496221">modeling</H3></a>

                    <DL><p>

                        <DT><A HREF="http://en.wikipedia.org/wiki/Enhanced_Entity-Relationship_Model" name="http://en.wikipedia.org/wiki/Enhanced_Entity-Relationship_Model" ADD_DATE="1382495932" ICON_URI="http://bits.wikimedia.org/favicon/wikipedia.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bits.wikimedia.org/favicon/wikipedia.ico" style="margin-right: 0.5em;"/>Enhanced entity–relationship model - Wikipedia, the free encyclopedia</A><a name="Enhanced entity–relationship model - Wikipedia, the free encyclopedia" href="#Enhanced entity–relationship model - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;MySQL Workbench offers creating, editing and exporting EER Models&quot;

                        <DT><A HREF="http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools" name="http://wiki.postgresql.org/wiki/GUI_Database_Design_Tools" ADD_DATE="1318547198" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>GUI Database Design Tools - PostgreSQL wiki</A><a name="GUI Database Design Tools - PostgreSQL wiki" href="#GUI Database Design Tools - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>

                    </DL><p>

                    <DT><a name="MDB" href="#MDB"><H3 ADD_DATE="1346359651">MDB</H3></a>

                    <DL><p>

                        <DT><A HREF="http://dba.openoffice.org/drivers/mdb/index.html" name="http://dba.openoffice.org/drivers/mdb/index.html" ADD_DATE="1317750487" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Linux MDB driver - alpha version</A><a name="Linux MDB driver - alpha version" href="#Linux MDB driver - alpha version" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="http://www.automatthew.com/2008/02/how-to-compile-mdbtools-on-mac-os-x.html" name="http://www.automatthew.com/2008/02/how-to-compile-mdbtools-on-mac-os-x.html" ADD_DATE="1317751954" ICON_URI="http://www.automatthew.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.automatthew.com/favicon.ico" style="margin-right: 0.5em;"/>The Electrofriend: How to compile mdbtools on Mac OS X 10.4 and 10.5</A><a name="The Electrofriend: How to compile mdbtools on Mac OS X 10.4 and 10.5" href="#The Electrofriend: How to compile mdbtools on Mac OS X 10.4 and 10.5" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="http://mdbtools.sourceforge.net/" name="http://mdbtools.sourceforge.net/" ADD_DATE="1346359637" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MDB Tools - Unlocking Your Data</A><a name="MDB Tools - Unlocking Your Data" href="#MDB Tools - Unlocking Your Data" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="http://www.razorsql.com/articles/ms_access_mac_os_x.html" name="http://www.razorsql.com/articles/ms_access_mac_os_x.html" ADD_DATE="1317751758" ICON_URI="http://www.razorsql.com/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://www.razorsql.com/favicon.ico" style="margin-right: 0.5em;"/>How to Open and Edit MS Access Databases from Mac OS X</A><a name="How to Open and Edit MS Access Databases from Mac OS X" href="#How to Open and Edit MS Access Databases from Mac OS X" style="margin-left: 0.5em;">&para;</a>

                    </DL><p>

                    <DT><a name="SQL" href="#SQL"><H3 ADD_DATE="1365883347">SQL</H3></a>

                        <DT><a name="inheritance" href="#inheritance"><H3 ADD_DATE="1367832786">inheritance</H3></a>

                        <DL><p>

                            <DT><A HREF="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database" name="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database" ADD_DATE="1365882420" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>sql - How can you represent inheritance in a database? - Stack Overflow</A><a name="sql - How can you represent inheritance in a database? - Stack Overflow" href="#sql - How can you represent inheritance in a database? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://forums.xkcd.com/viewtopic.php?f=40&t=100131" name="http://forums.xkcd.com/viewtopic.php?f=40&t=100131" ADD_DATE="1365882944" ICON_URI="http://forums.xkcd.com/favicon.ico"><img width="16" height="16" src="http://forums.xkcd.com/favicon.ico" style="margin-right: 0.5em;"/>xkcd • View topic - Inheritance in SQL</A><a name="xkcd • View topic - Inheritance in SQL" href="#xkcd • View topic - Inheritance in SQL" style="margin-left: 0.5em;">&para;</a>

                        <DT><a name="PostgreSQL" href="#PostgreSQL"><H3 ADD_DATE="1333386475">PostgreSQL</H3></a>

                            <DT><a name="disk space" href="#disk space"><H3 ADD_DATE="1340661986">disk space</H3></a>

                                <DT><a name="quotas" href="#quotas"><H3 ADD_DATE="1373521860">quotas</H3></a>

                                <DL><p>

                                    <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Best-way-to-limit-database-sizes-td2089238.html" name="http://postgresql.1045698.n5.nabble.com/Best-way-to-limit-database-sizes-td2089238.html" ADD_DATE="1373521754" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - admin - Best way to limit database sizes</A><a name="PostgreSQL - admin - Best way to limit database sizes" href="#PostgreSQL - admin - Best way to limit database sizes" style="margin-left: 0.5em;">&para;</a>

                                </DL><p>

                                <DT><A HREF="http://dba.stackexchange.com/questions/3491/postgresql-disk-space-not-released-after-truncate" name="http://dba.stackexchange.com/questions/3491/postgresql-disk-space-not-released-after-truncate" ADD_DATE="1340661221" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Disk space not released after TRUNCATE - Database Administrators</A><a name="PostgreSQL: Disk space not released after TRUNCATE - Database Administrators" href="#PostgreSQL: Disk space not released after TRUNCATE - Database Administrators" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="https://issues.apache.org/jira/browse/JENA-28" name="https://issues.apache.org/jira/browse/JENA-28" ADD_DATE="1340661975" ICON_URI="https://issues.apache.org/jira/s/en_UKd9dgiy/731/4/_/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://issues.apache.org/jira/s/en_UKd9dgiy/731/4/_/favicon.ico" style="margin-right: 0.5em;"/>[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA</A><a name="[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA" href="#[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://wiki.postgresql.org/wiki/VACUUM_FULL" name="http://wiki.postgresql.org/wiki/VACUUM_FULL" ADD_DATE="1340665068" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>VACUUM FULL - PostgreSQL wiki</A><a name="VACUUM FULL - PostgreSQL wiki" href="#VACUUM FULL - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/sql-cluster.html" name="http://www.postgresql.org/docs/8.3/static/sql-cluster.html" ADD_DATE="1340665221" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: CLUSTER</A><a name="PostgreSQL: Documentation: 8.3: CLUSTER" href="#PostgreSQL: Documentation: 8.3: CLUSTER" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://archives.postgresql.org/pgsql-sql/2006-09/msg00142.php" name="http://archives.postgresql.org/pgsql-sql/2006-09/msg00142.php" ADD_DATE="1340668156" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Re: ERROR: could not write block 196261 of temporary file: No space left</A><a name="Re: ERROR: could not write block 196261 of temporary file: No space left" href="#Re: ERROR: could not write block 196261 of temporary file: No space left" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://postgresql-in.blogspot.com/2008/04/postgresql-in-place-update.html" name="http://postgresql-in.blogspot.com/2008/04/postgresql-in-place-update.html" ADD_DATE="1340673360" ICON_URI="http://postgresql-in.blogspot.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql-in.blogspot.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: PostgreSQL: In place UPDATE</A><a name="PostgreSQL: PostgreSQL: In place UPDATE" href="#PostgreSQL: PostgreSQL: In place UPDATE" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://forums.untangle.com/installation/28084-disk-suddenly-full-postgres-using-all-space.html" name="http://forums.untangle.com/installation/28084-disk-suddenly-full-postgres-using-all-space.html" ADD_DATE="1340845831" ICON_URI="http://forums.untangle.com/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://forums.untangle.com/favicon.ico" style="margin-right: 0.5em;"/>disk suddenly full, postgres using all space - Untangle Forums</A><a name="disk suddenly full, postgres using all space - Untangle Forums" href="#disk suddenly full, postgres using all space - Untangle Forums" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: A customer box that&#39;s never used more than a few gigs of space suddenly ran out of disk space so bad the captive portal page wouldn&#39;t load properly.

                            <DT><a name="doc" href="#doc"><H3 ADD_DATE="1366152313">doc</H3></a>

                            <DL><p>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/functions-array.html" name="http://www.postgresql.org/docs/8.3/static/functions-array.html" ADD_DATE="1345012706" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: Array Functions and Operators</A><a name="PostgreSQL: Documentation: 8.3: Array Functions and Operators" href="#PostgreSQL: Documentation: 8.3: Array Functions and Operators" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/plpgsql-control-structures.html" name="http://www.postgresql.org/docs/8.3/static/plpgsql-control-structures.html" ADD_DATE="1342742575" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: Control Structures</A><a name="PostgreSQL: Documentation: 8.3: Control Structures" href="#PostgreSQL: Documentation: 8.3: Control Structures" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/errcodes-appendix.html" name="http://www.postgresql.org/docs/8.3/static/errcodes-appendix.html" ADD_DATE="1339194918" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: Error Codes</A><a name="PostgreSQL: Documentation: 8.3: Error Codes" href="#PostgreSQL: Documentation: 8.3: Error Codes" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/interactive/plpgsql-errors-and-messages.html" name="http://www.postgresql.org/docs/8.3/interactive/plpgsql-errors-and-messages.html" ADD_DATE="1341337017" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: Errors and Messages</A><a name="PostgreSQL: Documentation: 8.3: Errors and Messages" href="#PostgreSQL: Documentation: 8.3: Errors and Messages" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/hstore.html" name="http://www.postgresql.org/docs/8.3/static/hstore.html" ADD_DATE="1344312818" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: hstore</A><a name="PostgreSQL: Documentation: 8.3: hstore" href="#PostgreSQL: Documentation: 8.3: hstore" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/datatype-oid.html" name="http://www.postgresql.org/docs/8.3/static/datatype-oid.html" ADD_DATE="1350986387" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: Object Identifier Types</A><a name="PostgreSQL: Documentation: 8.3: Object Identifier Types" href="#PostgreSQL: Documentation: 8.3: Object Identifier Types" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/catalog-pg-enum.html" name="http://www.postgresql.org/docs/8.3/static/catalog-pg-enum.html" ADD_DATE="1349409516" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: pg_enum</A><a name="PostgreSQL: Documentation: 8.3: pg_enum" href="#PostgreSQL: Documentation: 8.3: pg_enum" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/plpython-funcs.html" name="http://www.postgresql.org/docs/8.3/static/plpython-funcs.html" ADD_DATE="1342571729" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: PL/Python Functions</A><a name="PostgreSQL: Documentation: 8.3: PL/Python Functions" href="#PostgreSQL: Documentation: 8.3: PL/Python Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/sql-rollback-to.html" name="http://www.postgresql.org/docs/8.3/static/sql-rollback-to.html" ADD_DATE="1340398641" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: ROLLBACK TO SAVEPOINT</A><a name="PostgreSQL: Documentation: 8.3: ROLLBACK TO SAVEPOINT" href="#PostgreSQL: Documentation: 8.3: ROLLBACK TO SAVEPOINT" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/functions-comparisons.html" name="http://www.postgresql.org/docs/8.3/static/functions-comparisons.html" ADD_DATE="1351586419" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: Row and Array Comparisons</A><a name="PostgreSQL: Documentation: 8.3: Row and Array Comparisons" href="#PostgreSQL: Documentation: 8.3: Row and Array Comparisons" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/functions-string.html" name="http://www.postgresql.org/docs/8.3/static/functions-string.html" ADD_DATE="1342738102" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: String Functions and Operators</A><a name="PostgreSQL: Documentation: 8.3: String Functions and Operators" href="#PostgreSQL: Documentation: 8.3: String Functions and Operators" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/functions-info.html" name="http://www.postgresql.org/docs/8.3/static/functions-info.html" ADD_DATE="1350027449" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: System Information Functions</A><a name="PostgreSQL: Documentation: 8.3: System Information Functions" href="#PostgreSQL: Documentation: 8.3: System Information Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/monitoring-stats.html" name="http://www.postgresql.org/docs/8.3/static/monitoring-stats.html" ADD_DATE="1338849024" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: The Statistics Collector</A><a name="PostgreSQL: Documentation: 8.3: The Statistics Collector" href="#PostgreSQL: Documentation: 8.3: The Statistics Collector" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.4/interactive/plpgsql-errors-and-messages.html" name="http://www.postgresql.org/docs/8.4/interactive/plpgsql-errors-and-messages.html" ADD_DATE="1343096314" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.4: Errors and Messages</A><a name="PostgreSQL: Documentation: 8.4: Errors and Messages" href="#PostgreSQL: Documentation: 8.4: Errors and Messages" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.4/static/xfunc-overload.html" name="http://www.postgresql.org/docs/8.4/static/xfunc-overload.html" ADD_DATE="1340247331" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.4: Function Overloading</A><a name="PostgreSQL: Documentation: 8.4: Function Overloading" href="#PostgreSQL: Documentation: 8.4: Function Overloading" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.4/static/xfunc-sql.html#XFUNC-SQL-VARIADIC-FUNCTIONS" name="http://www.postgresql.org/docs/8.4/static/xfunc-sql.html#XFUNC-SQL-VARIADIC-FUNCTIONS" ADD_DATE="1348017604" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.4: Query Language (SQL) Functions</A><a name="PostgreSQL: Documentation: 8.4: Query Language (SQL) Functions" href="#PostgreSQL: Documentation: 8.4: Query Language (SQL) Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.4/static/queries-with.html" name="http://www.postgresql.org/docs/8.4/static/queries-with.html" ADD_DATE="1357756970" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.4: WITH Queries (Common Table Expressions)</A><a name="PostgreSQL: Documentation: 8.4: WITH Queries (Common Table Expressions)" href="#PostgreSQL: Documentation: 8.4: WITH Queries (Common Table Expressions)" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.0/static/sql-syntax-calling-funcs.html" name="http://www.postgresql.org/docs/9.0/static/sql-syntax-calling-funcs.html" ADD_DATE="1340057070" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.0: Calling Functions</A><a name="PostgreSQL: Documentation: 9.0: Calling Functions" href="#PostgreSQL: Documentation: 9.0: Calling Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-altertable.html" name="http://www.postgresql.org/docs/9.1/static/sql-altertable.html" ADD_DATE="1367836103" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: ALTER TABLE</A><a name="PostgreSQL: Documentation: 9.1: ALTER TABLE" href="#PostgreSQL: Documentation: 9.1: ALTER TABLE" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-analyze.html" name="http://www.postgresql.org/docs/9.1/static/sql-analyze.html" ADD_DATE="1377904843" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: ANALYZE</A><a name="PostgreSQL: Documentation: 9.1: ANALYZE" href="#PostgreSQL: Documentation: 9.1: ANALYZE" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW" name="http://www.postgresql.org/docs/9.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW" ADD_DATE="1379915256" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Basic Statements: 39.5.4. Executing Dynamic Commands</A><a name="PostgreSQL: Documentation: 9.1: Basic Statements: 39.5.4. Executing Dynamic Commands" href="#PostgreSQL: Documentation: 9.1: Basic Statements: 39.5.4. Executing Dynamic Commands" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/datatype-binary.html" name="http://www.postgresql.org/docs/9.1/static/datatype-binary.html" ADD_DATE="1366908596" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Binary Data Types</A><a name="PostgreSQL: Documentation: 9.1: Binary Data Types" href="#PostgreSQL: Documentation: 9.1: Binary Data Types" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/multibyte.html" name="http://www.postgresql.org/docs/9.1/static/multibyte.html" ADD_DATE="1367850721" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Character Set Support</A><a name="PostgreSQL: Documentation: 9.1: Character Set Support" href="#PostgreSQL: Documentation: 9.1: Character Set Support" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-comment.html" name="http://www.postgresql.org/docs/9.1/static/sql-comment.html" ADD_DATE="1362547512" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: COMMENT</A><a name="PostgreSQL: Documentation: 9.1: COMMENT" href="#PostgreSQL: Documentation: 9.1: COMMENT" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-copy.html" name="http://www.postgresql.org/docs/9.1/static/sql-copy.html" ADD_DATE="1368031616" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: COPY</A><a name="PostgreSQL: Documentation: 9.1: COPY" href="#PostgreSQL: Documentation: 9.1: COPY" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createconversion.html" name="http://www.postgresql.org/docs/9.1/static/sql-createconversion.html" ADD_DATE="1367850996" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: CREATE CONVERSION</A><a name="PostgreSQL: Documentation: 9.1: CREATE CONVERSION" href="#PostgreSQL: Documentation: 9.1: CREATE CONVERSION" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createfunction.html" name="http://www.postgresql.org/docs/9.1/static/sql-createfunction.html" ADD_DATE="1374186100" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: CREATE FUNCTION</A><a name="PostgreSQL: Documentation: 9.1: CREATE FUNCTION" href="#PostgreSQL: Documentation: 9.1: CREATE FUNCTION" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createoperator.html" name="http://www.postgresql.org/docs/9.1/static/sql-createoperator.html" ADD_DATE="1379567289" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: CREATE OPERATOR</A><a name="PostgreSQL: Documentation: 9.1: CREATE OPERATOR" href="#PostgreSQL: Documentation: 9.1: CREATE OPERATOR" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createopclass.html" name="http://www.postgresql.org/docs/9.1/static/sql-createopclass.html" ADD_DATE="1362053259" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: CREATE OPERATOR CLASS</A><a name="PostgreSQL: Documentation: 9.1: CREATE OPERATOR CLASS" href="#PostgreSQL: Documentation: 9.1: CREATE OPERATOR CLASS" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createrule.html" name="http://www.postgresql.org/docs/9.1/static/sql-createrule.html" ADD_DATE="1362703210" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: CREATE RULE</A><a name="PostgreSQL: Documentation: 9.1: CREATE RULE" href="#PostgreSQL: Documentation: 9.1: CREATE RULE" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html" name="http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html" ADD_DATE="1373132572" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: CREATE TRIGGER</A><a name="PostgreSQL: Documentation: 9.1: CREATE TRIGGER" href="#PostgreSQL: Documentation: 9.1: CREATE TRIGGER" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createtype.html" name="http://www.postgresql.org/docs/9.1/static/sql-createtype.html" ADD_DATE="1362049875" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: CREATE TYPE</A><a name="PostgreSQL: Documentation: 9.1: CREATE TYPE" href="#PostgreSQL: Documentation: 9.1: CREATE TYPE" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-datetime.html" name="http://www.postgresql.org/docs/9.1/static/functions-datetime.html" ADD_DATE="1369340352" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Date/Time Functions and Operators</A><a name="PostgreSQL: Documentation: 9.1: Date/Time Functions and Operators" href="#PostgreSQL: Documentation: 9.1: Date/Time Functions and Operators" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/ddl-default.html" name="http://www.postgresql.org/docs/9.1/static/ddl-default.html" ADD_DATE="1369339991" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Default Values</A><a name="PostgreSQL: Documentation: 9.1: Default Values" href="#PostgreSQL: Documentation: 9.1: Default Values" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/hstore.html" name="http://www.postgresql.org/docs/9.1/static/hstore.html" ADD_DATE="1353017969" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: hstore</A><a name="PostgreSQL: Documentation: 9.1: hstore" href="#PostgreSQL: Documentation: 9.1: hstore" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/ddl-inherit.html" name="http://www.postgresql.org/docs/9.1/static/ddl-inherit.html" ADD_DATE="1372911851" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Inheritance</A><a name="PostgreSQL: Documentation: 9.1: Inheritance" href="#PostgreSQL: Documentation: 9.1: Inheritance" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS" name="http://www.postgresql.org/docs/9.1/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS" ADD_DATE="1374793507" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Lexical Structure</A><a name="PostgreSQL: Documentation: 9.1: Lexical Structure" href="#PostgreSQL: Documentation: 9.1: Lexical Structure" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-notify.html" name="http://www.postgresql.org/docs/9.1/static/sql-notify.html" ADD_DATE="1379907660" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: NOTIFY</A><a name="PostgreSQL: Documentation: 9.1: NOTIFY" href="#PostgreSQL: Documentation: 9.1: NOTIFY" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/datatype-oid.html" name="http://www.postgresql.org/docs/9.1/static/datatype-oid.html" ADD_DATE="1342045426" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Object Identifier Types</A><a name="PostgreSQL: Documentation: 9.1: Object Identifier Types" href="#PostgreSQL: Documentation: 9.1: Object Identifier Types" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/plpython.html" name="http://www.postgresql.org/docs/9.1/static/plpython.html" ADD_DATE="1342571998" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: PL/Python - Python Procedural Language</A><a name="PostgreSQL: Documentation: 9.1: PL/Python - Python Procedural Language" href="#PostgreSQL: Documentation: 9.1: PL/Python - Python Procedural Language" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/external-pl.html" name="http://www.postgresql.org/docs/9.1/static/external-pl.html" ADD_DATE="1362834165" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Procedural Languages</A><a name="PostgreSQL: Documentation: 9.1: Procedural Languages" href="#PostgreSQL: Documentation: 9.1: Procedural Languages" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/app-psql.html#APP-PSQL-PATTERNS" name="http://www.postgresql.org/docs/9.1/static/app-psql.html#APP-PSQL-PATTERNS" ADD_DATE="1342486329" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: psql</A><a name="PostgreSQL: Documentation: 9.1: psql" href="#PostgreSQL: Documentation: 9.1: psql" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/xfunc-sql.html" name="http://www.postgresql.org/docs/9.1/static/xfunc-sql.html" ADD_DATE="1351738107" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions</A><a name="PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions" href="#PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE" name="http://www.postgresql.org/docs/9.1/static/runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE" ADD_DATE="1377913034" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Query Planning: 18.7.1. Planner Method Configuration (enable_seqscan, etc.)</A><a name="PostgreSQL: Documentation: 9.1: Query Planning: 18.7.1. Planner Method Configuration (enable_seqscan, etc.)" href="#PostgreSQL: Documentation: 9.1: Query Planning: 18.7.1. Planner Method Configuration (enable_seqscan, etc.)" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html#AUTOVACUUM" name="http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html#AUTOVACUUM" ADD_DATE="1377905019" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Routine Vacuuming: 23.1.5. The Autovacuum Daemon</A><a name="PostgreSQL: Documentation: 9.1: Routine Vacuuming: 23.1.5. The Autovacuum Daemon" href="#PostgreSQL: Documentation: 9.1: Routine Vacuuming: 23.1.5. The Autovacuum Daemon" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/lo-funcs.html" name="http://www.postgresql.org/docs/9.1/static/lo-funcs.html" ADD_DATE="1367554117" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Server-side Functions</A><a name="PostgreSQL: Documentation: 9.1: Server-side Functions" href="#PostgreSQL: Documentation: 9.1: Server-side Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-set-constraints.html" name="http://www.postgresql.org/docs/9.1/static/sql-set-constraints.html" ADD_DATE="1373131555" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: SET CONSTRAINTS</A><a name="PostgreSQL: Documentation: 9.1: SET CONSTRAINTS" href="#PostgreSQL: Documentation: 9.1: SET CONSTRAINTS" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-string.html" name="http://www.postgresql.org/docs/9.1/static/functions-string.html" ADD_DATE="1367852219" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: String Functions and Operators</A><a name="PostgreSQL: Documentation: 9.1: String Functions and Operators" href="#PostgreSQL: Documentation: 9.1: String Functions and Operators" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-subquery.html" name="http://www.postgresql.org/docs/9.1/static/functions-subquery.html" ADD_DATE="1371738910" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Subquery Expressions</A><a name="PostgreSQL: Documentation: 9.1: Subquery Expressions" href="#PostgreSQL: Documentation: 9.1: Subquery Expressions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-admin.html" name="http://www.postgresql.org/docs/9.1/static/functions-admin.html" ADD_DATE="1370976726" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: System Administration Functions</A><a name="PostgreSQL: Documentation: 9.1: System Administration Functions" href="#PostgreSQL: Documentation: 9.1: System Administration Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-info.html" name="http://www.postgresql.org/docs/9.1/static/functions-info.html" ADD_DATE="1370976312" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: System Information Functions</A><a name="PostgreSQL: Documentation: 9.1: System Information Functions" href="#PostgreSQL: Documentation: 9.1: System Information Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.4/static/logfile-maintenance.html" name="http://www.postgresql.org/docs/8.4/static/logfile-maintenance.html" ADD_DATE="1333386461" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: Log File Maintenance</A><a name="PostgreSQL: Documentation: Manuals: Log File Maintenance" href="#PostgreSQL: Documentation: Manuals: Log File Maintenance" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/interactive/index.html" name="http://www.postgresql.org/docs/9.1/interactive/index.html" ADD_DATE="1317673868" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation</A><a name="PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation" href="#PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/app-psql.html" name="http://www.postgresql.org/docs/8.3/static/app-psql.html" ADD_DATE="1325722373" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: psql</A><a name="PostgreSQL: Documentation: Manuals: psql" href="#PostgreSQL: Documentation: Manuals: psql" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/functions-admin.html" name="http://www.postgresql.org/docs/8.3/static/functions-admin.html" ADD_DATE="1336443290" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: System Administration Functions</A><a name="PostgreSQL: Documentation: Manuals: System Administration Functions" href="#PostgreSQL: Documentation: Manuals: System Administration Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/8.1/static/manage-ag-templatedbs.html" name="http://www.postgresql.org/docs/8.1/static/manage-ag-templatedbs.html" ADD_DATE="1335056156" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: Template Databases</A><a name="PostgreSQL: Documentation: Manuals: Template Databases" href="#PostgreSQL: Documentation: Manuals: Template Databases" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/current/static/queries-with.html" name="http://www.postgresql.org/docs/current/static/queries-with.html" ADD_DATE="1332635517" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: WITH Queries (Common Table Expressions)</A><a name="PostgreSQL: Documentation: Manuals: WITH Queries (Common Table Expressions)" href="#PostgreSQL: Documentation: Manuals: WITH Queries (Common Table Expressions)" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="from/to MySQL" href="#from/to MySQL"><H3 ADD_DATE="1360831701">from/to MySQL</H3></a>

                            <DL><p>

                                <DT><A HREF="http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL" name="http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL" ADD_DATE="1360831667" ICON_URI="http://wiki.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://wiki.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Converting from other Databases to PostgreSQL - PostgreSQL wiki</A><a name="Converting from other Databases to PostgreSQL - PostgreSQL wiki" href="#Converting from other Databases to PostgreSQL - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL" name="http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL" ADD_DATE="1360831167" ICON_URI="http://en.wikibooks.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://en.wikibooks.org/favicon.ico" style="margin-right: 0.5em;"/>Converting MySQL to PostgreSQL - Wikibooks, open books for an open world</A><a name="Converting MySQL to PostgreSQL - Wikibooks, open books for an open world" href="#Converting MySQL to PostgreSQL - Wikibooks, open books for an open world" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.sourcefiles.org/Databases/Utilities/Conversion/my2pg.pl" name="http://www.sourcefiles.org/Databases/Utilities/Conversion/my2pg.pl" ADD_DATE="1360832036" ICON_URI="http://www.sourcefiles.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.sourcefiles.org/favicon.ico" style="margin-right: 0.5em;"/>my2pg.pl</A><a name="my2pg.pl" href="#my2pg.pl" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL" name="http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL" ADD_DATE="1365879925" ICON_URI="http://www.wikivs.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.wikivs.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL vs PostgreSQL - WikiVS</A><a name="MySQL vs PostgreSQL - WikiVS" href="#MySQL vs PostgreSQL - WikiVS" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database" name="http://stackoverflow.com/questions/3579079/how-can-you-represent-inheritance-in-a-database" ADD_DATE="1365882733" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>sql - How can you represent inheritance in a database? - Stack Overflow</A><a name="sql - How can you represent inheritance in a database? - Stack Overflow" href="#sql - How can you represent inheritance in a database? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://stackoverflow.com/questions/1942586/comparison-of-database-column-types-in-mysql-postgresql-and-sqlite-cross-map" name="http://stackoverflow.com/questions/1942586/comparison-of-database-column-types-in-mysql-postgresql-and-sqlite-cross-map" ADD_DATE="1367822656" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>Comparison of database column types in MySQL, PostgreSQL, and SQLite? (Cross-Mapping) - Stack Overflow</A><a name="Comparison of database column types in MySQL, PostgreSQL, and SQLite? (Cross-Mapping) - Stack Overflow" href="#Comparison of database column types in MySQL, PostgreSQL, and SQLite? (Cross-Mapping) - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://stackoverflow.com/questions/8424283/convert-mysql-set-data-type-to-postgres?rq=1" name="http://stackoverflow.com/questions/8424283/convert-mysql-set-data-type-to-postgres?rq=1" ADD_DATE="1367822956" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - convert MySQL SET data type to Postgres - Stack Overflow</A><a name="postgresql - convert MySQL SET data type to Postgres - Stack Overflow" href="#postgresql - convert MySQL SET data type to Postgres - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="invalid byte sequence errors" href="#invalid byte sequence errors"><H3 ADD_DATE="1366909936">invalid byte sequence errors</H3></a>

                            <DL><p>

                                <DT><A HREF="http://dba.stackexchange.com/questions/4777/how-to-solve-utf8-invalid-byte-sequence-copy-errors-on-a-restore-when-the-sourc" name="http://dba.stackexchange.com/questions/4777/how-to-solve-utf8-invalid-byte-sequence-copy-errors-on-a-restore-when-the-sourc" ADD_DATE="1366909823" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8? - Database Administrators Stack Exchange</A><a name="postgresql - How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8? - Database Administrators Stack Exchange" href="#postgresql - How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8? - Database Administrators Stack Exchange" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://grokbase.com/t/postgresql/pgsql-jdbc/072mze4g5s/invalid-byte-sequence-for-encoding-utf8-0x00" name="http://grokbase.com/t/postgresql/pgsql-jdbc/072mze4g5s/invalid-byte-sequence-for-encoding-utf8-0x00" ADD_DATE="1366909912" ICON_URI="http://grokbase.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://grokbase.com/favicon.ico" style="margin-right: 0.5em;"/>invalid byte sequence for encoding &quot;UTF8&quot;: 0x00 - Grokbase</A><a name="invalid byte sequence for encoding &quot;UTF8&quot;: 0x00 - Grokbase" href="#invalid byte sequence for encoding &quot;UTF8&quot;: 0x00 - Grokbase" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Making-TEXT-NUL-transparent-td5019640.html" name="http://postgresql.1045698.n5.nabble.com/Making-TEXT-NUL-transparent-td5019640.html" ADD_DATE="1367480866" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - hackers - Making TEXT NUL-transparent</A><a name="PostgreSQL - hackers - Making TEXT NUL-transparent" href="#PostgreSQL - hackers - Making TEXT NUL-transparent" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="PostGIS" href="#PostGIS"><H3 ADD_DATE="1347912102">PostGIS</H3></a>

                            <DL><p>

                                <DT><A HREF="http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/" name="http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/" ADD_DATE="1347909585" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Installing PostGIS on Ubuntu</A><a name="Installing PostGIS on Ubuntu" href="#Installing PostGIS on Ubuntu" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.kyngchaos.com/software:postgres" name="http://www.kyngchaos.com/software:postgres" ADD_DATE="1347911758" ICON_URI="http://www.kyngchaos.com/lib/tpl/arctic/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.kyngchaos.com/lib/tpl/arctic/images/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL [KyngChaos Wiki]</A><a name="PostgreSQL [KyngChaos Wiki]" href="#PostgreSQL [KyngChaos Wiki]" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://gis.stackexchange.com/questions/24356/struggling-with-enabling-a-postgis-database-on-mac" name="http://gis.stackexchange.com/questions/24356/struggling-with-enabling-a-postgis-database-on-mac" ADD_DATE="1347912089" ICON_URI="http://cdn.sstatic.net/gis/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/gis/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - Struggling with enabling a PostGIS database on Mac - GIS</A><a name="postgresql - Struggling with enabling a PostGIS database on Mac - GIS" href="#postgresql - Struggling with enabling a PostGIS database on Mac - GIS" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="https://gist.github.com/1481128" name="https://gist.github.com/1481128" ADD_DATE="1347912337" ICON_URI="https://github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://github.com/favicon.ico" style="margin-right: 0.5em;"/>Install Postgres 9.1, PostGIS and create PostGIS template on Ubuntu 11.10 Oneiric Ocelot — Gist</A><a name="Install Postgres 9.1, PostGIS and create PostGIS template on Ubuntu 11.10 Oneiric Ocelot — Gist" href="#Install Postgres 9.1, PostGIS and create PostGIS template on Ubuntu 11.10 Oneiric Ocelot — Gist" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="table modified time" href="#table modified time"><H3 ADD_DATE="1369925071">table modified time</H3></a>

                            <DL><p>

                                <DT><A HREF="http://stackoverflow.com/questions/3211769/how-to-get-last-access-modification-date-of-a-postgresql-database" name="http://stackoverflow.com/questions/3211769/how-to-get-last-access-modification-date-of-a-postgresql-database" ADD_DATE="1369925095" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>How to get last access/modification date of a PostgreSQL database? - Stack Overflow</A><a name="How to get last access/modification date of a PostgreSQL database? - Stack Overflow" href="#How to get last access/modification date of a PostgreSQL database? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://stackoverflow.com/questions/12750222/latest-table-modified-time-in-postgresql" name="http://stackoverflow.com/questions/12750222/latest-table-modified-time-in-postgresql" ADD_DATE="1369925085" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>sql - Latest table modified time in PostgreSQL - Stack Overflow</A><a name="sql - Latest table modified time in PostgreSQL - Stack Overflow" href="#sql - Latest table modified time in PostgreSQL - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/message-id/4811DC02.6030800@archonet.com" name="http://www.postgresql.org/message-id/4811DC02.6030800@archonet.com" ADD_DATE="1369925133" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: Last insert/update/delete time for a table</A><a name="Re: Last insert/update/delete time for a table" href="#Re: Last insert/update/delete time for a table" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/message-id/3f0b79eb0804250725w3349903iedbe11f0e2cd3fe5@mail.gmail.com" name="http://www.postgresql.org/message-id/3f0b79eb0804250725w3349903iedbe11f0e2cd3fe5@mail.gmail.com" ADD_DATE="1369925149" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: Last insert/update/delete time for a table</A><a name="Re: Last insert/update/delete time for a table" href="#Re: Last insert/update/delete time for a table" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="vacuuming" href="#vacuuming"><H3 ADD_DATE="1377911873">vacuuming</H3></a>

                            <DL><p>

                                <DT><A HREF="http://serverfault.com/questions/53376/how-do-i-know-if-the-autovacuumer-in-postgres-8-3-is-actually-working" name="http://serverfault.com/questions/53376/how-do-i-know-if-the-autovacuumer-in-postgres-8-3-is-actually-working" ADD_DATE="1377911319" ICON_URI="http://cdn.sstatic.net/serverfault/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/serverfault/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How do I know if the autovacuumer in postgres 8.3 is actually working? - Server Fault</A><a name="postgresql - How do I know if the autovacuumer in postgres 8.3 is actually working? - Server Fault" href="#postgresql - How do I know if the autovacuumer in postgres 8.3 is actually working? - Server Fault" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://blog.gocept.com/2012/05/22/dont-stop-postgresqls-autovacuum-with-your-application/" name="http://blog.gocept.com/2012/05/22/dont-stop-postgresqls-autovacuum-with-your-application/" ADD_DATE="1377911959" ICON_URI="http://1.gravatar.com/blavatar/b99b16aa78bd25f6aa8d01f9c1c99fb4?s=16" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://1.gravatar.com/blavatar/b99b16aa78bd25f6aa8d01f9c1c99fb4?s=16" style="margin-right: 0.5em;"/>Don’t stop PostgreSQL’s autovacuum with your application | gocept weblog</A><a name="Don’t stop PostgreSQL’s autovacuum with your application | gocept weblog" href="#Don’t stop PostgreSQL’s autovacuum with your application | gocept weblog" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Lock-problem-with-autovacuum-truncating-heap-td4265539.html" name="http://postgresql.1045698.n5.nabble.com/Lock-problem-with-autovacuum-truncating-heap-td4265539.html" ADD_DATE="1377912054" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - hackers - Lock problem with autovacuum truncating heap</A><a name="PostgreSQL - hackers - Lock problem with autovacuum truncating heap" href="#PostgreSQL - hackers - Lock problem with autovacuum truncating heap" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><A HREF="http://journal.tianhao.info/2010/12/postgresql-change-default-encoding-of-new-databases-to-utf-8-optional/" name="http://journal.tianhao.info/2010/12/postgresql-change-default-encoding-of-new-databases-to-utf-8-optional/" ADD_DATE="1335054607" ICON_URI="http://blog.tianhao.info/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blog.tianhao.info/favicon.ico" style="margin-right: 0.5em;"/>» PostgreSQL – Change Default Encoding of New Databases To UTF-8 (Optional) Journal</A><a name="» PostgreSQL – Change Default Encoding of New Databases To UTF-8 (Optional) Journal" href="#» PostgreSQL – Change Default Encoding of New Databases To UTF-8 (Optional) Journal" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="https://groups.google.com/forum/?fromgroups#!topic/pgsql.general/aitDYC6jMEI" name="https://groups.google.com/forum/?fromgroups#!topic/pgsql.general/aitDYC6jMEI" ADD_DATE="1340396170" ICON_URI="https://groups.google.com/forum/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://groups.google.com/forum/favicon.ico" style="margin-right: 0.5em;"/>[GENERAL] ROLLBACK in a function - Google Groups</A><a name="[GENERAL] ROLLBACK in a function - Google Groups" href="#[GENERAL] ROLLBACK in a function - Google Groups" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://grokbase.com/t/postgresql/pgsql-hackers/115ewt1b5s/domains-and-casts" name="http://grokbase.com/t/postgresql/pgsql-hackers/115ewt1b5s/domains-and-casts" ADD_DATE="1366907179" ICON_URI="http://grokbase.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://grokbase.com/favicon.ico" style="margin-right: 0.5em;"/>[PostgreSQL-Hackers] DOMAINs and CASTs - Grokbase</A><a name="[PostgreSQL-Hackers] DOMAINs and CASTs - Grokbase" href="#[PostgreSQL-Hackers] DOMAINs and CASTs - Grokbase" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.linuxquestions.org/questions/linux-server-73/postgresql-cant-rename-table-constraints-874005/" name="http://www.linuxquestions.org/questions/linux-server-73/postgresql-cant-rename-table-constraints-874005/" ADD_DATE="1363769604" ICON_URI="http://www.linuxquestions.org/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.linuxquestions.org/favicon.ico" style="margin-right: 0.5em;"/>[SOLVED] PostgreSQL Can&#39;t Rename Table Constraints</A><a name="[SOLVED] PostgreSQL Can&#39;t Rename Table Constraints" href="#[SOLVED] PostgreSQL Can&#39;t Rename Table Constraints" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://cs186.declarativity.net/browser/hw/hw1/student/Hw1/postgresql-8.0.3/src/backend/access/transam/xact.c" name="http://cs186.declarativity.net/browser/hw/hw1/student/Hw1/postgresql-8.0.3/src/backend/access/transam/xact.c" ADD_DATE="1340224855" ICON_URI="http://cs186.declarativity.net/chrome/common/trac.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cs186.declarativity.net/chrome/common/trac.ico" style="margin-right: 0.5em;"/>/hw/hw1/student/Hw1/postgresql-8.0.3/src/backend/access/transam/xact.c – cs186 – Trac</A><a name="/hw/hw1/student/Hw1/postgresql-8.0.3/src/backend/access/transam/xact.c – cs186 – Trac" href="#/hw/hw1/student/Hw1/postgresql-8.0.3/src/backend/access/transam/xact.c – cs186 – Trac" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://drupal.org/node/1018728" name="http://drupal.org/node/1018728" ADD_DATE="1362823422" ICON_URI="http://drupal.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://drupal.org/misc/favicon.ico" style="margin-right: 0.5em;"/>#1018728: postgres NAMEDATALEN limitation create problems | drupal.org</A><a name="#1018728: postgres NAMEDATALEN limitation create problems | drupal.org" href="##1018728: postgres NAMEDATALEN limitation create problems | drupal.org" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/971786/constraint-name-update-in-postgresql" name="http://stackoverflow.com/questions/971786/constraint-name-update-in-postgresql" ADD_DATE="1363765746" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>Constraint name update in PostgreSQL - Stack Overflow</A><a name="Constraint name update in PostgreSQL - Stack Overflow" href="#Constraint name update in PostgreSQL - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/1009584/how-to-emulate-insert-ignore-and-on-duplicate-key-update-sql-merge-with-po" name="http://stackoverflow.com/questions/1009584/how-to-emulate-insert-ignore-and-on-duplicate-key-update-sql-merge-with-po" ADD_DATE="1363797869" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>database - how to emulate &quot;insert ignore&quot; and &quot;on duplicate key update&quot; (sql merge) with postgresql? - Stack Overflow</A><a name="database - how to emulate &quot;insert ignore&quot; and &quot;on duplicate key update&quot; (sql merge) with postgresql? - Stack Overflow" href="#database - how to emulate &quot;insert ignore&quot; and &quot;on duplicate key update&quot; (sql merge) with postgresql? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.linuxforums.org/forum/red-hat-fedora-linux/17025-how-can-i-change-shmmax.html" name="http://www.linuxforums.org/forum/red-hat-fedora-linux/17025-how-can-i-change-shmmax.html" ADD_DATE="1332624618" ICON_URI="http://www.linuxforums.org/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://www.linuxforums.org/favicon.ico" style="margin-right: 0.5em;"/>How can I change &#39;shmmax&#39;</A><a name="How can I change &#39;shmmax&#39;" href="#How can I change &#39;shmmax&#39;" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html" name="http://www.cyberciti.biz/tips/postgres-allow-remote-access-tcp-connection.html" ADD_DATE="1330813804" ICON_URI="http://s0.cyberciti.org/static/legacy/i/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://s0.cyberciti.org/static/legacy/i/favicon.ico" style="margin-right: 0.5em;"/>How Do I Enable remote access to PostgreSQL database server?</A><a name="How Do I Enable remote access to PostgreSQL database server?" href="#How Do I Enable remote access to PostgreSQL database server?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://serverfault.com/questions/300123/how-to-edit-system-catalogs-in-postgresql-8-1" name="http://serverfault.com/questions/300123/how-to-edit-system-catalogs-in-postgresql-8-1" ADD_DATE="1362485737" ICON_URI="http://cdn.sstatic.net/serverfault/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/serverfault/img/favicon.ico" style="margin-right: 0.5em;"/>How to edit system catalogs in PostgreSQL 8.1? - Server Fault</A><a name="How to edit system catalogs in PostgreSQL 8.1? - Server Fault" href="#How to edit system catalogs in PostgreSQL 8.1? - Server Fault" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://code.activestate.com/recipes/286165-ilines-universal-newlines-from-any-data-source/" name="http://code.activestate.com/recipes/286165-ilines-universal-newlines-from-any-data-source/" ADD_DATE="1361889311" ICON_URI="http://code.activestate.com/static/activestyle/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://code.activestate.com/static/activestyle/img/favicon.ico" style="margin-right: 0.5em;"/>ilines -- universal newlines from any data source « Python recipes « ActiveState Code</A><a name="ilines -- universal newlines from any data source « Python recipes « ActiveState Code" href="#ilines -- universal newlines from any data source « Python recipes « ActiveState Code" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/2563494/where-postgresql-logs-are-on-mac-os-x" name="http://stackoverflow.com/questions/2563494/where-postgresql-logs-are-on-mac-os-x" ADD_DATE="1350028821" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>logging - Where postgresql logs are on mac os x? - Stack Overflow</A><a name="logging - Where postgresql logs are on mac os x? - Stack Overflow" href="#logging - Where postgresql logs are on mac os x? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.dbforums.com/postgresql/1655316-maximum-columns-problem.html" name="http://www.dbforums.com/postgresql/1655316-maximum-columns-problem.html" ADD_DATE="1360680549" ICON_URI="http://www.dbforums.com/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://www.dbforums.com/favicon.ico" style="margin-right: 0.5em;"/>Maximum columns problem - dBforums</A><a name="Maximum columns problem - dBforums" href="#Maximum columns problem - dBforums" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://mlawire.blogspot.com/2009/08/postgresql-indexes-on-foreign-keys.html" name="http://mlawire.blogspot.com/2009/08/postgresql-indexes-on-foreign-keys.html" ADD_DATE="1357356207" ICON_URI="http://mlawire.blogspot.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://mlawire.blogspot.com/favicon.ico" style="margin-right: 0.5em;"/>MLA Wire: Postgresql: Indexes on Foreign Keys</A><a name="MLA Wire: Postgresql: Indexes on Foreign Keys" href="#MLA Wire: Postgresql: Indexes on Foreign Keys" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://blog.endpoint.com/2009/12/mysql-and-postgres-command-equivalents.html" name="http://blog.endpoint.com/2009/12/mysql-and-postgres-command-equivalents.html" ADD_DATE="1320697471" ICON_URI="http://blog.endpoint.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blog.endpoint.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL and Postgres command equivalents (mysql vs psql) | End Point Blog</A><a name="MySQL and Postgres command equivalents (mysql vs psql) | End Point Blog" href="#MySQL and Postgres command equivalents (mysql vs psql) | End Point Blog" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://vibhorkumar.wordpress.com/2013/08/04/new-in-postgresql-9-3-new-in-functions/" name="http://vibhorkumar.wordpress.com/2013/08/04/new-in-postgresql-9-3-new-in-functions/" ADD_DATE="1379908605" ICON_URI="http://1.gravatar.com/blavatar/b8bffed7fdb4c45db7f4f07f397841f3?s=16" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://1.gravatar.com/blavatar/b8bffed7fdb4c45db7f4f07f397841f3?s=16" style="margin-right: 0.5em;"/>New in PostgreSQL 9.3: New in Functions | Database Technologies</A><a name="New in PostgreSQL 9.3: New in Functions | Database Technologies" href="#New in PostgreSQL 9.3: New in Functions | Database Technologies" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://omega-glory.net/2007/12/12/postgresql-count-workaround/" name="http://omega-glory.net/2007/12/12/postgresql-count-workaround/" ADD_DATE="1365880540" ICON_URI="http://omega-glory.net/static/images/favicon.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://omega-glory.net/static/images/favicon.png" style="margin-right: 0.5em;"/>Omega Glory - PostgreSQL Slow Count Workaround</A><a name="Omega Glory - PostgreSQL Slow Count Workaround" href="#Omega Glory - PostgreSQL Slow Count Workaround" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.pgadmin.org/docs/1.4/options-tab3.html" name="http://www.pgadmin.org/docs/1.4/options-tab3.html" ADD_DATE="1348017556" ICON_URI="http://www.pgadmin.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.pgadmin.org/favicon.ico" style="margin-right: 0.5em;"/>pgAdmin Options - Tab 3 (Query)</A><a name="pgAdmin Options - Tab 3 (Query)" href="#pgAdmin Options - Tab 3 (Query)" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://en.wikipedia.org/wiki/PhpPgAdmin" name="http://en.wikipedia.org/wiki/PhpPgAdmin" ADD_DATE="1366901186" ICON_URI="http://bits.wikimedia.org/favicon/wikipedia.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bits.wikimedia.org/favicon/wikipedia.ico" style="margin-right: 0.5em;"/>phpPgAdmin - Wikipedia, the free encyclopedia</A><a name="phpPgAdmin - Wikipedia, the free encyclopedia" href="#phpPgAdmin - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://blog.xzion.net/2010/02/10/postgres-session-variables-neat/" name="http://blog.xzion.net/2010/02/10/postgres-session-variables-neat/" ADD_DATE="1364429984" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Postgres Session Variables – Neat. | An Oak In The Fall</A><a name="Postgres Session Variables – Neat. | An Oak In The Fall" href="#Postgres Session Variables – Neat. | An Oak In The Fall" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/1943433/postgresql-concat-ws-like-function" name="http://stackoverflow.com/questions/1943433/postgresql-concat-ws-like-function" ADD_DATE="1362549138" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>Postgresql - concat_ws like function? - Stack Overflow</A><a name="Postgresql - concat_ws like function? - Stack Overflow" href="#Postgresql - concat_ws like function? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://postgresql.1045698.n5.nabble.com/GENERAL-Update-on-tables-when-the-row-doesn-t-change-td1844002.html#a1844018" name="http://postgresql.1045698.n5.nabble.com/GENERAL-Update-on-tables-when-the-row-doesn-t-change-td1844002.html#a1844018" ADD_DATE="1373545159" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - general - [GENERAL] Update on tables when the row doesn&#39;t change</A><a name="PostgreSQL - general - [GENERAL] Update on tables when the row doesn&#39;t change" href="#PostgreSQL - general - [GENERAL] Update on tables when the row doesn&#39;t change" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Quiet-quot-CONTEXT-quot-td1906036.html#a1906037" name="http://postgresql.1045698.n5.nabble.com/Quiet-quot-CONTEXT-quot-td1906036.html#a1906037" ADD_DATE="1372895140" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - general - Quiet &quot;CONTEXT&quot;?</A><a name="PostgreSQL - general - Quiet &quot;CONTEXT&quot;?" href="#PostgreSQL - general - Quiet &quot;CONTEXT&quot;?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Short-circuit-boolean-evaluation-td4361195.html" name="http://postgresql.1045698.n5.nabble.com/Short-circuit-boolean-evaluation-td4361195.html" ADD_DATE="1380543492" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - general - Short-circuit boolean evaluation</A><a name="PostgreSQL - general - Short-circuit boolean evaluation" href="#PostgreSQL - general - Short-circuit boolean evaluation" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/6454146/getting-the-encoding-of-a-postgres-database-using-the-command-line" name="http://stackoverflow.com/questions/6454146/getting-the-encoding-of-a-postgres-database-using-the-command-line" ADD_DATE="1367852352" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - Getting the encoding of a Postgres database using the command line? - Stack Overflow</A><a name="postgresql - Getting the encoding of a Postgres database using the command line? - Stack Overflow" href="#postgresql - Getting the encoding of a Postgres database using the command line? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/13683533/hash-a-column-in-postgres-using-sha-256" name="http://stackoverflow.com/questions/13683533/hash-a-column-in-postgres-using-sha-256" ADD_DATE="1362049774" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - Hash a column in postgres using sha-256 - Stack Overflow</A><a name="postgresql - Hash a column in postgres using sha-256 - Stack Overflow" href="#postgresql - Hash a column in postgres using sha-256 - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.sqlines.com/postgresql/how-to/create_user_defined_type" name="http://www.sqlines.com/postgresql/how-to/create_user_defined_type" ADD_DATE="1366907079" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>PostgreSQL - How to Create User-Defined Type (UDT) - SQLines</A><a name="PostgreSQL - How to Create User-Defined Type (UDT) - SQLines" href="#PostgreSQL - How to Create User-Defined Type (UDT) - SQLines" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/7605126/how-to-include-files-relative-to-the-current-executing-script-in-psql" name="http://stackoverflow.com/questions/7605126/how-to-include-files-relative-to-the-current-executing-script-in-psql" ADD_DATE="1363458243" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How to include files relative to the current executing script in psql? - Stack Overflow</A><a name="postgresql - How to include files relative to the current executing script in psql? - Stack Overflow" href="#postgresql - How to include files relative to the current executing script in psql? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/13260042/how-to-restore-public-schema-into-different-schema" name="http://stackoverflow.com/questions/13260042/how-to-restore-public-schema-into-different-schema" ADD_DATE="1377658202" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How to restore public schema into different schema - Stack Overflow</A><a name="postgresql - How to restore public schema into different schema - Stack Overflow" href="#postgresql - How to restore public schema into different schema - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/7682102/putting-explain-results-into-a-table" name="http://stackoverflow.com/questions/7682102/putting-explain-results-into-a-table" ADD_DATE="1351738902" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - Putting EXPLAIN results into a table? - Stack Overflow</A><a name="postgresql - Putting EXPLAIN results into a table? - Stack Overflow" href="#postgresql - Putting EXPLAIN results into a table? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://postgresql.1045698.n5.nabble.com/foreign-key-on-pg-shadow-td2142568.html" name="http://postgresql.1045698.n5.nabble.com/foreign-key-on-pg-shadow-td2142568.html" ADD_DATE="1362551492" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - sql - foreign key on pg_shadow</A><a name="PostgreSQL - sql - foreign key on pg_shadow" href="#PostgreSQL - sql - foreign key on pg_shadow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.jonathandean.com/2011/08/postgresql-8-4-on-mac-os-x-10-7-lion/" name="http://www.jonathandean.com/2011/08/postgresql-8-4-on-mac-os-x-10-7-lion/" ADD_DATE="1368571746" ICON_URI="http://www.jonathandean.com/wp-content/themes/jonathandean_v10/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.jonathandean.com/wp-content/themes/jonathandean_v10/images/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL 8.4 on Mac OS X 10.7 (Lion) | Jonathan Dean</A><a name="PostgreSQL 8.4 on Mac OS X 10.7 (Lion) | Jonathan Dean" href="#PostgreSQL 8.4 on Mac OS X 10.7 (Lion) | Jonathan Dean" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html" name="http://pgsql.tapoueh.org/site/html/news/20080131.bloat.html" ADD_DATE="1342200625" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>PostgreSQL and bloat</A><a name="PostgreSQL and bloat" href="#PostgreSQL and bloat" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://developer.apple.com/internet/opensource/postgres.html" name="http://developer.apple.com/internet/opensource/postgres.html" ADD_DATE="1317851881" ICON_URI="http://developer.apple.com/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://developer.apple.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL on Mac OS X</A><a name="PostgreSQL on Mac OS X" href="#PostgreSQL on Mac OS X" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://blog.hersoncruz.com/2011/12/postgresql-services-mac-os-x-lion-startstop/" name="http://blog.hersoncruz.com/2011/12/postgresql-services-mac-os-x-lion-startstop/" ADD_DATE="1363361844" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>PostgreSQL services Mac OS X Lion start/stop | blog.hersoncruz.com</A><a name="PostgreSQL services Mac OS X Lion start/stop | blog.hersoncruz.com" href="#PostgreSQL services Mac OS X Lion start/stop | blog.hersoncruz.com" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/7622908/postgresql-drop-function-without-knowing-the-number-type-of-parameters" name="http://stackoverflow.com/questions/7622908/postgresql-drop-function-without-knowing-the-number-type-of-parameters" ADD_DATE="1339770662" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql, DROP FUNCTION without knowing the number/type of parameters? - Stack Overflow</A><a name="postgresql, DROP FUNCTION without knowing the number/type of parameters? - Stack Overflow" href="#postgresql, DROP FUNCTION without knowing the number/type of parameters? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://explainextended.com/2009/05/05/postgresql-row-numbers/" name="http://explainextended.com/2009/05/05/postgresql-row-numbers/" ADD_DATE="1336436209" ICON_URI="http://explainextended.com/wp-content/themes/journalist/favicon.png" LAST_CHARSET="windows-1251"><img width="16" height="16" src="http://explainextended.com/wp-content/themes/journalist/favicon.png" style="margin-right: 0.5em;"/>PostgreSQL: assigning ROWNUM (row number) to each returned row | EXPLAIN EXTENDED</A><a name="PostgreSQL: assigning ROWNUM (row number) to each returned row | EXPLAIN EXTENDED" href="#PostgreSQL: assigning ROWNUM (row number) to each returned row | EXPLAIN EXTENDED" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://code.google.com/p/pqc/" name="http://code.google.com/p/pqc/" ADD_DATE="1340056974" ICON_URI="http://www.gstatic.com/codesite/ph/images/phosting.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gstatic.com/codesite/ph/images/phosting.ico" style="margin-right: 0.5em;"/>pqc - PostgreSQL Query Cache - Google Project Hosting</A><a name="pqc - PostgreSQL Query Cache - Google Project Hosting" href="#pqc - PostgreSQL Query Cache - Google Project Hosting" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://grokbase.com/t/postgresql/pgsql-sql/10bcqahmaf/psql-f-copy-from-stdin" name="http://grokbase.com/t/postgresql/pgsql-sql/10bcqahmaf/psql-f-copy-from-stdin" ADD_DATE="1363458007" ICON_URI="http://grokbase.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://grokbase.com/favicon.ico" style="margin-right: 0.5em;"/>psql -f COPY from STDIN - Grokbase</A><a name="psql -f COPY from STDIN - Grokbase" href="#psql -f COPY from STDIN - Grokbase" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://initd.org/psycopg/docs/" name="http://initd.org/psycopg/docs/" ADD_DATE="1325893540" ICON_URI="http://initd.org/favicon.ico"><img width="16" height="16" src="http://initd.org/favicon.ico" style="margin-right: 0.5em;"/>Psycopg</A><a name="Psycopg" href="#Psycopg" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.postgresql.org/message-id/20374.1211574676@sss.pgh.pa.us" name="http://www.postgresql.org/message-id/20374.1211574676@sss.pgh.pa.us" ADD_DATE="1360680610" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: 1600 column limit per table</A><a name="Re: 1600 column limit per table" href="#Re: 1600 column limit per table" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://archives.postgresql.org/message-id/9359.1243290777@sss.pgh.pa.us" name="http://archives.postgresql.org/message-id/9359.1243290777@sss.pgh.pa.us" ADD_DATE="1351739104" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Re: generic options for explain</A><a name="Re: generic options for explain" href="#Re: generic options for explain" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.postgresql.org/message-id/5fe0d78bda51d7176940fb8e78739b54@biglumber.com" name="http://www.postgresql.org/message-id/5fe0d78bda51d7176940fb8e78739b54@biglumber.com" ADD_DATE="1368696895" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: How to start a database in ReadOnly mode?</A><a name="Re: How to start a database in ReadOnly mode?" href="#Re: How to start a database in ReadOnly mode?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://archives.postgresql.org/pgadmin-support/2012-05/msg00036.php" name="http://archives.postgresql.org/pgadmin-support/2012-05/msg00036.php" ADD_DATE="1340228310" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Re: Restoring right side of the display</A><a name="Re: Restoring right side of the display" href="#Re: Restoring right side of the display" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.postgresql.org/message-id/140.1227903396@sss.pgh.pa.us" name="http://www.postgresql.org/message-id/140.1227903396@sss.pgh.pa.us" ADD_DATE="1379925644" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: why hash on the primary key?</A><a name="Re: why hash on the primary key?" href="#Re: why hash on the primary key?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/2647158/how-can-i-hash-passwords-in-postgresql" name="http://stackoverflow.com/questions/2647158/how-can-i-hash-passwords-in-postgresql" ADD_DATE="1344468295" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>security - How can I hash passwords in postgresql? - Stack Overflow</A><a name="security - How can I hash passwords in postgresql? - Stack Overflow" href="#security - How can I hash passwords in postgresql? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.depesz.com/2010/06/28/should-you-use-hash-index/" name="http://www.depesz.com/2010/06/28/should-you-use-hash-index/" ADD_DATE="1341863773" ICON_URI="http://www.depesz.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.depesz.com/favicon.ico" style="margin-right: 0.5em;"/>select * from depesz; » Blog Archive » Should you use HASH index?</A><a name="select * from depesz; » Blog Archive » Should you use HASH index?" href="#select * from depesz; » Blog Archive » Should you use HASH index?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.depesz.com/2008/08/05/waiting-for-84-hash-based-distinct/" name="http://www.depesz.com/2008/08/05/waiting-for-84-hash-based-distinct/" ADD_DATE="1351759513" ICON_URI="http://www.depesz.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.depesz.com/favicon.ico" style="margin-right: 0.5em;"/>select * from depesz; » Blog Archive » Waiting for 8.4 – hash based DISTINCT</A><a name="select * from depesz; » Blog Archive » Waiting for 8.4 – hash based DISTINCT" href="#select * from depesz; » Blog Archive » Waiting for 8.4 – hash based DISTINCT" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/6274457/set-isolation-level-for-postgresql-stored-procedures" name="http://stackoverflow.com/questions/6274457/set-isolation-level-for-postgresql-stored-procedures" ADD_DATE="1378328473" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>set isolation level for postgresql stored procedures - Stack Overflow</A><a name="set isolation level for postgresql stored procedures - Stack Overflow" href="#set isolation level for postgresql stored procedures - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://forums.devshed.com/postgresql-help-21/slow-queries-after-convertinf-db-from-sql-ascii-to-utf8t-887470.html" name="http://forums.devshed.com/postgresql-help-21/slow-queries-after-convertinf-db-from-sql-ascii-to-utf8t-887470.html" ADD_DATE="1367833539" ICON_URI="http://forums.devshed.com/images/favicon2.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://forums.devshed.com/images/favicon2.ico" style="margin-right: 0.5em;"/>Slow queries after convertinf DB from SQL_ASCII to UTF8 - Dev Shed</A><a name="Slow queries after convertinf DB from SQL_ASCII to UTF8 - Dev Shed" href="#Slow queries after convertinf DB from SQL_ASCII to UTF8 - Dev Shed" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://sourceforge.net/tracker/?func=detail&aid=3072065&group_id=37132&atid=418980" name="http://sourceforge.net/tracker/?func=detail&aid=3072065&group_id=37132&atid=418980" ADD_DATE="1355382299" ICON_URI="http://sourceforge.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://sourceforge.net/favicon.ico" style="margin-right: 0.5em;"/>SourceForge.net: phpPgAdmin: Detail: 3072065 - &quot;Auto login&quot; doesn&#39;t work</A><a name="SourceForge.net: phpPgAdmin: Detail: 3072065 - &quot;Auto login&quot; doesn&#39;t work" href="#SourceForge.net: phpPgAdmin: Detail: 3072065 - &quot;Auto login&quot; doesn&#39;t work" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/12570724/foreign-key-to-a-pg-catalog-table-in-postgresql" name="http://stackoverflow.com/questions/12570724/foreign-key-to-a-pg-catalog-table-in-postgresql" ADD_DATE="1362551133" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>sql - Foreign key to a pg_catalog table in PostgreSQL - Stack Overflow</A><a name="sql - Foreign key to a pg_catalog table in PostgreSQL - Stack Overflow" href="#sql - Foreign key to a pg_catalog table in PostgreSQL - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/10306830/postgres-define-a-default-value-for-cast-failures" name="http://stackoverflow.com/questions/10306830/postgres-define-a-default-value-for-cast-failures" ADD_DATE="1369339956" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>sql - Postgres: define a default value for CAST failures? - Stack Overflow</A><a name="sql - Postgres: define a default value for CAST failures? - Stack Overflow" href="#sql - Postgres: define a default value for CAST failures? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/398884/postgresql-hash-index" name="http://stackoverflow.com/questions/398884/postgresql-hash-index" ADD_DATE="1366152256" ICON_URI="http://stackoverflow.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://stackoverflow.com/favicon.ico" style="margin-right: 0.5em;"/>sql - PostgreSQL HASH index - Stack Overflow</A><a name="sql - PostgreSQL HASH index - Stack Overflow" href="#sql - PostgreSQL HASH index - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/12606842/what-is-the-maximum-number-of-columns-in-a-postgresql-select-query" name="http://stackoverflow.com/questions/12606842/what-is-the-maximum-number-of-columns-in-a-postgresql-select-query" ADD_DATE="1360679821" ICON_URI="http://stackoverflow.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://stackoverflow.com/favicon.ico" style="margin-right: 0.5em;"/>sql - What is the maximum number of columns in a PostgreSQL select query - Stack Overflow</A><a name="sql - What is the maximum number of columns in a PostgreSQL select query - Stack Overflow" href="#sql - What is the maximum number of columns in a PostgreSQL select query - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/4848964/postgresql-difference-between-text-and-varchar-character-varying/4848999#4848999" name="http://stackoverflow.com/questions/4848964/postgresql-difference-between-text-and-varchar-character-varying/4848999#4848999" ADD_DATE="1382047506" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>string - PostgreSQL: Difference between text and varchar (character varying) - Stack Overflow</A><a name="string - PostgreSQL: Difference between text and varchar (character varying) - Stack Overflow" href="#string - PostgreSQL: Difference between text and varchar (character varying) - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://wiki.postgresql.org/wiki/String_Functions_and_Operators_Compatibility#concat_ws" name="http://wiki.postgresql.org/wiki/String_Functions_and_Operators_Compatibility#concat_ws" ADD_DATE="1362550434" ICON_URI="http://wiki.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://wiki.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>String Functions and Operators Compatibility - PostgreSQL wiki</A><a name="String Functions and Operators Compatibility - PostgreSQL wiki" href="#String Functions and Operators Compatibility - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://vibhorkumar.wordpress.com/2011/10/28/instead-of-trigger/" name="http://vibhorkumar.wordpress.com/2011/10/28/instead-of-trigger/" ADD_DATE="1379908228" ICON_URI="http://1.gravatar.com/blavatar/b8bffed7fdb4c45db7f4f07f397841f3?s=16" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://1.gravatar.com/blavatar/b8bffed7fdb4c45db7f4f07f397841f3?s=16" style="margin-right: 0.5em;"/>Updateable Views in PostgreSQL 9.1 using INSTEAD OF Trigger | Database Technologies</A><a name="Updateable Views in PostgreSQL 9.1 using INSTEAD OF Trigger | Database Technologies" href="#Updateable Views in PostgreSQL 9.1 using INSTEAD OF Trigger | Database Technologies" style="margin-left: 0.5em;">&para;</a>

                        </DL><p>

                        <DT><a name="MySQL" href="#MySQL"><H3 ADD_DATE="1346354953">MySQL</H3></a>

                        <DL><p>

                            <DT><a name="doc" href="#doc"><H3 ADD_DATE="1368223591">doc</H3></a>

                            <DL><p>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" name="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" ADD_DATE="1364880853" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax</A><a name="MySQL :: MySQL 5.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax" href="#MySQL :: MySQL 5.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;file_name cannot be an existing file&quot;

"The file is created on the server host, so you must have the FILE privilege to use this syntax"

"if the MySQL client software is installed on the remote machine, you can instead use a client command such as mysql -e "SELECT ..." > file_name to generate the file on the client host"

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.1/en/select-into.html" name="http://dev.mysql.com/doc/refman/5.1/en/select-into.html" ADD_DATE="1364880728" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.1 Reference Manual :: 13.2.8.1 SELECT ... INTO Syntax</A><a name="MySQL :: MySQL 5.1 Reference Manual :: 13.2.8.1 SELECT ... INTO Syntax" href="#MySQL :: MySQL 5.1 Reference Manual :: 13.2.8.1 SELECT ... INTO Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/charset-convert.html" name="http://dev.mysql.com/doc/refman/5.5/en/charset-convert.html" ADD_DATE="1366752059" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 10.1.9.2 CONVERT() and CAST()</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 10.1.9.2 CONVERT() and CAST()" href="#MySQL :: MySQL 5.5 Reference Manual :: 10.1.9.2 CONVERT() and CAST()" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html" name="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html" ADD_DATE="1345023577" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 11.3 Date and Time Types</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 11.3 Date and Time Types" href="#MySQL :: MySQL 5.5 Reference Manual :: 11.3 Date and Time Types" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/binary-varbinary.html" name="http://dev.mysql.com/doc/refman/5.5/en/binary-varbinary.html" ADD_DATE="1366749860" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 11.4.2 The BINARY and VARBINARY Types</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 11.4.2 The BINARY and VARBINARY Types" href="#MySQL :: MySQL 5.5 Reference Manual :: 11.4.2 The BINARY and VARBINARY Types" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/create-index.html" name="http://dev.mysql.com/doc/refman/5.5/en/create-index.html" ADD_DATE="1379929639" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.1.13 CREATE INDEX Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.1.13 CREATE INDEX Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.1.13 CREATE INDEX Syntax" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;

Storage Engine	Permissible Index Types

MyISAM	BTREE

InnoDB	BTREE

MEMORY/HEAP	HASH, BTREE

NDB	BTREE, HASH (see note in text)

"

note that HASH is *not* available for either MyISAM or InnoDB

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/create-procedure.html" name="http://dev.mysql.com/doc/refman/5.5/en/create-procedure.html" ADD_DATE="1366898392" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-prepared-statements.html" name="http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-prepared-statements.html" ADD_DATE="1366898699" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.5 SQL Syntax for Prepared Statements</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.5 SQL Syntax for Prepared Statements" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.5 SQL Syntax for Prepared Statements" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/resignal.html" name="http://dev.mysql.com/doc/refman/5.5/en/resignal.html" ADD_DATE="1364942562" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.3 RESIGNAL Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.3 RESIGNAL Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.3 RESIGNAL Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/signal.html" name="http://dev.mysql.com/doc/refman/5.5/en/signal.html" ADD_DATE="1364942396" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.4 SIGNAL Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.4 SIGNAL Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.4 SIGNAL Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/grant.html" name="http://dev.mysql.com/doc/refman/5.5/en/grant.html" ADD_DATE="1366768685" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.7.1.3 GRANT Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.7.1.3 GRANT Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.7.1.3 GRANT Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/show-create-procedure.html" name="http://dev.mysql.com/doc/refman/5.5/en/show-create-procedure.html" ADD_DATE="1366898978" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.7.5.11 SHOW CREATE PROCEDURE Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.7.5.11 SHOW CREATE PROCEDURE Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.7.5.11 SHOW CREATE PROCEDURE Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/kill.html" name="http://dev.mysql.com/doc/refman/5.5/en/kill.html" ADD_DATE="1369431847" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.7.6.4 KILL Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.7.6.4 KILL Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.7.6.4 KILL Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html" name="http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html" ADD_DATE="1366744812" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 14.3.15 Limits on InnoDB Tables</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 14.3.15 Limits on InnoDB Tables" href="#MySQL :: MySQL 5.5 Reference Manual :: 14.3.15 Limits on InnoDB Tables" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-create-index-overview.html" name="http://dev.mysql.com/doc/refman/5.5/en/innodb-create-index-overview.html" ADD_DATE="1366895888" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation" href="#MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/view-algorithms.html" name="http://dev.mysql.com/doc/refman/5.5/en/view-algorithms.html" ADD_DATE="1369922467" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms" href="#MySQL :: MySQL 5.5 Reference Manual :: 19.5.2 View Processing Algorithms" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;For UNDEFINED, MySQL chooses which algorithm to use&quot;

"A reason to choose TEMPTABLE explicitly is that locks can be released on underlying tables after the temporary table has been created and before it is used to finish processing the statement"

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html" name="http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html" ADD_DATE="1366893751" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options" href="#MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html" name="http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html" ADD_DATE="1364873441" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands" href="#MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#sqlmode_postgresql" name="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#sqlmode_postgresql" ADD_DATE="1368048993" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes &gt; POSTGRESQL</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes &gt; POSTGRESQL" href="#MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes &gt; POSTGRESQL" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;Equivalent to PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS.&quot;

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/index-btree-hash.html" name="http://dev.mysql.com/doc/refman/5.5/en/index-btree-hash.html" ADD_DATE="1366865295" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes" href="#MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/identifiers.html" name="http://dev.mysql.com/doc/refman/5.5/en/identifiers.html" ADD_DATE="1366748434" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names" href="#MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html" name="http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html" ADD_DATE="1378707531" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: C.5.4.1 How to Reset the Root Password</A><a name="MySQL :: MySQL 5.5 Reference Manual :: C.5.4.1 How to Reset the Root Password" href="#MySQL :: MySQL 5.5 Reference Manual :: C.5.4.1 How to Reset the Root Password" style="margin-left: 0.5em;">&para;</a>

<DD>-

to add a user if you are not root but have sudo access:

sudo service mysql stop

sudo mysqld --skip-grant-tables  --skip-networking &

sudo mysql

> INSERT INTO mysql.user (Host, User, Password) VALUES ('localhost', 'user', PASSWORD('password'));

sudo kill "$(cat /var/run/mysqld/mysqld.pid)"

sudo service mysql start

mysql

> GRANT SELECT, SHOW VIEW ON `db`.* TO 'user'@'localhost' WITH GRANT OPTION;

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_clustered_index" name="http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_clustered_index" ADD_DATE="1366896044" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index</A><a name="MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index" href="#MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated.&quot;

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/alter-database.html" name="http://dev.mysql.com/doc/refman/5.6/en/alter-database.html" ADD_DATE="1346340363" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax</A><a name="MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax" href="#MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html" name="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html" ADD_DATE="1346821922" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program</A><a name="MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program" href="#MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="dynamic SQL" href="#dynamic SQL"><H3 ADD_DATE="1366898821">dynamic SQL</H3></a>

                            <DL><p>

                                <DT><A HREF="http://stackoverflow.com/questions/190776/how-to-have-dynamic-sql-in-mysql-stored-procedure" name="http://stackoverflow.com/questions/190776/how-to-have-dynamic-sql-in-mysql-stored-procedure" ADD_DATE="1366898705" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>How To have Dynamic SQL in MySQL Stored Procedure - Stack Overflow</A><a name="How To have Dynamic SQL in MySQL Stored Procedure - Stack Overflow" href="#How To have Dynamic SQL in MySQL Stored Procedure - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.it-iss.com/mysql/mysql-writing-dynamic-sql-in-stored-procedures/" name="http://www.it-iss.com/mysql/mysql-writing-dynamic-sql-in-stored-procedures/" ADD_DATE="1366898755" ICON_URI="http://www.it-iss.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.it-iss.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL – Writing dynamic SQL in stored procedures « IT Integrated Business Solutions</A><a name="MySQL – Writing dynamic SQL in stored procedures « IT Integrated Business Solutions" href="#MySQL – Writing dynamic SQL in stored procedures « IT Integrated Business Solutions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://forums.mysql.com/read.php?125,127701,127719#msg-127719" name="http://forums.mysql.com/read.php?125,127701,127719#msg-127719" ADD_DATE="1366898787" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://forums.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: Re: Dynamic SQl in Triggers/Procdures</A><a name="MySQL :: Re: Dynamic SQl in Triggers/Procdures" href="#MySQL :: Re: Dynamic SQl in Triggers/Procdures" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed.&quot;

                            </DL><p>

                            <DT><a name="enum" href="#enum"><H3 ADD_DATE="1367823275">enum</H3></a>

                            <DL><p>

                                <DT><A HREF="http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/" name="http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/" ADD_DATE="1367823304" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>8 Reasons Why MySQL&#39;s ENUM Data Type Is Evil - Chris Komlenic</A><a name="8 Reasons Why MySQL&#39;s ENUM Data Type Is Evil - Chris Komlenic" href="#8 Reasons Why MySQL&#39;s ENUM Data Type Is Evil - Chris Komlenic" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: The pros and (mostly) cons of MySQL&#39;s ENUM data-type (as compared to reference tables), as well as when it is okay to use and how to use it if you must.

"With an ENUM we're actually storing pieces of data in a place that was only intended to hold crucial information about the model"

"in large systems the effect of normalization can already tax the limits of human comprehension and complicate queries"

"Programmers waste enormous amounts of time thinking about, or worrying about, the speed of noncritical parts of their programs, and these attempts at efficiency actually have a strong negative impact when debugging and maintenance are considered." [Donald Knuth]

                                <DT><A HREF="http://www.kawoolutions.com/SQL_Database_Design/8._User-Defined_Types/8.3_Enumerated_Types" name="http://www.kawoolutions.com/SQL_Database_Design/8._User-Defined_Types/8.3_Enumerated_Types" ADD_DATE="1367824491" ICON_URI="http://www.kawoolutions.com/images/favicon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.kawoolutions.com/images/favicon.gif" style="margin-right: 0.5em;"/>Kawoolutions - SQL Database Design - 8. User-Defined Types - 8.3 Enumerated Types</A><a name="Kawoolutions - SQL Database Design - 8. User-Defined Types - 8.3 Enumerated Types" href="#Kawoolutions - SQL Database Design - 8. User-Defined Types - 8.3 Enumerated Types" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: Kawoolutions,,SQL Database Design,8. User-Defined Types,8.3 Enumerated Types

"some people claim, that MySQL ENUMs are much faster than separate tables, especially on large databases. Furthermore, enums can give you some savings in database size, depending on the implementation. For example, a MySQL ENUM occupies only one byte for up to 255 values and two bytes for up to 65535 values."

                            </DL><p>

                            <DT><a name="missing" href="#missing"><H3 ADD_DATE="1373777167">missing</H3></a>

                            <DL><p>

                                <DT><a name="CHECK constraints" href="#CHECK constraints"><H3 ADD_DATE="1373777177">CHECK constraints</H3></a>

                                <DL><p>

                                    <DT><A HREF="http://blog.christosoft.de/2012/08/mysql-check-constraint/" name="http://blog.christosoft.de/2012/08/mysql-check-constraint/" ADD_DATE="1373777223" ICON_URI="http://en.christosoft.de/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://en.christosoft.de/favicon.ico" style="margin-right: 0.5em;"/>MySQL: How to do a (simple/complex) CHECK CONSTRAINT? « Christosoft Blog</A><a name="MySQL: How to do a (simple/complex) CHECK CONSTRAINT? « Christosoft Blog" href="#MySQL: How to do a (simple/complex) CHECK CONSTRAINT? « Christosoft Blog" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;you can execute it in MySQL without an error. But also without any effect whatsoever. I tried it in InnoDB (MySQL 5.5) and it did not check the constraint at all.&quot;

"So we go with a trigger instead. For constraints, we use a BEFORE trigger."

                                    <DT><A HREF="http://www.codingforums.com/archive/index.php/t-216111.html" name="http://www.codingforums.com/archive/index.php/t-216111.html" ADD_DATE="1373777187" ICON_URI="http://www.codingforums.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.codingforums.com/favicon.ico" style="margin-right: 0.5em;"/>phpmyadmin -- create table with &#39;check&#39; function [Archive] - CodingForums.com</A><a name="phpmyadmin -- create table with &#39;check&#39; function [Archive] - CodingForums.com" href="#phpmyadmin -- create table with &#39;check&#39; function [Archive] - CodingForums.com" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: [Archive]  phpmyadmin -- create table with &#39;check&#39; function MySQL

"mysql itself does not support CHECK constraints"

                                </DL><p>

                            </DL><p>

                            <DT><a name="MySQL Workbench" href="#MySQL Workbench"><H3 ADD_DATE="1366740023">MySQL Workbench</H3></a>

                            <DL><p>

                                <DT><a name="exporting indexes separately" href="#exporting indexes separately"><H3 ADD_DATE="1367759236">exporting indexes separately</H3></a>

<DD>this happens in /mysql-workbench-gpl-5.2.47-src/modules/db.mysql/src/module_db_mysql.cpp . it does *not* use mysqldump, unfortunately.

</DD>

                                <DL><p>

                                </DL><p>

                                <DT><A HREF="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" name="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" ADD_DATE="1366739722" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQL :: Download MySQL Workbench</A><a name="MySQL :: Download MySQL Workbench" href="#MySQL :: Download MySQL Workbench" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://bugs.mysql.com/bug.php?id=40167" name="http://bugs.mysql.com/bug.php?id=40167" ADD_DATE="1365122620" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #40167: no method to show hidden relationships again</A><a name="MySQL Bugs: #40167: no method to show hidden relationships again" href="#MySQL Bugs: #40167: no method to show hidden relationships again" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://bugs.mysql.com/bug.php?id=46626" name="http://bugs.mysql.com/bug.php?id=46626" ADD_DATE="1365497065" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench</A><a name="MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" href="#MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://bugs.mysql.com/bug.php?id=67322" name="http://bugs.mysql.com/bug.php?id=67322" ADD_DATE="1366740010" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10</A><a name="MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" href="#MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://dba.stackexchange.com/questions/4314/mysql-workbench-loses-saved-connections" name="http://dba.stackexchange.com/questions/4314/mysql-workbench-loses-saved-connections" ADD_DATE="1366743179" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>MySQL Workbench Loses Saved Connections - Database Administrators Stack Exchange</A><a name="MySQL Workbench Loses Saved Connections - Database Administrators Stack Exchange" href="#MySQL Workbench Loses Saved Connections - Database Administrators Stack Exchange" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://stackoverflow.com/questions/12623651/error-error-1005-cant-create-table-errno-121" name="http://stackoverflow.com/questions/12623651/error-error-1005-cant-create-table-errno-121" ADD_DATE="1366747441" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - ERROR: Error 1005: Can&#39;t create table (errno: 121) - Stack Overflow</A><a name="mysql - ERROR: Error 1005: Can&#39;t create table (errno: 121) - Stack Overflow" href="#mysql - ERROR: Error 1005: Can&#39;t create table (errno: 121) - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="resetting ibdata" href="#resetting ibdata"><H3 ADD_DATE="1369878988">resetting ibdata</H3></a>

<DD>you need to do this after manually renaming a database with InnoDB tables

(but you should not manually rename a database with InnoDB tables, unless you have set innodb_file_per_table in /etc/mysql/my.cnf!)

</DD>

                            <DL><p>

                                <DT><A HREF="http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql" name="http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql" ADD_DATE="1369877285" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>database - How to shrink/purge ibdata1 file in MySQL - Stack Overflow</A><a name="database - How to shrink/purge ibdata1 file in MySQL - Stack Overflow" href="#database - How to shrink/purge ibdata1 file in MySQL - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;

to setup your server to use separate files for each table you need to change my.cnf in order to enable this:

[mysqld]

innodb_file_per_table

"

                                <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-data-log-reconfiguration.html" name="http://dev.mysql.com/doc/refman/5.5/en/innodb-data-log-reconfiguration.html" ADD_DATE="1369878943" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 14.3.6 Adding, Removing, or Resizing InnoDB Data and Log Files</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 14.3.6 Adding, Removing, or Resizing InnoDB Data and Log Files" href="#MySQL :: MySQL 5.5 Reference Manual :: 14.3.6 Adding, Removing, or Resizing InnoDB Data and Log Files" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <DT><a name="string primary keys" href="#string primary keys"><H3 ADD_DATE="1366864765">string primary keys</H3></a>

                            <DL><p>

                                <DT><A HREF="http://stackoverflow.com/questions/2250545/performance-penalty-of-strings-as-primary-keys" name="http://stackoverflow.com/questions/2250545/performance-penalty-of-strings-as-primary-keys" ADD_DATE="1366864782" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - performance penalty of strings as primary keys? - Stack Overflow</A><a name="mysql - performance penalty of strings as primary keys? - Stack Overflow" href="#mysql - performance penalty of strings as primary keys? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;we use varchar(32) for primary keys (GUIDs) and we haven&#39;t met performance issues of this. Our product is a web site with extreme overload and is critical to be stable. We use SQL Server 2005.&quot;

                            </DL><p>

                            <DT><a name="vs. other SQL DBs" href="#vs. other SQL DBs"><H3 ADD_DATE="1366900069">vs. other SQL DBs</H3></a>

                            <DL><p>

                                <DT><A HREF="http://grimoire.ca/mysql/choose-something-else" name="http://grimoire.ca/mysql/choose-something-else" ADD_DATE="1366900045" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>The Codex » Do Not Pass This Way Again</A><a name="The Codex » Do Not Pass This Way Again" href="#The Codex » Do Not Pass This Way Again" style="margin-left: 0.5em;">&para;</a>

<DD>-

arguments for MySQL:

better UI (phpMyAdmin):

"as a user, a company head, and a person who [...] has no time [for] front-ends [which were] ignored because the backend is *so amazingly awesome*" (may be referring to lack of sufficiently-good phpMyAdmin equivalents for other DBs?)

                            </DL><p>

                            <DT><A HREF="http://ariejan.net/2008/11/27/export-csv-directly-from-mysql/" name="http://ariejan.net/2008/11/27/export-csv-directly-from-mysql/" ADD_DATE="1364875901" ICON_URI="http://ariejan.net/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://ariejan.net/images/favicon.ico" style="margin-right: 0.5em;"/>ariejan.net</A><a name="ariejan.net" href="#ariejan.net" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: a blog by ariejan de vroom about software engineering and craftsmanship.

                            <DT><A HREF="http://stackoverflow.com/questions/989643/how-to-use-the-cast-function-correctly-in-a-mysql-select-statement" name="http://stackoverflow.com/questions/989643/how-to-use-the-cast-function-correctly-in-a-mysql-select-statement" ADD_DATE="1366752124" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>casting - How to use the CAST function correctly in a MySql SELECT statement? - Stack Overflow</A><a name="casting - How to use the CAST function correctly in a MySql SELECT statement? - Stack Overflow" href="#casting - How to use the CAST function correctly in a MySql SELECT statement? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

<DD>&quot;VARCHAR isn&#39;t a valid type for the CAST function, but CHAR is.&quot;

                            <DT><A HREF="http://skyontech.com/blog/create-MySQL-view-in-phpMyAdmin" name="http://skyontech.com/blog/create-MySQL-view-in-phpMyAdmin" ADD_DATE="1364874584" ICON_URI="http://skyontech.com/blog/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://skyontech.com/blog/misc/favicon.ico" style="margin-right: 0.5em;"/>Creating a MySQL View directly in phpMyAdmin | Sky on Tech</A><a name="Creating a MySQL View directly in phpMyAdmin | Sky on Tech" href="#Creating a MySQL View directly in phpMyAdmin | Sky on Tech" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.devcha.com/2008/01/extend-phpmyadmin-session-timeout-value.html" name="http://www.devcha.com/2008/01/extend-phpmyadmin-session-timeout-value.html" ADD_DATE="1331080013" ICON_URI="http://www.devcha.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.devcha.com/favicon.ico" style="margin-right: 0.5em;"/>Extend phpMyAdmin Session Timeout Value (Expired Session)</A><a name="Extend phpMyAdmin Session Timeout Value (Expired Session)" href="#Extend phpMyAdmin Session Timeout Value (Expired Session)" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.bluebox.net/about/blog/2009/07/mysql_encoding/" name="http://www.bluebox.net/about/blog/2009/07/mysql_encoding/" ADD_DATE="1366749540" ICON_URI="http://www.bluebox.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.bluebox.net/favicon.ico" style="margin-right: 0.5em;"/>Getting out of MySQL Character Set Hell &lt; Blue Box Blog</A><a name="Getting out of MySQL Character Set Hell &lt; Blue Box Blog" href="#Getting out of MySQL Character Set Hell &lt; Blue Box Blog" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html" name="http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html" ADD_DATE="1366764865" ICON_URI="http://s0.cyberciti.org/static/legacy/i/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://s0.cyberciti.org/static/legacy/i/favicon.ico" style="margin-right: 0.5em;"/>How Do I Enable Remote Access To MySQL Database Server?</A><a name="How Do I Enable Remote Access To MySQL Database Server?" href="#How Do I Enable Remote Access To MySQL Database Server?" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: MySQL Remote Access - A step-by-step guide to enable remote access to a MySQL database server under Linux, UNIX and BSD operating systems. 

                            <DT><A HREF="http://stackoverflow.com/questions/67093/how-do-i-quickly-rename-a-mysql-database-change-schema-name" name="http://stackoverflow.com/questions/67093/how-do-i-quickly-rename-a-mysql-database-change-schema-name" ADD_DATE="1364504267" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>How do I quickly rename a mysql database (change schema name)? - Stack Overflow</A><a name="How do I quickly rename a mysql database (change schema name)? - Stack Overflow" href="#How do I quickly rename a mysql database (change schema name)? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format" name="http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format" ADD_DATE="1364930621" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>linux - How to output MySQL query results in csv format? - Stack Overflow</A><a name="linux - How to output MySQL query results in csv format? - Stack Overflow" href="#linux - How to output MySQL query results in csv format? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment-18031137" name="http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment-18031137" ADD_DATE="1366748108" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow</A><a name="mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow" href="#mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://dba.stackexchange.com/questions/13083/cant-remove-grant-usage" name="http://dba.stackexchange.com/questions/13083/cant-remove-grant-usage" ADD_DATE="1369920700" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - can&#39;t remove &quot;GRANT USAGE&quot; - Database Administrators Stack Exchange</A><a name="mysql - can&#39;t remove &quot;GRANT USAGE&quot; - Database Administrators Stack Exchange" href="#mysql - can&#39;t remove &quot;GRANT USAGE&quot; - Database Administrators Stack Exchange" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html" name="http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html" ADD_DATE="1361398908" ICON_URI="http://blog.tsheets.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blog.tsheets.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL – Extract or Restore a Single Table From a Huge mysqldump File</A><a name="MySQL – Extract or Restore a Single Table From a Huge mysqldump File" href="#MySQL – Extract or Restore a Single Table From a Huge mysqldump File" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: A while back, I wrote an article that explained some awk magic for extracting the restore information for a single table from a mysqldump file.  Since then I&#39;ve created a Perl script that accomplishes the same thing, but is a little more flexible.

                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/show.html" name="http://dev.mysql.com/doc/refman/5.5/en/show.html" ADD_DATE="1370079565" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.7.5 SHOW Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.7.5 SHOW Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.7.5 SHOW Syntax" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://forums.mysql.com/read.php?28,243757,245694" name="http://forums.mysql.com/read.php?28,243757,245694" ADD_DATE="1361398973" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://forums.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: Re: How to Restore a particular table from the mysqldump of a whole database?</A><a name="MySQL :: Re: How to Restore a particular table from the mysqldump of a whole database?" href="#MySQL :: Re: How to Restore a particular table from the mysqldump of a whole database?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://forums.mysql.com/read.php?22,153445,153938" name="http://forums.mysql.com/read.php?22,153445,153938" ADD_DATE="1366747353" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://forums.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: Re: latin1_bin vs latin1_general_cs</A><a name="MySQL :: Re: latin1_bin vs latin1_general_cs" href="#MySQL :: Re: latin1_bin vs latin1_general_cs" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://forums.mysql.com/read.php?103,187048,188748" name="http://forums.mysql.com/read.php?103,187048,188748" ADD_DATE="1366744312" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://forums.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: Re: utf8_unicode_ci vs utf8_general_ci</A><a name="MySQL :: Re: utf8_unicode_ci vs utf8_general_ci" href="#MySQL :: Re: utf8_unicode_ci vs utf8_general_ci" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=44732" name="http://bugs.mysql.com/bug.php?id=44732" ADD_DATE="1368250469" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #44732: mysql client should printing warnings on stderr in batch mode</A><a name="MySQL Bugs: #44732: mysql client should printing warnings on stderr in batch mode" href="#MySQL Bugs: #44732: mysql client should printing warnings on stderr in batch mode" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=62207" name="http://bugs.mysql.com/bug.php?id=62207" ADD_DATE="1366740558" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #62207: Table comments are truncated to 66 characters rather than the 2048 the db allows</A><a name="MySQL Bugs: #62207: Table comments are truncated to 66 characters rather than the 2048 the db allows" href="#MySQL Bugs: #62207: Table comments are truncated to 66 characters rather than the 2048 the db allows" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://lists.mysql.com/mysql/202489" name="http://lists.mysql.com/mysql/202489" ADD_DATE="1366895054" ICON_URI="http://www.mysql.com/common/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.mysql.com/common/favicon.ico" style="margin-right: 0.5em;"/>MySQL Lists: mysql: Re: Why does mysql drop index very very slow in a large table?</A><a name="MySQL Lists: mysql: Re: Why does mysql drop index very very slow in a large table?" href="#MySQL Lists: mysql: Re: Why does mysql drop index very very slow in a large table?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://lists.mysql.com/mysql/202483" name="http://lists.mysql.com/mysql/202483" ADD_DATE="1366895136" ICON_URI="http://www.mysql.com/common/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.mysql.com/common/favicon.ico" style="margin-right: 0.5em;"/>MySQL Lists: mysql: RE: Why does mysql drop index very very slow in a large table?</A><a name="MySQL Lists: mysql: RE: Why does mysql drop index very very slow in a large table?" href="#MySQL Lists: mysql: RE: Why does mysql drop index very very slow in a large table?" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://developer.apple.com/internet/opensource/osdb.html" name="http://developer.apple.com/internet/opensource/osdb.html" ADD_DATE="1319067384" ICON_URI="http://developer.apple.com/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://developer.apple.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL on Mac OS X</A><a name="MySQL on Mac OS X" href="#MySQL on Mac OS X" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://mysql-python.sourceforge.net/MySQLdb.html" name="http://mysql-python.sourceforge.net/MySQLdb.html" ADD_DATE="1323978074" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQLdb</A><a name="MySQLdb" href="#MySQLdb" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/553369/need-mysql-4-to-ignore-alter-table-errors" name="http://stackoverflow.com/questions/553369/need-mysql-4-to-ignore-alter-table-errors" ADD_DATE="1366897937" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow</A><a name="Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow" href="#Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://drupal.org/node/306156" name="http://drupal.org/node/306156" ADD_DATE="1364875790" ICON_URI="http://drupal.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://drupal.org/misc/favicon.ico" style="margin-right: 0.5em;"/>What&#39;s the opposite of mysqldump to load data back into a database? | drupal.org</A><a name="What&#39;s the opposite of mysqldump to load data back into a database? | drupal.org" href="#What&#39;s the opposite of mysqldump to load data back into a database? | drupal.org" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/11940027/mysqldump-returning-unknown-variable-sql-mode-error" name="http://stackoverflow.com/questions/11940027/mysqldump-returning-unknown-variable-sql-mode-error" ADD_DATE="1374878990" ICON_URI="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow</A><a name="mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow" href="#mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                        </DL><p>

                        <DT><a name="SQLite" href="#SQLite"><H3 ADD_DATE="1367832799">SQLite</H3></a>

                        <DL><p>

                            <DT><A HREF="http://sqlite.org/limits.html" name="http://sqlite.org/limits.html" ADD_DATE="1360681987" ICON_URI="http://sqlite.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://sqlite.org/favicon.ico" style="margin-right: 0.5em;"/>Implementation Limits For SQLite</A><a name="Implementation Limits For SQLite" href="#Implementation Limits For SQLite" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/issues/363#note-7" name="https://projects.nceas.ucsb.edu/nceas/issues/363#note-7" ADD_DATE="1372412589" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>Quick example comparing SQLite vs PostgreSQL timings &lt; Task #363: Assemble all GHCN data into a single database - Environment and organisms - NCEAS Projects</A><a name="Quick example comparing SQLite vs PostgreSQL timings &lt; Task #363: Assemble all GHCN data into a single database - Environment and organisms - NCEAS Projects" href="#Quick example comparing SQLite vs PostgreSQL timings &lt; Task #363: Assemble all GHCN data into a single database - Environment and organisms - NCEAS Projects" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://stackoverflow.com/questions/9356753/can-i-update-new-in-before-insert-trigger-in-sqlite" name="http://stackoverflow.com/questions/9356753/can-i-update-new-in-before-insert-trigger-in-sqlite" ADD_DATE="1373408214" ICON_URI="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>sql - Can I update New in before insert trigger in sqlite? - Stack Overflow</A><a name="sql - Can I update New in before insert trigger in sqlite? - Stack Overflow" href="#sql - Can I update New in before insert trigger in sqlite? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.sqlite.org/lang_createtrigger.html" name="http://www.sqlite.org/lang_createtrigger.html" ADD_DATE="1373407893" ICON_URI="http://www.sqlite.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.sqlite.org/favicon.ico" style="margin-right: 0.5em;"/>SQLite Query Language: CREATE TRIGGER</A><a name="SQLite Query Language: CREATE TRIGGER" href="#SQLite Query Language: CREATE TRIGGER" style="margin-left: 0.5em;">&para;</a>

                        </DL><p>

                        <DT><a name="XPath to SQL" href="#XPath to SQL"><H3 ADD_DATE="1367832814">XPath to SQL</H3></a>

                        <DL><p>

                            <DT><A HREF="http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.logging.ui.doc.user/ref/rmapping_XPath_SQL.html" name="http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.logging.ui.doc.user/ref/rmapping_XPath_SQL.html" ADD_DATE="1366335769" ICON_URI="http://publib.boulder.ibm.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://publib.boulder.ibm.com/favicon.ico" style="margin-right: 0.5em;"/>http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.logging.ui.doc.user/ref/rmapping_XPath_SQL.html</A><a name="http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.logging.ui.doc.user/ref/rmapping_XPath_SQL.html" href="#http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.logging.ui.doc.user/ref/rmapping_XPath_SQL.html" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://www.velocityreviews.com/forums/t168336-xpath-to-sql-translation.html" name="http://www.velocityreviews.com/forums/t168336-xpath-to-sql-translation.html" ADD_DATE="1366335182" ICON_URI="http://www.velocityreviews.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.velocityreviews.com/favicon.ico" style="margin-right: 0.5em;"/>xpath to sql translation</A><a name="xpath to sql translation" href="#xpath to sql translation" style="margin-left: 0.5em;">&para;</a>

                        </DL><p>

                    <DT><A HREF="http://en.wikipedia.org/wiki/Object-relational_database" name="http://en.wikipedia.org/wiki/Object-relational_database" ADD_DATE="1367483651" ICON_URI="http://bits.wikimedia.org/favicon/wikipedia.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bits.wikimedia.org/favicon/wikipedia.ico" style="margin-right: 0.5em;"/>Object-relational database - Wikipedia, the free encyclopedia</A><a name="Object-relational database - Wikipedia, the free encyclopedia" href="#Object-relational database - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>

                <DT><a name="semantic" href="#semantic"><H3 ADD_DATE="1382496153">semantic</H3></a>

                <DL><p>

                    <DT><A HREF="http://answers.semanticweb.com/questions/136/how-should-a-semantic-inheritance-chain-look-like" name="http://answers.semanticweb.com/questions/136/how-should-a-semantic-inheritance-chain-look-like" ADD_DATE="1382466147" ICON_URI="http://semanticweb.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://semanticweb.com/favicon.ico" style="margin-right: 0.5em;"/>How should a semantic inheritance chain look like? - ANSWERS</A><a name="How should a semantic inheritance chain look like? - ANSWERS" href="#How should a semantic inheritance chain look like? - ANSWERS" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: During our work with a triple store we noticed a strange behaviour related to inheritance chaining and linking properties to classes.  Consider the following example:    3 types defined - GrandParent, Parent and Child.  3 properties defined - GrandParentsProp, ParentsProp and ChildsProp.  Parent inh...

"The owl inference rule for domains is: if (A engineSize B) then because the domain of engineSize is Car, then A is a Car."

but the same field name can have different meanings, depending on which class it's defined in

                </DL><p>

        <DT><A HREF="https://www.google.com/calendar/render" name="https://www.google.com/calendar/render" ADD_DATE="1318014776" ICON_URI="https://calendar.google.com/googlecalendar/images/favicon_v2013_22.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://calendar.google.com/googlecalendar/images/favicon_v2013_22.ico" style="margin-right: 0.5em;"/>Google Calendar</A><a name="Google Calendar" href="#Google Calendar" style="margin-left: 0.5em;">&para;</a>

    <DT><A HREF="http://tinman.cs.gsu.edu/~raj/4710/f11/Ch08.pdf" name="http://tinman.cs.gsu.edu/~raj/4710/f11/Ch08.pdf" ADD_DATE="1382496254" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Ch08.pdf</A><a name="Ch08.pdf" href="#Ch08.pdf" style="margin-left: 0.5em;">&para;</a>