Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: Automatical...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 4 Topic 3053 of 3255
Post > Topic >>

Re: Automatically update sequence

by ognjen@[EMAIL PROTECTED] (Ognjen Blagojevic) Mar 28, 2008 at 05:39 PM

Alan Hodgson wrote:
> What you should do is fetch the next value from the sequence yourself
and 
> then use it in the insert. Or, if you're pre-loading existing data, load
it 
> and then set the sequence value afterwards.

I must use it in insert since it is an ex****t from MySQL database.

I understand that I can update the sequence afterwards, but I was just 
wondering is it possible that Postgres updates it automatically after I 
insert the data?

Regards,
Ognjen

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 4 Posts in Topic:
Automatically update sequence
ognjen@[EMAIL PROTECTED]   2008-03-28 16:54:11 
Re: Automatically update sequence
sdavis2@[EMAIL PROTECTED]  2008-03-28 12:28:58 
Re: Automatically update sequence
ahodgson@[EMAIL PROTECTED  2008-03-28 09:35:56 
Re: Automatically update sequence
ognjen@[EMAIL PROTECTED]   2008-03-28 17:39:43 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sun Oct 12 9:38:53 CDT 2008.