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
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
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
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 in
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 updates.
SELECT
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
Hi admin
i have problem with user authentification
I've made a dump from PostgreSQL 7.2.2 under linux 8.0 with the command:
pg_dump -a -b -Fc -f bakstore -o -v store
and running success, and then i try to restore with the command:
pg_restore -a -d store -Fc -o -v bakstrore
and running
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