Laurent ROCHE <[EMAIL PROTECTED]> writes:
> Not good because in that case pg_dump will generate code that can not run in
> 8.1 ... like :
>
> ALTER SEQUENCE ... OWNED BY
Dumps produced by version X of pg_dump have never been guaranteed to
load into earlier versions.
-Doug
--
>
Cc : Andreas Kretschmer <[EMAIL PROTECTED]>; pgsql-general@postgresql.org
Envoyé le : Jeudi, 18 Octobre 2007, 20h33mn 15s
Objet : Re: Re : [GENERAL] pg_dump SERIAL and SEQUENCE
Laurent ROCHE wrote:
> Yep, of course but what's the situation for people using 8.1 and
> pg_dump that
On Oct 18, 2007, at 1:02 PM, Andreas Kretschmer wrote:
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not
dropped, however
when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Laurent ROCHE wrote:
>> Yep, of course but what's the situation for people using 8.1 and
>> pg_dump that does not generate code with SERIAL ?
> They grab 8.2's pg_dump and connect with it to their 8.1 server, to
> generate a dump that does.
Actually, I
Laurent ROCHE wrote:
> Yep, of course but what's the situation for people using 8.1 and
> pg_dump that does not generate code with SERIAL ?
They grab 8.2's pg_dump and connect with it to their 8.1 server, to
generate a dump that does.
--
Alvaro Herrerahttp://www.C
é le : Jeudi, 18 Octobre 2007, 20h02mn 47s
Objet : Re: [GENERAL] pg_dump SERIAL and SEQUENCE
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
> Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped,
however
> when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
&
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
> Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped, however
> when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
> I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY does not exist ! ! !
Read this message: <[EMAIL PROTE
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> OK, I take note of this.
> I assume it's because you consider that pg_dump has only one role (to produce
> files to be used by pg_restore) and not two as I said in my previous email.
I agree that pg_dump has usefulness for creating schema documentation.
PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgsql-general@postgresql.org
Envoyé le : Vendredi, 2 Mars 2007, 19h18mn 17s
Objet : Re: Re : [GENERAL] pg_dump, serial
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> I have read the given links, and I understand the reasons.
> Sti
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> I have read the given links, and I understand the reasons.
> Still, I am a bit surprised to see no mention of this in the documentation of
> pg_dump. I would expect to see at least a line stating that the colum
> declared with SERIAL will transformed t
uting Froggy
- Message d'origine
De : Tom Lane <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : pgsql-general@postgresql.org
Envoyé le : Vendredi, 2 Mars 2007, 17h03mn 18s
Objet : Re: [GENERAL] pg_dump, serial
Laurent ROCHE <[EMAIL PROTECTED]> writes:
>
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> I understand (and I have read) that there have been changes and discussions
> about the way, pg_dump treats SERIAL columns in the latest versions(8.x).
> However, I have not been able to get a document explaining exactly what the
> changes are and what'
On Fri, Apr 22, 2005 at 04:44:05PM -0500, Michael Hipp wrote:
>
> Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table
> like this:
>
> CREATE TABLE cases (
> id serial PRIMARY KEY,
>
> Works fine, but when I pg_dump the database, what shows up in the dump is:
>
> CREAT
Michael Hipp <[EMAIL PROTECTED]> writes:
> Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table
> like
> this:
> CREATE TABLE cases (
> id serial PRIMARY KEY,
> Works fine, but when I pg_dump the database, what shows up in the dump is:
> CREATE TABLE cases (
> id
14 matches
Mail list logo
