Project

General

Profile

« Previous | Next » 

Revision 10836

Added by Aaron Marcuse-Kubitza over 11 years ago

web/links/index.htm: updated to Firefox bookmarks. PostgreSQL: added info on vacuuming and analyzing.

View differences:

web/links/index.htm
1011 1011 
                <DT><A HREF="http://stackoverflow.com/questions/2296097/making-an-svg-image-object-clickable-with-onclick-avoiding-absolute-positioning" name="http://stackoverflow.com/questions/2296097/making-an-svg-image-object-clickable-with-onclick-avoiding-absolute-positioning" ADD_DATE="1360695157" 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;"/>html - Making an svg image object clickable with onclick, avoiding absolute positioning - Stack Overflow</A><a name="html - Making an svg image object clickable with onclick, avoiding absolute positioning - Stack Overflow" href="#html - Making an svg image object clickable with onclick, avoiding absolute positioning - Stack Overflow" style="margin-left: 0.5em;">&para;</a>
1012 1012 
                <DT><A HREF="http://meyerweb.com/eric/tools/dencoder/" name="http://meyerweb.com/eric/tools/dencoder/" ADD_DATE="1333064653" ICON_URI="http://meyerweb.com/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://meyerweb.com/favicon.ico" style="margin-right: 0.5em;"/>URL Decoder/Encoder</A><a name="URL Decoder/Encoder" href="#URL Decoder/Encoder" style="margin-left: 0.5em;">&para;</a>
1013 1013 
                <DT><A HREF="http://support.mozilla.org/en-US/questions/890741" name="http://support.mozilla.org/en-US/questions/890741" ADD_DATE="1363371811" ICON_URI="http://support.cdn.mozilla.net/media/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.cdn.mozilla.net/media/img/favicon.ico" style="margin-right: 0.5em;"/>weird square favicon | Firefox Support Forum | Mozilla Support</A><a name="weird square favicon | Firefox Support Forum | Mozilla Support" href="#weird square favicon | Firefox Support Forum | Mozilla Support" style="margin-left: 0.5em;">&para;</a>
1014 
                <DT><A HREF="http://www.mozilla.org/en-US/plugincheck/" name="http://www.mozilla.org/en-US/plugincheck/" ADD_DATE="1377561967" ICON_URI="http://mozorg.cdn.mozilla.net/media/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://mozorg.cdn.mozilla.net/media/img/favicon.ico" style="margin-right: 0.5em;"/>Mozilla — Plugin Check &amp; Updates — mozilla.org</A><a name="Mozilla — Plugin Check &amp; Updates — mozilla.org" href="#Mozilla — Plugin Check &amp; Updates — mozilla.org" style="margin-left: 0.5em;">&para;</a>
1014 1015 
            </DL><p>
1015 1016 
            <DT><a name="DBs" href="#DBs"><H3 ADD_DATE="1346355036">DBs</H3></a>
1016 1017 
            <DL><p>
......
1226 1227 
                            <DT><A HREF="http://www.postgresql.org/docs/9.0/static/sql-syntax-calling-funcs.html" name="http://www.postgresql.org/docs/9.0/static/sql-syntax-calling-funcs.html" ADD_DATE="1340057070" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.0: Calling Functions</A><a name="PostgreSQL: Documentation: 9.0: Calling Functions" href="#PostgreSQL: Documentation: 9.0: Calling Functions" style="margin-left: 0.5em;">&para;</a>
1227 1228 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-altertable.html" name="http://www.postgresql.org/docs/9.1/static/sql-altertable.html" ADD_DATE="1367836103" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: ALTER TABLE</A><a name="PostgreSQL: Documentation: 9.1: ALTER TABLE" href="#PostgreSQL: Documentation: 9.1: ALTER TABLE" style="margin-left: 0.5em;">&para;</a>
1228 1229 
<DD>&quot;As an exception, if the USING clause does not change the column contents and the old type is either binary coercible to the new type or an unconstrained domain over the new type, a table rewrite is not needed, but any indexes on the affected columns must still be rebuilt&quot;
1230 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-analyze.html" name="http://www.postgresql.org/docs/9.1/static/sql-analyze.html" ADD_DATE="1377904843" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: ANALYZE</A><a name="PostgreSQL: Documentation: 9.1: ANALYZE" href="#PostgreSQL: Documentation: 9.1: ANALYZE" style="margin-left: 0.5em;">&para;</a>
1231 
<DD>&quot;the autovacuum daemon (see Section 23.1.5) takes care of automatic analyzing of tables when they are first loaded with data, and as they change throughout regular operation&quot;
1229 1232 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/datatype-binary.html" name="http://www.postgresql.org/docs/9.1/static/datatype-binary.html" ADD_DATE="1366908596" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Binary Data Types</A><a name="PostgreSQL: Documentation: 9.1: Binary Data Types" href="#PostgreSQL: Documentation: 9.1: Binary Data Types" style="margin-left: 0.5em;">&para;</a>
1230 1233 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/multibyte.html" name="http://www.postgresql.org/docs/9.1/static/multibyte.html" ADD_DATE="1367850721" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Character Set Support</A><a name="PostgreSQL: Documentation: 9.1: Character Set Support" href="#PostgreSQL: Documentation: 9.1: Character Set Support" style="margin-left: 0.5em;">&para;</a>
1231 1234 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-comment.html" name="http://www.postgresql.org/docs/9.1/static/sql-comment.html" ADD_DATE="1362547512" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: COMMENT</A><a name="PostgreSQL: Documentation: 9.1: COMMENT" href="#PostgreSQL: Documentation: 9.1: COMMENT" style="margin-left: 0.5em;">&para;</a>
......
1279 1282 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/external-pl.html" name="http://www.postgresql.org/docs/9.1/static/external-pl.html" ADD_DATE="1362834165" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Procedural Languages</A><a name="PostgreSQL: Documentation: 9.1: Procedural Languages" href="#PostgreSQL: Documentation: 9.1: Procedural Languages" style="margin-left: 0.5em;">&para;</a>
1280 1283 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/app-psql.html#APP-PSQL-PATTERNS" name="http://www.postgresql.org/docs/9.1/static/app-psql.html#APP-PSQL-PATTERNS" ADD_DATE="1342486329" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: psql</A><a name="PostgreSQL: Documentation: 9.1: psql" href="#PostgreSQL: Documentation: 9.1: psql" style="margin-left: 0.5em;">&para;</a>
1281 1284 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/xfunc-sql.html" name="http://www.postgresql.org/docs/9.1/static/xfunc-sql.html" ADD_DATE="1351738107" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions</A><a name="PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions" href="#PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions" style="margin-left: 0.5em;">&para;</a>
1285 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html#AUTOVACUUM" name="http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html#AUTOVACUUM" ADD_DATE="1377905019" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Routine Vacuuming &gt; 23.1.5. The Autovacuum Daemon</A><a name="PostgreSQL: Documentation: 9.1: Routine Vacuuming &gt; 23.1.5. The Autovacuum Daemon" href="#PostgreSQL: Documentation: 9.1: Routine Vacuuming &gt; 23.1.5. The Autovacuum Daemon" style="margin-left: 0.5em;">&para;</a>
1282 1286 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/lo-funcs.html" name="http://www.postgresql.org/docs/9.1/static/lo-funcs.html" ADD_DATE="1367554117" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: Server-side Functions</A><a name="PostgreSQL: Documentation: 9.1: Server-side Functions" href="#PostgreSQL: Documentation: 9.1: Server-side Functions" style="margin-left: 0.5em;">&para;</a>
1283 1287 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/sql-set-constraints.html" name="http://www.postgresql.org/docs/9.1/static/sql-set-constraints.html" ADD_DATE="1373131555" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: SET CONSTRAINTS</A><a name="PostgreSQL: Documentation: 9.1: SET CONSTRAINTS" href="#PostgreSQL: Documentation: 9.1: SET CONSTRAINTS" style="margin-left: 0.5em;">&para;</a>
1284 1288 
<DD>&quot;PostgreSQL does not require constraint names to be unique within a schema (but only per-table)&quot;
......
1293 1297 
<DD>-
1294 1298 
includes set_config(), current_setting()
1295 1299 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-info.html" name="http://www.postgresql.org/docs/9.1/static/functions-info.html" ADD_DATE="1370976312" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: System Information Functions</A><a name="PostgreSQL: Documentation: 9.1: System Information Functions" href="#PostgreSQL: Documentation: 9.1: System Information Functions" style="margin-left: 0.5em;">&para;</a>
1300 
<DD>&quot;current_schemas(boolean) returns an array of the names of all schemas presently in the search path. The Boolean option determines whether or not implicitly included system schemas such as pg_catalog are included in the returned search path.&quot;
1296 1301 
                            <DT><A HREF="http://www.postgresql.org/docs/8.4/static/logfile-maintenance.html" name="http://www.postgresql.org/docs/8.4/static/logfile-maintenance.html" ADD_DATE="1333386461" 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: Log File Maintenance</A><a name="PostgreSQL: Documentation: Manuals: Log File Maintenance" href="#PostgreSQL: Documentation: Manuals: Log File Maintenance" style="margin-left: 0.5em;">&para;</a>
1297 1302 
                            <DT><A HREF="http://www.postgresql.org/docs/9.1/interactive/index.html" name="http://www.postgresql.org/docs/9.1/interactive/index.html" ADD_DATE="1317673868" 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: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation</A><a name="PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation" href="#PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation" style="margin-left: 0.5em;">&para;</a>
1298 1303 
                            <DT><A HREF="http://www.postgresql.org/docs/8.3/static/app-psql.html" name="http://www.postgresql.org/docs/8.3/static/app-psql.html" ADD_DATE="1325722373" 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: psql</A><a name="PostgreSQL: Documentation: Manuals: psql" href="#PostgreSQL: Documentation: Manuals: psql" style="margin-left: 0.5em;">&para;</a>
......
1338 1343 
                            <DT><A HREF="http://www.postgresql.org/message-id/4811DC02.6030800@archonet.com" name="http://www.postgresql.org/message-id/4811DC02.6030800@archonet.com" ADD_DATE="1369925133" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: Last insert/update/delete time for a table</A><a name="Re: Last insert/update/delete time for a table" href="#Re: Last insert/update/delete time for a table" style="margin-left: 0.5em;">&para;</a>
1339 1344 
                            <DT><A HREF="http://www.postgresql.org/message-id/3f0b79eb0804250725w3349903iedbe11f0e2cd3fe5@mail.gmail.com" name="http://www.postgresql.org/message-id/3f0b79eb0804250725w3349903iedbe11f0e2cd3fe5@mail.gmail.com" ADD_DATE="1369925149" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: Last insert/update/delete time for a table</A><a name="Re: Last insert/update/delete time for a table" href="#Re: Last insert/update/delete time for a table" style="margin-left: 0.5em;">&para;</a>
1340 1345 
                        </DL><p>
1346 
                        <DT><a name="vacuuming" href="#vacuuming"><H3 ADD_DATE="1377911873">vacuuming</H3></a>
1347 
                        <DL><p>
1348 
                            <DT><A HREF="http://serverfault.com/questions/53376/how-do-i-know-if-the-autovacuumer-in-postgres-8-3-is-actually-working" name="http://serverfault.com/questions/53376/how-do-i-know-if-the-autovacuumer-in-postgres-8-3-is-actually-working" ADD_DATE="1377911319" ICON_URI="http://cdn.sstatic.net/serverfault/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/serverfault/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How do I know if the autovacuumer in postgres 8.3 is actually working? - Server Fault</A><a name="postgresql - How do I know if the autovacuumer in postgres 8.3 is actually working? - Server Fault" href="#postgresql - How do I know if the autovacuumer in postgres 8.3 is actually working? - Server Fault" style="margin-left: 0.5em;">&para;</a>
1349 
<DD>&quot;pg_stat_user_tables has columns *last_autovacuum* and *last_autoanalyze*. They will be updated whenever it does something.&quot;
1350 
                            <DT><A HREF="http://blog.gocept.com/2012/05/22/dont-stop-postgresqls-autovacuum-with-your-application/" name="http://blog.gocept.com/2012/05/22/dont-stop-postgresqls-autovacuum-with-your-application/" ADD_DATE="1377911959" ICON_URI="http://1.gravatar.com/blavatar/b99b16aa78bd25f6aa8d01f9c1c99fb4?s=16" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://1.gravatar.com/blavatar/b99b16aa78bd25f6aa8d01f9c1c99fb4?s=16" style="margin-right: 0.5em;"/>Don’t stop PostgreSQL’s autovacuum with your application | gocept weblog</A><a name="Don’t stop PostgreSQL’s autovacuum with your application | gocept weblog" href="#Don’t stop PostgreSQL’s autovacuum with your application | gocept weblog" style="margin-left: 0.5em;">&para;</a>
1351 
<DD>page's description: The problem Some weeks ago, we received a complaint from a customer about bad PostgreSQL performance for a specific application. I took a look into the database and found strange things going on: the query planner was executing &quot;interesting&quot; query plans, tables were bloated with lots of dead rows (one was 6 times as big…
1352 

  		




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


  		




  
  1354
  
    

  		




  
  1355
  
    
&quot;autovacuum will abort if it is not able to obtain a table lock within one second&quot;


  		




  
  1356
  
    

  		




  
  1357
  
    
&quot;In 9.0, the autovacuum process will be aborted about 1 second after


  		




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


  		




  
  1359
  
    
simple INSERT will take 1 second.&quot;


  		




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


  		




  
  1361
  
    
                            <DT><A HREF="http://postgresql.1045698.n5.nabble.com/Lock-problem-with-autovacuum-truncating-heap-td4265539.html" name="http://postgresql.1045698.n5.nabble.com/Lock-problem-with-autovacuum-truncating-heap-td4265539.html" ADD_DATE="1377912054" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - hackers - Lock problem with autovacuum truncating heap</A><a name="PostgreSQL - hackers - Lock problem with autovacuum truncating heap" href="#PostgreSQL - hackers - Lock problem with autovacuum truncating heap" style="margin-left: 0.5em;">&para;</a>


  		




  
  1362
  
    
<DD>page's description: Lock problem with autovacuum truncating heap. We have run across a problem with autovacuum that occurs when it can truncate off a large amount of empty blocks. It behaves different in version 9.0...


  		




  
  1363
  
    
                        </DL><p>


  		




  1341
  1364
  
    
                        <DT><A HREF="http://journal.tianhao.info/2010/12/postgresql-change-default-encoding-of-new-databases-to-utf-8-optional/" name="http://journal.tianhao.info/2010/12/postgresql-change-default-encoding-of-new-databases-to-utf-8-optional/" ADD_DATE="1335054607" ICON_URI="http://blog.tianhao.info/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blog.tianhao.info/favicon.ico" style="margin-right: 0.5em;"/>» PostgreSQL – Change Default Encoding of New Databases To UTF-8 (Optional) Journal</A><a name="» PostgreSQL – Change Default Encoding of New Databases To UTF-8 (Optional) Journal" href="#» PostgreSQL – Change Default Encoding of New Databases To UTF-8 (Optional) Journal" style="margin-left: 0.5em;">&para;</a>


  		




  1342
  1365
  
    
                        <DT><A HREF="https://groups.google.com/forum/?fromgroups#!topic/pgsql.general/aitDYC6jMEI" name="https://groups.google.com/forum/?fromgroups#!topic/pgsql.general/aitDYC6jMEI" ADD_DATE="1340396170" ICON_URI="https://groups.google.com/forum/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://groups.google.com/forum/favicon.ico" style="margin-right: 0.5em;"/>[GENERAL] ROLLBACK in a function - Google Groups</A><a name="[GENERAL] ROLLBACK in a function - Google Groups" href="#[GENERAL] ROLLBACK in a function - Google Groups" style="margin-left: 0.5em;">&para;</a>


  		




  1343
  1366
  
    
                        <DT><A HREF="http://grokbase.com/t/postgresql/pgsql-hackers/115ewt1b5s/domains-and-casts" name="http://grokbase.com/t/postgresql/pgsql-hackers/115ewt1b5s/domains-and-casts" ADD_DATE="1366907179" ICON_URI="http://grokbase.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://grokbase.com/favicon.ico" style="margin-right: 0.5em;"/>[PostgreSQL-Hackers] DOMAINs and CASTs - Grokbase</A><a name="[PostgreSQL-Hackers] DOMAINs and CASTs - Grokbase" href="#[PostgreSQL-Hackers] DOMAINs and CASTs - Grokbase" style="margin-left: 0.5em;">&para;</a>


  		




  ......




  1393
  1416
  
    
                        <DT><A HREF="http://www.sqlines.com/postgresql/how-to/create_user_defined_type" name="http://www.sqlines.com/postgresql/how-to/create_user_defined_type" ADD_DATE="1366907079" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>PostgreSQL - How to Create User-Defined Type (UDT) - SQLines</A><a name="PostgreSQL - How to Create User-Defined Type (UDT) - SQLines" href="#PostgreSQL - How to Create User-Defined Type (UDT) - SQLines" style="margin-left: 0.5em;">&para;</a>


  		




  1394
  1417
  
    
<DD>page's description: You can create a user-defined type using CREATE DOMAIN and CREATE TYPE statements.  Quick Example:      -- Define a type using CREATE DOMAIN    CREATE DOMAIN addr VARCHAR(90) NOT NULL DEFAULT &#39;N/A&#39;;    -- Define a type using CREATE TYPE    CREATE TYPE address AS (city VARCHAR(90), street VARCHAR(90));       -- Use them in a table     CREATE TABLE location (ship_address addr, full_address address);


  		




  1395
  1418
  
    
                        <DT><A HREF="http://stackoverflow.com/questions/7605126/how-to-include-files-relative-to-the-current-executing-script-in-psql" name="http://stackoverflow.com/questions/7605126/how-to-include-files-relative-to-the-current-executing-script-in-psql" ADD_DATE="1363458243" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How to include files relative to the current executing script in psql? - Stack Overflow</A><a name="postgresql - How to include files relative to the current executing script in psql? - Stack Overflow" href="#postgresql - How to include files relative to the current executing script in psql? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>


  		




  
  1419
  
    
                        <DT><A HREF="http://stackoverflow.com/questions/13260042/how-to-restore-public-schema-into-different-schema" name="http://stackoverflow.com/questions/13260042/how-to-restore-public-schema-into-different-schema" ADD_DATE="1377658202" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How to restore public schema into different schema - Stack Overflow</A><a name="postgresql - How to restore public schema into different schema - Stack Overflow" href="#postgresql - How to restore public schema into different schema - Stack Overflow" style="margin-left: 0.5em;">&para;</a>


  		




  1396
  1420
  
    
                        <DT><A HREF="http://stackoverflow.com/questions/7682102/putting-explain-results-into-a-table" name="http://stackoverflow.com/questions/7682102/putting-explain-results-into-a-table" ADD_DATE="1351738902" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - Putting EXPLAIN results into a table? - Stack Overflow</A><a name="postgresql - Putting EXPLAIN results into a table? - Stack Overflow" href="#postgresql - Putting EXPLAIN results into a table? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>


  		




  1397
  1421
  
    
                        <DT><A HREF="http://postgresql.1045698.n5.nabble.com/foreign-key-on-pg-shadow-td2142568.html" name="http://postgresql.1045698.n5.nabble.com/foreign-key-on-pg-shadow-td2142568.html" ADD_DATE="1362551492" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - sql - foreign key on pg_shadow</A><a name="PostgreSQL - sql - foreign key on pg_shadow" href="#PostgreSQL - sql - foreign key on pg_shadow" style="margin-left: 0.5em;">&para;</a>


  		




  1398
  1422
  
    
<DD>page's description: foreign key on pg_shadow. Dear list, Upon designing our application we thought that the following setup would be a good idea to implement security: Using the pg_shadow table as it is: |...


  		












Also available in:  Unified diff