Later patch has been added to the PostgreSQL unapplied patches list at:
http://momjian.postgresql.org/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Andrew Dunstan wrote:
>
> This is a totally trivial patch for something that was a very minor nit that
> annoyed me the other day while I was documenting my current project. It
> makes pg_dump use the same layout for types as for tables, by putting "\n\t"
> before the first field and "\n" before the final ");"
>
> Can't really justify this too much except to say I had an itch and I
> scratched it ;-)
>
> cheers
>
> andrew
>
>
>
> *** pg_dump.c~ 2003-06-25 00:08:19.000000000 -0400
> --- pg_dump.c 2003-07-17 15:34:52.000000000 -0400
> ***************
> *** 3412,3418 ****
> i_attname = PQfnumber(res, "attname");
> i_atttypdefn = PQfnumber(res, "atttypdefn");
>
> ! appendPQExpBuffer(q, "CREATE TYPE %s AS (",
> fmtId(tinfo->typname));
>
> for (i = 0; i < ntups; i++)
> --- 3412,3418 ----
> i_attname = PQfnumber(res, "attname");
> i_atttypdefn = PQfnumber(res, "atttypdefn");
>
> ! appendPQExpBuffer(q, "CREATE TYPE %s AS (\n",
> fmtId(tinfo->typname));
>
> for (i = 0; i < ntups; i++)
> ***************
> *** 3423,3433 ****
> attname = PQgetvalue(res, i, i_attname);
> atttypdefn = PQgetvalue(res, i, i_atttypdefn);
>
> ! if (i > 0)
> ! appendPQExpBuffer(q, ",\n\t");
> ! appendPQExpBuffer(q, "%s %s", fmtId(attname), atttypdefn);
> }
> ! appendPQExpBuffer(q, ");\n");
>
> /*
> * DROP must be fully qualified in case same name appears in
> --- 3423,3431 ----
> attname = PQgetvalue(res, i, i_attname);
> atttypdefn = PQgetvalue(res, i, i_atttypdefn);
>
> ! appendPQExpBuffer(q, "\n\t%s %s", fmtId(attname),
> atttypdefn); }
> ! appendPQExpBuffer(q, "\n);\n");
>
> /*
> * DROP must be fully qualified in case same name appears in
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
>
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
