Hola buen día todos,
Debo convertir una columna de tipo integer a tipo text por que se requieren
valores alfanuméricos, la base de datos actualmente tiene alrededor de 50
mil registros. La pregunta es, si despues de convertirla debo ejecutar
algun tipo de proceso como para sanear el cambio? o lo
Kernel escribió:
> De manera intencionada he generado un bucle, ¿Hay alguna manera de prevenir
> esto?,¿hay alguna manera de limitar el numero de bucles?
Sí. https://www.postgresql.org/docs/9.5/static/queries-with.html
Desde "When working with recursive queries it is important to be sure
that th
On 10/21/2016 10:24 AM, Emanuel Calvo wrote:
>
>
> Hey Nahum,
>
> you may want to do that update in batches using id ranges. Also, should
> avoid the
> single transaction method if you have replicas.
>
> BTW, don't know why we are speaking in english, as this is an _español_
> mailing list. J
Hey Nahum,
you may want to do that update in batches using id ranges. Also, should
avoid the
single transaction method if you have replicas.
BTW, don't know why we are speaking in english, as this is an _español_
mailing list. Just heads up. :)
Regards,
On Thu, Oct 20, 2016 at 10:27 PM Nahum C
El 20/10/2016 a las 21:12, Freddy Martinez escribió:
por ejemplo:
WITH RECURSIVE search_perspectives(id, parent) AS (
SELECT
perspectives.id,
perspectives.parent
FROM perspectives
WHERE id = p_perspective_id
UNION ALL
SELECT
p.id,
p.parent
FROM perspectives p, search_perspectives s
WHERE p.p
