https://www.bibsonomy.org/user/jil/createBibSonomy RSS Feed for /user/jil/createBasically there are 4 steps: Rename old table Create new table with partitioning Add constraint on old table for it's proposed partition ranges Attach old table as a partition to new partition table Sounds easy right? What about indexes? What about Triggers? And guess what, there are other traps to watch out for!https://www.kylehailey.com/post/postgres-partition-conversion-minimal-downtimejil2024-08-21T22:58:31+02:00convert create pain partition pita postgres psql script set variable <span itemprop="description">Basically there are 4 steps: Rename old table Create new table with partitioning Add constraint on old table for it&#039;s proposed partition ranges Attach old table as a partition to new partition table Sounds easy right? What about indexes? What about Triggers? And guess what, there are other traps to watch out for!</span>truncate -s 10G foo fallocate -l 5G bar It needs to be stated that truncate on a file system supporting sparse files will create a sparse file and fallocate will nothttps://stackoverflow.com/questions/139261/how-to-create-a-file-with-a-given-size-in-linuxjil2022-01-06T16:42:00+01:00create dd file linux reserve space sparse <span itemprop="description">truncate -s 10G foo fallocate -l 5G bar It needs to be stated that truncate on a file system supporting sparse files will create a sparse file and fallocate will not</span>https://wiki.debian.org/SimpleBackportCreationjil2019-06-05T12:43:22+02:00backport compile create custom debian local package <a itemprop="url" data-versiondate="2019-06-05T12:43:22+02:00" href="https://wiki.debian.org/SimpleBackportCreation" rel="nofollow" class="description-link">https://wiki.debian.org/SimpleBackportCreation</a>If you really want to create an array rather than a list use either String[] names = ["lucas", "Fred", "Mary"] or def names = ["lucas", "Fred", "Mary"].toArray()https://stackoverflow.com/questions/2290002/array-of-strings-in-groovyjil2019-03-19T11:49:57+01:00array create groovy initialize list string <span itemprop="description">If you really want to create an array rather than a list use either String[] names = [&#034;lucas&#034;, &#034;Fred&#034;, &#034;Mary&#034;] or def names = [&#034;lucas&#034;, &#034;Fred&#034;, &#034;Mary&#034;].toArray()</span>Stream.of("a","b","c").collect(Collectors.toSet());https://stackoverflow.com/questions/16358796/does-asset-exist-in-any-apijil2019-03-13T19:21:31+01:00build create java set varargs <span itemprop="description">Stream.of(&#034;a&#034;,&#034;b&#034;,&#034;c&#034;).collect(Collectors.toSet());</span> Open USB block device using gdisk /dev/sdc, configure it as GPT and create Microsoft basic data partition (code 0700), then write changes and quit (Next steps will destroy partition table in your USB drive!!!). sudo gdisk /dev/sdc o > This option deletes all partitions and creates a new protective MBR. > Proceed? (Y/N): y n > Partition number ... > hit Enter > First sector ... : > hit Enter > Last sector ... : > hit Enter > Current type is 'Linux filesystem' > Hex code or GUID (L to show codes, Enter = 8300): 0700 p > Should print something like: > Disk /dev/sdc: 15646720 sectors, 7.5 GiB > Model: DataTraveler 160 > Sector size (logical/physical): 512/512 bytes > Disk identifier (GUID): ... > Partition table holds up to 128 entries > Main partition table begins at sector 2 and ends at sector 33 > First usable sector is 34, last usable sector is 15646686 > Partitions will be aligned on 2048-sector boundaries > Total free space is 2014 sectors (1007.0 KiB) > Number Start (sector) End (sector) Size Code Name > 1 2048 15646686 7.5 GiB 0700 Microsoft basic data w > Final checks complete. About to write GPT data. THIS WILL OVERWRITE EXISTING PARTITIONS!! > Do you want to proceed? (Y/N): y q Format new partition as NTFS: sudo mkfs.ntfs /dev/sdc1 Mount new USB partition to temporary directory in your home: mkdir ~/tmp-win10-usb-drive sudo mount /dev/sdc1 ~/tmp-win10-usb-drive Download Windows installation ISO, create new temporary directory in your home and mount it there: mkdir ~/tmp-win10-iso-mnt sudo mount Win10_1809Oct_English_x64.iso ~/tmp-win10-iso-mnt Copy all files from mounted ISO to USB drive (you can use rsync to see progress): sudo cp -rT ~/tmp-win10-iso-mnt/ ~/tmp-win10-usb-drive/` Unmount Windows ISO and USB drive and remove temporary directories: sudo umount ~/tmp-win10-iso-mnt/ ~/tmp-win10-usb-drive/ rmdir ~/tmp-win10-iso-mnt/ ~/tmp-win10-usb-drive/ Insert USB drive to new computer and boot from it.https://superuser.com/questions/1017756/create-a-bootable-windows-10-usb-drive-uefi-from-linuxjil2019-03-08T09:44:52+01:00boot build create efi installer linux ntfs stick usb windows <span itemprop="description"> Open USB block device using gdisk /dev/sdc, configure it as GPT and create Microsoft basic data partition (code 0700), then write changes and quit (Next steps will destroy partition table in your USB drive!!!). sudo gdisk /dev/sdc o &gt; This option deletes all partitions and creates a new protective MBR. &gt; Proceed? (Y/N): y n &gt; Partition number ... &gt; hit Enter &gt; First sector ... : &gt; hit Enter &gt; Last sector ... : &gt; hit Enter &gt; Current type is &#039;Linux filesystem&#039; &gt; Hex code or GUID (L to show codes, Enter = 8300): 0700 p &gt; Should print something like: &gt; Disk /dev/sdc: 15646720 sectors, 7.5 GiB &gt; Model: DataTraveler 160 &gt; Sector size (logical/physical): 512/512 bytes &gt; Disk identifier (GUID): ... &gt; Partition table holds up to 128 entries &gt; Main partition table begins at sector 2 and ends at sector 33 &gt; First usable sector is 34, last usable sector is 15646686 &gt; Partitions will be aligned on 2048-sector boundaries &gt; Total free space is 2014 sectors (1007.0 KiB) &gt; Number Start (sector) End (sector) Size Code Name &gt; 1 2048 15646686 7.5 GiB 0700 Microsoft basic data w &gt; Final checks complete. About to write GPT data. THIS WILL OVERWRITE EXISTING PARTITIONS!! &gt; Do you want to proceed? (Y/N): y q Format new partition as NTFS: sudo mkfs.ntfs /dev/sdc1 Mount new USB partition to temporary directory in your home: mkdir ~/tmp-win10-usb-drive sudo mount /dev/sdc1 ~/tmp-win10-usb-drive Download Windows installation ISO, create new temporary directory in your home and mount it there: mkdir ~/tmp-win10-iso-mnt sudo mount Win10_1809Oct_English_x64.iso ~/tmp-win10-iso-mnt Copy all files from mounted ISO to USB drive (you can use rsync to see progress): sudo cp -rT ~/tmp-win10-iso-mnt/ ~/tmp-win10-usb-drive/` Unmount Windows ISO and USB drive and remove temporary directories: sudo umount ~/tmp-win10-iso-mnt/ ~/tmp-win10-usb-drive/ rmdir ~/tmp-win10-iso-mnt/ ~/tmp-win10-usb-drive/ Insert USB drive to new computer and boot from it.</span>git format-patch master --stdout > fix_empty_poster.patch git am --signoff < fix_empty_poster.patchhttps://www.devroom.io/2009/10/26/how-to-create-and-apply-a-patch-with-git/jil2019-01-15T17:17:39+01:00apply create export git import patch <span itemprop="description">git format-patch master --stdout &gt; fix_empty_poster.patch git am --signoff &lt; fix_empty_poster.patch</span>https://www.postgresql.org/docs/9.6/routine-reindex.htmljil2018-12-17T14:34:04+01:00create index lock postgres psql rebuild recreate reindex update <a itemprop="url" data-versiondate="2018-12-17T14:34:04+01:00" href="https://www.postgresql.org/docs/9.6/routine-reindex.html" rel="nofollow" class="description-link">https://www.postgresql.org/docs/9.6/routine-reindex.html</a>If you use bash, this command should work. mv a $'b\nc'https://unix.stackexchange.com/questions/212688/add-a-newline-into-a-filename-with-mvjil2018-04-26T18:14:06+02:00bash create filename in newline shell with <span itemprop="description">If you use bash, this command should work. mv a $&#039;b\nc&#039;</span>From the community documentation: hibernate.hbm2ddl.auto Automatically validates or exports schema DDL to the database when the SessionFactory is created. With create-drop, the database schema will be dropped when the SessionFactory is closed explicitly. e.g. validate | update | create | create-drop So the list of possible options are, validate: validate the schema, makes no changes to the database. update: update the schema. create: creates the schema, destroying previous data. create-drop: drop the schema at the end of the session.http://stackoverflow.com/questions/438146/hibernate-hbm2ddl-auto-possible-values-and-what-they-dojil2016-03-04T13:53:49+01:00config create ddl hbm2ddl hibernate parameter schema values <span itemprop="description">From the community documentation: hibernate.hbm2ddl.auto Automatically validates or exports schema DDL to the database when the SessionFactory is created. With create-drop, the database schema will be dropped when the SessionFactory is closed explicitly. e.g. validate | update | create | create-drop So the list of possible options are, validate: validate the schema, makes no changes to the database. update: update the schema. create: creates the schema, destroying previous data. create-drop: drop the schema at the end of the session.</span>http://postgresql-buch.de/beispiele:kapitelanhangjil2009-12-06T22:13:09+01:008.2 8.3 buch cast conversion create double function implicit postgresql precision typ type <a itemprop="url" data-versiondate="2009-12-06T22:13:09+01:00" href="http://postgresql-buch.de/beispiele:kapitelanhang" rel="nofollow" class="description-link">http://postgresql-buch.de/beispiele:kapitelanhang</a>CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS 'SELECT textin(int4out($1));'; CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT; http://www.mediawiki.org/wiki/Manual:Upgrading_Postgresjil2009-12-06T21:34:16+01:008.3 cast compatibility create function postgresql sql text <span itemprop="description">CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE LANGUAGE SQL AS &#039;SELECT textin(int4out($1));&#039;; CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) AS IMPLICIT; </span>http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.htmljil2007-11-24T02:43:39+01:00case case-sensitive collate create doc dokumentation manual mysql query sensitive <a itemprop="url" data-versiondate="2007-11-24T02:43:39+01:00" href="http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html" rel="nofollow" class="description-link">http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html</a>