Skip site navigation (1) Skip section navigation (2)

Re: pg_dump/restore problem

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: "renneyt(at)yahoo(dot)com" <renneyt(at)yahoo(dot)com>
Cc: postgres <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_dump/restore problem
Date: 2006-06-13 23:02:42
Message-ID: 20060613230242.GO34196@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Jun 13, 2006 at 04:28:47PM -0400, renneyt(at)yahoo(dot)com wrote:
> Does  pg_get_serial_sequence()  exist as plpgsql code? Where may I find 
> it? I would like to retrofit it into a 7.4.8 PG database.

No, but it shouldn't be terribly hard to do it in plpgsql; you just need
to build the right sequence name (assuming you haven't been messing with
the sequence names).
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2006-06-14 02:08:56
Subject: Re: pg_dump/restore problem
Previous:From: renneyt@yahoo.comDate: 2006-06-13 20:28:47
Subject: Re: pg_dump/restore problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group