Oliver Elphick <[EMAIL PROTECTED]> writes:
>>> 3. A view is being created before one of the tables it refers to.
> While I don't think that the oids have wrapped round, the oid of the
> table in question is larger than the oid of the view. It is quite
> likely that the table was dropped and rec
On Sat, 2002-09-21 at 19:49, Tom Lane wrote:
> > 3. A view is being created before one of the tables it refers to.
>
> On thinking about it, I'm having a hard time seeing how that case could
> arise, unless the source database was old enough to have wrapped around
> its OID counter. I'd be inte
Awhile back, Oliver Elphick <[EMAIL PROTECTED]> wrote:
> I am trying to populate a 7.3 database from a 7.2 dump. I used 7.3's
> pg_dumpall, but this did not handle all the issues:
> 1. The language dumping needs to be improved:
This is now fixed.
> 2. Either casts or extra default conversions
On Thu, 2002-09-12 at 00:52, Philip Warner wrote:
> At 12:31 PM 9/09/2002 +0100, Oliver Elphick wrote:
> >3. A view is being created before one of the tables it refers to.
> >Should not views be created only at the very end?
>
> This would be trivial (and we already put several items at the end),
At 12:31 PM 9/09/2002 +0100, Oliver Elphick wrote:
> CREATE FUNCTION plperl_call_handler () RETURNS opaque
>^^
> AS '/usr/local/pgsql/lib/plperl.so', 'plperl_call_handler'
> LANGUAGE "C";
...
> CREATE TRUSTED PROCEDUR
At 12:31 PM 9/09/2002 +0100, Oliver Elphick wrote:
>3. A view is being created before one of the tables it refers to.
>Should not views be created only at the very end?
This would be trivial (and we already put several items at the end), but I
am not sure it would fix the problem since views can
I am trying to populate a 7.3 database from a 7.2 dump. I used 7.3's
pg_dumpall, but this did not handle all the issues:
1. The language dumping needs to be improved:
CREATE FUNCTION plperl_call_handler () RETURNS opaque
^^
AS '
