X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id C2D5BD1B561
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 25 Sep 2003 06:37:02 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 67892-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 25 Sep 2003 03:36:32 -0300 (ADT)
Received: from coig.katowice.pl (pluton.coig.katowice.pl [217.98.68.8])
	by svr1.postgresql.org (Postfix) with ESMTP id E8C94D1B54D
	for <pgsql-sql@postgresql.org>; Thu, 25 Sep 2003 03:36:29 -0300 (ADT)
Received: from [217.98.68.20] (HELO Mariuszb)
	by coig.katowice.pl (CommuniGate Pro SMTP 3.5.9)
	with SMTP id 135592 for pgsql-sql@postgresql.org;
	Thu, 25 Sep 2003 08:36:24 +0200
Message-ID: <005601c3832f$61fbcf60$930f10ac@win.coig.com>
From: =?iso-8859-2?Q?Przemys=B3aw_S=B3upkowski?=
	<przemyslaw.slupkowski@euro.coig.pl>
To: "Lista dyskusyjna pgsql-sql" <pgsql-sql@postgresql.org>
Subject: Sequenties in pgSQL 7.3.x
Date: Thu, 25 Sep 2003 08:36:42 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0053_01C38340.257FE470"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.5 tagged_above=0.0 required=5.0 tests=HTML_30_40,
	RCVD_IN_OSIRUSOFT_COM
X-Spam-Level: *
X-Archive-Number: 200309/297
X-Sequence-Number: 15275

This is a multi-part message in MIME format.

------=_NextPart_000_0053_01C38340.257FE470
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

Hi
I am using postgresql 7.3.x. I am upgrating a database PostgreSQL.=20
The main problem is how to change field last value in sequencde which exist=
s in database.
I created script to read this field and then I'm drop the table, do modific=
ation and i'm must change this value to another value.
But DBMS returns me message like that
ERROR:  You can't change sequence relation seq_id_seq
How to do this
------=_NextPart_000_0053_01C38340.257FE470
Content-Type: text/html;
	charset="iso-8859-2"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-2">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DVerdana size=3D2>Hi</FONT></DIV>
<DIV>I&nbsp;am using postgresql 7.3.x. I am&nbsp;upgrating a=20
database&nbsp;PostgreSQL. </DIV>
<DIV>The main problem is how to change field last value in sequencde which=
=20
exists in database.</DIV>
<DIV>I created script to read this field and then I'm&nbsp;drop the table, =
do=20
modification and i'm must change this value to another value.</DIV>
<DIV>But DBMS returns me message like that</DIV>
<DIV><FONT face=3DVerdana size=3D2>ERROR:&nbsp; You can't change sequence r=
elation=20
seq_id_seq</FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>How to do this</FONT></DIV></BODY></HTML>

------=_NextPart_000_0053_01C38340.257FE470--