Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitb34f6ab

Browse files
committed
psql backward compatibility fix
For servers older than 8.3, sort display of child tables by relname insteadof oid::regclass::text, because the cast from regclass to text did not workback then. The older display may be slightly worse when different schemasare involved, but that should be rare enough.
1 parentba3fb57 commitb34f6ab

File tree

1 file changed

+5
-2
lines changed

1 file changed

+5
-2
lines changed

‎src/bin/psql/describe.c‎

Lines changed: 5 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
*
99
* Copyright (c) 2000-2009, PostgreSQL Global Development Group
1010
*
11-
* $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.222 2009/07/0719:05:57 petere Exp $
11+
* $PostgreSQL: pgsql/src/bin/psql/describe.c,v 1.223 2009/07/0720:32:20 petere Exp $
1212
*/
1313
#include"postgres_fe.h"
1414

@@ -1821,7 +1821,10 @@ describeOneTableDetails(const char *schemaname,
18211821
PQclear(result);
18221822

18231823
/* print child tables */
1824-
printfPQExpBuffer(&buf,"SELECT c.oid::pg_catalog.regclass FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid=i.inhrelid AND i.inhparent = '%s' ORDER BY c.oid::pg_catalog.regclass::text;",oid);
1824+
if (pset.sversion >=80300)
1825+
printfPQExpBuffer(&buf,"SELECT c.oid::pg_catalog.regclass FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid=i.inhrelid AND i.inhparent = '%s' ORDER BY c.oid::pg_catalog.regclass::text;",oid);
1826+
else
1827+
printfPQExpBuffer(&buf,"SELECT c.oid::pg_catalog.regclass FROM pg_catalog.pg_class c, pg_catalog.pg_inherits i WHERE c.oid=i.inhrelid AND i.inhparent = '%s' ORDER BY c.relname;",oid);
18251828

18261829
result=PSQLexec(buf.data, false);
18271830
if (!result)

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp