Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id BA455632845 for ; Thu, 11 Feb 2010 12:23:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 67743-01-10 for ; Thu, 11 Feb 2010 16:22:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id E6DE1633B88 for ; Thu, 11 Feb 2010 12:20:00 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id 9B7F911C0046; Thu, 11 Feb 2010 17:19:55 +0100 (CET) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0XLxJpyK-98W; Thu, 11 Feb 2010 17:19:49 +0100 (CET) Received: from hermes.vectorsf.com (hermes.vectorsf.com [10.70.4.30]) by hermes.vectorsf.com (Postfix) with ESMTP id 9C21D11C0041; Thu, 11 Feb 2010 17:19:49 +0100 (CET) From: =?iso-8859-1?Q?I=F1igo_Martinez_Lasala?= To: Cc: References: In-Reply-To: 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> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00B8_01CAAB3E.735B3640" X-Mailer: Microsoft Office Outlook 12.0 X-Mailer: Zimbra 5.0.20_GA_3127.RHEL4_64 (ZimbraConnectorForOutlook/5.0.3191.20) Thread-Index: AcqrH0rBCPxR8Y95S7+rO/7QkF4xFgAFbk5w Content-Language: es X-Originating-IP: [10.70.7.99] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.298 tagged_above=-10 required=5 tests=AWL=-1.300, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201002/95 X-Sequence-Number: 33698 This is a multi-part message in MIME format. ------=_NextPart_000_00B8_01CAAB3E.735B3640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit 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 ....¡ ------=_NextPart_000_00B8_01CAAB3E.735B3640 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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 = ....=A1

------=_NextPart_000_00B8_01CAAB3E.735B3640--