Revision 9372
Added by Aaron Marcuse-Kubitza over 11 years ago
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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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't create table (errno: 121) - Stack Overflow</A><a name="mysql - ERROR: Error 1005: Can't create table (errno: 121) - Stack Overflow" href="#mysql - ERROR: Error 1005: Can't create table (errno: 121) - Stack Overflow" style="margin-left: 0.5em;">¶</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;">¶</a> |
|
737 |
<DD>- |
|
738 |
arguments for MySQL: |
|
739 |
|
|
740 |
better UI (phpMyAdmin): |
|
741 |
"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?) |
|
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;">¶</a> |
... | ... | |
739 | 762 |
|
740 | 763 |
"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." |
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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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't create table (errno: 121) - Stack Overflow</A><a name="mysql - ERROR: Error 1005: Can't create table (errno: 121) - Stack Overflow" href="#mysql - ERROR: Error 1005: Can't create table (errno: 121) - Stack Overflow" style="margin-left: 0.5em;">¶</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;">¶</a> |
759 | 768 |
<DD>"we use varchar(32) for primary keys (GUIDs) and we haven'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." |
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;">¶</a> |
|
764 |
<DD>- |
|
765 |
arguments for MySQL: |
|
766 |
|
|
767 |
better UI (phpMyAdmin): |
|
768 |
"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?) |
|
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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</a> |
|
807 |
<DD>page's description: A customer box that's never used more than a few gigs of space suddenly ran out of disk space so bad the captive portal page wouldn'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;">¶</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;">¶</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;">¶</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;">¶</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 "UTF8": 0x00 - Grokbase</A><a name="invalid byte sequence for encoding "UTF8": 0x00 - Grokbase" href="#invalid byte sequence for encoding "UTF8": 0x00 - Grokbase" style="margin-left: 0.5em;">¶</a> |
|
878 |
<DD>page's description: (6 replies) Hi, I've got another problem. I sometimes get the following SQLException when doing an insert: ERROR: invalid byte sequence for encoding "UTF8": 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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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 "UTF8": 0x00 - Grokbase</A><a name="invalid byte sequence for encoding "UTF8": 0x00 - Grokbase" href="#invalid byte sequence for encoding "UTF8": 0x00 - Grokbase" style="margin-left: 0.5em;">¶</a> |
|
880 |
<DD>page's description: (6 replies) Hi, I've got another problem. I sometimes get the following SQLException when doing an insert: ERROR: invalid byte sequence for encoding "UTF8": 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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</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;">¶</a> |
|
895 |
<DD>page's description: A customer box that's never used more than a few gigs of space suddenly ran out of disk space so bad the captive portal page wouldn'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;">¶</a> |
Also available in: Unified diff
web/links/index.htm: updated to Firefox bookmarks. sorted MySQL and PostgreSQL sections.