From bcld@hotmail.com Thu Feb  11 13:36:42 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 8F212632A9A;
	Thu, 11 Feb 2010 09:36:42 -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 30410-10; Thu, 11 Feb 2010 13:36:23 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from snt0-omc1-s33.snt0.hotmail.com (snt0-omc1-s33.snt0.hotmail.com
	[65.55.90.44])
	by mail.postgresql.org (Postfix) with ESMTP id 389126327C9;
	Thu, 11 Feb 2010 09:36:31 -0400 (AST)
Received: from SNT110-W49 ([65.55.90.8]) by snt0-omc1-s33.snt0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Thu, 11 Feb 2010 05:36:29 -0800
Message-ID: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_5045f853-6c73-4ed7-b6aa-158bb52c2d87_"
X-Originating-IP: [190.39.84.72]
From: Luis Dominguez <bcld@hotmail.com>
To: "pgsql-es-ayuda@postgresql.org" <pgsql-es-ayuda@postgresql.org>,
	"vepug@postgresql.org" <vepug@postgresql.org>, "pgsql-admin@postgresql.org"
	<pgsql-admin@postgresql.org>
Subject: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
Date: Thu, 11 Feb 2010 13:36:29 +0000
Importance: Normal
MIME-Version: 1.0
X-OriginalArrivalTime: 11 Feb 2010 13:36:29.0051 (UTC)
	FILETIME=[371DB4B0:01CAAB1F]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201002/92
X-Sequence-Number: 33695

--_5045f853-6c73-4ed7-b6aa-158bb52c2d87_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




Good
morning=2C 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=2C and this field is
paramount in my application for purposes of monitoring=2C postgresql 8.4
now also have the same timestamp but refers to other data (date +
time)=2C I investigated other
types of data such as (serial=2C uuid=2C xid=2C byte etc) in postgresql and
not get something just to replace it=2C I thought of a function that do
something similar but not yet tried=2C and of course I turn to you to see
if I can lend a hand with this rut that I have right now ....=A1





From: bcld@hotmail.com
To: pgsql-es-ayuda@postgresql.org=3B vepug@postgresql.org=3B pgsql-admin@po=
stgresql.org
Subject: REF : MIgracion de datos ms sql server 7.0 a Postgresql 8.4 en Lin=
ux
Date: Thu=2C 11 Feb 2010 12:58:46 +0000








=20

Buenos dias=2C estoy en estos momentos en un  proceso
de migracion de una base de datos de un manejador ms sql server 7.0  a
postgresql vesion 8.4 pero tengo un problema con un tipo de dato el
(timestamp) que en sql server 7.0  se refiere a un campo binario unico
que se actualiza en forma aleatoria por fila =2C y este campo es
primordial en mi aplicacion para efectos del seguimiento=2C ahora en
postgresql 8.4 tambien tengo el mismo timestamp pero se refiere a otro
tipo de dato (fecha+hora )=2C he investigado otros tipo de datos tales
como (serial=2C uuid=2Cxid=2C bytea etc)en postgresql y no consigo algo igu=
al para
sustituirlo=2C he pensado en una funcion que realice algo parecido pero
todavia no lo intento=2C y por supuesto recurro a ustedes para ver si me
pueden echar una mano con este bache que tengo ahorita ....=A1

Saludos
Luis Dominguez 		 	   		 =20
  		 	   		 =20
_________________________________________________________________


--_5045f853-6c73-4ed7-b6aa-158bb52c2d87_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
<br><br><span id=3D"result_box" class=3D"long_text"><span style=3D"backgrou=
nd-color: rgb(255=2C 255=2C 255)=3B" title=3D"Buenos dias=2C estoy en estos=
 momentos en un proceso de migracion de una base de datos de un manejador m=
s sql server 7.0 a postgresql vesion 8.4 pero tengo un problema con un tipo=
 de dato el (timestamp) que en sql server 7.0 se refiere a un" onmouseover=
=3D"this.style.backgroundColor=3D'#ebeff9'" onmouseout=3D"this.style.backgr=
oundColor=3D'#fff'">Good
morning=2C 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 </span><span styl=
e=3D"background-color: rgb(255=2C 255=2C 255)=3B" title=3D"campo binario un=
ico que se actualiza en forma aleatoria por fila =2C y este campo es primor=
dial en mi aplicacion para efectos del seguimiento=2C ahora en postgresql 8=
.4 tambien tengo el mismo timestamp pero se refiere a otro tipo de dato (fe=
cha+hora )=2C he investigado" onmouseover=3D"this.style.backgroundColor=3D'=
#ebeff9'" onmouseout=3D"this.style.backgroundColor=3D'#fff'">single
binary field that is updated randomly by row=2C and this field is
paramount in my application for purposes of monitoring=2C postgresql 8.4
now also have the same timestamp but refers to other data (date +
time)=2C I investigated </span><span style=3D"background-color: rgb(255=2C =
255=2C 255)=3B" title=3D"otros tipo de datos tales como (serial=2C uuid=2Cx=
id=2C bytea etc)en postgresql y no consigo algo igual para sustituirlo=2C h=
e pensado en una funcion que realice algo parecido pero todavia no lo inten=
to=2C y por supuesto recurro a ustedes para ver si" onmouseover=3D"this.sty=
le.backgroundColor=3D'#ebeff9'" onmouseout=3D"this.style.backgroundColor=3D=
'#fff'">other
types of data such as (serial=2C uuid=2C xid=2C byte etc) in postgresql and
not get something just to replace it=2C I thought of a function that do
something similar but not yet tried=2C and of course I turn to you to see
if </span><span style=3D"background-color: rgb(255=2C 255=2C 255)=3B" title=
=3D"me pueden echar una mano con este bache que tengo ahorita ....=A1" onmo=
useover=3D"this.style.backgroundColor=3D'#ebeff9'" onmouseout=3D"this.style=
.backgroundColor=3D'#fff'">I can lend a hand with this rut that I have righ=
t now ....=A1</span></span><br><br><br><br><br><br><hr id=3D"stopSpelling">=
From: bcld@hotmail.com<br>To: pgsql-es-ayuda@postgresql.org=3B vepug@postgr=
esql.org=3B pgsql-admin@postgresql.org<br>Subject: REF : MIgracion de datos=
 ms sql server 7.0 a Postgresql 8.4 en Linux<br>Date: Thu=2C 11 Feb 2010 12=
:58:46 +0000<br><br>



<style>
.ExternalClass .ecxhmmessage P
{padding:0px=3B}
.ExternalClass body.ecxhmmessage
{font-size:10pt=3Bfont-family:Verdana=3B}
</style>


&nbsp=3B<br><br>Buenos dias=2C estoy en estos momentos en un&nbsp=3B proces=
o
de migracion de una base de datos de un manejador ms sql server 7.0&nbsp=3B=
 a
postgresql vesion 8.4 pero tengo un problema con un tipo de dato el
(timestamp) que en sql server 7.0&nbsp=3B se refiere a un campo binario uni=
co
que se actualiza en forma aleatoria por fila =2C y este campo es
primordial en mi aplicacion para efectos del seguimiento=2C ahora en
postgresql 8.4 tambien tengo el mismo timestamp pero se refiere a otro
tipo de dato (fecha+hora )=2C he investigado otros tipo de datos tales
como (serial=2C uuid=2Cxid=2C bytea etc)en postgresql y no consigo algo igu=
al para
sustituirlo=2C he pensado en una funcion que realice algo parecido pero
todavia no lo intento=2C y por supuesto recurro a ustedes para ver si me
pueden echar una mano con este bache que tengo ahorita ....=A1<br><br>Salud=
os<br>Luis Dominguez 		 	   		  <br><hr> <a href=3D"http://"></a> 		 	   		=
  <br /><hr /> <a href=3D'' target=3D'_new'></a></body>
</html>=

--_5045f853-6c73-4ed7-b6aa-158bb52c2d87_--



From Kevin.Grittner@wicourts.gov Thu Feb  11 15:06:49 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 7F6C063346B;
	Thu, 11 Feb 2010 11:06:49 -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 50400-10; Thu, 11 Feb 2010 15:06:29 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99])
	by mail.postgresql.org (Postfix) with ESMTP id F16D5632D64;
	Thu, 11 Feb 2010 11:06:37 -0400 (AST)
Received: from Courts-MTA by gw.wicourts.gov
	with Novell_GroupWise; Thu, 11 Feb 2010 09:06:35 -0600
Message-Id: <4B73C895020000250002F180@gw.wicourts.gov>
X-Mailer: Novell GroupWise Internet Agent 8.0.1 
Date: Thu, 11 Feb 2010 09:06:29 -0600
From: "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
To: "Luis Dominguez" <bcld@hotmail.com>,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	"pgsql-es-ayuda@postgresql.org" <pgsql-es-ayuda@postgresql.org>,
	"vepug@postgresql.org" <vepug@postgresql.org>
Subject: Re: REF: Data Migration MS SQL Server 7.0 to PostgreSQL 8.4 on Linux
References: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
In-Reply-To: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.724 tagged_above=-10 required=5 tests=AWL=-0.614,
	BAYES_05=-1.11
X-Spam-Level: 
X-Archive-Number: 201002/93
X-Sequence-Number: 33696

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



From imartinez@vectorsf.com Thu Feb  11 16:23:02 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id BA455632845
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	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 <pgsql-admin-postgresql.org@mail.postgresql.org>;
	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 <pgsql-admin@postgresql.org>; 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?= <imartinez@vectorsf.com>
To: <pgsql-admin@postgresql.org>
Cc: <bcld@hotmail.com>
References: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
In-Reply-To: <SNT110-W49AEC4F2267D5ACA7179D3C64E0@phx.gbl>
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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
p
	{mso-style-priority:99;
	mso-margin-top-alt:auto;
	margin-right:0cm;
	mso-margin-bottom-alt:auto;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";}
span.longtext
	{mso-style-name:long_text;}
span.EstiloCorreo19
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DES link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Hola Rafael.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>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.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If you don&#8217;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.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Espero haberte dado alguna idea.<o:p></o:p></span></p>

<p class=3DMsoNormal><span =
style=3D'font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p>&nbsp;</o:p></span></p>

<div>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt =
0cm 0cm 0cm'>

<p class=3DMsoNormal><b><span =
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'>De:</span></=
b><span
style=3D'font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Luis =
Dominguez
[mailto:bcld@hotmail.com] <br>
<b>Enviado el:</b> jueves, 11 de febrero de 2010 14:36<br>
<b>Para:</b> pgsql-es-ayuda@postgresql.org; vepug@postgresql.org;
pgsql-admin@postgresql.org<br>
<b>Asunto:</b> [ADMIN] REF: Data Migration MS SQL Server 7.0 to =
PostgreSQL 8.4
on Linux<o:p></o:p></span></p>

</div>

</div>

<p class=3DMsoNormal><o:p>&nbsp;</o:p></p>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><span =
style=3D'font-size:10.0pt;
font-family:"Verdana","sans-serif"'><br>
<br>
<span class=3Dlongtext><span style=3D'background:white'>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</span></span><br>
<br>
<br>
<o:p></o:p></span></p>

</div>

</body>

</html>

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



From jcenteno@aldia.com.mx Fri Feb  12 17:24:58 2010
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--