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

Re: 'default nextval()' loses schema-qualification in dump ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: arnaud(dot)listes(at)codata(dot)eu
Cc: pgsql-odbc(at)postgresql(dot)org, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: 'default nextval()' loses schema-qualification in dump ?
Date: 2010-07-06 15:17:38
Message-ID: 28564.1278429458@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Arnaud Lesauvage <arnaud(dot)listes(at)codata(dot)eu> writes:
> As you have understood, I am not very savvy about postgresql's 
> internals, but from what you say my guess is that the problem is int the 
> psqlODBC is getting the default value of the sequence ?

I have no idea, because you haven't showed us what's happening, only
your oversimplified description of what's happening.  We really need to
see the exact SQL used to define the table (copy that from your dump,
perhaps) as well as the exact SQL used in the misbehaving insert
commands.

			regards, tom lane

In response to

Responses

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2010-07-06 18:24:55
Subject: Re: UPDATE statement value mutation
Previous:From: Arnaud LesauvageDate: 2010-07-06 15:02:43
Subject: Re: 'default nextval()' loses schema-qualification in dump ?

pgsql-general by date

Next:From: Thomas KellererDate: 2010-07-06 15:32:54
Subject: Re: SQL Query Help Please !
Previous:From: Sebastian RitterDate: 2010-07-06 15:13:36
Subject: Re: PostgreSQL trigger execution order

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