Project

General

Profile

« Previous | Next » 

Revision 9372

web/links/index.htm: updated to Firefox bookmarks. sorted MySQL and PostgreSQL sections.

View differences:

index.htm
717 717
                            <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>
718 718
                            <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>
719 719
                        </DL><p>
720
                        <DT><a name="MySQL Workbench" href="#MySQL Workbench"><H3 ADD_DATE="1366740023">MySQL Workbench</H3></a>
721
                        <DL><p>
722
                            <DT><a name="exporting indexes separately" href="#exporting indexes separately"><H3 ADD_DATE="1367759236">exporting indexes separately</H3></a>
723
<DD>this happens in /mysql-workbench-gpl-5.2.47-src/modules/db.mysql/src/module_db_mysql.cpp . it does *not* use mysqldump, unfortunately.
724
</DD>
725
                            <DL><p>
726
                            </DL><p>
727
                            <DT><A HREF="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" name="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" ADD_DATE="1366739722" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQL :: Download MySQL Workbench</A><a name="MySQL :: Download MySQL Workbench" href="#MySQL :: Download MySQL Workbench" style="margin-left: 0.5em;">&para;</a>
728
                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=40167" name="http://bugs.mysql.com/bug.php?id=40167" ADD_DATE="1365122620" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #40167: no method to show hidden relationships again</A><a name="MySQL Bugs: #40167: no method to show hidden relationships again" href="#MySQL Bugs: #40167: no method to show hidden relationships again" style="margin-left: 0.5em;">&para;</a>
729
                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=46626" name="http://bugs.mysql.com/bug.php?id=46626" ADD_DATE="1365497065" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench</A><a name="MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" href="#MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" style="margin-left: 0.5em;">&para;</a>
730
                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=67322" name="http://bugs.mysql.com/bug.php?id=67322" ADD_DATE="1366740010" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10</A><a name="MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" href="#MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" style="margin-left: 0.5em;">&para;</a>
731
                            <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>
732
                            <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>
733
                        </DL><p>
734
                        <DT><a name="vs. other SQL DBs" href="#vs. other SQL DBs"><H3 ADD_DATE="1366900069">vs. other SQL DBs</H3></a>
735
                        <DL><p>
736
                            <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>
737
<DD>-
738
arguments for MySQL:
739

  
740
better UI (phpMyAdmin):
741
&quot;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*&quot; (may be referring to lack of sufficiently-good phpMyAdmin equivalents for other DBs?)
742
                        </DL><p>
720 743
                        <DT><a name="dynamic SQL" href="#dynamic SQL"><H3 ADD_DATE="1366898821">dynamic SQL</H3></a>
721 744
                        <DL><p>
722 745
                            <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>
......
739 762

  
740 763
&quot;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.&quot;
741 764
                        </DL><p>
742
                        <DT><a name="MySQL Workbench" href="#MySQL Workbench"><H3 ADD_DATE="1366740023">MySQL Workbench</H3></a>
743
                        <DL><p>
744
                            <DT><a name="exporting indexes separately" href="#exporting indexes separately"><H3 ADD_DATE="1367759236">exporting indexes separately</H3></a>
745
<DD>this happens in /mysql-workbench-gpl-5.2.47-src/modules/db.mysql/src/module_db_mysql.cpp . it does *not* use mysqldump, unfortunately.
746
</DD>
747
                            <DL><p>
748
                            </DL><p>
749
                            <DT><A HREF="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" name="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" ADD_DATE="1366739722" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQL :: Download MySQL Workbench</A><a name="MySQL :: Download MySQL Workbench" href="#MySQL :: Download MySQL Workbench" style="margin-left: 0.5em;">&para;</a>
750
                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=40167" name="http://bugs.mysql.com/bug.php?id=40167" ADD_DATE="1365122620" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #40167: no method to show hidden relationships again</A><a name="MySQL Bugs: #40167: no method to show hidden relationships again" href="#MySQL Bugs: #40167: no method to show hidden relationships again" style="margin-left: 0.5em;">&para;</a>
751
                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=46626" name="http://bugs.mysql.com/bug.php?id=46626" ADD_DATE="1365497065" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench</A><a name="MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" href="#MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" style="margin-left: 0.5em;">&para;</a>
752
                            <DT><A HREF="http://bugs.mysql.com/bug.php?id=67322" name="http://bugs.mysql.com/bug.php?id=67322" ADD_DATE="1366740010" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10</A><a name="MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" href="#MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" style="margin-left: 0.5em;">&para;</a>
753
                            <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>
754
                            <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>
755
                        </DL><p>
756 765
                        <DT><a name="string primary keys" href="#string primary keys"><H3 ADD_DATE="1366864765">string primary keys</H3></a>
757 766
                        <DL><p>
758 767
                            <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>
759 768
<DD>&quot;we use varchar(32) for primary keys (GUIDs) and we haven&#39;t met performance issues of this. Our product is a web site with extreme overload and is critical to be stable. We use SQL Server 2005.&quot;
760 769
                        </DL><p>
761
                        <DT><a name="vs. other SQL DBs" href="#vs. other SQL DBs"><H3 ADD_DATE="1366900069">vs. other SQL DBs</H3></a>
762
                        <DL><p>
763
                            <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>
764
<DD>-
765
arguments for MySQL:
766

  
767
better UI (phpMyAdmin):
768
&quot;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*&quot; (may be referring to lack of sufficiently-good phpMyAdmin equivalents for other DBs?)
769
                        </DL><p>
770 770
                        <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>
771 771
<DD>page's description: a blog by ariejan de vroom about software engineering and craftsmanship.
772 772
                        <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>
......
795 795
                    </DL><p>
796 796
                    <DT><a name="PostgreSQL" href="#PostgreSQL"><H3 ADD_DATE="1333386475">PostgreSQL</H3></a>
797 797
                    <DL><p>
798
                        <DT><a name="disk space" href="#disk space"><H3 ADD_DATE="1340661986">disk space</H3></a>
799
                        <DL><p>
800
                            <DT><A HREF="http://dba.stackexchange.com/questions/3491/postgresql-disk-space-not-released-after-truncate" name="http://dba.stackexchange.com/questions/3491/postgresql-disk-space-not-released-after-truncate" ADD_DATE="1340661221" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Disk space not released after TRUNCATE - Database Administrators</A><a name="PostgreSQL: Disk space not released after TRUNCATE - Database Administrators" href="#PostgreSQL: Disk space not released after TRUNCATE - Database Administrators" style="margin-left: 0.5em;">&para;</a>
801
                            <DT><A HREF="https://issues.apache.org/jira/browse/JENA-28" name="https://issues.apache.org/jira/browse/JENA-28" ADD_DATE="1340661975" ICON_URI="https://issues.apache.org/jira/s/en_UKd9dgiy/731/4/_/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://issues.apache.org/jira/s/en_UKd9dgiy/731/4/_/favicon.ico" style="margin-right: 0.5em;"/>[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA</A><a name="[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA" href="#[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA" style="margin-left: 0.5em;">&para;</a>
802
                            <DT><A HREF="http://wiki.postgresql.org/wiki/VACUUM_FULL" name="http://wiki.postgresql.org/wiki/VACUUM_FULL" ADD_DATE="1340665068" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>VACUUM FULL - PostgreSQL wiki</A><a name="VACUUM FULL - PostgreSQL wiki" href="#VACUUM FULL - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>
803
                            <DT><A HREF="http://www.postgresql.org/docs/8.3/static/sql-cluster.html" name="http://www.postgresql.org/docs/8.3/static/sql-cluster.html" ADD_DATE="1340665221" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: CLUSTER</A><a name="PostgreSQL: Documentation: 8.3: CLUSTER" href="#PostgreSQL: Documentation: 8.3: CLUSTER" style="margin-left: 0.5em;">&para;</a>
804
                            <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>
805
                            <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>
806
                            <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>
807
<DD>page's description: A customer box that&#39;s never used more than a few gigs of space suddenly ran out of disk space so bad the captive portal page wouldn&#39;t load properly.
808
                        </DL><p>
809 798
                        <DT><a name="doc" href="#doc"><H3 ADD_DATE="1366152313">doc</H3></a>
810 799
                        <DL><p>
811 800
                            <DT><A HREF="http://www.postgresql.org/docs/8.3/static/functions-array.html" name="http://www.postgresql.org/docs/8.3/static/functions-array.html" ADD_DATE="1345012706" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: Array Functions and Operators</A><a name="PostgreSQL: Documentation: 8.3: Array Functions and Operators" href="#PostgreSQL: Documentation: 8.3: Array Functions and Operators" style="margin-left: 0.5em;">&para;</a>
......
871 860
                            <DT><A HREF="http://www.postgresql.org/docs/8.1/static/manage-ag-templatedbs.html" name="http://www.postgresql.org/docs/8.1/static/manage-ag-templatedbs.html" ADD_DATE="1335056156" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: Template Databases</A><a name="PostgreSQL: Documentation: Manuals: Template Databases" href="#PostgreSQL: Documentation: Manuals: Template Databases" style="margin-left: 0.5em;">&para;</a>
872 861
                            <DT><A HREF="http://www.postgresql.org/docs/current/static/queries-with.html" name="http://www.postgresql.org/docs/current/static/queries-with.html" ADD_DATE="1332635517" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: WITH Queries (Common Table Expressions)</A><a name="PostgreSQL: Documentation: Manuals: WITH Queries (Common Table Expressions)" href="#PostgreSQL: Documentation: Manuals: WITH Queries (Common Table Expressions)" style="margin-left: 0.5em;">&para;</a>
873 862
                        </DL><p>
874
                        <DT><a name="invalid byte sequence errors" href="#invalid byte sequence errors"><H3 ADD_DATE="1366909936">invalid byte sequence errors</H3></a>
863
                        <DT><a name="from/to MySQL" href="#from/to MySQL"><H3 ADD_DATE="1360831701">from/to MySQL</H3></a>
875 864
                        <DL><p>
876
                            <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>
877
                            <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>
878
<DD>page's description: (6 replies) Hi, I&#39;ve got another problem. I sometimes get the following SQLException when doing an insert: ERROR: invalid byte sequence for encoding &quot;UTF8&quot;: 0x00 Exception: org.postgresql.util.PSQLException org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
879
                            <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>
880
<DD>page's description: Making TEXT NUL-transparent. Occasionally, we get bitten by embedded NUL bytes in TEXT values. We take care of generating proper UTF-8, but this additional restriction sometimes slips by. It would...
881
-
882
Lack of support for NUL bytes is a critical limitation of PostgreSQL when dealing with arbitrary input data which should be stored verbatim
883
                        </DL><p>
884
                        <DT><a name="MySQL" href="#MySQL"><H3 ADD_DATE="1360831701">MySQL</H3></a>
885
                        <DL><p>
886 865
                            <DT><A HREF="http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL" name="http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL" ADD_DATE="1360831667" ICON_URI="http://wiki.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://wiki.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Converting from other Databases to PostgreSQL - PostgreSQL wiki</A><a name="Converting from other Databases to PostgreSQL - PostgreSQL wiki" href="#Converting from other Databases to PostgreSQL - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>
887 866
                            <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>
888 867
                            <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>
......
894 873
                            <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>
895 874
                            <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>
896 875
                        </DL><p>
876
                        <DT><a name="invalid byte sequence errors" href="#invalid byte sequence errors"><H3 ADD_DATE="1366909936">invalid byte sequence errors</H3></a>
877
                        <DL><p>
878
                            <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>
879
                            <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>
880
<DD>page's description: (6 replies) Hi, I&#39;ve got another problem. I sometimes get the following SQLException when doing an insert: ERROR: invalid byte sequence for encoding &quot;UTF8&quot;: 0x00 Exception: org.postgresql.util.PSQLException org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
881
                            <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>
882
<DD>page's description: Making TEXT NUL-transparent. Occasionally, we get bitten by embedded NUL bytes in TEXT values. We take care of generating proper UTF-8, but this additional restriction sometimes slips by. It would...
883
-
884
Lack of support for NUL bytes is a critical limitation of PostgreSQL when dealing with arbitrary input data which should be stored verbatim
885
                        </DL><p>
886
                        <DT><a name="disk space" href="#disk space"><H3 ADD_DATE="1340661986">disk space</H3></a>
887
                        <DL><p>
888
                            <DT><A HREF="http://dba.stackexchange.com/questions/3491/postgresql-disk-space-not-released-after-truncate" name="http://dba.stackexchange.com/questions/3491/postgresql-disk-space-not-released-after-truncate" ADD_DATE="1340661221" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Disk space not released after TRUNCATE - Database Administrators</A><a name="PostgreSQL: Disk space not released after TRUNCATE - Database Administrators" href="#PostgreSQL: Disk space not released after TRUNCATE - Database Administrators" style="margin-left: 0.5em;">&para;</a>
889
                            <DT><A HREF="https://issues.apache.org/jira/browse/JENA-28" name="https://issues.apache.org/jira/browse/JENA-28" ADD_DATE="1340661975" ICON_URI="https://issues.apache.org/jira/s/en_UKd9dgiy/731/4/_/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://issues.apache.org/jira/s/en_UKd9dgiy/731/4/_/favicon.ico" style="margin-right: 0.5em;"/>[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA</A><a name="[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA" href="#[#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA" style="margin-left: 0.5em;">&para;</a>
890
                            <DT><A HREF="http://wiki.postgresql.org/wiki/VACUUM_FULL" name="http://wiki.postgresql.org/wiki/VACUUM_FULL" ADD_DATE="1340665068" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>VACUUM FULL - PostgreSQL wiki</A><a name="VACUUM FULL - PostgreSQL wiki" href="#VACUUM FULL - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>
891
                            <DT><A HREF="http://www.postgresql.org/docs/8.3/static/sql-cluster.html" name="http://www.postgresql.org/docs/8.3/static/sql-cluster.html" ADD_DATE="1340665221" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 8.3: CLUSTER</A><a name="PostgreSQL: Documentation: 8.3: CLUSTER" href="#PostgreSQL: Documentation: 8.3: CLUSTER" style="margin-left: 0.5em;">&para;</a>
892
                            <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>
893
                            <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>
894
                            <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>
895
<DD>page's description: A customer box that&#39;s never used more than a few gigs of space suddenly ran out of disk space so bad the captive portal page wouldn&#39;t load properly.
896
                        </DL><p>
897 897
                        <DT><a name="PostGIS" href="#PostGIS"><H3 ADD_DATE="1347912102">PostGIS</H3></a>
898 898
                        <DL><p>
899 899
                            <DT><A HREF="http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/" name="http://www.paolocorti.net/2008/01/30/installing-postgis-on-ubuntu/" ADD_DATE="1347909585" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Installing PostGIS on Ubuntu</A><a name="Installing PostGIS on Ubuntu" href="#Installing PostGIS on Ubuntu" style="margin-left: 0.5em;">&para;</a>

Also available in: Unified diff