<DT><A HREF="http://vegpath.org/links/" name="__http://vegpath.org/links/" ADD_DATE="1389762684" ICON_URI="http://vegpath.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://vegpath.org/favicon.ico" style="margin-right: 0.5em;"/>links</A><a name="__links" href="#__links" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://vegpath.org./" name="__http://vegpath.org./" ADD_DATE="1365044622" ICON_URI="http://vegpath.org./favicon.ico"><img width="16" height="16" src="http://vegpath.org./favicon.ico" style="margin-right: 0.5em;"/>VegPath</A><a name="__VegPath" href="#__VegPath" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://bien.nceas.ucsb.edu/bien/" name="__http://bien.nceas.ucsb.edu/bien/" ADD_DATE="1317673928" ICON_URI="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" style="margin-right: 0.5em;"/>BIEN</A><a name="__BIEN" href="#__BIEN" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://www.redmine.org/projects/redmine/wiki/RedmineTextFormatting" name="__http://www.redmine.org/projects/redmine/wiki/RedmineTextFormatting" ADD_DATE="1318963452" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>markup</A><a name="__markup" href="#__markup" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Meetings" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Meetings" ADD_DATE="1389763462" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" style="margin-right: 0.5em;"/>meetings</A><a name="__meetings" href="#__meetings" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/To_Do" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/To_Do" ADD_DATE="1342214119" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" style="margin-right: 0.5em;"/>to do</A><a name="__to do" href="#__to do" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="https://docs.google.com/spreadsheet/ccc?key=0ArZXrTAXd-TYdDRRb2RxYi11TWZrQVh5bVdKOURCeFE" name="__https://docs.google.com/spreadsheet/ccc?key=0ArZXrTAXd-TYdDRRb2RxYi11TWZrQVh5bVdKOURCeFE" ADD_DATE="1387233673" ICON_URI="https://ssl.gstatic.com/docs/spreadsheets/favicon_jfk2.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.gstatic.com/docs/spreadsheets/favicon_jfk2.png" style="margin-right: 0.5em;"/>pub</A><a name="__pub" href="#__pub" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking_validation_status" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Spot-checking_validation_status" ADD_DATE="1355767956" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" style="margin-right: 0.5em;"/>valid</A><a name="__valid" href="#__valid" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?server=localhost%3A5432%3Aallow&subject=database&database=vegbien" name="__http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?server=localhost%3A5432%3Aallow&subject=database&database=vegbien" ADD_DATE="1362008923" ICON_URI="http://vegbiendev.nceas.ucsb.edu/phppgadmin/images/themes/default/Introduction.png"><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 HREF="http://vegbiendev.nceas.ucsb.edu/phpmyadmin/" name="__http://vegbiendev.nceas.ucsb.edu/phpmyadmin/" ADD_DATE="1361027615" ICON_URI="http://vegbiendev.nceas.ucsb.edu/phpmyadmin/favicon.ico"><img width="16" height="16" src="http://vegbiendev.nceas.ucsb.edu/phpmyadmin/favicon.ico" style="margin-right: 0.5em;"/>&quot;</A><a name="__&quot;" href="#__&quot;" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://nimoy.nceas.ucsb.edu/phpmyadmin/" name="__http://nimoy.nceas.ucsb.edu/phpmyadmin/" ADD_DATE="1318544417" ICON_URI="http://nimoy.nceas.ucsb.edu/phpmyadmin/favicon.ico"><img width="16" height="16" src="http://nimoy.nceas.ucsb.edu/phpmyadmin/favicon.ico" style="margin-right: 0.5em;"/>nimoy</A><a name="__nimoy" href="#__nimoy" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://rs.tdwg.org/dwc/terms/" name="__http://rs.tdwg.org/dwc/terms/" ADD_DATE="1344350345"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>DwC</A><a name="__DwC" href="#__DwC" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://vegbank.org/vegbank/views/dba_tabledescription_index.jsp?view=index&entity=dba_tabledescription" name="__http://vegbank.org/vegbank/views/dba_tabledescription_index.jsp?view=index&entity=dba_tabledescription" ADD_DATE="1345855547" ICON_URI="http://vegbank.org/vegbank/images/vegbank_logo16x16.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://vegbank.org/vegbank/images/vegbank_logo16x16.gif" style="margin-right: 0.5em;"/>VegBank</A><a name="__VegBank" href="#__VegBank" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://tnrs.iplantcollaborative.org/TNRSapp.html" name="__http://tnrs.iplantcollaborative.org/TNRSapp.html" ADD_DATE="1350962070" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>TNRS</A><a name="__TNRS" href="#__TNRS" style="margin-left: 0.5em;">&para;</a>

            <DT><a name="DataONE compatibility" href="#DataONE compatibility"><H3 ADD_DATE="1385071044">DataONE compatibility</H3></a>

            <DL><p>

                <DT><A HREF="http://knb.ecoinformatics.org/m/#share" name="http://knb.ecoinformatics.org/m/#share" ADD_DATE="1385071003" ICON_URI="http://knb.ecoinformatics.org/m/js/themes/knb/img/favicon-32.png" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://knb.ecoinformatics.org/m/js/themes/knb/img/favicon-32.png" style="margin-right: 0.5em;"/>KNB | Knowledge Network for Biocomplexity: share</A><a name="KNB | Knowledge Network for Biocomplexity: share" href="#KNB | Knowledge Network for Biocomplexity: share" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.dataone.org/contribute-data" name="http://www.dataone.org/contribute-data" ADD_DATE="1385070264" ICON_URI="http://www.dataone.org/sites/all/themes/dataone_v3/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.dataone.org/sites/all/themes/dataone_v3/favicon.ico" style="margin-right: 0.5em;"/>Contribute Data | DataONE</A><a name="Contribute Data | DataONE" href="#Contribute Data | DataONE" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><a name="open-sourcing" href="#open-sourcing"><H3 ADD_DATE="1384914579">open-sourcing</H3></a>

            <DL><p>

                <DL><p>

                    <DT><A HREF="http://creativecommons.org/publicdomain/zero/1.0/" name="http://creativecommons.org/publicdomain/zero/1.0/" ADD_DATE="1384924633" ICON_URI="http://creativecommons.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://creativecommons.org/favicon.ico" style="margin-right: 0.5em;"/>Creative Commons — CC0 1.0 Universal</A><a name="Creative Commons — CC0 1.0 Universal" href="#Creative Commons — CC0 1.0 Universal" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="http://stackoverflow.com/questions/1623926/difference-between-mit-bsd-and-cc-by-licenses" name="http://stackoverflow.com/questions/1623926/difference-between-mit-bsd-and-cc-by-licenses" ADD_DATE="1384923692" 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;"/>licensing - Difference between MIT/BSD and CC-BY licenses - Stack Overflow</A><a name="licensing - Difference between MIT/BSD and CC-BY licenses - Stack Overflow" href="#licensing - Difference between MIT/BSD and CC-BY licenses - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

"The license you choose for your software should not have confusion and debate: don't use CC for software"

                    <DT><A HREF="http://www.gnu.org/licenses/license-list.html#OtherLicenses" name="http://www.gnu.org/licenses/license-list.html#OtherLicenses" ADD_DATE="1384923980" ICON_URI="http://www.gnu.org/graphics/gnu-head-mini.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gnu.org/graphics/gnu-head-mini.png" style="margin-right: 0.5em;"/>Various Licenses and Comments about Them - GNU Project - Free Software Foundation:  Licenses for Works of Practical Use Besides Software and Documentation</A><a name="Various Licenses and Comments about Them - GNU Project - Free Software Foundation:  Licenses for Works of Practical Use Besides Software and Documentation" href="#Various Licenses and Comments about Them - GNU Project - Free Software Foundation:  Licenses for Works of Practical Use Besides Software and Documentation" style="margin-left: 0.5em;">&para;</a>

    This is a non-copyleft free license that is good for art and entertainment works, and educational works. Please don't use it for software or documentation, since it is incompatible with the GNU GPL and with the GNU FDL."

                    <DT><A HREF="http://www.gnu.org/prep/maintain/html_node/License-Notices-for-Other-Files.html" name="http://www.gnu.org/prep/maintain/html_node/License-Notices-for-Other-Files.html" ADD_DATE="1384924446" ICON_URI="http://www.gnu.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gnu.org/favicon.ico" style="margin-right: 0.5em;"/>(GNU Verbatim Copying License) Information for Maintainers of GNU Software: License Notices for Other Files</A><a name="(GNU Verbatim Copying License) Information for Maintainers of GNU Software: License Notices for Other Files" href="#(GNU Verbatim Copying License) Information for Maintainers of GNU Software: License Notices for Other Files" style="margin-left: 0.5em;">&para;</a>

                </DL><p>

                <DT><a name="UCSB" href="#UCSB"><H3 ADD_DATE="1385017577">UCSB</H3></a>

                <DL><p>

                    <DT><A HREF="http://regents.universityofcalifornia.edu/governance/standing-orders/so1004.html" name="http://regents.universityofcalifornia.edu/governance/standing-orders/so1004.html" ADD_DATE="1384915649" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Standing Order 100. Officers of the University | Board of Regents</A><a name="Standing Order 100. Officers of the University | Board of Regents" href="#Standing Order 100. Officers of the University | Board of Regents" style="margin-left: 0.5em;">&para;</a>

"(dd) Except as otherwise specifically provided in the Bylaws and Standing Orders, the President is authorized to execute on behalf of the Corporation all contracts and other documents necessary in the exercise of the President's duties"

                    <DT><A HREF="http://policy.ucop.edu/delegations-of-authority/current-delegations.html" name="http://policy.ucop.edu/delegations-of-authority/current-delegations.html" ADD_DATE="1384914568" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Current List of Delegations | UCOP</A><a name="Current List of Delegations | UCOP" href="#Current List of Delegations | UCOP" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="http://policy.ucop.edu/_files/da/da2201.pdf" name="http://policy.ucop.edu/_files/da/da2201.pdf" ADD_DATE="1384916265" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>DA2201, Execution of Documents for Administration of University Patent and Other Intellectual Property Matters - da2201.pdf</A><a name="DA2201, Execution of Documents for Administration of University Patent and Other Intellectual Property Matters - da2201.pdf" href="#DA2201, Execution of Documents for Administration of University Patent and Other Intellectual Property Matters - da2201.pdf" style="margin-left: 0.5em;">&para;</a>

[...]

Effective August 13, 2007, the authority

granted to the President as

and Presidential policies which are or may be

established from time to time"

                    <DT><A HREF="http://www.ucop.edu/academic-affairs/" name="http://www.ucop.edu/academic-affairs/" ADD_DATE="1384916070" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Academic Affairs | UCOP</A><a name="Academic Affairs | UCOP" href="#Academic Affairs | UCOP" style="margin-left: 0.5em;">&para;</a>

Provost and Executive Vice President"

                    <DT><A HREF="http://tia.ucsb.edu/frequently-asked-questions/" name="http://tia.ucsb.edu/frequently-asked-questions/" ADD_DATE="1384916847" ICON_URI="http://tia.ucsb.edu/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://tia.ucsb.edu/favicon.ico" style="margin-right: 0.5em;"/>** Frequently Asked Questions | UCSB Office of Technology &amp; Industry Alliances: Can I Open Source Software?</A><a name="** Frequently Asked Questions | UCSB Office of Technology &amp; Industry Alliances: Can I Open Source Software?" href="#** Frequently Asked Questions | UCSB Office of Technology &amp; Industry Alliances: Can I Open Source Software?" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="https://tia.ucsb.edu/wp-content/uploads/2012/11/request-to-open-source-software-05-11.docx" name="https://tia.ucsb.edu/wp-content/uploads/2012/11/request-to-open-source-software-05-11.docx" ADD_DATE="1384917798"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>*** UCSB: Request to Open Source Software</A><a name="*** UCSB: Request to Open Source Software" href="#*** UCSB: Request to Open Source Software" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="http://tia.ucsb.edu/faculty/open-source-software/" name="http://tia.ucsb.edu/faculty/open-source-software/" ADD_DATE="1391833182" ICON_URI="http://tia.ucsb.edu/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://tia.ucsb.edu/favicon.ico" style="margin-right: 0.5em;"/>Open Source Software | UCSB Office of Technology &amp; Industry Alliances</A><a name="Open Source Software | UCSB Office of Technology &amp; Industry Alliances" href="#Open Source Software | UCSB Office of Technology &amp; Industry Alliances" style="margin-left: 0.5em;">&para;</a>

                    <DT><a name="funding sources" href="#funding sources"><H3 ADD_DATE="1384919240">funding sources</H3></a>

                    <DL><p>

                        <DT><A HREF="http://www.msi.ucsb.edu/current-projects/iplantnceas-collaboration-build-bien-and-environment-organisms-working-groups" name="http://www.msi.ucsb.edu/current-projects/iplantnceas-collaboration-build-bien-and-environment-organisms-working-groups" ADD_DATE="1384918307" ICON_URI="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" style="margin-right: 0.5em;"/>iPlant/NCEAS Collaboration to Build the BIEN and Environment &amp; Organisms Working Groups&#39; Informatics Frameworks | Marine Science Institute, UCSB</A><a name="iPlant/NCEAS Collaboration to Build the BIEN and Environment &amp; Organisms Working Groups&#39; Informatics Frameworks | Marine Science Institute, UCSB" href="#iPlant/NCEAS Collaboration to Build the BIEN and Environment &amp; Organisms Working Groups&#39; Informatics Frameworks | Marine Science Institute, UCSB" style="margin-left: 0.5em;">&para;</a>

Award Period: 

Tuesday, March 1, 2011 to Sunday, June 30, 2013

Award Amount: 

Schildhauer

"

                        <DT><A HREF="http://www.msi.ucsb.edu/current-projects/naturelab-nceas-core-support-and-capacity-building" name="http://www.msi.ucsb.edu/current-projects/naturelab-nceas-core-support-and-capacity-building" ADD_DATE="1384919616" ICON_URI="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" style="margin-right: 0.5em;"/>NatureLab: NCEAS core support and capacity building | Marine Science Institute, UCSB</A><a name="NatureLab: NCEAS core support and capacity building | Marine Science Institute, UCSB" href="#NatureLab: NCEAS core support and capacity building | Marine Science Institute, UCSB" style="margin-left: 0.5em;">&para;</a>

Award Period: 

Thursday, December 20, 2012 to Monday, August 31, 2015

Award Amount: 

Davis

"

                        <DT><A HREF="http://www.moore.org/grants/list/GBMF3530?cat=f4dcf360-a10f-68a5-8452-ff00002785c8" name="http://www.moore.org/grants/list/GBMF3530?cat=f4dcf360-a10f-68a5-8452-ff00002785c8" ADD_DATE="1384919179" ICON_URI="http://www.moore.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.moore.org/favicon.ico" style="margin-right: 0.5em;"/>^ Grants List | Gordon and Betty Moore Foundation: Creating a global center of excellence focused on knowledge generation to sustain nature and human well-being.</A><a name="^ Grants List | Gordon and Betty Moore Foundation: Creating a global center of excellence focused on knowledge generation to sustain nature and human well-being." href="#^ Grants List | Gordon and Betty Moore Foundation: Creating a global center of excellence focused on knowledge generation to sustain nature and human well-being." style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="http://www.msi.ucsb.edu/current-projects/nceas-national-center-ecological-analysis-and-synthesis" name="http://www.msi.ucsb.edu/current-projects/nceas-national-center-ecological-analysis-and-synthesis" ADD_DATE="1384919794" ICON_URI="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" style="margin-right: 0.5em;"/>NCEAS: National Center for Ecological Analysis and Synthesis | Marine Science Institute, UCSB</A><a name="NCEAS: National Center for Ecological Analysis and Synthesis | Marine Science Institute, UCSB" href="#NCEAS: National Center for Ecological Analysis and Synthesis | Marine Science Institute, UCSB" style="margin-left: 0.5em;">&para;</a>

Award Period: 

Sunday, October 1, 2006 to Monday, September 30, 2013

Award Amount: 

"

                    </DL><p>

                    <DT><A HREF="http://www.copyright.gov/help/faq/faq-definitions.html" name="http://www.copyright.gov/help/faq/faq-definitions.html" ADD_DATE="1384917322" ICON_URI="http://www.copyright.gov/images/favicon_cop.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.copyright.gov/images/favicon_cop.ico" style="margin-right: 0.5em;"/>U.S. Copyright Office - Definitions (FAQ):  Who is an author?</A><a name="U.S. Copyright Office - Definitions (FAQ):  Who is an author?" href="#U.S. Copyright Office - Definitions (FAQ):  Who is an author?" style="margin-left: 0.5em;">&para;</a>

"In cases of works made for hire, the employer or commissioning party is considered to be the author"

                </DL><p>

                <DT><a name="UArizona" href="#UArizona"><H3 ADD_DATE="1385017612">UArizona</H3></a>

                <DL><p>

                    <DT><A HREF="http://ott.arizona.edu/information-resources/about-intellectual-property-university-arizona" name="http://ott.arizona.edu/information-resources/about-intellectual-property-university-arizona" ADD_DATE="1385017681" ICON_URI="http://techtransfer.arizona.edu/sites/ott/files/favicon_ua.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://techtransfer.arizona.edu/sites/ott/files/favicon_ua.png" style="margin-right: 0.5em;"/>About Intellectual Property at The University of Arizona | Office of Technology Transfer</A><a name="About Intellectual Property at The University of Arizona | Office of Technology Transfer" href="#About Intellectual Property at The University of Arizona | Office of Technology Transfer" style="margin-left: 0.5em;">&para;</a>

"Generally, federal agency funding contracts are governed by the terms of the Bayh-Dole Act which allows the University to own and exploit inventions created with federal funding"

                    <DT><A HREF="http://ott.arizona.edu/sites/ott/files/abor_6-908-intellectual_property_policy.pdf" name="http://ott.arizona.edu/sites/ott/files/abor_6-908-intellectual_property_policy.pdf" ADD_DATE="1385017231" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Arizona Board of Regents: Intellectual Property Policy: Microsoft Word - 6-908-Intellectual Property Policy - abor_6-908-intellectual_property_policy.pdf</A><a name="Arizona Board of Regents: Intellectual Property Policy: Microsoft Word - 6-908-Intellectual Property Policy - abor_6-908-intellectual_property_policy.pdf" href="#Arizona Board of Regents: Intellectual Property Policy: Microsoft Word - 6-908-Intellectual Property Policy - abor_6-908-intellectual_property_policy.pdf" style="margin-left: 0.5em;">&para;</a>

of the following categories:

(1) Any intellectual property created by a university or

Board employee in the course and scope of

                        <DT><a name="TNRS" href="#TNRS"><H3 ADD_DATE="1385018370">TNRS</H3></a>

                        <DL><p>

                            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/library/UA-OTT+Notifications" name="https://pods.iplantcollaborative.org/wiki/display/library/UA-OTT+Notifications" ADD_DATE="1385018174" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>UA-OTT Notifications - Library - iPlant Collaborative Wiki</A><a name="UA-OTT Notifications - Library - iPlant Collaborative Wiki" href="#UA-OTT Notifications - Library - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="https://github.com/iPlantCollaborativeOpenSource/TNRS/blob/master/LICENSE" name="https://github.com/iPlantCollaborativeOpenSource/TNRS/blob/master/LICENSE" ADD_DATE="1385018358" 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;"/>TNRS/LICENSE at master · iPlantCollaborativeOpenSource/TNRS · GitHub</A><a name="TNRS/LICENSE at master · iPlantCollaborativeOpenSource/TNRS · GitHub" href="#TNRS/LICENSE at master · iPlantCollaborativeOpenSource/TNRS · GitHub" style="margin-left: 0.5em;">&para;</a>

                        </DL><p>

                        <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/library/Applying+iPlant+License+to+Code" name="https://pods.iplantcollaborative.org/wiki/display/library/Applying+iPlant+License+to+Code" ADD_DATE="1385018816" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Applying iPlant License to Code - Library - iPlant Collaborative Wiki</A><a name="Applying iPlant License to Code - Library - iPlant Collaborative Wiki" href="#Applying iPlant License to Code - Library - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/library/Checklist+for+open+source+code+release" name="https://pods.iplantcollaborative.org/wiki/display/library/Checklist+for+open+source+code+release" ADD_DATE="1389511062" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Checklist for open source code release - Library - iPlant Collaborative Wiki</A><a name="Checklist for open source code release - Library - iPlant Collaborative Wiki" href="#Checklist for open source code release - Library - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/library/Current+OTT+contact+for+open+source+and+iPlant" name="https://pods.iplantcollaborative.org/wiki/display/library/Current+OTT+contact+for+open+source+and+iPlant" ADD_DATE="1385017966" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Current OTT contact for open source and iPlant - Library - iPlant Collaborative Wiki</A><a name="Current OTT contact for open source and iPlant - Library - iPlant Collaborative Wiki" href="#Current OTT contact for open source and iPlant - Library - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="http://www.iplantcollaborative.org/open-source" name="http://www.iplantcollaborative.org/open-source" ADD_DATE="1385018897" ICON_URI="http://www.iplantcollaborative.org/sites/default/files/favicon.ico"><img width="16" height="16" src="http://www.iplantcollaborative.org/sites/default/files/favicon.ico" style="margin-right: 0.5em;"/>Open Source | iPlant Collaborative</A><a name="Open Source | iPlant Collaborative" href="#Open Source | iPlant Collaborative" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="http://www.iplantcollaborative.org/connect/staff-collaborators" name="http://www.iplantcollaborative.org/connect/staff-collaborators" ADD_DATE="1385018442" ICON_URI="http://www.iplantcollaborative.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.iplantcollaborative.org/misc/favicon.ico" style="margin-right: 0.5em;"/>Staff &amp; Collaborators | iPlant Collaborative Web Portal</A><a name="Staff &amp; Collaborators | iPlant Collaborative Web Portal" href="#Staff &amp; Collaborators | iPlant Collaborative Web Portal" style="margin-left: 0.5em;">&para;</a>

                    </DL><p>

                    <DT><a name="SALVIAS" href="#SALVIAS"><H3 ADD_DATE="1385019618">SALVIAS</H3></a>

                    <DL><p>

                        <DT><A HREF="http://eeb37.biosci.arizona.edu/~salvias/mission.html" name="http://eeb37.biosci.arizona.edu/~salvias/mission.html" ADD_DATE="1385019606" LAST_CHARSET="windows-1252"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>The SALVIAS Project Mission Statement</A><a name="The SALVIAS Project Mission Statement" href="#The SALVIAS Project Mission Statement" style="margin-left: 0.5em;">&para;</a>

                    </DL><p>

                </DL><p>

                <DT><a name="VegBank" href="#VegBank"><H3 ADD_DATE="1387589082">VegBank</H3></a>

                <DL><p>

                    <DT><A HREF="http://www.gnu.org/licenses/old-licenses/gpl-2.0.html" name="http://www.gnu.org/licenses/old-licenses/gpl-2.0.html" ADD_DATE="1387589044" ICON_URI="http://www.gnu.org/graphics/gnu-head-mini.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gnu.org/graphics/gnu-head-mini.png" style="margin-right: 0.5em;"/>GNU General Public License v2.0 - GNU Project - Free Software Foundation</A><a name="GNU General Public License v2.0 - GNU Project - Free Software Foundation" href="#GNU General Public License v2.0 - GNU Project - Free Software Foundation" style="margin-left: 0.5em;">&para;</a>

"If identifiable sections of that work are not derived from the Program, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works"

                    <DT><A HREF="http://www.gnu.org/licenses/gpl.html" name="http://www.gnu.org/licenses/gpl.html" ADD_DATE="1387589680" ICON_URI="http://www.gnu.org/graphics/gnu-head-mini.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gnu.org/graphics/gnu-head-mini.png" style="margin-right: 0.5em;"/>(for comparison to GPLv2) The GNU General Public License v3.0 - GNU Project - Free Software Foundation</A><a name="(for comparison to GPLv2) The GNU General Public License v3.0 - GNU Project - Free Software Foundation" href="#(for comparison to GPLv2) The GNU General Public License v3.0 - GNU Project - Free Software Foundation" style="margin-left: 0.5em;">&para;</a>

                </DL><p>

            </DL><p>

            <DT><a name="TWiki" href="#TWiki"><H3 ADD_DATE="1366707157">TWiki</H3></a>

                <DT><a name="research using VegBank" href="#research using VegBank"><H3 ADD_DATE="1373785119">research using VegBank</H3></a>

                <DL><p>

                    <DT><A HREF="http://www.geog.uoregon.edu/gavin/papers/gavin_jbi06.pdf" name="http://www.geog.uoregon.edu/gavin/papers/gavin_jbi06.pdf" ADD_DATE="1373786755" ICON_URI="http://www.geog.uoregon.edu/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.geog.uoregon.edu/favicon.ico" style="margin-right: 0.5em;"/>2006: Spatial variation of climatic and non-climatic controls on species distribution: the range limit of Tsuga heterophylla</A><a name="2006: Spatial variation of climatic and non-climatic controls on species distribution: the range limit of Tsuga heterophylla" href="#2006: Spatial variation of climatic and non-climatic controls on species distribution: the range limit of Tsuga heterophylla" style="margin-left: 0.5em;">&para;</a>

"In the USA, known

occurrences in vegetation plots were obtained from the

VegBank database (VEGBANK Contributors, 2004)"

                    <DT><A HREF="http://cegis.usgs.gov/pdf/stohlgren-proposal_508.pdf" name="http://cegis.usgs.gov/pdf/stohlgren-proposal_508.pdf" ADD_DATE="1373786393" ICON_URI="http://cegis.usgs.gov/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cegis.usgs.gov/favicon.ico" style="margin-right: 0.5em;"/>2007: Merging disparate datasets: - stohlgren-proposal_508.pdf</A><a name="2007: Merging disparate datasets: - stohlgren-proposal_508.pdf" href="#2007: Merging disparate datasets: - stohlgren-proposal_508.pdf" style="margin-left: 0.5em;">&para;</a>

"The datasets we will be focusing on

integrating with GODM to address hypothesis

e archived in VegBank, and in excessive of 10,000 more plots

are scheduled to be added in the near future."

                    <DT><A HREF="http://www.pnas.org/content/early/2009/07/22/0905030106.full.pdf" name="http://www.pnas.org/content/early/2009/07/22/0905030106.full.pdf" ADD_DATE="1373785757" ICON_URI="http://www.pnas.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.pnas.org/favicon.ico" style="margin-right: 0.5em;"/>2009: Temperature dependence, spatial scale, and tree species diversity in eastern Asia and North America</A><a name="2009: Temperature dependence, spatial scale, and tree species diversity in eastern Asia and North America" href="#2009: Temperature dependence, spatial scale, and tree species diversity in eastern Asia and North America" style="margin-left: 0.5em;">&para;</a>

in the 2 continents (398 plots for eastern Asia, see ref. 23; and 972 plots for

North America, see http://www.vegbank.org/)." (p. 4)

                    <DT><A HREF="http://www.fs.fed.us/psw/mtnclim/talks/pdf/Harsch.pdf" name="http://www.fs.fed.us/psw/mtnclim/talks/pdf/Harsch.pdf" ADD_DATE="1373785075" ICON_URI="http://www.fs.fed.us/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.fs.fed.us/favicon.ico" style="margin-right: 0.5em;"/>2012: Hotter? Colder? Wetter? Drier? Elevational range shifts in response to 50 years of climatic change across western North America</A><a name="2012: Hotter? Colder? Wetter? Drier? Elevational range shifts in response to 50 years of climatic change across western North America" href="#2012: Hotter? Colder? Wetter? Drier? Elevational range shifts in response to 50 years of climatic change across western North America" style="margin-left: 0.5em;">&para;</a>

"Modified: 10/18/12"

"Last-Modified: Tue, 23 Oct 2012 22:57:51 GMT"

                <DT><A HREF="http://www.gbif.org/mendeley/usecases" name="http://www.gbif.org/mendeley/usecases" ADD_DATE="1386062283" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/> ‐ GBIF use cases | GBIF.ORG</A><a name=" ‐ GBIF use cases | GBIF.ORG" href="# ‐ GBIF use cases | GBIF.ORG" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><A HREF="http://www.msi.ucsb.edu/current-projects/iplantnceas-collaboration-build-bien-and-environment-organisms-working-groups" name="http://www.msi.ucsb.edu/current-projects/iplantnceas-collaboration-build-bien-and-environment-organisms-working-groups" ADD_DATE="1384918307" ICON_URI="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.msi.ucsb.edu/sites/msi.ucsb.edu/themes/msi_adaptive/images/fav-icon.gif" style="margin-right: 0.5em;"/>**** iPlant/NCEAS Collaboration to Build the BIEN and Environment &amp; Organisms Working Groups&#39; Informatics Frameworks | Marine Science Institute, UCSB</A><a name="**** iPlant/NCEAS Collaboration to Build the BIEN and Environment &amp; Organisms Working Groups&#39; Informatics Frameworks | Marine Science Institute, UCSB" href="#**** iPlant/NCEAS Collaboration to Build the BIEN and Environment &amp; Organisms Working Groups&#39; Informatics Frameworks | Marine Science Institute, UCSB" style="margin-left: 0.5em;">&para;</a>

Tuesday, March 1, 2011 to Sunday, June 30, 2013

Award Amount: 

$281 483"

    developing an integrated information resource by merging several well-established plant occurrence information resources, including specimen data from various natural history and botanical museums, as well as plots data;"

            <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/biengeo/repository/revisions/master/entry/load-geoscrub-input.sh" name="https://projects.nceas.ucsb.edu/nceas/projects/biengeo/repository/revisions/master/entry/load-geoscrub-input.sh" ADD_DATE="1367527203" 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;"/>/load-geoscrub-input.sh - BIEN Geo - NCEAS Projects</A><a name="/load-geoscrub-input.sh - BIEN Geo - NCEAS Projects" href="#/load-geoscrub-input.sh - BIEN Geo - NCEAS Projects" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/biengeo/repository/revisions/master/entry/README.txt" name="https://projects.nceas.ucsb.edu/nceas/projects/biengeo/repository/revisions/master/entry/README.txt" ADD_DATE="1363808685" 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;"/>/README.txt - BIEN Geo - NCEAS Projects</A><a name="/README.txt - BIEN Geo - NCEAS Projects" href="#/README.txt - BIEN Geo - NCEAS Projects" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/SOT/11-02-24+Kickoff+Meeting" name="https://pods.iplantcollaborative.org/wiki/display/SOT/11-02-24+Kickoff+Meeting" ADD_DATE="1317772288" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>11-02-24 Kickoff Meeting - Scientific Opportunities Team - iPlant Collaborative Wiki</A><a name="11-02-24 Kickoff Meeting - Scientific Opportunities Team - iPlant Collaborative Wiki" href="#11-02-24 Kickoff Meeting - Scientific Opportunities Team - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.nceas.ucsb.edu/participants/19629" name="http://www.nceas.ucsb.edu/participants/19629" ADD_DATE="1317767903" ICON_URI="http://www.nceas.ucsb.edu/favicon.ico"><img width="16" height="16" src="http://www.nceas.ucsb.edu/favicon.ico" style="margin-right: 0.5em;"/>Activity Participants: botanical information network Working Group 24th—28th October 2011 | NCEAS</A><a name="Activity Participants: botanical information network Working Group 24th—28th October 2011 | NCEAS" href="#Activity Participants: botanical information network Working Group 24th—28th October 2011 | NCEAS" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/iptol/BI_Project_Charter" name="https://pods.iplantcollaborative.org/wiki/display/iptol/BI_Project_Charter" ADD_DATE="1317686587" ICON_URI="https://pods.iplantcollaborative.org/wiki/s/2035/11/_/images/logo/confluence_16.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/s/2035/11/_/images/logo/confluence_16.png" style="margin-right: 0.5em;"/>BI_Project_Charter - iPToL - iPlant Collaborative Wiki</A><a name="BI_Project_Charter - iPToL - iPlant Collaborative Wiki" href="#BI_Project_Charter - iPToL - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/repository" name="https://projects.nceas.ucsb.edu/nceas/projects/bien/repository" ADD_DATE="1317765427" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" style="margin-right: 0.5em;"/>BIEN - / - Repository - NCEAS Projects</A><a name="BIEN - / - Repository - NCEAS Projects" href="#BIEN - / - Repository - NCEAS Projects" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki" name="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki" ADD_DATE="1318280630" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" style="margin-right: 0.5em;"/>BIEN - Wiki - NCEAS Projects</A><a name="BIEN - Wiki - NCEAS Projects" href="#BIEN - Wiki - NCEAS Projects" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/sciplant/BIEN+Database+3.0" name="https://pods.iplantcollaborative.org/wiki/display/sciplant/BIEN+Database+3.0" ADD_DATE="1385071786" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>BIEN Database 3.0 - SciPlant - iPlant Collaborative Wiki</A><a name="BIEN Database 3.0 - SciPlant - iPlant Collaborative Wiki" href="#BIEN Database 3.0 - SciPlant - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://vegpath.org/links/" name="http://vegpath.org/links/" ADD_DATE="1389762684" ICON_URI="http://vegpath.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://vegpath.org/favicon.ico" style="margin-right: 0.5em;"/>BIEN links</A><a name="BIEN links" href="#BIEN links" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.iplantcollaborative.org/node/1044" name="http://www.iplantcollaborative.org/node/1044" ADD_DATE="1317675381" ICON_URI="http://www.iplantcollaborative.org/sites/default/files/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.iplantcollaborative.org/sites/default/files/favicon.ico" style="margin-right: 0.5em;"/>BIEN Project | iPlant Collaborative Web Portal</A><a name="BIEN Project | iPlant Collaborative Web Portal" href="#BIEN Project | iPlant Collaborative Web Portal" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://chac.iplantcollaborative.org/documents/bien.pdf" name="http://chac.iplantcollaborative.org/documents/bien.pdf" ADD_DATE="1317674748"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>bien.pdf</A><a name="bien.pdf" href="#bien.pdf" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://bien.nceas.ucsb.edu/bien/" name="http://bien.nceas.ucsb.edu/bien/" ADD_DATE="1317673928" ICON_URI="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" style="margin-right: 0.5em;"/>Botanical Information and Ecology Network</A><a name="Botanical Information and Ecology Network" href="#Botanical Information and Ecology Network" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://groups.nceas.ucsb.edu/bien" name="http://groups.nceas.ucsb.edu/bien" ADD_DATE="1317767384" ICON_URI="http://groups.nceas.ucsb.edu/bien/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://groups.nceas.ucsb.edu/bien/favicon.ico" style="margin-right: 0.5em;"/>Botanical Information and Ecology Network</A><a name="Botanical Information and Ecology Network" href="#Botanical Information and Ecology Network" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.iplantcollaborative.org/" name="http://www.iplantcollaborative.org/" ADD_DATE="1323983414" ICON_URI="http://www.iplantcollaborative.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.iplantcollaborative.org/misc/favicon.ico" style="margin-right: 0.5em;"/>Home Page | iPlant Collaborative</A><a name="Home Page | iPlant Collaborative" href="#Home Page | iPlant Collaborative" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://athena.nceas.ucsb.edu/munin/nceas.ucsb.edu/vegbiendev.nceas.ucsb.edu/index.html#system" name="http://athena.nceas.ucsb.edu/munin/nceas.ucsb.edu/vegbiendev.nceas.ucsb.edu/index.html#system" ADD_DATE="1330468318" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Munin :: nceas.ucsb.edu :: vegbiendev.nceas.ucsb.edu</A><a name="Munin :: nceas.ucsb.edu :: vegbiendev.nceas.ucsb.edu" href="#Munin :: nceas.ucsb.edu :: vegbiendev.nceas.ucsb.edu" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.nceas.ucsb.edu/projects/12290" name="http://www.nceas.ucsb.edu/projects/12290" ADD_DATE="1317769279" ICON_URI="http://www.nceas.ucsb.edu/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.nceas.ucsb.edu/favicon.ico" style="margin-right: 0.5em;"/>NCEAS Project 12290: botanical information network | NCEAS</A><a name="NCEAS Project 12290: botanical information network | NCEAS" href="#NCEAS Project 12290: botanical information network | NCEAS" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://docs.google.com/spreadsheet/ccc?key=0ArZXrTAXd-TYdDRRb2RxYi11TWZrQVh5bVdKOURCeFE" name="https://docs.google.com/spreadsheet/ccc?key=0ArZXrTAXd-TYdDRRb2RxYi11TWZrQVh5bVdKOURCeFE" ADD_DATE="1387233654" ICON_URI="https://ssl.gstatic.com/docs/spreadsheets/favicon_jfk2.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.gstatic.com/docs/spreadsheets/favicon_jfk2.png" style="margin-right: 0.5em;"/>publishable datasources</A><a name="publishable datasources" href="#publishable datasources" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://bien.nceas.ucsb.edu/bien/bien-database-summary-statistics/bien-2/sources/" name="http://bien.nceas.ucsb.edu/bien/bien-database-summary-statistics/bien-2/sources/" ADD_DATE="1353554924" ICON_URI="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" style="margin-right: 0.5em;"/>Sources « Botanical Information and Ecology Network</A><a name="Sources « Botanical Information and Ecology Network" href="#Sources « Botanical Information and Ecology Network" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.iplantcollaborative.org/about-iplant/the-organization/strategic-initiatives" name="http://www.iplantcollaborative.org/about-iplant/the-organization/strategic-initiatives" ADD_DATE="1399415856" ICON_URI="http://www.iplantcollaborative.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.iplantcollaborative.org/misc/favicon.ico" style="margin-right: 0.5em;"/>Strategic Initiatives | iPlant Collaborative</A><a name="Strategic Initiatives | iPlant Collaborative" href="#Strategic Initiatives | iPlant Collaborative" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://tnrs.iplantcollaborative.org/TNRSapp.html" name="http://tnrs.iplantcollaborative.org/TNRSapp.html" ADD_DATE="1317772105" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Taxonomic Name Resolution Service</A><a name="Taxonomic Name Resolution Service" href="#Taxonomic Name Resolution Service" style="margin-left: 0.5em;">&para;</a>

        </DL><p>

        <DT><a name="vegetation data" href="#vegetation data"><H3 ADD_DATE="1317767236">vegetation data</H3></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>

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

"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>

"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"

                <DT><A HREF="http://digir.net/prot/archive/messaging_1.html" name="http://digir.net/prot/archive/messaging_1.html" ADD_DATE="1332995374" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>DiGIR Messaging</A><a name="DiGIR Messaging" href="#DiGIR Messaging" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.biodiversitycollectionsindex.org/static/index.html" name="http://www.biodiversitycollectionsindex.org/static/index.html" ADD_DATE="1332997278" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Biodiversity Collections Index</A><a name="Biodiversity Collections Index" href="#Biodiversity Collections Index" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="https://github.com/diogok/simple-digir/blob/master/SimpleDigir.php" name="https://github.com/diogok/simple-digir/blob/master/SimpleDigir.php" ADD_DATE="1332998321" 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;"/>simple-digir/SimpleDigir.php at master · diogok/simple-digir · GitHub</A><a name="simple-digir/SimpleDigir.php at master · diogok/simple-digir · GitHub" href="#simple-digir/SimpleDigir.php at master · diogok/simple-digir · GitHub" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.biodiversitycollectionsindex.org/search/index/new_search/true/n_lang/true/physical_only/true?no_results=ok" name="http://www.biodiversitycollectionsindex.org/search/index/new_search/true/n_lang/true/physical_only/true?no_results=ok" ADD_DATE="1334002233" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>BCI: Search:</A><a name="BCI: Search:" href="#BCI: Search:" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.biodiversitycollectionsindex.org/search/index?new_search=true&search=digir&physical_only=true&imageField.x=0&imageField.y=0" name="http://www.biodiversitycollectionsindex.org/search/index?new_search=true&search=digir&physical_only=true&imageField.x=0&imageField.y=0" ADD_DATE="1334002276" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>BCI: Search: digir</A><a name="BCI: Search: digir" href="#BCI: Search: digir" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

                <DL><p>

                    <DT><A HREF="https://raw.github.com/Datafable/gbif-data-licenses/master/data/licenses.csv" name="https://raw.github.com/Datafable/gbif-data-licenses/master/data/licenses.csv" ADD_DATE="1384772508" ICON_URI="https://raw.github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://raw.github.com/favicon.ico" style="margin-right: 0.5em;"/>licenses.csv</A><a name="licenses.csv" href="#licenses.csv" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="https://github.com/Datafable/gbif-data-licenses/blob/master/guidelines.md" name="https://github.com/Datafable/gbif-data-licenses/blob/master/guidelines.md" ADD_DATE="1384772513" 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;"/>guidelines</A><a name="guidelines" href="#guidelines" style="margin-left: 0.5em;">&para;</a>

                </DL><p>

                <DT><A HREF="http://www.gbif.org/disclaimer/datasharing" name="http://www.gbif.org/disclaimer/datasharing" ADD_DATE="1384397131" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data sharing</A><a name="Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data sharing" href="#Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data sharing" style="margin-left: 0.5em;">&para;</a>

"The Data Publisher warrants that it has made the necessary agreements with the original owners of the data that it can make the data available through the GBIF network."

                <DT><A HREF="http://www.gbif.org/disclaimer/datause" name="http://www.gbif.org/disclaimer/datause" ADD_DATE="1384332153" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data use agreement</A><a name="Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data use agreement" href="#Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data use agreement" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.gbif.org/newsroom/uses" name="http://www.gbif.org/newsroom/uses" ADD_DATE="1384383363" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data</A><a name="GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data" href="#GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="ftp://ftp.gbif.org/" name="ftp://ftp.gbif.org/" ADD_DATE="1360879586" ICON_URI="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8%2F9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAeBJREFUeNqcU81O20AQ%2FtZ2AgQSYQRqL1UPVG2hAUQkxLEStz4DrXpLpD5Drz31Cajax%2Bghhx6qHIJURBTxIwQRwopCBbZjHMcOTrzermPipsSt1Iw03p3ZmW%2B%2B2R0TxhgOD34wjCHZlQ0iDYz9yvEfhxMTCYhEQDIZhkxKd2sqzX2TOD2vBQCQhpPefng1ZP2dVPlLLdpL8SEMcxng%2Fbs0RIHhtgs4twxOh%2BHjZxvzDx%2F3GQQiDFISiRBLFMPKTRMollzcWECrDVhtxtdRVsL9youPxGj%2FbdfFlUZhtDyYbYqWRUdai1oQRZ5oHeHl2gNM%2B01Uqio8RlH%2BnsazJzNwXcq1B%2BiXPHprlEEymeBfXs1w8XxxihfyuXqoHqpoGjZM04bddgG%2F9%2B8WGj87qDdsrK9m%2BoA%2BpbhQTDh2l1%2Bi2weNbSHMZyjvNXmVbqh9Fj5Oz27uEoP%2BSTxANruJs9L%2FT6P0ewqPx5nmiAG5f6AoCtN1PbJzuRyJAyDBzzSQYvErf06yYxhGXlEa8H2KVGoasjwLx3Ewk858opQWXm%2B%2Fib9EQrBzclLLLy89xYvlpchvtixcX6uo1y%2FzsiwHrkIsgKbp%2BYWFOWicuqppoNTnStHzPFCPQhBEBOyGAX4JMADFetubi4BSYAAAAABJRU5ErkJggg%3D%3D" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8%2F9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAeBJREFUeNqcU81O20AQ%2FtZ2AgQSYQRqL1UPVG2hAUQkxLEStz4DrXpLpD5Drz31Cajax%2Bghhx6qHIJURBTxIwQRwopCBbZjHMcOTrzermPipsSt1Iw03p3ZmW%2B%2B2R0TxhgOD34wjCHZlQ0iDYz9yvEfhxMTCYhEQDIZhkxKd2sqzX2TOD2vBQCQhpPefng1ZP2dVPlLLdpL8SEMcxng%2Fbs0RIHhtgs4twxOh%2BHjZxvzDx%2F3GQQiDFISiRBLFMPKTRMollzcWECrDVhtxtdRVsL9youPxGj%2FbdfFlUZhtDyYbYqWRUdai1oQRZ5oHeHl2gNM%2B01Uqio8RlH%2BnsazJzNwXcq1B%2BiXPHprlEEymeBfXs1w8XxxihfyuXqoHqpoGjZM04bddgG%2F9%2B8WGj87qDdsrK9m%2BoA%2BpbhQTDh2l1%2Bi2weNbSHMZyjvNXmVbqh9Fj5Oz27uEoP%2BSTxANruJs9L%2FT6P0ewqPx5nmiAG5f6AoCtN1PbJzuRyJAyDBzzSQYvErf06yYxhGXlEa8H2KVGoasjwLx3Ewk858opQWXm%2B%2Fib9EQrBzclLLLy89xYvlpchvtixcX6uo1y%2FzsiwHrkIsgKbp%2BYWFOWicuqppoNTnStHzPFCPQhBEBOyGAX4JMADFetubi4BSYAAAAABJRU5ErkJggg%3D%3D" style="margin-right: 0.5em;"/>Index of ftp://ftp.gbif.org/</A><a name="Index of ftp://ftp.gbif.org/" href="#Index of ftp://ftp.gbif.org/" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://imsgbif.gbif.org/CMS_ORC/?doc_id=2955&download=1" name="http://imsgbif.gbif.org/CMS_ORC/?doc_id=2955&download=1" ADD_DATE="1384334586"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Memorandum of Understanding for the Global Biodiversity Information Facility</A><a name="Memorandum of Understanding for the Global Biodiversity Information Facility" href="#Memorandum of Understanding for the Global Biodiversity Information Facility" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://data.gbif.org/species/6" name="http://data.gbif.org/species/6" ADD_DATE="1369416680" ICON_URI="http://data.gbif.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://data.gbif.org/favicon.ico" style="margin-right: 0.5em;"/>Plantae (Plants) - GBIF Portal</A><a name="Plantae (Plants) - GBIF Portal" href="#Plantae (Plants) - GBIF Portal" style="margin-left: 0.5em;">&para;</a>

"79,725,738 records with coordinates"

                <DT><A HREF="http://www.gbif.org/resources/2605#" name="http://www.gbif.org/resources/2605#" ADD_DATE="1384332087" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012</A><a name="Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012" href="#Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><a name="growth forms" href="#growth forms"><H3 ADD_DATE="1367820473">growth forms</H3></a>

            <DL><p>

                <DT><A HREF="http://plants.usda.gov/growth_habits_def.html" name="http://plants.usda.gov/growth_habits_def.html" ADD_DATE="1367819658" ICON_URI="http://plants.usda.gov/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://plants.usda.gov/favicon.ico" style="margin-right: 0.5em;"/>Growth Habits Codes and Definitions | USDA PLANTS</A><a name="Growth Habits Codes and Definitions | USDA PLANTS" href="#Growth Habits Codes and Definitions | USDA PLANTS" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.fgdc.gov/standards/projects/FGDC-standards-projects/vegetation/NVCS_V2_FINAL_2008-02.pdf#page=83&section.page=76" name="http://www.fgdc.gov/standards/projects/FGDC-standards-projects/vegetation/NVCS_V2_FINAL_2008-02.pdf#page=83&section.page=76" ADD_DATE="1367820260" ICON_URI="http://www.fgdc.gov/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.fgdc.gov/favicon.ico" style="margin-right: 0.5em;"/>Appendix E (Normative): Growth Form Names, Codes, and Definitions &lt; National Vegetation Classification Standard (Version 2)</A><a name="Appendix E (Normative): Growth Form Names, Codes, and Definitions &lt; National Vegetation Classification Standard (Version 2)" href="#Appendix E (Normative): Growth Form Names, Codes, and Definitions &lt; National Vegetation Classification Standard (Version 2)" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><a name="NCBI" href="#NCBI"><H3 ADD_DATE="1384332331">NCBI</H3></a>

                <DT><A HREF="http://vegbank.org/vegdocs/vegbranch/docs/normalizer/normalizer.html" name="http://vegbank.org/vegdocs/vegbranch/docs/normalizer/normalizer.html" ADD_DATE="1317750583" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>VegBranch tools : Normalizer</A><a name="VegBranch tools : Normalizer" href="#VegBranch tools : Normalizer" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><A HREF="http://www.ala.org.au/" name="http://www.ala.org.au/" ADD_DATE="1317686713" ICON_URI="http://www.ala.org.au/wp-content/themes/ala2011/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.ala.org.au/wp-content/themes/ala2011/images/favicon.ico" style="margin-right: 0.5em;"/>Atlas of Living Australia</A><a name="Atlas of Living Australia" href="#Atlas of Living Australia" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://mail.iplantcollaborative.org/mailman/listinfo/bien-db" name="http://mail.iplantcollaborative.org/mailman/listinfo/bien-db" ADD_DATE="1351012861" LAST_CHARSET="us-ascii"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Bien-db Info Page</A><a name="Bien-db Info Page" href="#Bien-db Info Page" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.biodiversitycollectionsindex.org/static/citing.html" name="http://www.biodiversitycollectionsindex.org/static/citing.html" ADD_DATE="1360673202" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Biodiversity Collections Index</A><a name="Biodiversity Collections Index" href="#Biodiversity Collections Index" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://spectranomics.stanford.edu/species" name="http://spectranomics.stanford.edu/species" ADD_DATE="1394806696" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Carnegie Spectranomics</A><a name="Carnegie Spectranomics" href="#Carnegie Spectranomics" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/dashboard.action" name="https://pods.iplantcollaborative.org/wiki/dashboard.action" ADD_DATE="1317679822" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Dashboard - iPlant Collaborative Wiki</A><a name="Dashboard - iPlant Collaborative Wiki" href="#Dashboard - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.youtube.com/watch?v=LemPnZn54Kw#t=2709s" name="http://www.youtube.com/watch?v=LemPnZn54Kw#t=2709s" ADD_DATE="1374160719" ICON_URI="http://s.ytimg.com/yts/img/favicon_32-vflWoMFGx.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://s.ytimg.com/yts/img/favicon_32-vflWoMFGx.png" style="margin-right: 0.5em;"/>Enquist Lab in action on PBS NOVA &lt; PBS Nova - Fractals - Hunting the Hidden Dimension. - YouTube</A><a name="Enquist Lab in action on PBS NOVA &lt; PBS Nova - Fractals - Hunting the Hidden Dimension. - YouTube" href="#Enquist Lab in action on PBS NOVA &lt; PBS Nova - Fractals - Hunting the Hidden Dimension. - YouTube" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://apps.fs.fed.us/fiadb-downloads/datamart.html" name="http://apps.fs.fed.us/fiadb-downloads/datamart.html" ADD_DATE="1352423391" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>FIA DataMart 5.1 :: Home</A><a name="FIA DataMart 5.1 :: Home" href="#FIA DataMart 5.1 :: Home" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.givd.info/list_databases.html" name="http://www.givd.info/list_databases.html" ADD_DATE="1389515466" LAST_CHARSET="windows-1252"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>GIVD: List of Databases</A><a name="GIVD: List of Databases" href="#GIVD: List of Databases" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/iptol/Home" name="https://pods.iplantcollaborative.org/wiki/display/iptol/Home" ADD_DATE="1317753528" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Home - iPToL - iPlant Collaborative Wiki</A><a name="Home - iPToL - iPlant Collaborative Wiki" href="#Home - iPToL - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.nceas.ucsb.edu/featured/condon" name="http://www.nceas.ucsb.edu/featured/condon" ADD_DATE="1317757604" ICON_URI="http://www.nceas.ucsb.edu/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.nceas.ucsb.edu/favicon.ico" style="margin-right: 0.5em;"/>Jellyfish Blooms of the Global Ocean: Magnitude, Causes and Consequences for Marine Food Webs, Carbon Cycling and Socioeconomics | NCEAS</A><a name="Jellyfish Blooms of the Global Ocean: Magnitude, Causes and Consequences for Marine Food Webs, Carbon Cycling and Socioeconomics | NCEAS" href="#Jellyfish Blooms of the Global Ocean: Magnitude, Causes and Consequences for Marine Food Webs, Carbon Cycling and Socioeconomics | NCEAS" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://traitnet.ecoinformatics.org/" name="http://traitnet.ecoinformatics.org/" ADD_DATE="1317678447" ICON_URI="http://traitnet.ecoinformatics.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://traitnet.ecoinformatics.org/favicon.ico" style="margin-right: 0.5em;"/>Mission — TraitNet</A><a name="Mission — TraitNet" href="#Mission — TraitNet" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.fgdc.gov/standards/projects/FGDC-standards-projects/vegetation/NVCS_V2_FINAL_2008-02.pdf" name="http://www.fgdc.gov/standards/projects/FGDC-standards-projects/vegetation/NVCS_V2_FINAL_2008-02.pdf" ADD_DATE="1367819868" ICON_URI="http://www.fgdc.gov/favicon.ico"><img width="16" height="16" src="http://www.fgdc.gov/favicon.ico" style="margin-right: 0.5em;"/>National Vegetation Classification Standard (Version 2)</A><a name="National Vegetation Classification Standard (Version 2)" href="#National Vegetation Classification Standard (Version 2)" style="margin-left: 0.5em;">&para;</a>

contains field names for plots data

            <DT><A HREF="http://research.fit.edu/paleolab/pollen.php" name="http://research.fit.edu/paleolab/pollen.php" ADD_DATE="1394806406" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>PaleoLab | Pollen database</A><a name="PaleoLab | Pollen database" href="#PaleoLab | Pollen database" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://phylodiversity.net/phylomatic/" name="http://phylodiversity.net/phylomatic/" ADD_DATE="1372279279" ICON_URI="http://phylodiversity.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://phylodiversity.net/favicon.ico" style="margin-right: 0.5em;"/>Phylomatic (v3)</A><a name="Phylomatic (v3)" href="#Phylomatic (v3)" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.ctfs.si.edu/" name="http://www.ctfs.si.edu/" ADD_DATE="1317753678" ICON_URI="http://biogeodb.stri.si.edu/codelibrary/images/icons/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://biogeodb.stri.si.edu/codelibrary/images/icons/favicon.ico" style="margin-right: 0.5em;"/>Smithsonian Tropical Research Institute-Center for Tropical Forest Science</A><a name="Smithsonian Tropical Research Institute-Center for Tropical Forest Science" href="#Smithsonian Tropical Research Institute-Center for Tropical Forest Science" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://splink.cria.org.br/manager/index?setlang=en" name="http://splink.cria.org.br/manager/index?setlang=en" ADD_DATE="1352227957" ICON_URI="http://splink.cria.org.br/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://splink.cria.org.br/favicon.ico" style="margin-right: 0.5em;"/>speciesLink: networkManager</A><a name="speciesLink: networkManager" href="#speciesLink: networkManager" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://utk.co1.qualtrics.com/SE/?SID=SV_aWxuyT94cZBsBb7" name="https://utk.co1.qualtrics.com/SE/?SID=SV_aWxuyT94cZBsBb7" ADD_DATE="1384453000" ICON_URI="https://utk.co1.qualtrics.com/WRQualtricsShared/Brands/utk/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://utk.co1.qualtrics.com/WRQualtricsShared/Brands/utk/favicon.ico" style="margin-right: 0.5em;"/>Survey | Qualtrics Survey Software | Current Progress 21%</A><a name="Survey | Qualtrics Survey Software | Current Progress 21%" href="#Survey | Qualtrics Survey Software | Current Progress 21%" style="margin-left: 0.5em;">&para;</a>

"Which of the following do you use to access or submit data? (Choose all that apply.)

            <DT><A HREF="http://webchat.nceas.ucsb.edu/?channels=nceas" name="http://webchat.nceas.ucsb.edu/?channels=nceas" ADD_DATE="1317857134" ICON_URI="http://webchat.nceas.ucsb.edu/images/favicon.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://webchat.nceas.ucsb.edu/images/favicon.png" style="margin-right: 0.5em;"/>Connect - NCEAS Web IRC</A><a name="Connect - NCEAS Web IRC" href="#Connect - NCEAS Web IRC" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.nceas.ucsb.edu/ackformat" name="http://www.nceas.ucsb.edu/ackformat" ADD_DATE="1394806614" ICON_URI="http://www.nceas.ucsb.edu/files/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.nceas.ucsb.edu/files/favicon.ico" style="margin-right: 0.5em;"/>Suggested Acknowledgment Formats | NCEAS</A><a name="Suggested Acknowledgment Formats | NCEAS" href="#Suggested Acknowledgment Formats | NCEAS" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.ia.ucsb.edu/pa/display.aspx?pkey=3045" name="http://www.ia.ucsb.edu/pa/display.aspx?pkey=3045" ADD_DATE="1371772726" ICON_URI="http://www.ia.ucsb.edu/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.ia.ucsb.edu/favicon.ico" style="margin-right: 0.5em;"/>&quot;New Moore Foundation Funding Supports UCSB Ecology Synthesis Center Embarking on a New Era &quot; - UC Santa Barbara News Release</A><a name="&quot;New Moore Foundation Funding Supports UCSB Ecology Synthesis Center Embarking on a New Era &quot; - UC Santa Barbara News Release" href="#&quot;New Moore Foundation Funding Supports UCSB Ecology Synthesis Center Embarking on a New Era &quot; - UC Santa Barbara News Release" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.identity.ucsb.edu/people_finder/" name="http://www.identity.ucsb.edu/people_finder/" ADD_DATE="1318292044" ICON_URI="http://www.identity.ucsb.edu/_images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.identity.ucsb.edu/_images/favicon.ico" style="margin-right: 0.5em;"/>Identity :: People Finder</A><a name="Identity :: People Finder" href="#Identity :: People Finder" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.bfs.ucsb.edu/payroll/factor-leave-accrual" name="http://www.bfs.ucsb.edu/payroll/factor-leave-accrual" ADD_DATE="1367477380" ICON_URI="http://www.bfs.ucsb.edu/sites/www.bfs.ucsb.edu/files/fav-icon.gif"><img width="16" height="16" src="http://www.bfs.ucsb.edu/sites/www.bfs.ucsb.edu/files/fav-icon.gif" style="margin-right: 0.5em;"/>Factor Leave Accrual | Business &amp; Financial Services - UCSB</A><a name="Factor Leave Accrual | Business &amp; Financial Services - UCSB" href="#Factor Leave Accrual | Business &amp; Financial Services - UCSB" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="http://www.nceas.ucsb.edu/projects/12678" name="http://www.nceas.ucsb.edu/projects/12678" ADD_DATE="1395362659" ICON_URI="https://www.nceas.ucsb.edu/files/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://www.nceas.ucsb.edu/files/favicon.ico" style="margin-right: 0.5em;"/>SNAP: Integrating natural defenses into coastal disaster risk reduction @ NCEAS Project 12678 | NCEAS</A><a name="SNAP: Integrating natural defenses into coastal disaster risk reduction @ NCEAS Project 12678 | NCEAS" href="#SNAP: Integrating natural defenses into coastal disaster risk reduction @ NCEAS Project 12678 | NCEAS" style="margin-left: 0.5em;">&para;</a>

                </DL><p>

                <DT><A HREF="http://d1z0sq8846aidu.cloudfront.net/Apps/OHI/Vault/Download?VaultID=7578&ts=1390940733" name="http://d1z0sq8846aidu.cloudfront.net/Apps/OHI/Vault/Download?VaultID=7578&ts=1390940733" ADD_DATE="1390940930"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Ocean Health Index 2013: Results Summary</A><a name="Ocean Health Index 2013: Results Summary" href="#Ocean Health Index 2013: Results Summary" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><a name="Roundtable" href="#Roundtable"><H3 ADD_DATE="1371794032">Roundtable</H3></a>

            <DL><p>

                <DT><a name="*** virtual collaboration" href="#*** virtual collaboration"><H3 ADD_DATE="1393265597">*** virtual collaboration</H3></a>

                <DL><p>

                    <DT><A HREF="http://www.facilitate.com/support/facilitator-toolkit/docs/Facing-Fears-Virtual-Meetings.pdf" name="http://www.facilitate.com/support/facilitator-toolkit/docs/Facing-Fears-Virtual-Meetings.pdf" ADD_DATE="1393266191" ICON_URI="http://www.facilitate.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.facilitate.com/favicon.ico" style="margin-right: 0.5em;"/>* Facing-Fears-Virtual-Meetings.pdf</A><a name="* Facing-Fears-Virtual-Meetings.pdf" href="#* Facing-Fears-Virtual-Meetings.pdf" style="margin-left: 0.5em;">&para;</a>

"Reduce the

scope for the actual meeting"

their own desks."

I actually think this is a bad idea, because it causes the people within the pods to communicate with each other rather than with the entire group

                    <DT><A HREF="http://www.facilitate.com/support/facilitator-toolkit/docs/Forbes-Insight-F2F.pdf" name="http://www.facilitate.com/support/facilitator-toolkit/docs/Forbes-Insight-F2F.pdf" ADD_DATE="1393267073" ICON_URI="http://www.facilitate.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.facilitate.com/favicon.ico" style="margin-right: 0.5em;"/>Forbes-Insight-F2F.pdf</A><a name="Forbes-Insight-F2F.pdf" href="#Forbes-Insight-F2F.pdf" style="margin-left: 0.5em;">&para;</a>

note that the chart on face-to-face vs. technology-enabled meetings (p3) does not includes *disadvantages* of either

                    <DT><A HREF="http://roundtable.nceas.ucsb.edu/2014/02/21/virtual-collaboration/" name="http://roundtable.nceas.ucsb.edu/2014/02/21/virtual-collaboration/" ADD_DATE="1393265501" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Using virtual collaboration to replace or supplement carbon-intensive research travel: barriers, best practices, and opportunities for innovation | Roundtable</A><a name="Using virtual collaboration to replace or supplement carbon-intensive research travel: barriers, best practices, and opportunities for innovation | Roundtable" href="#Using virtual collaboration to replace or supplement carbon-intensive research travel: barriers, best practices, and opportunities for innovation | Roundtable" style="margin-left: 0.5em;">&para;</a>

                </DL><p>

                <DT><A HREF="https://atmo.iplantcollaborative.org/application/" name="https://atmo.iplantcollaborative.org/application/" ADD_DATE="1351209187" ICON_URI="https://atmo.iplantcollaborative.org/resources/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://atmo.iplantcollaborative.org/resources/images/favicon.ico" style="margin-right: 0.5em;"/>Atmosphere</A><a name="Atmosphere" href="#Atmosphere" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/atmman/Atmosphere+Manual+Table+of+Contents" name="https://pods.iplantcollaborative.org/wiki/display/atmman/Atmosphere+Manual+Table+of+Contents" ADD_DATE="1402074490" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Atmosphere Manual Table of Contents - Atmosphere Manual - iPlant Collaborative Wiki</A><a name="Atmosphere Manual Table of Contents - Atmosphere Manual - iPlant Collaborative Wiki" href="#Atmosphere Manual Table of Contents - Atmosphere Manual - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.realvnc.com/download/viewer/" name="http://www.realvnc.com/download/viewer/" ADD_DATE="1402074529" ICON_URI="http://www.realvnc.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.realvnc.com/favicon.ico" style="margin-right: 0.5em;"/>RealVNC - Download VNC® Viewer</A><a name="RealVNC - Download VNC® Viewer" href="#RealVNC - Download VNC® Viewer" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><a name="Data Store" href="#Data Store"><H3 ADD_DATE="1402074976">Data Store</H3></a>

            <DL><p>

            <DL><p>

                <DT><A HREF="https://pods.iplantcollaborative.org/jira/browse/TNRS" name="https://pods.iplantcollaborative.org/jira/browse/TNRS" ADD_DATE="1361007268" ICON_URI="https://pods.iplantcollaborative.org/jira/s/en_US-ygkafh-418945332/852/7/_/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/jira/s/en_US-ygkafh-418945332/852/7/_/favicon.ico" style="margin-right: 0.5em;"/>(deprecated) TNRS - The iPlant Collaborative JIRA</A><a name="(deprecated) TNRS - The iPlant Collaborative JIRA" href="#(deprecated) TNRS - The iPlant Collaborative JIRA" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="https://github.com/iPlantCollaborativeOpenSource/TNRS" name="https://github.com/iPlantCollaborativeOpenSource/TNRS" ADD_DATE="1371149187" ICON_URI="https://assets-cdn.github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://assets-cdn.github.com/favicon.ico" style="margin-right: 0.5em;"/>iPlantCollaborativeOpenSource/TNRS · GitHub</A><a name="iPlantCollaborativeOpenSource/TNRS · GitHub" href="#iPlantCollaborativeOpenSource/TNRS · GitHub" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="https://github.com/iPlantCollaborativeOpenSource/TNRS/issues" name="https://github.com/iPlantCollaborativeOpenSource/TNRS/issues" ADD_DATE="1400283866" ICON_URI="https://assets-cdn.github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://assets-cdn.github.com/favicon.ico" style="margin-right: 0.5em;"/>Issues · iPlantCollaborativeOpenSource/TNRS · GitHub</A><a name="Issues · iPlantCollaborativeOpenSource/TNRS · GitHub" href="#Issues · iPlantCollaborativeOpenSource/TNRS · GitHub" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://tnrs.iplantcollaborative.org/instructions.html#download_results" name="http://tnrs.iplantcollaborative.org/instructions.html#download_results" ADD_DATE="1371599361" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Taxonomic Name Resolution Service - Instructions</A><a name="Taxonomic Name Resolution Service - Instructions" href="#Taxonomic Name Resolution Service - Instructions" style="margin-left: 0.5em;">&para;</a>

            </DL><p>

            <DT><A HREF="http://asmarterplanet.com/blog/2012/02/big-data-the-view-from-the-classroom.html" name="http://asmarterplanet.com/blog/2012/02/big-data-the-view-from-the-classroom.html" ADD_DATE="1375339514" ICON_URI="http://asmarterplanet.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://asmarterplanet.com/favicon.ico" style="margin-right: 0.5em;"/>Big Data: The View From The Classroom « A Smarter Planet Blog A Smarter Planet Blog</A><a name="Big Data: The View From The Classroom « A Smarter Planet Blog A Smarter Planet Blog" href="#Big Data: The View From The Classroom « A Smarter Planet Blog A Smarter Planet Blog" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://cshl.adobeconnect.com/_a1148320334/p9igon3soa9/output/cheatsheet.pdf?download=true" name="https://cshl.adobeconnect.com/_a1148320334/p9igon3soa9/output/cheatsheet.pdf?download=true" ADD_DATE="1402074752"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>cheatsheet.pdf @ Adobe Connect File Share</A><a name="cheatsheet.pdf @ Adobe Connect File Share" href="#cheatsheet.pdf @ Adobe Connect File Share" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://iplant.webex.com/cmp0307l/webcomponents/widget/globalcallin/globalcallin.do?siteurl=iplant&serviceType=MC&eventID=196234947&tollFree=1" name="https://iplant.webex.com/cmp0307l/webcomponents/widget/globalcallin/globalcallin.do?siteurl=iplant&serviceType=MC&eventID=196234947&tollFree=1" ADD_DATE="1333400068" ICON_URI="https://iplant.webex.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://iplant.webex.com/favicon.ico" style="margin-right: 0.5em;"/>Global call-in numbers</A><a name="Global call-in numbers" href="#Global call-in numbers" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://www.iplantcollaborative.org/sites/default/files/iPlantCLA.txt" name="http://www.iplantcollaborative.org/sites/default/files/iPlantCLA.txt" ADD_DATE="1371150306" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>iPlant Collaborative Contributor License Agreement</A><a name="iPlant Collaborative Contributor License Agreement" href="#iPlant Collaborative Contributor License Agreement" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://user.iplantcollaborative.org/" name="http://user.iplantcollaborative.org/" ADD_DATE="1351206322" ICON_URI="http://user.iplantcollaborative.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://user.iplantcollaborative.org/favicon.ico" style="margin-right: 0.5em;"/>iPlant User Management</A><a name="iPlant User Management" href="#iPlant User Management" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="https://pods.iplantcollaborative.org/wiki/renderer/notationhelp.action" name="https://pods.iplantcollaborative.org/wiki/renderer/notationhelp.action" ADD_DATE="1362528382" ICON_URI="https://pods.iplantcollaborative.org/wiki/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/favicon.ico" style="margin-right: 0.5em;"/>Notation Guide - iPlant Collaborative Wiki</A><a name="Notation Guide - iPlant Collaborative Wiki" href="#Notation Guide - iPlant Collaborative Wiki" style="margin-left: 0.5em;">&para;</a>

                <DT><a name="authority to bind" href="#authority to bind"><H3 ADD_DATE="1384913809">authority to bind</H3></a>

                <DL><p>

                    <DT><A HREF="http://www.pazarlaw.com/authority-to-bind-you-did-what/" name="http://www.pazarlaw.com/authority-to-bind-you-did-what/" ADD_DATE="1384913779" ICON_URI="http://www.pazarlaw.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.pazarlaw.com/favicon.ico" style="margin-right: 0.5em;"/>Authority to Bind – “You did what?” | Pazar Law</A><a name="Authority to Bind – “You did what?” | Pazar Law" href="#Authority to Bind – “You did what?” | Pazar Law" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="http://danashultz.com/blog/2010/06/28/who-can-sign-a-contract-for-a-corporation/" name="http://danashultz.com/blog/2010/06/28/who-can-sign-a-contract-for-a-corporation/" ADD_DATE="1384913693" ICON_URI="http://danashultz.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://danashultz.com/favicon.ico" style="margin-right: 0.5em;"/>The High-touch Legal Services® Blog…for Startups!Who Can Sign Contracts for a Corporation? » The High-touch Legal Services® Blog...for Startups!</A><a name="The High-touch Legal Services® Blog…for Startups!Who Can Sign Contracts for a Corporation? » The High-touch Legal Services® Blog...for Startups!" href="#The High-touch Legal Services® Blog…for Startups!Who Can Sign Contracts for a Corporation? » The High-touch Legal Services® Blog...for Startups!" style="margin-left: 0.5em;">&para;</a>

                </DL><p>

                <DT><A HREF="http://en.wikipedia.org/wiki/Derivative_Work" name="http://en.wikipedia.org/wiki/Derivative_Work" ADD_DATE="1387227571" 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;"/>Derivative work - Wikipedia, the free encyclopedia</A><a name="Derivative work - Wikipedia, the free encyclopedia" href="#Derivative work - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://archive.mises.org/16451/lets-make-copyright-opt-out/" name="http://archive.mises.org/16451/lets-make-copyright-opt-out/" ADD_DATE="1384981301" ICON_URI="http://archive.mises.org/wp-content/themes/thesis_18/custom/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://archive.mises.org/wp-content/themes/thesis_18/custom/images/favicon.ico" style="margin-right: 0.5em;"/>Let’s Make Copyright Opt-OUT</A><a name="Let’s Make Copyright Opt-OUT" href="#Let’s Make Copyright Opt-OUT" style="margin-left: 0.5em;">&para;</a>

"But if you don’t want copyright, you’re out of luck. Under the current law, copyright is received automatically. Contrary to popular wisdom, you don’t “copyright” something. It’s not a verb. You don’t need to put a copyright notice on your work. You don’t need to register it. It’s automatic. And there’s nothing you can do about it. (See “Copyright Is Very Sticky!“) This makes it often impossible to know who the owner of a given work is or who to approach to ask permission; it contributes to the “orphan works” problem as well–where older works still apparently under copyright fall into obscurity because the copyright owner is unknown or cannot be found for permission to republish."

                <DT><A HREF="http://en.wikipedia.org/wiki/Scenes_a_faire" name="http://en.wikipedia.org/wiki/Scenes_a_faire" ADD_DATE="1387591228" 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;"/>Scènes à faire - Wikipedia, the free encyclopedia</A><a name="Scènes à faire - Wikipedia, the free encyclopedia" href="#Scènes à faire - Wikipedia, the free encyclopedia" style="margin-left: 0.5em;">&para;</a>

                <DT><A HREF="http://www.copyright.gov/fls/fl102.html" name="http://www.copyright.gov/fls/fl102.html" ADD_DATE="1387591269" ICON_URI="http://www.copyright.gov/images/favicon_cop.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.copyright.gov/images/favicon_cop.ico" style="margin-right: 0.5em;"/>U.S. Copyright Office - Fair Use</A><a name="U.S. Copyright Office - Fair Use" href="#U.S. Copyright Office - Fair Use" style="margin-left: 0.5em;">&para;</a>

"Copyright [...] does not extend to any ideas, systems, or factual information conveyed in a work"

            </DL><p>

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

                    <DL><p>

                        <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;"/>*** The Enhanced Entity-Relationship (EER) Model @ Ch08.pdf</A><a name="*** The Enhanced Entity-Relationship (EER) Model @ Ch08.pdf" href="#*** The Enhanced Entity-Relationship (EER) Model @ Ch08.pdf" style="margin-left: 0.5em;">&para;</a>

generalization have few specific attributes

and no specific relationships



to their real-world counterparts

"

                        <DT><A HREF="http://www.utteraccess.com/wiki/index.php/Anomalies:_Insert,_Update_and_Delete" name="http://www.utteraccess.com/wiki/index.php/Anomalies:_Insert,_Update_and_Delete" ADD_DATE="1396580564" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Anomalies: Insert, Update and Delete - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com</A><a name="Anomalies: Insert, Update and Delete - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com" href="#Anomalies: Insert, Update and Delete - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com" style="margin-left: 0.5em;">&para;</a>

                        <DT><A HREF="http://www.tdan.com/view-articles/7474" name="http://www.tdan.com/view-articles/7474" ADD_DATE="1383027917" ICON_URI="http://www.tdan.com/view-articles/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.tdan.com/view-articles/favicon.ico" style="margin-right: 0.5em;"/>Crow&#39;s Feet Are Best</A><a name="Crow&#39;s Feet Are Best" href="#Crow&#39;s Feet Are Best" style="margin-left: 0.5em;">&para;</a>

"Peter Chen invented data modeling with his innovative way of showing data structures in terms of entities and relationships"

                        <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>

                        <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>

                    <DL><p>

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

                        <DL><p>

"Or... use Postgres

                        <DT><a name="optimization" href="#optimization"><H3 ADD_DATE="1383111725">optimization</H3></a>

                        <DL><p>

                            <DT><A HREF="http://use-the-index-luke.com/blog/2013-07/afraid-of-ssd" name="http://use-the-index-luke.com/blog/2013-07/afraid-of-ssd" ADD_DATE="1383112257" ICON_URI="http://use-the-index-luke.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://use-the-index-luke.com/favicon.ico" style="margin-right: 0.5em;"/>Afraid of SSD?</A><a name="Afraid of SSD?" href="#Afraid of SSD?" style="margin-left: 0.5em;">&para;</a>

"If you want to get the factor 50 speed-up of SSDs, you’d better avoid reading large chunks of sequential data, because that’s where you can only gain a factor five improvement. To put that into database context: if you are doing many full table scans, you won’t get the full potential of SSD. On the other hand, index lookups have a tendency to cause many random IO operations and can thus benefit from the fast response time of SSDs"

                            <DT><A HREF="http://blogs.msdn.com/b/craigfr/archive/2006/09/20/hash-aggregate.aspx" name="http://blogs.msdn.com/b/craigfr/archive/2006/09/20/hash-aggregate.aspx" ADD_DATE="1383111708" ICON_URI="http://blogs.msdn.com/themes/MSDN2/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blogs.msdn.com/themes/MSDN2/favicon.ico" style="margin-right: 0.5em;"/>Hash Aggregate - Craig Freedman&#39;s SQL Server Blog - Site Home - MSDN Blogs</A><a name="Hash Aggregate - Craig Freedman&#39;s SQL Server Blog - Site Home - MSDN Blogs" href="#Hash Aggregate - Craig Freedman&#39;s SQL Server Blog - Site Home - MSDN Blogs" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://use-the-index-luke.com/sql/sorting-grouping/indexed-group-by" name="http://use-the-index-luke.com/sql/sorting-grouping/indexed-group-by" ADD_DATE="1383112075" ICON_URI="http://use-the-index-luke.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://use-the-index-luke.com/favicon.ico" style="margin-right: 0.5em;"/>Indexed Group By | SQL Performance Explained</A><a name="Indexed Group By | SQL Performance Explained" href="#Indexed Group By | SQL Performance Explained" style="margin-left: 0.5em;">&para;</a>

                            <DT><A HREF="http://use-the-index-luke.com/sql/explain-plan/postgresql/operations" name="http://use-the-index-luke.com/sql/explain-plan/postgresql/operations" ADD_DATE="1383111842" ICON_URI="http://use-the-index-luke.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://use-the-index-luke.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL EXPLAIN | Understand each Operation</A><a name="PostgreSQL EXPLAIN | Understand each Operation" href="#PostgreSQL EXPLAIN | Understand each Operation" style="margin-left: 0.5em;">&para;</a>

"A plain Index Scan fetches one tuple-pointer at a time from the index, and immediately visits that tuple in the table. A bitmap scan fetches all the tuple-pointers from the index in one go, sorts them using an in-memory "bitmap" data structure, and then visits the table tuples in physical tuple-location order."

                        </DL><p>

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

                        <DL><p>

                            <DT><a name="backups" href="#backups"><H3 ADD_DATE="1397769882">backups</H3></a>

pg_start_backup() method:

(more reliable and Postgres-recommended, but requires putting the DB server into a special mode during backup)

                                <DT><a name="pg_clog, pg_xlog" href="#pg_clog, pg_xlog"><H3 ADD_DATE="1397777677">pg_clog, pg_xlog</H3></a>

                                <DL><p>

                                    <DT><A HREF="http://it.toolbox.com/blogs/database-soup/pg_log-pg_xlog-and-pg_clog-45611" name="http://it.toolbox.com/blogs/database-soup/pg_log-pg_xlog-and-pg_clog-45611" ADD_DATE="1397777816" ICON_URI="http://images.ittoolbox.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://images.ittoolbox.com/favicon.ico" style="margin-right: 0.5em;"/>** pg_log, pg_xlog, and pg_clog</A><a name="** pg_log, pg_xlog, and pg_clog" href="#** pg_log, pg_xlog, and pg_clog" style="margin-left: 0.5em;">&para;</a>

"Should you ever delete files from pg_clog, you might as well delete the entire database directory.  There is no recovery from a missing clog."

                                    <DT><A HREF="http://kb.parallels.com/en/6067" name="http://kb.parallels.com/en/6067" ADD_DATE="1397778230" ICON_URI="http://kb.parallels.com/images/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://kb.parallels.com/images/favicon.ico" style="margin-right: 0.5em;"/>KB Parallels: How to recreate postgres pg_clog/xxxx file</A><a name="KB Parallels: How to recreate postgres pg_clog/xxxx file" href="#KB Parallels: How to recreate postgres pg_clog/xxxx file" style="margin-left: 0.5em;">&para;</a>

Sometimes the transaction log files become corrupted or deleted due to hordware crash, orpower failure, usually the error is like folowing:

 hsphere=# select * from TABLE;

ERROR:  could not access status of transaction 1918986094

"The needed file should be reacreated manually with blanked inside, but filesize should be the same"

                                    <DT><A HREF="http://bytes.com/topic/postgresql/answers/422686-pg_clog-pg_xlog-empty-postgresql-refuses-start" name="http://bytes.com/topic/postgresql/answers/422686-pg_clog-pg_xlog-empty-postgresql-refuses-start" ADD_DATE="1397778294" ICON_URI="http://bytes.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://bytes.com/favicon.ico" style="margin-right: 0.5em;"/>pg_clog and pg_xlog empty, postgresql refuses to start - PostgreSQL Database</A><a name="pg_clog and pg_xlog empty, postgresql refuses to start - PostgreSQL Database" href="#pg_clog and pg_xlog empty, postgresql refuses to start - PostgreSQL Database" style="margin-left: 0.5em;">&para;</a>

"I'd put back the clog files if at all possible. If not you can

substitute zero-filled 256K files for each clog file the server

not be capable of replaying whatever happened since your last checkpoint."

                                    <DT><A HREF="http://www.postgresql.org/message-id/CB0FB369FF86E248A884BCC002562BCB010C0D9F@pisgsna01sxch01.ana.firstamdata.com" name="http://www.postgresql.org/message-id/CB0FB369FF86E248A884BCC002562BCB010C0D9F@pisgsna01sxch01.ana.firstamdata.com" ADD_DATE="1397777667" 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: what are the pg_clog and pg_xlog directories ?</A><a name="Re: what are the pg_clog and pg_xlog directories ?" href="#Re: what are the pg_clog and pg_xlog directories ?" style="margin-left: 0.5em;">&para;</a>

                                </DL><p>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/continuous-archiving.html" name="http://www.postgresql.org/docs/9.3/static/continuous-archiving.html" ADD_DATE="1397776277" ICON_URI="http://www.postgresql.org/favicon.ico"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>** PostgreSQL: Documentation: 9.3: Continuous Archiving and Point-in-Time Recovery (PITR)</A><a name="** PostgreSQL: Documentation: 9.3: Continuous Archiving and Point-in-Time Recovery (PITR)" href="#** PostgreSQL: Documentation: 9.3: Continuous Archiving and Point-in-Time Recovery (PITR)" style="margin-left: 0.5em;">&para;</a>

"When wal_level is minimal some SQL commands are optimized to avoid WAL logging" this is really the only reason that wal_level must be archive, since the server normally keeps around lots of WAL segments anyway.

"The file identified by pg_stop_backup's result is the last segment that is required to form a complete set of backup files"

* actually, this is only needed if parts of base/ were copied *after* the backup finishes copying pg_xlog/. most backup mechanisms copy in alphabetical order, so that pg_xlog/ will be the last subdir copied, and the last segment in it will be copied after base/ is already done.

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-wal.html" name="http://www.postgresql.org/docs/9.3/static/runtime-config-wal.html" ADD_DATE="1397779174" 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.3: Write Ahead Log</A><a name="** PostgreSQL: Documentation: 9.3: Write Ahead Log" href="#** PostgreSQL: Documentation: 9.3: Write Ahead Log" style="margin-left: 0.5em;">&para;</a>

"In many situations, turning off synchronous_commit for noncritical transactions can provide much of the potential performance benefit of turning off fsync, without the attendant risks of data corruption."

"In hot_standby level, the same information is logged as with archive, plus information needed to reconstruct the status of running transactions from the WAL. [...] It is thought that there is little measurable difference in performance between using hot_standby and archive levels" ie, if you are going to use archive anyway, might as well go straight to hot_standby

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/backup-file.html" name="http://www.postgresql.org/docs/9.3/static/backup-file.html" ADD_DATE="1397776134" 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.3: File System Level Backup</A><a name="*** PostgreSQL: Documentation: 9.3: File System Level Backup" href="#*** PostgreSQL: Documentation: 9.3: File System Level Backup" style="margin-left: 0.5em;">&para;</a>

** in practice, this is not necessarily the case. it is entirely possible to get a usable filesystem-level backup, using the approaches described at http://vegpath.org/links/#backups .

this is important because filesystem-level backups have several significant advantages over traditional database-level backups with pg_dump:

1) only changed files will be backed up each time, rather than the entire database

in general, to get a consistent filesystem-level backup, you need a WAL chain that's at least long enough (time-wise) for the WAL blocks created when it starts copying base/ to still be around when it finishes copying pg_xlog/ (it must also copy in alphabetical order, and not in parallel)

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html#GUC-WAL-KEEP-SEGMENTS" name="http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html#GUC-WAL-KEEP-SEGMENTS" ADD_DATE="1398234626" 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.3: Replication: wal_keep_segments</A><a name="*** PostgreSQL: Documentation: 9.3: Replication: wal_keep_segments" href="#*** PostgreSQL: Documentation: 9.3: Replication: wal_keep_segments" style="margin-left: 0.5em;">&para;</a>

    Specifies the minimum number of past log file segments kept in the pg_xlog directory"

                                <DT><A HREF="http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-parallel-pg_dump/" name="http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-parallel-pg_dump/" ADD_DATE="1397769449" ICON_URI="http://michael.otacoo.com/content/favicon_otacoo.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://michael.otacoo.com/content/favicon_otacoo.gif" style="margin-right: 0.5em;"/>Postgres 9.3 feature highlight: parallel pg_dump</A><a name="Postgres 9.3 feature highlight: parallel pg_dump" href="#Postgres 9.3 feature highlight: parallel pg_dump" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-checkpoint.html" name="http://www.postgresql.org/docs/9.3/static/sql-checkpoint.html" ADD_DATE="1398205258" 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.3: CHECKPOINT</A><a name="PostgreSQL: Documentation: 9.3: CHECKPOINT" href="#PostgreSQL: Documentation: 9.3: CHECKPOINT" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/app-pgbasebackup.html" name="http://www.postgresql.org/docs/9.3/static/app-pgbasebackup.html" ADD_DATE="1397778881" 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.3: pg_basebackup</A><a name="PostgreSQL: Documentation: 9.3: pg_basebackup" href="#PostgreSQL: Documentation: 9.3: pg_basebackup" style="margin-left: 0.5em;">&para;</a>

                            </DL><p>

                            <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>

"put each tablespace on a LVM partition of a control sized,  

extensible"

                                <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>

                            </DL><p>

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

                            <DL><p>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/xfunc-volatility.html" name="http://www.postgresql.org/docs/9.3/static/xfunc-volatility.html" ADD_DATE="1393355422" ICON_URI="http://www.postgresql.org/favicon.ico"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>** PostgreSQL: Documentation: 9.3: Function Volatility Categories</A><a name="** PostgreSQL: Documentation: 9.3: Function Volatility Categories" href="#** PostgreSQL: Documentation: 9.3: Function Volatility Categories" style="margin-left: 0.5em;">&para;</a>

*** "A common error is to label a function IMMUTABLE when its results depend on a configuration parameter. For example, a function that manipulates timestamps might well have results that depend on the TimeZone setting. For safety, such functions should be labeled STABLE instead."

this especially includes functions that depend on the search_path! (ie. that don't have schema qualifiers on all invoked functions.) however, this effect will only be noticeable if the function is called on only *constant* values in a *PL/pgSQL* function, in which case the wrong search_path (the one in effect at *create* time) will be used.

ie. if you are going to use your STABLE function in a PL/pgSQL function, be sure to label it STABLE so that it does not get constant-folded until call time (if labeled IMMUTABLE, it would be folded right away when the function is created)

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/explicit-joins.html" name="http://www.postgresql.org/docs/9.3/static/explicit-joins.html" ADD_DATE="1394188171" 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.3: Controlling the Planner with Explicit JOIN Clauses</A><a name="*** PostgreSQL: Documentation: 9.3: Controlling the Planner with Explicit JOIN Clauses" href="#*** PostgreSQL: Documentation: 9.3: Controlling the Planner with Explicit JOIN Clauses" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-query.html" name="http://www.postgresql.org/docs/9.3/static/runtime-config-query.html" ADD_DATE="1394182959" 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.3: Query Planning</A><a name="**** PostgreSQL: Documentation: 9.3: Query Planning" href="#**** PostgreSQL: Documentation: 9.3: Query Planning" style="margin-left: 0.5em;">&para;</a>

**** "join_collapse_limit (integer)

    The planner will rewrite explicit JOIN constructs (except FULL JOINs) into lists of FROM items whenever a list of no more than this many items would result. Smaller values reduce planning time but might yield inferior query plans."

                                <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>

"If the constraint is marked NOT VALID, the potentially-lengthy initial check to verify that all rows in the table satisfy the constraint is skipped. *The constraint will still be enforced against subsequent inserts or updates* (that is, they'll fail unless there is a matching row in the referenced table)." [+emph]

it has been experimentally verified that the constraint *is* enforced against new rows, so this unfortunately *cannot* be used to temporarily disable an fkey

"To force an immediate rewrite of the table, you can use VACUUM FULL, CLUSTER or one of the forms of ALTER TABLE that forces a rewrite. This results in no semantically-visible change in the table, but gets rid of no-longer-useful data."

                                <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/ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION" name="http://www.postgresql.org/docs/9.1/static/ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION" ADD_DATE="1383215159" 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: Constraints: 5.3.6. Exclusion Constraints</A><a name="PostgreSQL: Documentation: 9.1: Constraints: 5.3.6. Exclusion Constraints" href="#PostgreSQL: Documentation: 9.1: Constraints: 5.3.6. Exclusion Constraints" 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>

text format:

"Backslash characters (\) can be used in the COPY data to quote data characters that might otherwise be taken as row or column delimiters."

with ESCAPE=" : "->""

                                <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>

This is referring to the session when the function is *defined*, not when it's called.

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-createindex.html" name="http://www.postgresql.org/docs/9.1/static/sql-createindex.html" ADD_DATE="1383214747" 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 INDEX</A><a name="PostgreSQL: Documentation: 9.1: CREATE INDEX" href="#PostgreSQL: Documentation: 9.1: CREATE INDEX" 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>

an operator class is equivalent to a comparator in other programming languages (with the exception that the same comparator cannot be used for both trees and hashes)

                                <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-createtable.html#SQL-CREATETABLE-EXCLUDE" name="http://www.postgresql.org/docs/9.1/static/sql-createtable.html#SQL-CREATETABLE-EXCLUDE" ADD_DATE="1383214924" 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 TABLE: EXCLUDE</A><a name="PostgreSQL: Documentation: 9.1: CREATE TABLE: EXCLUDE" href="#PostgreSQL: Documentation: 9.1: CREATE TABLE: EXCLUDE" 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>

"A column-specific trigger (one defined using the UPDATE OF column_name syntax) will fire when any of its columns are listed as targets in the UPDATE command's SET list. It is possible for a column's value to change even when the trigger is not fired, because changes made to the row's contents by BEFORE UPDATE triggers are not considered. Conversely, a command such as UPDATE ... SET x = x ... will fire a trigger on column x, even though the column's value did not change."

"For UPDATE events, it is possible to specify a list of columns"

                                <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/indexes-types.html" name="http://www.postgresql.org/docs/9.1/static/indexes-types.html" ADD_DATE="1383112654" 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: Index Types</A><a name="PostgreSQL: Documentation: 9.1: Index Types" href="#PostgreSQL: Documentation: 9.1: Index Types" 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>

"the OPERATOR syntax, as for example in:

SELECT 3 OPERATOR(pg_catalog.+) 4;

"

                                <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/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/sql-select.html#AEN75336" name="http://www.postgresql.org/docs/9.1/static/sql-select.html#AEN75336" ADD_DATE="1399996974" ICON_URI="http://www.postgresql.org/favicon.ico"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: SELECT: Data-Modifying Statements in WITH</A><a name="PostgreSQL: Documentation: 9.1: SELECT: Data-Modifying Statements in WITH" href="#PostgreSQL: Documentation: 9.1: SELECT: Data-Modifying Statements in WITH" 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>

this is INCORRECT: UNIQUE constraints must be globally unique because their implicit indexes must be globally unique. trying to create an inter-table duplicate UNIQUE constraint gives the error:

--

NOTICE:  CREATE TABLE / UNIQUE will create implicit index "x" for table "b"

                                <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>

includes set_config(), current_setting()

                                <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>

"In Unix parlance, the session user is the "real user" and the current user is the "effective user"."

                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE" name="http://www.postgresql.org/docs/9.1/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE" ADD_DATE="1384405185" 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: has_table_privilege()</A><a name="PostgreSQL: Documentation: 9.1: System Information Functions: has_table_privilege()" href="#PostgreSQL: Documentation: 9.1: System Information Functions: has_table_privilege()" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS" name="http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS" ADD_DATE="1384428283" ICON_URI="http://www.postgresql.org/favicon.ico"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.2: Control Structures: 39.6.6.1. Obtaining information about an error</A><a name="PostgreSQL: Documentation: 9.2: Control Structures: 39.6.6.1. Obtaining information about an error" href="#PostgreSQL: Documentation: 9.2: Control Structures: 39.6.6.1. Obtaining information about an error" style="margin-left: 0.5em;">&para;</a>

"

  GET STACKED DIAGNOSTICS text_var1 = MESSAGE_TEXT,

"

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/functions-aggregate.html" name="http://www.postgresql.org/docs/9.3/static/functions-aggregate.html" ADD_DATE="1394669601" 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.3: Aggregate Functions</A><a name="PostgreSQL: Documentation: 9.3: Aggregate Functions" href="#PostgreSQL: Documentation: 9.3: Aggregate Functions" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-client.html#GUC-STATEMENT-TIMEOUT" name="http://www.postgresql.org/docs/9.3/static/runtime-config-client.html#GUC-STATEMENT-TIMEOUT" ADD_DATE="1398998369" 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.3: Client Connection Defaults: statement_timeout</A><a name="PostgreSQL: Documentation: 9.3: Client Connection Defaults: statement_timeout" href="#PostgreSQL: Documentation: 9.3: Client Connection Defaults: statement_timeout" style="margin-left: 0.5em;">&para;</a>

    Abort any statement that takes more than the specified number of milliseconds, starting from the time the command arrives at the server from the client."

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/functions-conditional.html#FUNCTIONS-CASE" name="http://www.postgresql.org/docs/9.3/static/functions-conditional.html#FUNCTIONS-CASE" ADD_DATE="1399980245" 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.3: Conditional Expressions: CASE</A><a name="PostgreSQL: Documentation: 9.3: Conditional Expressions: CASE" href="#PostgreSQL: Documentation: 9.3: Conditional Expressions: CASE" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createcast.html" name="http://www.postgresql.org/docs/9.3/static/sql-createcast.html" ADD_DATE="1397607986" 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.3: CREATE CAST</A><a name="PostgreSQL: Documentation: 9.3: CREATE CAST" href="#PostgreSQL: Documentation: 9.3: CREATE CAST" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createdomain.html" name="http://www.postgresql.org/docs/9.3/static/sql-createdomain.html" ADD_DATE="1386257057" 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.3: CREATE DOMAIN</A><a name="PostgreSQL: Documentation: 9.3: CREATE DOMAIN" href="#PostgreSQL: Documentation: 9.3: CREATE DOMAIN" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createview.html" name="http://www.postgresql.org/docs/9.3/static/sql-createview.html" ADD_DATE="1393552021" 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.3: CREATE VIEW</A><a name="PostgreSQL: Documentation: 9.3: CREATE VIEW" href="#PostgreSQL: Documentation: 9.3: CREATE VIEW" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#GUC-LOG-ERROR-VERBOSITY" name="http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#GUC-LOG-ERROR-VERBOSITY" ADD_DATE="1384823719" 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.3: Error Reporting and Logging</A><a name="PostgreSQL: Documentation: 9.3: Error Reporting and Logging" href="#PostgreSQL: Documentation: 9.3: Error Reporting and Logging" style="margin-left: 0.5em;">&para;</a>

to hide stack traces in psql:

\set VERBOSITY terse

there is unfortunately *no* option to do this in pgAdmin

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN" name="http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN" ADD_DATE="1393518205" 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.3: Error Reporting and Logging: 18.8.2. When To Log</A><a name="PostgreSQL: Documentation: 9.3: Error Reporting and Logging: 18.8.2. When To Log" href="#PostgreSQL: Documentation: 9.3: Error Reporting and Logging: 18.8.2. When To Log" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/functions-geometry.html" name="http://www.postgresql.org/docs/9.3/static/functions-geometry.html" ADD_DATE="1393319486" 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.3: Geometric Functions and Operators</A><a name="PostgreSQL: Documentation: 9.3: Geometric Functions and Operators" href="#PostgreSQL: Documentation: 9.3: Geometric Functions and Operators" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/xindex.html" name="http://www.postgresql.org/docs/9.3/static/xindex.html" ADD_DATE="1396196647" 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.3: Interfacing Extensions To Indexes</A><a name="PostgreSQL: Documentation: 9.3: Interfacing Extensions To Indexes" href="#PostgreSQL: Documentation: 9.3: Interfacing Extensions To Indexes" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/indexes-opclass.html" name="http://www.postgresql.org/docs/9.3/static/indexes-opclass.html" ADD_DATE="1396218006" 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.3: Operator Classes and Operator Families</A><a name="PostgreSQL: Documentation: 9.3: Operator Classes and Operator Families" href="#PostgreSQL: Documentation: 9.3: Operator Classes and Operator Families" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/functions-matching.html#POSIX-MATCHING-RULES" name="http://www.postgresql.org/docs/9.3/static/functions-matching.html#POSIX-MATCHING-RULES" ADD_DATE="1393381432" 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.3: Pattern Matching: 9.7.3.5. Regular Expression Matching Rules</A><a name="PostgreSQL: Documentation: 9.3: Pattern Matching: 9.7.3.5. Regular Expression Matching Rules" href="#PostgreSQL: Documentation: 9.3: Pattern Matching: 9.7.3.5. Regular Expression Matching Rules" style="margin-left: 0.5em;">&para;</a>

"non-newline-sensitive matching (default)"

"If inverse partial newline-sensitive matching is specified, this affects ^ and $ as with newline-sensitive matching, but not . and bracket expressions. This isn't very useful but is provided for symmetry."

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/app-pgdump.html" name="http://www.postgresql.org/docs/9.3/static/app-pgdump.html" ADD_DATE="1392338412" 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.3: pg_dump</A><a name="PostgreSQL: Documentation: 9.3: pg_dump" href="#PostgreSQL: Documentation: 9.3: pg_dump" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/app-pgdump.html#PG-DUMP-OPTIONS" name="http://www.postgresql.org/docs/9.3/static/app-pgdump.html#PG-DUMP-OPTIONS" ADD_DATE="1397769730" 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.3: pg_dump: Options</A><a name="PostgreSQL: Documentation: 9.3: pg_dump: Options" href="#PostgreSQL: Documentation: 9.3: pg_dump: Options" style="margin-left: 0.5em;">&para;</a>

[...]

You can only use this option with the directory output format because this is the only output format where multiple processes can write their data at the same time.

[...]

For a consistent backup, the database server needs to support synchronized snapshots, a feature that was introduced in PostgreSQL 9.2. With this feature, database clients can ensure they see the same data set even though they use different connections. pg_dump -j uses multiple database connections; it connects to the database once with the master process and once again for each worker job. Without the synchronized snapshot feature, the different worker jobs wouldn't be guaranteed to see the same data in each connection, which could lead to an inconsistent backup.

"

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/app-pg-dumpall.html" name="http://www.postgresql.org/docs/9.3/static/app-pg-dumpall.html" ADD_DATE="1397770361" 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.3: pg_dumpall</A><a name="PostgreSQL: Documentation: 9.3: pg_dumpall" href="#PostgreSQL: Documentation: 9.3: pg_dumpall" style="margin-left: 0.5em;">&para;</a>

    Dump only global objects (roles and tablespaces), no databases.

"

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/view-pg-settings.html" name="http://www.postgresql.org/docs/9.3/static/view-pg-settings.html" ADD_DATE="1393515328" 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.3: pg_settings</A><a name="PostgreSQL: Documentation: 9.3: pg_settings" href="#PostgreSQL: Documentation: 9.3: pg_settings" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" name="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" ADD_DATE="1384429194" 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.3: pg_upgrade</A><a name="PostgreSQL: Documentation: 9.3: pg_upgrade" href="#PostgreSQL: Documentation: 9.3: pg_upgrade" style="margin-left: 0.5em;">&para;</a>

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

this is especially useful for error parsing in column-based import [wiki.vegpath.org/Column-based_import] (and may even have been motivated by it!)

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/app-psql.html#APP-PSQL-PATTERNS" name="http://www.postgresql.org/docs/9.3/static/app-psql.html#APP-PSQL-PATTERNS" ADD_DATE="1392338475" 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.3: psql</A><a name="PostgreSQL: Documentation: 9.3: psql" href="#PostgreSQL: Documentation: 9.3: psql" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-reset.html" name="http://www.postgresql.org/docs/9.3/static/sql-reset.html" ADD_DATE="1396538550" 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.3: RESET</A><a name="PostgreSQL: Documentation: 9.3: RESET" href="#PostgreSQL: Documentation: 9.3: RESET" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" name="http://www.postgresql.org/docs/9.3/static/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" ADD_DATE="1394165454" 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.3: Resource Consumption: 18.4.4. Cost-based Vacuum Delay</A><a name="PostgreSQL: Documentation: 9.3: Resource Consumption: 18.4.4. Cost-based Vacuum Delay" href="#PostgreSQL: Documentation: 9.3: Resource Consumption: 18.4.4. Cost-based Vacuum Delay" style="margin-left: 0.5em;">&para;</a>

"This feature is disabled by default for manually issued VACUUM commands." however, *autovacuum*_vacuum_cost_delay is *enabled* by default

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/ddl-schemas.html" name="http://www.postgresql.org/docs/9.3/static/ddl-schemas.html" ADD_DATE="1393374155" 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.3: Schemas</A><a name="PostgreSQL: Documentation: 9.3: Schemas" href="#PostgreSQL: Documentation: 9.3: Schemas" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/ddl-system-columns.html" name="http://www.postgresql.org/docs/9.3/static/ddl-system-columns.html" ADD_DATE="1394185064" 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.3: System Columns</A><a name="PostgreSQL: Documentation: 9.3: System Columns" href="#PostgreSQL: Documentation: 9.3: System Columns" style="margin-left: 0.5em;">&para;</a>

    The physical location of the row version within its table. Note that although the ctid can be used to locate the row version very quickly, a row's ctid will change if it is updated or moved by VACUUM FULL. Therefore ctid is useless as a long-term row identifier [unless your DB is select-optimized and rarely updated]. The OID, or even better a user-defined serial number, should be used to identify logical rows."

"tableoid

                                <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>

"MySQL triggers are also not activated by cascading updates and deletes even when caused by a SQL statement"

                                <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="hash indexes" href="#hash indexes"><H3 ADD_DATE="1383135543">hash indexes</H3></a>

                            <DL><p>

                                <DT><A HREF="http://grokbase.com/t/postgresql/pgsql-performance/0559m8364s/hash-index-vs-b-tree-index-postgresql-8-0" name="http://grokbase.com/t/postgresql/pgsql-performance/0559m8364s/hash-index-vs-b-tree-index-postgresql-8-0" ADD_DATE="1383136591" 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;"/>&quot;Hash index&quot; vs. &quot;b-tree index&quot; (PostgreSQL 8.0) - Grokbase</A><a name="&quot;Hash index&quot; vs. &quot;b-tree index&quot; (PostgreSQL 8.0) - Grokbase" href="#&quot;Hash index&quot; vs. &quot;b-tree index&quot; (PostgreSQL 8.0) - Grokbase" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://stackoverflow.com/questions/2393240/postgres-hashing-user-defined-types" name="http://stackoverflow.com/questions/2393240/postgres-hashing-user-defined-types" ADD_DATE="1396191920" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico?v=5bcec08ba0c5" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico?v=5bcec08ba0c5" style="margin-right: 0.5em;"/>* sql - Postgres hashing user defined types - Stack Overflow</A><a name="* sql - Postgres hashing user defined types - Stack Overflow" href="#* sql - Postgres hashing user defined types - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

for access method "hash""

ie. a user-defined type needs a special `hash` operator class

                                <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>

cheaper than a probe into an index, so this type of plan makes plenty

of sense if the hashtable will fit in RAM and there are going to be a

lot of probes"

                                <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/398884/postgresql-hash-index" name="http://stackoverflow.com/questions/398884/postgresql-hash-index" ADD_DATE="1366152256" 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 - 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>

                            </DL><p>

                            <DT><a name="installing 9.3" href="#installing 9.3"><H3 ADD_DATE="1384429280">installing 9.3</H3></a>

- in pgAdmin > Preferences > Query tool > Query editor, set Max characters per column back to -1 (to avoid cells being truncated). this is *not* a bug in PostgreSQL, only in pgAdmin, and does *not* signal a need to downgrade.

</DD>

                            <DL><p>

                                <DT><A HREF="http://postgresql.1045698.n5.nabble.com/9-3beta2-unrecognized-node-type-in-join-alias-vars-when-retrieving-view-definition-td5764616.html" name="http://postgresql.1045698.n5.nabble.com/9-3beta2-unrecognized-node-type-in-join-alias-vars-when-retrieving-view-definition-td5764616.html" ADD_DATE="1384528374" 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 - bugs - 9.3beta2 unrecognized node type in join alias vars when retrieving view definition</A><a name="PostgreSQL - bugs - 9.3beta2 unrecognized node type in join alias vars when retrieving view definition" href="#PostgreSQL - bugs - 9.3beta2 unrecognized node type in join alias vars when retrieving view definition" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/message-id/20130508192711.GA9243@msgid.df7cb.de" name="http://www.postgresql.org/message-id/20130508192711.GA9243@msgid.df7cb.de" ADD_DATE="1384429717" 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: Problems with apt.postgresql.org and precise</A><a name="Re: Problems with apt.postgresql.org and precise" href="#Re: Problems with apt.postgresql.org and precise" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://wiki.postgresql.org/wiki/Apt" name="http://wiki.postgresql.org/wiki/Apt" ADD_DATE="1384429170" 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;"/>Apt - PostgreSQL wiki</A><a name="Apt - PostgreSQL wiki" href="#Apt - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>

on Linux:

$ sudo apt-get --yes install postgresql-9.3 postgresql-contrib-9.3 postgresql-plpython-9.3 postgresql-plpython3-9.3 libpq-dev postgresql-9.3-postgis phppgadmin

                                <DT><A HREF="https://gist.github.com/pyk/8243010" name="https://gist.github.com/pyk/8243010" ADD_DATE="1397860988" ICON_URI="https://gist.github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://gist.github.com/favicon.ico" style="margin-right: 0.5em;"/>installing postgresql 9.3.2 on ubuntu 12.04 . with error fix: ummet dependencies</A><a name="installing postgresql 9.3.2 on ubuntu 12.04 . with error fix: ummet dependencies" href="#installing postgresql 9.3.2 on ubuntu 12.04 . with error fix: ummet dependencies" style="margin-left: 0.5em;">&para;</a>

                                <DT><a name="upgrading DB to 9.3" href="#upgrading DB to 9.3"><H3 ADD_DATE="1384438805">upgrading DB to 9.3</H3></a>

                                <DL><p>

                                    <DT><A HREF="http://www.postgresql.org/message-id/514F545C.7020302@gmail.com" name="http://www.postgresql.org/message-id/514F545C.7020302@gmail.com" ADD_DATE="1384438709" 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: Problem with data migration from 9.1 to 9.2</A><a name="Re: Problem with data migration from 9.1 to 9.2" href="#Re: Problem with data migration from 9.1 to 9.2" style="margin-left: 0.5em;">&para;</a>

on Linux:

$ sudo -u postgres /usr/lib/postgresql/9.3/bin/initdb -D /var/lib/postgresql/9.3/main/ -E UTF8 --lc-collate=en_US.UTF-8

$ sudo -u postgres initdb -D /Library/PostgreSQL/9.3/data/ -E UTF8 --lc-collate=en_US.UTF-8

$ sudo chmod go-w /Library/PostgreSQL/9.3/

                                    <DT><A HREF="http://stackoverflow.com/questions/19271219/ubuntu-12-04-postgresql-9-1-cant-access-libdir-postgis-2-0" name="http://stackoverflow.com/questions/19271219/ubuntu-12-04-postgresql-9-1-cant-access-libdir-postgis-2-0" ADD_DATE="1384519712" 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;"/>Ubuntu 12.04, PostgreSQL-9.1 - Can&#39;t access $libdir/postgis-2.0 - Stack Overflow</A><a name="Ubuntu 12.04, PostgreSQL-9.1 - Can&#39;t access $libdir/postgis-2.0 - Stack Overflow" href="#Ubuntu 12.04, PostgreSQL-9.1 - Can&#39;t access $libdir/postgis-2.0 - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

on Linux:

$ sd ln -s postgis-2.1.so /usr/lib/postgresql/9.3/lib/postgis-2.0.so

                                    <DT><A HREF="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" name="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" ADD_DATE="1384429194" 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.3: pg_upgrade</A><a name="PostgreSQL: Documentation: 9.3: pg_upgrade" href="#PostgreSQL: Documentation: 9.3: pg_upgrade" style="margin-left: 0.5em;">&para;</a>

on Linux:

$ sudo service postgresql stop

$ for i in /etc/postgresql/9.1/main/*.conf*; do sudo ln -sf "$i" /var/lib/postgresql/9.1/main/; done

$ ./delete_old_cluster.sh

$ ./analyze_new_cluster.sh # runtime: 30 min ("07:10:59" - "06:40:23") for a 30 GB cluster (staging tables only)

                                </DL><p>

                                <DT><A HREF="https://groups.google.com/forum/#!msg/django-users/Bv63_job__w/b5ylXGwVW8kJ" name="https://groups.google.com/forum/#!msg/django-users/Bv63_job__w/b5ylXGwVW8kJ" ADD_DATE="1384765320" 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;"/>Psycopg2 on Mac OS X (Snow Leopard) - Google Groups</A><a name="Psycopg2 on Mac OS X (Snow Leopard) - Google Groups" href="#Psycopg2 on Mac OS X (Snow Leopard) - Google Groups" style="margin-left: 0.5em;">&para;</a>

on Mac:

'(2) Create symbolic links in /usr/lib :

sudo ln -s /Library/PostgreSQL/9.3/lib/libssl.1.0.0.dylib /usr/lib/libssl.1.0.0.dylib

sudo ln -s /Library/PostgreSQL/9.3/lib/libcrypto.1.0.0.dylib /usr/lib/libcrypto.1.0.0.dylib

'

                            </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>

-

Lack of support for NUL bytes is a critical limitation of PostgreSQL when dealing with arbitrary input data which should be stored verbatim

                            </DL><p>

                            <DT><a name="oids" href="#oids"><H3 ADD_DATE="1384057193">oids</H3></a>

                            <DL><p>

                                <DT><A HREF="http://www.postgresql.org/message-id/37C9BD7D.43F1E677@dokodiner.com" name="http://www.postgresql.org/message-id/37C9BD7D.43F1E677@dokodiner.com" ADD_DATE="1384056827" 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;"/>OID vs SERIAL</A><a name="OID vs SERIAL" href="#OID vs SERIAL" style="margin-left: 0.5em;">&para;</a>

Pros:

[...]

"

the oid value cannot be set by the user, and therefore a table with an fkey to an oid column is **not reimportable**

                                <DT><A HREF="http://www.sqlines.com/postgresql/oid" name="http://www.sqlines.com/postgresql/oid" ADD_DATE="1384057216" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>PostgreSQL - OID System Column - Table with OIDs (Identity, Autoincrement) - SQLines</A><a name="PostgreSQL - OID System Column - Table with OIDs (Identity, Autoincrement) - SQLines" href="#PostgreSQL - OID System Column - Table with OIDs (Identity, Autoincrement) - SQLines" style="margin-left: 0.5em;">&para;</a>

"Uniqueness 	Across all tables until the max value is reached" (which happens after "232-1 (4 billion)" rows)

                            </DL><p>

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

                            <DL><p>

                            </DL><p>

                            <DT><a name="recovery mode" href="#recovery mode"><H3 ADD_DATE="1386063918">recovery mode</H3></a>

                            <DL><p>

                                <DT><a name="because of Linux out-of-memory (OOM) killer" href="#because of Linux out-of-memory (OOM) killer"><H3 ADD_DATE="1386067073">because of Linux out-of-memory (OOM) killer</H3></a>

                                <DL><p>

                                    <DT><A HREF="http://stackoverflow.com/questions/16418173/psql-seems-to-timeout-with-long-queries" name="http://stackoverflow.com/questions/16418173/psql-seems-to-timeout-with-long-queries" ADD_DATE="1386064802" 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 - psql seems to timeout with long queries - Stack Overflow</A><a name="*** postgresql - psql seems to timeout with long queries - Stack Overflow" href="#*** postgresql - psql seems to timeout with long queries - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

In the latter case you will see reports of OOM killer activity in the kernel's dmesg output. I expect this is what you'll see in your case.

PostgreSQL servers should be configured without virtual memory overcommit so that the OOM killer does not run and PostgreSQL can handle out-of-memory conditions its self. See the PostgreSQL documentation on Linux memory overcommit."

                                    <DT><A HREF="http://www.postgresql.org/message-id/Pine.LNX.4.44.0305011809260.10366-100000@gord.tabbweb.com" name="http://www.postgresql.org/message-id/Pine.LNX.4.44.0305011809260.10366-100000@gord.tabbweb.com" ADD_DATE="1386063904" 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;"/>** The database system is in recovery mode</A><a name="** The database system is in recovery mode" href="#** The database system is in recovery mode" style="margin-left: 0.5em;">&para;</a>

load issue?"

"Here's the logs:

[...] NOTICE:  Message from PostgreSQL backend:

2013-12-02 23:51:14 PST LOG:  redo starts at 1DDB/54FA3B30

"

                                    <DT><A HREF="http://www.postgresql.org/message-id/17004.1052001841@sss.pgh.pa.us" name="http://www.postgresql.org/message-id/17004.1052001841@sss.pgh.pa.us" ADD_DATE="1386064233" 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: The database system is in recovery mode</A><a name="** Re: The database system is in recovery mode" href="#** Re: The database system is in recovery mode" style="margin-left: 0.5em;">&para;</a>

signal 9, not 11, when it wants to kill something" (!!!) apparently, the kernel doesn't even give the process a chance to shut down cleanly

                                    <DT><A HREF="http://www.oracle.com/technetwork/articles/servers-storage-dev/oom-killer-1911807.html" name="http://www.oracle.com/technetwork/articles/servers-storage-dev/oom-killer-1911807.html" ADD_DATE="1386067095" ICON_URI="http://www.oracle.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.oracle.com/favicon.ico" style="margin-right: 0.5em;"/>How to Configure the Linux Out of Memory Killer</A><a name="How to Configure the Linux Out of Memory Killer" href="#How to Configure the Linux Out of Memory Killer" style="margin-left: 0.5em;">&para;</a>

"We can set valid ranges for oom_adj from -16 to +15, and a setting of -17 exempts a process entirely from the OOM killer. The higher the number, the more likely our process will be selected for termination if the system encounters an OOM condition"

"The contents of /proc/2592/oom_score can also be viewed to determine how likely a process is to be killed by the OOM killer. A score of 0 is an indication that our process is exempt from the OOM killer. The higher the OOM score, the more likely a process will be killed in an OOM condition."

                                </DL><p>

                                <DT><A HREF="http://www.postgresql.org/message-id/14187.1160674973@sss.pgh.pa.us" name="http://www.postgresql.org/message-id/14187.1160674973@sss.pgh.pa.us" ADD_DATE="1386062112" 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: FATAL: the database system is in recovery mode</A><a name="Re: FATAL: the database system is in recovery mode" href="#Re: FATAL: the database system is in recovery mode" style="margin-left: 0.5em;">&para;</a>

and checkpoint_timeout, it shouldn't take an hour to recover from a

crash.  Does it appear that the startup subprocess is making progress at

all?  (Use "ps" to find the postmaster's startup process child, then see

                            <DT><a name="SHOW GRANTS FOR" href="#SHOW GRANTS FOR"><H3 ADD_DATE="1384404369">SHOW GRANTS FOR</H3></a>

                            <DL><p>

                                <DT><A HREF="http://postgresql.1045698.n5.nabble.com/quot-SHOW-GRANTS-FOR-username-quot-or-why-z-is-not-enough-for-me-td5714952.html" name="http://postgresql.1045698.n5.nabble.com/quot-SHOW-GRANTS-FOR-username-quot-or-why-z-is-not-enough-for-me-td5714952.html" ADD_DATE="1384404388" 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 - novice - &quot;SHOW GRANTS FOR username&quot; or why \z is not enough for me</A><a name="PostgreSQL - novice - &quot;SHOW GRANTS FOR username&quot; or why \z is not enough for me" href="#PostgreSQL - novice - &quot;SHOW GRANTS FOR username&quot; or why \z is not enough for me" style="margin-left: 0.5em;">&para;</a>

"

>I somehow think that there must be a more elegant solution

                            <DT><a name="TIDs" href="#TIDs"><H3 ADD_DATE="1394183336">TIDs</H3></a>

                            <DL><p>

                                <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Using-ctid-column-changes-plan-drastically-td5717711.html" name="http://postgresql.1045698.n5.nabble.com/Using-ctid-column-changes-plan-drastically-td5717711.html" ADD_DATE="1394185828" 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 - performance - Using ctid column changes plan drastically</A><a name="PostgreSQL - performance - Using ctid column changes plan drastically" href="#PostgreSQL - performance - Using ctid column changes plan drastically" style="margin-left: 0.5em;">&para;</a>

"Joins on tid columns just aren't supported very well at the moment. [...] There are gotchas if any of the rows receive concurrent updates." (Tom Lane)

"type tid doesn't have any hash support" (Tom Lane)

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/ddl-system-columns.html" name="http://www.postgresql.org/docs/9.3/static/ddl-system-columns.html" ADD_DATE="1394185064" 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.3: System Columns</A><a name="PostgreSQL: Documentation: 9.3: System Columns" href="#PostgreSQL: Documentation: 9.3: System Columns" style="margin-left: 0.5em;">&para;</a>

    The physical location of the row version within its table. Note that although the ctid can be used to locate the row version very quickly, a row's ctid will change if it is updated or moved by VACUUM FULL. Therefore ctid is useless as a long-term row identifier [unless your DB is select-optimized and rarely updated]. The OID, or even better a user-defined serial number, should be used to identify logical rows."

                                <DT><A HREF="http://www.postgresql.org/message-id/200206031717.g53HHLs03112@saturn.janwieck.net" name="http://www.postgresql.org/message-id/200206031717.g53HHLs03112@saturn.janwieck.net" ADD_DATE="1394183279" 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: tid scan - is it ever used?</A><a name="Re: tid scan - is it ever used?" href="#Re: tid scan - is it ever used?" style="margin-left: 0.5em;">&para;</a>

    Currently it is the fastest possible access to a single  row.

    So  an application that selects data and wants to update rows

    is optimized for PostgreSQL if it knows about that  fact  and

    qualifies the updates by ctid.

"

                                <DT><A HREF="http://www.postgresql.org/message-id/1031147457.3339.12.camel@taru.tm.ee" name="http://www.postgresql.org/message-id/1031147457.3339.12.camel@taru.tm.ee" ADD_DATE="1394183324" 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: What is Tid Scan</A><a name="Re: What is Tid Scan" href="#Re: What is Tid Scan" style="margin-left: 0.5em;">&para;</a>

consists of 4-byte page number and 2-byte tuple index inside page.

So if you know the TID you can directly get the corresponding tuple."

                                <DT><A HREF="http://blog.2ndquadrant.com/using_the_postgresql_system_co/" name="http://blog.2ndquadrant.com/using_the_postgresql_system_co/" ADD_DATE="1394186108" ICON_URI="http://blog.2ndquadrant.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blog.2ndquadrant.com/favicon.ico" style="margin-right: 0.5em;"/>Using the PostgreSQL System Columns | 2ndQuadrant</A><a name="Using the PostgreSQL System Columns | 2ndQuadrant" href="#Using the PostgreSQL System Columns | 2ndQuadrant" 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://dba.stackexchange.com/questions/42040/how-to-monitor-or-do-vacuum-without-stop-all" name="http://dba.stackexchange.com/questions/42040/how-to-monitor-or-do-vacuum-without-stop-all" ADD_DATE="1394172285" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico?v=a731663709aa" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico?v=a731663709aa" style="margin-right: 0.5em;"/>* postgresql - How to monitor or do vacuum without stop all? - Database Administrators Stack Exchange</A><a name="* postgresql - How to monitor or do vacuum without stop all? - Database Administrators Stack Exchange" href="#* postgresql - How to monitor or do vacuum without stop all? - Database Administrators Stack Exchange" 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" 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;"/>* VACUUM FULL - PostgreSQL wiki</A><a name="* VACUUM FULL - PostgreSQL wiki" href="#* VACUUM FULL - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>

[...]

This trick will not work in PostgreSQL versions 9.1 or later, as it detects that the change in data type is degenerate and so no rewrite is necessary." however, adding a USING clause could prevent this from being optimized away, allowing this to work in 9.1+ as well

                                <DT><A HREF="http://postgresql.1045698.n5.nabble.com/How-can-I-tell-if-I-m-autovacuuming-td2085097.html" name="http://postgresql.1045698.n5.nabble.com/How-can-I-tell-if-I-m-autovacuuming-td2085097.html" ADD_DATE="1394169885" 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 - How can I tell if I&#39;m autovacuuming?</A><a name="** PostgreSQL - admin - How can I tell if I&#39;m autovacuuming?" href="#** PostgreSQL - admin - How can I tell if I&#39;m autovacuuming?" style="margin-left: 0.5em;">&para;</a>

"> (b) How can I verify that my databases are being vacuumed by autovacuum?

in your server log, by setting log_min_messages to 'debug1' in your

postgresql.conf."

                                <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>

"Vacuuming (whether automatic or manual) stops at the oldest transaction id that is still in use." (as opposed to skipping past any active transactions to completed ones)

"postgres[13251]: [40-1] user=,db= ERROR:  canceling autovacuum task"

"I have installed a nightly cron job to force-vacuum the database. PostgreSQL has shown much improved query responses since then. Some queries’ completion times even improved by a factor of 10."

                                <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>

"In 9.0, the autovacuum process will be aborted about 1 second after

another transaction starts waiting for a lock. The result is that even a

simple INSERT will take 1 second."

this means that autovacuum will never complete if clients keep making INSERTs :(

                                <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>

                            </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://postgresql.1045698.n5.nabble.com/Determine-the-name-of-the-calling-function-td5740893.html" name="http://postgresql.1045698.n5.nabble.com/Determine-the-name-of-the-calling-function-td5740893.html" ADD_DATE="1393202325" 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 - novice - Determine the name of the calling function</A><a name="** PostgreSQL - novice - Determine the name of the calling function" href="#** PostgreSQL - novice - Determine the name of the calling function" style="margin-left: 0.5em;">&para;</a>

"the result of pg_exception_context clearly does contain the info you

want"

                            <DT><A HREF="http://rhaas.blogspot.com.au/2012/03/security-barrier-views.html" name="http://rhaas.blogspot.com.au/2012/03/security-barrier-views.html" ADD_DATE="1392395338" ICON_URI="http://rhaas.blogspot.com.au/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://rhaas.blogspot.com.au/favicon.ico" style="margin-right: 0.5em;"/>** Robert Haas: Security Barrier Views</A><a name="** Robert Haas: Security Barrier Views" href="#** Robert Haas: Security Barrier Views" 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://people.planetpostgresql.org/andrew/index.php?/archives/36-A-ragged-bee-in-the-bonnet.html" name="http://people.planetpostgresql.org/andrew/index.php?/archives/36-A-ragged-bee-in-the-bonnet.html" ADD_DATE="1383866460" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>A ragged bee in the bonnet - Andrew&#39;s PostgreSQL blog</A><a name="A ragged bee in the bonnet - Andrew&#39;s PostgreSQL blog" href="#A ragged bee in the bonnet - Andrew&#39;s PostgreSQL blog" 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>

Current value of 'shmmax' is 33554432.  

1. cat 268435456 > /proc/sys/kernel/shmmax 

2. sysctl -w kernel.shmmax=268435456

                            <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>

"5. Improvement in pg_get_viewdef() to print new line after each SELECT and FROM entry "

                            <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="https://github.com/petere/plsh" name="https://github.com/petere/plsh" ADD_DATE="1396921888" ICON_URI="https://github.global.ssl.fastly.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://github.global.ssl.fastly.net/favicon.ico" style="margin-right: 0.5em;"/>petere/plsh · GitHub</A><a name="petere/plsh · GitHub" href="#petere/plsh · GitHub" 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="https://www.google.com/search?q=postgres%20foreign%20key%20to%20a%20view" name="https://www.google.com/search?q=postgres%20foreign%20key%20to%20a%20view" ADD_DATE="1385433190" ICON_URI="https://www.google.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://www.google.com/favicon.ico" style="margin-right: 0.5em;"/>postgres foreign key to a view - Google Search</A><a name="postgres foreign key to a view - Google Search" href="#postgres foreign key to a view - Google Search" 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>

"Because testing for this would almost surely be a net loss for the vast

majority of applications.  Checking to see if the new row value exactly

update, that's a lot of overhead that you are hoping to make back by

sometimes avoiding the physical store of the new tuple."

                            <DT><A HREF="http://postgresql.1045698.n5.nabble.com/avoiding-CONTEXT-messages-td5703132.html#a5703227" name="http://postgresql.1045698.n5.nabble.com/avoiding-CONTEXT-messages-td5703132.html#a5703227" ADD_DATE="1384823914" 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 - avoiding CONTEXT messages</A><a name="PostgreSQL - general - avoiding CONTEXT messages" href="#PostgreSQL - general - avoiding CONTEXT messages" style="margin-left: 0.5em;">&para;</a>

'in psql, you do it by setting:

\set VERBOSITY terse'

                            <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>

"In psql, "\set VERBOSITY terse" might approximate what you want." (tom lane)

                            <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>

"SQL is a somewhat declarative language. There is no "order" to

evaluation as such. So you can't talk about short circuiting either.

                            <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://jonathandean.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://jonathandean.com/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/4DE4EDC5020000250003DF1B@gw.wicourts.gov" name="http://www.postgresql.org/message-id/4DE4EDC5020000250003DF1B@gw.wicourts.gov" ADD_DATE="1386065494" 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: Server crash... trying to figure it out</A><a name="Re: Server crash... trying to figure it out" href="#Re: Server crash... trying to figure it out" style="margin-left: 0.5em;">&para;</a>

shared_buffers + (user_connections [~=max_connections] * work_mem)"

                            <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>

cheaper than a probe into an index, so this type of plan makes plenty

of sense if the hashtable will fit in RAM and there are going to be a

lot of probes"

                            <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://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>

"my search queries take 5 times longer to give me results" [in UTF8 than in SQL_ASCII]

                            <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://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 - 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://stackoverflow.com/questions/4328679/how-to-configure-postgresql-so-it-accepts-loginpassword-auth" name="http://stackoverflow.com/questions/4328679/how-to-configure-postgresql-so-it-accepts-loginpassword-auth" ADD_DATE="1383034371" 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;"/>ubuntu - How to configure postgresql so it accepts login+password auth? - Stack Overflow</A><a name="ubuntu - How to configure postgresql so it accepts login+password auth? - Stack Overflow" href="#ubuntu - How to configure postgresql so it accepts login+password auth? - Stack Overflow" 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>

"Till 9.0, we have to use RULE for implementing updateable view"

                        </DL><p>

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

                        <DL><p>

                            <DT><a name="`mysql`" href="#`mysql`"><H3 ADD_DATE="1390517329">`mysql`</H3></a>

(this format is slightly different than the actual interactive format because the queries are echoed with lines before and after)

$ mysql --table --verbose --verbose <file

                            <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>

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

                                <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>

Storage Engine	Permissible Index Types

MyISAM	BTREE

InnoDB	BTREE

                                <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>

"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/view-updatability.html" name="http://dev.mysql.com/doc/refman/5.5/en/view-updatability.html" ADD_DATE="1384931059" 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.3 Updatable and Insertable Views</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 19.5.3 Updatable and Insertable Views" href="#MySQL :: MySQL 5.5 Reference Manual :: 19.5.3 Updatable and Insertable Views" style="margin-left: 0.5em;">&para;</a>

"The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts or updates to rows except those for which the WHERE clause in the select_statement is true."

this refers to views that include only a subset of rows (via WHERE), and requires rows inserted into it to be part of that subset. without this option, the WHERE clause is ignored when inserting.

                                <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>

                                <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>

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

sudo service mysql stop

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>

                                <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 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>

                            </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>

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

"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" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.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>

"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="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>

"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>

"mysql itself does not support CHECK constraints"

                                </DL><p>

                                <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>

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

</DD>

                                <DL><p>

                                </DL><p>

                            </DL><p>

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

(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>

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

[mysqld]

                            <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>

                            </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="https://www.odesk.com/blog/2009/06/postgresql-vs-mysql/" name="https://www.odesk.com/blog/2009/06/postgresql-vs-mysql/" ADD_DATE="1394189973" ICON_URI="https://www.odesk.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://www.odesk.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL vs. MySQL: A Comparison of Speed, Integrity and Popularity » oBlog</A><a name="PostgreSQL vs. MySQL: A Comparison of Speed, Integrity and Popularity » oBlog" href="#PostgreSQL vs. MySQL: A Comparison of Speed, Integrity and Popularity » oBlog" style="margin-left: 0.5em;">&para;</a>

                                <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>

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>

                            <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>

                            <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>

                            <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://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>

                            <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>