fabriciocolombo

select 'ALTER FUNCTION ' || quote_ident(routine_schema) || '.' || quote_ident(routine_name) || ' OWNER TO ' ||routine_schema || ';'
  from information_schema.routines
 where specific_schema NOT LIKE E'pg\\_%'
   and specific_schema <> 'information_schema'
   and specific_schema <> 'public'
   /*AND specific_schema = $YourSchema leave commented for all */
union all
SELECT 'ALTER TABLE ' || quote_ident(s.nspname) || '.' || quote_ident(s.relname) || ' OWNER TO ' || nspname || ';'
  FROM (SELECT nspname, relname
          FROM pg_class c

fabriciocolombo

HTTP codes, we are family

Above we have looked at just a few of the available HTTP codes; there are many others. Some are very well-known, such as 404 Not Found, but others are quite obscure and don't crop up very often. Whatever the case, the first digit is always an indication of the family of codes they belong to:

• 1xx (Informational): Request received, continuing process.
• 2xx (Successful): The action was successfully received, understood, and accepted.
• 3xx (Redirection): Further action needs to be taken in order to complete the request.
• 4xx (Client Error): The request contains bad syntax or cannot be fulfilled.
• 5xx (Server Error): The server failed to fulfil an apparently valid request.

fabriciocolombo

  procedure ReplaceArray;
  var
    vPerson: IBSONObject;
    vAddresses,
    vNewAddresses: IBSONArray;
  begin
    //Insert person
    vAddresses := TBSONArray.NewFromValues(['one address', 'two address']);
    vPerson := TBSONObject.NewFrom('id', 1).Put('name', 'fabricio').Put('addresses', vAddresses);
    FCollection.Save(vPerson);

fabriciocolombo

Testing spring web flow with hibernate option AvailableSettings.ENABLE_LAZY_LOAD_NO_TRANS enabled to verify if the connection leak on Lazy Load without transaction disappear

https://hibernate.onjira.com/browse/HHH-7524

fabriciocolombo

Synonyms to close an issue with commit message

• fixes #xxx
• fixed #xxx
• fix #xxx
• closes #xxx
• close #xxx
• closed #xxx

fabriciocolombo

Admin console

user: admin
password: password

BI server

user: joe
password: password

fabriciocolombo

pg_dump.exe --host $host --port 5432  --username $userName --format plain --create --verbose --file $fileName $databaseName

To restore backup done with plain format
  psql -a -h $host -p 5432 -U $user -d $database -f $fileName -o restore.log

To restore backup done with other format
  pg_restore -h $host -U $user --verbose -d $databaseName -C $backupFileName [2> restore.log] 

fabriciocolombo

JDBC Connection URLs for 22 Databases

Source

PostgresSQL JDBC connection URL

jdbc:postgresql:template1
org.postgresql.Driver

MySQL JDBC connection URL

fabriciocolombo

Agregação
  Os objetos contidos podem existir sem serem parte do objeto que os contém. Exemplo: Carro -> Rodas. Você pode tirar as   rodas do carro antes de destruí-lo e elas podem ser colocadas em outro carro.

Composição
  Os objetos contidos não fazem sentido fora do contexto do objeto que os contém.
Exemplo: Pedido -> Itens. Se você destruir o pedido, os itens são destruidos junto, eles não tem sentido fora do pedido.

fabriciocolombo

{$Message Hint 'Feed the cats'}     //emits a hint 
{$MessaGe Warn 'Looks like rain.'}  //emits a warning
{$Message Error 'Not implemented'}  //emits an error, continues compiling
{$Message Fatal 'Bang.  Yer dead.'} //emits an error, terminates compiler