From: Iñigo Martinez Lasala <imartinez@vectorsf.com>
To: pgsql-admin@postgresql.org
Cc: bcld@hotmail.com
Subject: Re: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
Date: Thu, 11 Feb 2010 17:19:49 +0100 (CET)
Message-ID: <00b701caab36$1196ce40$34c46ac0$@com> (raw)
In-Reply-To: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
References: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
Hola Rafael.
You could generate a UUID. There is a contrib module in contrib/uuid-ossp
with several functions in order to generate an UUID with different
algorithms, as documentation says.
If you don’t want to use these functions because you use an specific
format, perhaps they could serve you as example in order to create a
custom one.
Espero haberte dado alguna idea.
De: Luis Dominguez [mailto:bcld@hotmail.com]
Enviado el: jueves, 11 de febrero de 2010 14:36
Para: pgsql-es-ayuda@postgresql.org; vepug@postgresql.org;
pgsql-admin@postgresql.org
Asunto: [ADMIN] REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on
Linux
Good morning, I am now in the process of migrating a database from a
driver ms sql server 7.0 to postgresql 8.4 vesion but I have a problem
with the data type (timestamp) SQL Server 7.0 that refers to a single
binary field that is updated randomly by row, and this field is paramount
in my application for purposes of monitoring, postgresql 8.4 now also have
the same timestamp but refers to other data (date + time), I investigated
other types of data such as (serial, uuid, xid, byte etc) in postgresql
and not get something just to replace it, I thought of a function that do
something similar but not yet tried, and of course I turn to you to see if
I can lend a hand with this rut that I have right now ....¡
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: imartinez@vectorsf.com, bcld@hotmail.com
Subject: Re: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
In-Reply-To: <00b701caab36$1196ce40$34c46ac0$@com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox