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

pg_dump(all) and views, broke

From: Terry Mackintosh <terry(at)terrym(dot)com>
To: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: pg_dump(all) and views, broke
Date: 1998-11-25 17:26:29
Message-ID: Pine.LNX.3.95.981125121616.6676A-100000@terry1.acun.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi all

CREATE RULE "_RETmessages" AS ON SELECT TO "messages" DO INSTEAD SELECT
"title", "mess", "iurl", "lurl", "posted", "fname", "lname", "email",
"uid", "ppid", "pid", "bid" FROM "post", "users" WHERE "uid" = "uid";
ERROR:  Column uid is ambiguous

It left off the table names from 'WHERE "uid" = "uid";'

I do not profess to understand all this rule stuff, but I don't understand
why when I create a view using 'create view ....', then why does pg_dump
need to create the view as a table, then later create a rule to make the
table into a view?  Why not just dump a 'create view ....' command
instead?  Not that it matters, as long as it works, just seems confusing
is all.

Thanks, have a great day.
Terry Mackintosh <terry(at)terrym(dot)com>          http://www.terrym.com
sysadmin/owner  Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.4
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!


Responses

pgsql-hackers by date

Next:From: Jan WieckDate: 1998-11-25 17:31:22
Subject: Re: [HACKERS] pg_dump(all) and views, broke
Previous:From: Tom LaneDate: 1998-11-25 16:09:08
Subject: Re: [HACKERS] 6.4.x

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