codekingpro/portable-devtools
114k
1��=u �sphinx.addnodes��document���)��}�(� rawsource�� ��children�]�(�docutils.nodes��target���)��}�(h�.. _sequence_dialog:�h]��2attributes�}�(�ids�]��classes�]��names�]��dupnames�]��backrefs�]��refid��sequence-dialog�u�tagname�h3�line�K�parent�h� _document�h�source��jD:\a\pgadmin-packaging-foundation\pgadmin-packaging-foundation\pgadmin4-8.6\docs\en_US\sequence_dialog.rst�ubh �section���)��}�(hhh]�(h �title���)��}�(h�`Sequence Dialog`:index:�h]�(h �index���)��}�(hhh]�h}�(h]�h]�h]�h]�h]��entries�]�(�single��Sequence Dialog��index-0�hNt�auhh/h"h#hKh h+ubh)��}�(hhh]�h}�(h]�h>ah]�h]�h]�h]�uhh4h h+ubh �Text����Sequence Dialog�����}�(h h+h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhh)h h&h!hh"h#hKubh � paragraph���)��}�(h��Use the *Sequence* dialog to create a sequence. A sequence generates unique5values in a sequential order (not necessarily contiguous).�h]�(hJ�Use the �����}�(h hWh!hh"NhNubh �emphasis���)��}�(h�6*Sequence*�h]�hJ�Sequence�����}�(h hah!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hWubhJ�u dialog to create a sequence. A sequence generates unique7values in a sequential order (not necessarily contiguous).�����}�(h hWh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubhV)��}�(h��The *Sequence* dialog organizes the development of a sequence through the8following dialog tabs: *General*, *Definition*, and *Security*. The *SQL* tab9displays the SQL code generated by dialog selections.�h]�(hJ�The �����}�(h hyh!hh"NhNubh`)��}�(h�10*Sequence*�h]�hJ�Sequence�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�S dialog organizes the development of a sequence through the11following dialog tabs: �����}�(h hyh!hh"NhNubh`)��}�(h� *General*�h]�hJ�General�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, �����}�(h hyh!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�12Definition�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�, and �����}�(h hyh!hh"NhNubh`)��}�(h�13*Security*�h]�hJ�Security�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�. The �����}�(h hyh!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h hyubhJ�: tab14displays the SQL code generated by dialog selections.�����}�(h hyh!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK15h h&h!hubh �image���)��}�(h�`.. image:: images/sequence_general.png16 :alt: Sequence dialog general tab17 :align: center18�h]�h}�(h]�h]�h]�h]�h]��alt��Sequence dialog general tab��align��center��uri��images/sequence_general.png��19candidates�}��*�h�suhh�h"h#hKh h&h!hubhV)��}�(h�;Use the fields in the *General* tab to identify a sequence:�h]�(hJ�Use the fields in the �����}�(h h�h!hh"NhNubh`)��}�(h� *General*�h]�hJ�General�����}�(h h�h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h h�ubhJ� tab to identify a sequence:�����}�(h h�h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh �bullet_list���)��}�(hhh]�(h � list_item���)��}�(h��Use the *Name* field to add a descriptive name for the sequence. The name will20be displayed in the *pgAdmin* tree control. The sequence name must be21distinct from the name of any other sequence, table, index, view, or foreign22table in the same schema.�h]�hV)��}�(h��Use the *Name* field to add a descriptive name for the sequence. The name will23be displayed in the *pgAdmin* tree control. The sequence name must be24distinct from the name of any other sequence, table, index, view, or foreign25table in the same schema.�h]�(hJ�Use the �����}�(h j! h!hh"NhNubh`)��}�(h�*Name*�h]�hJ�Name�����}�(h j) h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j! ubhJ�U field to add a descriptive name for the sequence. The name will26be displayed in the �����}�(h j! h!hh"NhNubh`)��}�(h� *pgAdmin*�h]�hJ�pgAdmin�����}�(h j; h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j! ubhJ�� tree control. The sequence name must be27distinct from the name of any other sequence, table, index, view, or foreign28table in the same schema.�����}�(h j! h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKh j h!hubj )��}�(h�dUse the drop-down listbox next to *Owner* to select the name of the role that29will own the sequence.�h]�hV)��}�(h�dUse the drop-down listbox next to *Owner* to select the name of the role that30will own the sequence.�h]�(hJ�"Use the drop-down listbox next to �����}�(h j] h!hh"NhNubh`)��}�(h�*Owner*�h]�hJ�Owner�����}�(h je h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j] ubhJ�; to select the name of the role that31will own the sequence.�����}�(h j] h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh jY ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKh j h!hubj )��}�(h�bUse the drop-down listbox next to *Schema* to select the schema in which the32sequence will reside.�h]�hV)��}�(h�bUse the drop-down listbox next to *Schema* to select the schema in which the33sequence will reside.�h]�(hJ�"Use the drop-down listbox next to �����}�(h j� h!hh"NhNubh`)��}�(h�*Schema*�h]�hJ�Schema�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�8 to select the schema in which the34sequence will reside.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKh j h!hubj )��}�(h�7Store notes about the sequence in the *Comment* field.35�h]�hV)��}�(h�6Store notes about the sequence in the *Comment* field.�h]�(hJ�&Store notes about the sequence in the �����}�(h j� h!hh"NhNubh`)��}�(h� *Comment*�h]�hJ�Comment�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� field.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKh j h!hubeh}�(h]�h]�h]�h]�h]��bullet�h�uhj h"h#hKh h&h!hubhV)��}�(h�'Click the *Definition* tab to continue.�h]�(hJ�36Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�37Definition�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� tab to continue.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKh h&h!hubh�)��}�(h�f.. image:: images/sequence_definition.png38 :alt: Sequence dialog definition tab39 :align: center40�h]�h}�(h]�h]�h]�h]�h]��alt��Sequence dialog definition tab��align��center��uri��images/sequence_definition.png�h�}�h�j
suhh�h"h#hK h h&h!hubhV)��}�(h�>Use the fields in the *Definition* tab to define the sequence:�h]�(hJ�Use the fields in the �����}�(h j h!hh"NhNubh`)��}�(h�*Definition*�h]�hJ�41Definition�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ� tab to define the sequence:�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK$h h&h!hubj )��}�(hhh]�(j )��}�(h�nUse the *Increment* field to specify which value is added to the current42sequence value to create a new value.�h]�hV)��}�(h�nUse the *Increment* field to specify which value is added to the current43sequence value to create a new value.�h]�(hJ�Use the �����}�(h j6 h!hh"NhNubh`)��}�(h�*Increment*�h]�hJ� Increment�����}�(h j> h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j6 ubhJ�[ field to specify which value is added to the current44sequence value to create a new value.�����}�(h j6 h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK&h j2 ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK&h j/ h!hubj )��}�(h��Provide a value in the *Start* field to specify the beginning value of the45sequence. The default starting value is MINVALUE for ascending sequences and46MAXVALUE for descending ones.�h]�hV)��}�(h��Provide a value in the *Start* field to specify the beginning value of the47sequence. The default starting value is MINVALUE for ascending sequences and48MAXVALUE for descending ones.�h]�(hJ�Provide a value in the �����}�(h j` h!hh"NhNubh`)��}�(h�*Start*�h]�hJ�Start�����}�(h jh h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j` ubhJ�� field to specify the beginning value of the49sequence. The default starting value is MINVALUE for ascending sequences and50MAXVALUE for descending ones.�����}�(h j` h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK(h j\ ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK(h j/ h!hubj )��}�(hX Provide a value in the *Minimum* field to specify the minimum value a sequence51can generate. If this clause is not supplied or NO MINVALUE is specified,52then defaults will be used. The defaults are 1 and -263-1 for ascending and53descending sequences, respectively.�h]�hV)��}�(hX Provide a value in the *Minimum* field to specify the minimum value a sequence54can generate. If this clause is not supplied or NO MINVALUE is specified,55then defaults will be used. The defaults are 1 and -263-1 for ascending and56descending sequences, respectively.�h]�(hJ�Provide a value in the �����}�(h j� h!hh"NhNubh`)��}�(h� *Minimum*�h]�hJ�Minimum�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� field to specify the minimum value a sequence57can generate. If this clause is not supplied or NO MINVALUE is specified,58then defaults will be used. The defaults are 1 and -263-1 for ascending and59descending sequences, respectively.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK+h j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK+h j/ h!hubj )��}�(hX Provide a value in the *Maximum* field to specify the maximum value for the60sequence. If this clause is not supplied or NO MAXVALUE is specified, then61default values will be used. The defaults are 263-1 and -1 for ascending and62descending sequences, respectively.�h]�hV)��}�(hX Provide a value in the *Maximum* field to specify the maximum value for the63sequence. If this clause is not supplied or NO MAXVALUE is specified, then64default values will be used. The defaults are 263-1 and -1 for ascending and65descending sequences, respectively.�h]�(hJ�Provide a value in the �����}�(h j� h!hh"NhNubh`)��}�(h� *Maximum*�h]�hJ�Maximum�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� field to specify the maximum value for the66sequence. If this clause is not supplied or NO MAXVALUE is specified, then67default values will be used. The defaults are 263-1 and -1 for ascending and68descending sequences, respectively.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK/h j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK/h j/ h!hubj )��}�(h��Provide a value in the *Cache* field to specify how many sequence numbers are69to be preallocated and stored in memory for faster access. The minimum value70is 1 (only one value can be generated at a time, i.e., no cache), and this is71also the default.�h]�hV)��}�(h��Provide a value in the *Cache* field to specify how many sequence numbers are72to be preallocated and stored in memory for faster access. The minimum value73is 1 (only one value can be generated at a time, i.e., no cache), and this is74also the default.�h]�(hJ�Provide a value in the �����}�(h j� h!hh"NhNubh`)��}�(h�*Cache*�h]�hJ�Cache�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� field to specify how many sequence numbers are75to be preallocated and stored in memory for faster access. The minimum value76is 1 (only one value can be generated at a time, i.e., no cache), and this is77also the default.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK3h j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK3h j/ h!hubj )��}�(hXB Move the switch next to *Cycled* towards the *right position* to allow the sequence to wrap78around when the MAXVALUE or the MINVALUE has been reached by an ascending or79descending sequence respectively. If the limit is reached, the next number80generated will be the MINVALUE or MAXVALUE, respectively. The default is *No*.�h]�hV)��}�(hXB Move the switch next to *Cycled* towards the *right position* to allow the sequence to wrap81around when the MAXVALUE or the MINVALUE has been reached by an ascending or82descending sequence respectively. If the limit is reached, the next number83generated will be the MINVALUE or MAXVALUE, respectively. The default is *No*.�h]�(hJ�Move the switch next to �����}�(h j h!hh"NhNubh`)��}�(h�*Cycled*�h]�hJ�Cycled�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�
towards the �����}�(h j h!hh"NhNubh`)��}�(h�*right position*�h]�hJ�right position�����}�(h j" h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJX to allow the sequence to wrap84around when the MAXVALUE or the MINVALUE has been reached by an ascending or85descending sequence respectively. If the limit is reached, the next number86generated will be the MINVALUE or MAXVALUE, respectively. The default is �����}�(h j h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h j4 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK7h j ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK7h j/ h!hubj )��}�(h��Move the switch next to *Unlogged?* towards the *right position* to make the sequence Unlogged.87The default is *No*. This option is available only on PostgreSQL 15 and above.�h]�hV)��}�(h��Move the switch next to *Unlogged?* towards the *right position* to make the sequence Unlogged.88The default is *No*. This option is available only on PostgreSQL 15 and above.�h]�(hJ�Move the switch next to �����}�(h jV h!hh"NhNubh`)��}�(h�*Unlogged?*�h]�hJ� Unlogged?�����}�(h j^ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jV ubhJ�
towards the �����}�(h jV h!hh"NhNubh`)��}�(h�*right position*�h]�hJ�right position�����}�(h jp h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jV ubhJ�/ to make the sequence Unlogged.89The default is �����}�(h jV h!hh"NhNubh`)��}�(h�*No*�h]�hJ�No�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jV ubhJ�;. This option is available only on PostgreSQL 15 and above.�����}�(h jV h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK;h jR ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK;h j/ h!hubj )��}�(hX The *OWNED BY* option causes the sequence to be associated with a specific90table column, such that if that column (or its whole table) is dropped, the91sequence will be automatically dropped as well. The specified table must have92the same owner and be in the same schema as the sequence.93�h]�hV)��}�(hX The *OWNED BY* option causes the sequence to be associated with a specific94table column, such that if that column (or its whole table) is dropped, the95sequence will be automatically dropped as well. The specified table must have96the same owner and be in the same schema as the sequence.�h]�(hJ�The �����}�(h j� h!hh"NhNubh`)��}�(h�97*OWNED BY*�h]�hJ�OWNED BY�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJX option causes the sequence to be associated with a specific98table column, such that if that column (or its whole table) is dropped, the99sequence will be automatically dropped as well. The specified table must have100the same owner and be in the same schema as the sequence.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK=h j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK=h j/ h!hubeh}�(h]�h]�h]�h]�h]�j� h�uhj h"h#hK&h h&h!hubhV)��}�(h�%Click the *Security* tab to continue.�h]�(hJ�101Click the �����}�(h j� h!hh"NhNubh`)��}�(h�102*Security*�h]�hJ�Security�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� tab to continue.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKBh h&h!hubh�)��}�(h�b.. image:: images/sequence_security.png103 :alt: Sequence dialog security tab104 :align: center105�h]�h}�(h]�h]�h]�h]�h]��alt��Sequence dialog security tab��align��center��uri��images/sequence_security.png�h�}�h�j� suhh�h"h#hKDh h&h!hubhV)��}�(h�XUse the *Security* tab to assign privileges and define security labels for the106sequence.�h]�(hJ�Use the �����}�(h j h!hh"NhNubh`)��}�(h�107*Security*�h]�hJ�Security�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�F tab to assign privileges and define security labels for the108sequence.�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKHh h&h!hubhV)��}�(h�\Use the *Privileges* panel to assign privileges. Click the *Add* icon (+) to109set privileges:�h]�(hJ�Use the �����}�(h j! h!hh"NhNubh`)��}�(h�*Privileges*�h]�hJ�110Privileges�����}�(h j) h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j! ubhJ�' panel to assign privileges. Click the �����}�(h j! h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j; h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j! ubhJ� icon (+) to111set privileges:�����}�(h j! h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKKh h&h!hubj )��}�(hhh]�(j )��}�(h�lSelect the name of a role that will be granted privileges from the drop-down112listbox in the *Grantee* field.�h]�hV)��}�(h�lSelect the name of a role that will be granted privileges from the drop-down113listbox in the *Grantee* field.�h]�(hJ�\Select the name of a role that will be granted privileges from the drop-down114listbox in the �����}�(h jZ h!hh"NhNubh`)��}�(h� *Grantee*�h]�hJ�Grantee�����}�(h jb h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jZ ubhJ� field.�����}�(h jZ h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKNh jV ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKNh jS h!hubj )��}�(h��Click inside the *Privileges* field. Check the boxes to the left of one or115more privileges to grant the selected privilege to the specified user.�h]�hV)��}�(h��Click inside the *Privileges* field. Check the boxes to the left of one or116more privileges to grant the selected privilege to the specified user.�h]�(hJ�Click inside the �����}�(h j� h!hh"NhNubh`)��}�(h�*Privileges*�h]�hJ�117Privileges�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�t field. Check the boxes to the left of one or118more privileges to grant the selected privilege to the specified user.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKPh j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKPh jS h!hubj )��}�(h�nThe current user, who is the default grantor for granting the privilege, is displayed in the *Grantor* field.119�h]�hV)��}�(h�mThe current user, who is the default grantor for granting the privilege, is displayed in the *Grantor* field.�h]�(hJ�]The current user, who is the default grantor for granting the privilege, is displayed in the �����}�(h j� h!hh"NhNubh`)��}�(h� *Grantor*�h]�hJ�Grantor�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� field.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKRh j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKRh jS h!hubeh}�(h]�h]�h]�h]�h]�j� h�uhj h"h#hKNh h&h!hubhV)��}�(h��Click the *Add* icon (+) to assign additional privileges; to discard a120privilege, click the trash icon to the left of the row and confirm deletion in121the *Delete Row* popup.�h]�(hJ�122Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� icon (+) to assign additional privileges; to discard a123privilege, click the trash icon to the left of the row and confirm deletion in124the �����}�(h j� h!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�125Delete Row�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� popup.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKTh h&h!hubhV)��}�(h��Use the *Security Labels* panel to define security labels applied to the126sequence. Click the *Add* icon (+) to add each security label selection:�h]�(hJ�Use the �����}�(h j h!hh"NhNubh`)��}�(h�*Security Labels*�h]�hJ�Security Labels�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�D panel to define security labels applied to the127sequence. Click the �����}�(h j h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j& h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j ubhJ�/ icon (+) to add each security label selection:�����}�(h j h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKXh h&h!hubj )��}�(hhh]�(j )��}�(h��Specify a security label provider in the *Provider* field. The named provider128must be loaded and must consent to the proposed labeling operation.�h]�hV)��}�(h��Specify a security label provider in the *Provider* field. The named provider129must be loaded and must consent to the proposed labeling operation.�h]�(hJ�)Specify a security label provider in the �����}�(h jE h!hh"NhNubh`)��}�(h�130*Provider*�h]�hJ�Provider�����}�(h jM h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jE ubhJ�^ field. The named provider131must be loaded and must consent to the proposed labeling operation.�����}�(h jE h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK[h jA ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK[h j> h!hubj )��}�(hX Specify a a security label in the *Security Label* field. The meaning of a132given label is at the discretion of the label provider. PostgreSQL places no133restrictions on whether or how a label provider must interpret security134labels; it merely provides a mechanism for storing them.135�h]�hV)��}�(hX Specify a a security label in the *Security Label* field. The meaning of a136given label is at the discretion of the label provider. PostgreSQL places no137restrictions on whether or how a label provider must interpret security138labels; it merely provides a mechanism for storing them.�h]�(hJ�"Specify a a security label in the �����}�(h jo h!hh"NhNubh`)��}�(h�*Security Label*�h]�hJ�Security Label�����}�(h jw h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h jo ubhJ�� field. The meaning of a139given label is at the discretion of the label provider. PostgreSQL places no140restrictions on whether or how a label provider must interpret security141labels; it merely provides a mechanism for storing them.�����}�(h jo h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK]h jk ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK]h j> h!hubeh}�(h]�h]�h]�h]�h]�j� h�uhj h"h#hK[h h&h!hubhV)��}�(h��Click the *Add* icon (+) to assign additional security labels; to discard a142security label, click the trash icon to the left of the row and confirm deletion143in the *Delete Row* popup.�h]�(hJ�144Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Add*�h]�hJ�Add�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�� icon (+) to assign additional security labels; to discard a145security label, click the trash icon to the left of the row and confirm deletion146in the �����}�(h j� h!hh"NhNubh`)��}�(h�*Delete Row*�h]�hJ�147Delete Row�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� popup.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKbh h&h!hubhV)��}�(h� Click the *SQL* tab to continue.�h]�(hJ�148Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� tab to continue.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKfh h&h!hubhV)��}�(h��Your entries in the *Sequence* dialog generate a generate a SQL command (see an149example below). Use the *SQL* tab for review; revisit or switch tabs to make any150changes to the SQL command.�h]�(hJ�Your entries in the �����}�(h j� h!hh"NhNubh`)��}�(h�151*Sequence*�h]�hJ�Sequence�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�J dialog generate a generate a SQL command (see an152example below). Use the �����}�(h j� h!hh"NhNubh`)��}�(h�*SQL*�h]�hJ�SQL�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�O tab for review; revisit or switch tabs to make any153changes to the SQL command.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKhh h&h!hubh%)��}�(hhh]�(h*)��}�(h�Example�h]�hJ�Example�����}�(h j" h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh)h j h!hh"h#hKmubhV)��}�(h�eThe following is an example of the sql command generated by user selections in154the *Sequence* dialog:�h]�(hJ�SThe following is an example of the sql command generated by user selections in155the �����}�(h j0 h!hh"NhNubh`)��}�(h�156*Sequence*�h]�hJ�Sequence�����}�(h j8 h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j0 ubhJ� dialog:�����}�(h j0 h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKoh j h!hubh�)��}�(h�X.. image:: images/sequence_sql.png157 :alt: Sequence dialog sql tab158 :align: center159�h]�h}�(h]�h]�h]�h]�h]��alt��Sequence dialog sql tab��align��center��uri��images/sequence_sql.png�h�}�h�j_ suhh�h"h#hKrh j h!hubhV)��}�(h��The example shown demonstrates a sequence named *seconds*. The sequence will160increase in *5* second increments, and stop when it reaches a maximum value161equal of *60*.�h]�(hJ�0The example shown demonstrates a sequence named �����}�(h ja h!hh"NhNubh`)��}�(h� *seconds*�h]�hJ�seconds�����}�(h ji h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h ja ubhJ� . The sequence will162increase in �����}�(h ja h!hh"NhNubh`)��}�(h�*5*�h]�hJ�5�����}�(h j{ h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h ja ubhJ�F second increments, and stop when it reaches a maximum value163equal of �����}�(h ja h!hh"NhNubh`)��}�(h�*60*�h]�hJ�60�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h ja ubhJ�.�����}�(h ja h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKvh j h!hubj )��}�(hhh]�(j )��}�(h�2Click the *Info* button (i) to access online help.�h]�hV)��}�(hj� h]�(hJ�164Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Info*�h]�hJ�Info�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�" button (i) to access online help.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hKzh j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hKzh j� h!hubj )��}�(h�%Click the *Save* button to save work.�h]�hV)��}�(hj� h]�(hJ�165Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Save*�h]�hJ�Save�����}�(h j� h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ� button to save work.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK{h j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK{h j� h!hubj )��}�(h�5Click the *Close* button to exit without saving work.�h]�hV)��}�(hj� h]�(hJ�166Click the �����}�(h j� h!hh"NhNubh`)��}�(h�*Close*�h]�hJ�Close�����}�(h j h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j� ubhJ�$ button to exit without saving work.�����}�(h j� h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK|h j� ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK|h j� h!hubj )��}�(h�=Click the *Reset* button to restore configuration parameters.�h]�hV)��}�(hj% h]�(hJ�167Click the �����}�(h j' h!hh"NhNubh`)��}�(h�*Reset*�h]�hJ�Reset�����}�(h j. h!hh"NhNubah}�(h]�h]�h]�h]�h]�uhh_h j' ubhJ�, button to restore configuration parameters.�����}�(h j' h!hh"NhNubeh}�(h]�h]�h]�h]�h]�uhhUh"h#hK}h j# ubah}�(h]�h]�h]�h]�h]�uhj h"h#hK}h j� h!hubeh}�(h]�h]�h]�h]�h]�j� h�uhj h"h#hKzh j h!hubeh}�(h]��example�ah]�h]��example�ah]�h]�uhh$h h&h!hh"h#hKmubeh}�(h]�(h�id1�eh]�h]�(�sequence dialog��sequence_dialog�eh]�h]�uhh$h hh!hh"h#hK�expect_referenced_by_name�}�j` hs�expect_referenced_by_id�}�hhsubeh}�(h]�h]�h]�h]�h]��source�h#�translation_progress�}�(�total�K �168translated�K uuhh�current_source�N�current_line�N�settings��docutils.frontend��Values���)��}�(�output�Nh)N� generator�N� datestamp�N�root_prefix��/��source_link�N�169source_url�N�
toc_backlinks��entry��footnote_backlinks���
sectnum_xform���strip_comments�N�strip_elements_with_classes�N�
strip_classes�N�report_level�K�170halt_level�K�exit_status_level�K�debug�N�warning_stream�N� traceback���input_encoding�� utf-8-sig��input_encoding_error_handler��strict��output_encoding��utf-8��output_encoding_error_handler�j� �error_encoding��cp1252��error_encoding_error_handler��backslashreplace��
language_code��en��record_dependencies�N�config�N� id_prefix�h�auto_id_prefix��id��
dump_settings�N�dump_internals�N�dump_transforms�N�dump_pseudo_xml�N�expose_internals�N�strict_visitor�N�_disable_config�N�_source�h#�_destination�N�
_config_files�]��file_insertion_enabled���raw_enabled�K�line_length_limit�M'�pep_references�N�pep_base_url��https://peps.python.org/��pep_file_url_template��pep-%04d��rfc_references�N�rfc_base_url��&https://datatracker.ietf.org/doc/html/�� tab_width�K�trim_footnote_reference_space���syntax_highlight��long��smart_quotes���smartquotes_locales�]��character_level_inline_markup���doctitle_xform���
docinfo_xform���sectsubtitle_xform���
image_loading��link��embed_stylesheet���cloak_email_addresses���section_self_link���env�Nub�reporter�N�indirect_targets�]��substitution_defs�}��substitution_names�}��refnames�}��refids�}�h]�has�nameids�}�(j` hj_ j\ jW jT u� nametypes�}�(j` �j_ �jW �uh}�(hh&j\ h&jT j u�
footnote_refs�}��
citation_refs�}��
autofootnotes�]��autofootnote_refs�]��symbol_footnotes�]��symbol_footnote_refs�]�� footnotes�]�� citations�]��autofootnote_start�K�symbol_footnote_start�K �171id_counter��collections��Counter���}�j� Ks��R��parse_messages�]��transform_messages�]�(h �system_message���)��}�(hhh]�hV)��}�(hhh]�hJ�5Hyperlink target "sequence-dialog" is not referenced.�����}�h j� sbah}�(h]�h]�h]�h]�h]�uhhUh j� ubah}�(h]�h]�h]�h]�h]��level�K�type��INFO��source�h#�line�Kuhj� ubj� )��}�(hhh]�hV)��}�(hhh]�hJ�-Hyperlink target "index-0" is not referenced.�����}�h j sbah}�(h]�h]�h]�h]�h]�uhhUh j ubah}�(h]�h]�h]�h]�h]��level�K�type�j �source�h#�line�Kuhj� ube�transformer�N�include_log�]��172decoration�Nh!hub.