Jim C. Nasby wrote:
On Tue, Jun 13, 2006 at 04:28:47PM -0400, [EMAIL PROTECTED] 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 plp
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> On Tue, Jun 13, 2006 at 04:28:47PM -0400, [EMAIL PROTECTED] 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
On Tue, Jun 13, 2006 at 04:28:47PM -0400, [EMAIL PROTECTED] 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 sequ
Jim C. Nasby wrote:
On Mon, Jun 12, 2006 at 04:51:18PM -0400, [EMAIL PROTECTED] wrote:
I am trying to move some data from an 8.0.7 instance to a 7.4.8
instance. I did a pg_dump and then did a pg_restore.
For the most part the data transferred through to the older instance but
I h
On Mon, Jun 12, 2006 at 04:51:18PM -0400, [EMAIL PROTECTED] wrote:
> I am trying to move some data from an 8.0.7 instance to a 7.4.8
> instance. I did a pg_dump and then did a pg_restore.
> For the most part the data transferred through to the older instance but
> I had problems with the sequence
Devi Munandar writes:
> MAPIDENTPGUSERNAME
> phpuserphpuserpostgres
With this setup you can connect if your OS user is "phpuser" and the user
you want to connect as is "postgres". So log in as "phpuser" on you OS
and run pg_restore with the option -U p
