Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 079A36336D5
	for <pgsql-es-ayuda-postgresql.org@mail.postgresql.org>;
	Fri, 12 Feb 2010 13:24:58 -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 67085-02
	for <pgsql-es-ayuda-postgresql.org@mail.postgresql.org>;
	Fri, 12 Feb 2010 17:24:44 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from aldia.com.mx (unknown [148.235.107.242])
	by mail.postgresql.org (Postfix) with ESMTP id 76CEC632563
	for <pgsql-es-ayuda@postgresql.org>;
	Fri, 12 Feb 2010 13:24:45 -0400 (AST)
Received: from [192.168.10.34] ([192.168.10.34])
	by aldia.com.mx (8.11.6/8.11.6) with ESMTP id o1CHOhg13863
	for <pgsql-es-ayuda@postgresql.org>; Fri, 12 Feb 2010 11:24:43 -0600
Message-ID: <4B758E33.5090706@aldia.com.mx>
Date: Fri, 12 Feb 2010 11:21:55 -0600
From: =?ISO-8859-1?Q?Jenaro_Centeno_G=F3mez?= <jcenteno@aldia.com.mx>
Organization: Alimentos La Concordia, S.A. de C.V.
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.8pre) Gecko/20100126 Lightning/1.0b1 Shredder/3.0.2pre
MIME-Version: 1.0
To: pgsql-es-ayuda@postgresql.org
Subject: Re: [ADMIN] REF: Data Migration MS SQL Server 7.0
	to	 PostgreSQL 8.4 on Linux
References: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
	<4B73C895020000250002F180@gw.wicourts.gov>
In-Reply-To: <4B73C895020000250002F180@gw.wicourts.gov>
Content-Type: multipart/mixed; boundary="------------070700050205080008050707"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.23 tagged_above=-10 required=5 tests=AWL=0.128,
	BAYES_50=0.001, HTML_MESSAGE=0.001, RDNS_NONE=0.1
X-Spam-Level: 
X-Archive-Number: 201002/213
X-Sequence-Number: 48004

This is a multi-part message in MIME format.
--------------070700050205080008050707
Content-Type: multipart/alternative;
	boundary="------------000604030209060003080209"


--------------000604030209060003080209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

On 11/02/10 09:06, Kevin Grittner wrote:
> Luis Dominguez<bcld@hotmail.com>  wrote:
>
>    
>> 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
>>      
>
> Did you consider creating a SEQUENCE used by a trigger on update or
> insert of a row?
>
> http://www.postgresql.org/docs/8.4/interactive/sql-createsequence.html
>
> -Kevin
> --
> TIP 1: para suscribirte y desuscribirte, visita http://archives.postgresql.org/pgsql-es-ayuda
>
>
>    
timestamp type in SQL Server is like ROWID in Oracle, and as Kevin said, 
you could use the serial type as a replacement.

-- 
-------------------------------------------------------------------------------------------
L.A. Jenaro Centeno Gómez              Al-Día Se renueva con la mejora continua.

Jefe de Tecnologías de la Información
Alimentos La Concordia, S.A. de C.V.
Tel. 01 474 741 9200
Ext. 9280
www.aldia.com.mx


--------------000604030209060003080209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html; charset=ISO-8859-1"
 http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
On 11/02/10 09:06, Kevin Grittner wrote:
<blockquote cite="mid:4B73C895020000250002F180@gw.wicourts.gov"
 type="cite">
  <pre wrap="">Luis Dominguez <a class="moz-txt-link-rfc2396E" href="mailto:bcld@hotmail.com">&lt;bcld@hotmail.com&gt;</a> wrote:
 
  </pre>
  <blockquote type="cite">
    <pre wrap="">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
    </pre>
  </blockquote>
  <pre wrap=""> 
Did you consider creating a SEQUENCE used by a trigger on update or
insert of a row?
 
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.4/interactive/sql-createsequence.html">http://www.postgresql.org/docs/8.4/interactive/sql-createsequence.html</a>
 
-Kevin
--
TIP 1: para suscribirte y desuscribirte, visita <a class="moz-txt-link-freetext" href="http://archives.postgresql.org/pgsql-es-ayuda">http://archives.postgresql.org/pgsql-es-ayuda</a>


  </pre>
</blockquote>
<font face="AquaBase">timestamp type in SQL Server is like ROWID in
Oracle, and as Kevin said, you could use the serial type as a
replacement.</font><br>
<br>
<pre class="moz-signature" cols="80">-- 
-------------------------------------------------------------------------------------------
L.A. Jenaro Centeno G&oacute;mez              Al-D&iacute;a Se renueva con la mejora continua.                                                                                                                

Jefe de Tecnolog&iacute;as de la Informaci&oacute;n
Alimentos La Concordia, S.A. de C.V.
Tel. 01 474 741 9200
Ext. 9280
<a class="moz-txt-link-abbreviated" href="http://www.aldia.com.mx">www.aldia.com.mx</a>
</pre>
</body>
</html>

--------------000604030209060003080209--

--------------070700050205080008050707
Content-Type: text/x-vcard; charset=utf-8;
 name="jcenteno.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="jcenteno.vcf"

begin:vcard
fn;quoted-printable:Jenaro Centeno G=C3=B3mez
n;quoted-printable:Centeno G=C3=B3mez;Jenaro
org;quoted-printable:Alimentos La Concordia, S.A. de C.V.;Tecnolog=C3=ADas de la Informaci=C3=B3n
adr;quoted-printable:La Marimba;;Loma de Prados No. 1332;Lagos de Moreno;Jal;47460;M=C3=A9xico
email;internet:jcenteno@aldia.com.mx
title;quoted-printable:Jefe de Tecnolog=C3=ADas de la Informaci=C3=B3n
tel;work:474 7419200 Ext. 9280
x-mozilla-html:TRUE
url:www.aldia.com.mx
version:2.1
end:vcard


--------------070700050205080008050707--