pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problems with OIDs
7+ messages / 5 participants
[nested] [flat]

* Problems with OIDs
@ 2002-10-24 06:33 Carlos Garcìa Gòmez <garciagca@inta.es>
  2002-10-27 08:28 ` Re: Problems with OIDs Andrew McMillan <andrew@catalyst.net.nz>
  0 siblings, 1 reply; 7+ messages in thread

From: Carlos Garcìa Gòmez @ 2002-10-24 06:33 UTC (permalink / raw)
  To: pgsql-php


Hi all!

I've got the following problem: I had a view with OID 5330 that had to be
removed from the database, afterwards I created again a view (with the same
name, because I need it to be this way) and get the an error telling me that
the view with OID 5330 cannot be found, How can I solve it??

Thank u all!!




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Problems with OIDs
  2002-10-24 06:33 Problems with OIDs Carlos Garcìa Gòmez <garciagca@inta.es>
@ 2002-10-27 08:28 ` Andrew McMillan <andrew@catalyst.net.nz>
  2002-10-28 07:43   ` Re: Problems with OIDs Carlos García Gómez <almah@wanadoo.es>
  0 siblings, 1 reply; 7+ messages in thread

From: Andrew McMillan @ 2002-10-27 08:28 UTC (permalink / raw)
  To: Carlos Garcìa Gòmez <garciagca@inta.es>; +Cc: pgsql-php

On Thu, 2002-10-24 at 19:33, Carlos Garcìa Gòmez wrote:
> Hi all!
> 
> I've got the following problem: I had a view with OID 5330 that had to be
> removed from the database, afterwards I created again a view (with the same
> name, because I need it to be this way) and get the an error telling me that
> the view with OID 5330 cannot be found, How can I solve it??

You will have to recreate whatever referred to that view as well.

If this isn't sufficient answer, you'll need to provide more detail,
specifically what is it that you are doing when you get the error
message?

Cheers,
					Andrew.
-- 
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for free with http://survey.net.nz/ 
---------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Problems with OIDs
  2002-10-24 06:33 Problems with OIDs Carlos Garcìa Gòmez <garciagca@inta.es>
  2002-10-27 08:28 ` Re: Problems with OIDs Andrew McMillan <andrew@catalyst.net.nz>
@ 2002-10-28 07:43   ` Carlos García Gómez <almah@wanadoo.es>
  0 siblings, 0 replies; 7+ messages in thread

From: Carlos García Gómez @ 2002-10-28 07:43 UTC (permalink / raw)
  To: pgsql-php


> Hi all!
>
> I've got the following problem: I had a view with OID 5330 that had to be
> removed from the database, afterwards I created again a view (with the
same
> name, because I need it to be this way) and get the an error telling me
that
> the view with OID 5330 cannot be found, How can I solve it??

>>You will have to recreate whatever referred to that view as well.

>>If this isn't sufficient answer, you'll need to provide more detail,
>>specifically what is it that you are doing when you get the error
>>message?

>>Cheers,
>>					Andrew.


Ok, I will explain it better: first of all I had a view called
datos_u_candidato, this view was working fine and there wasn't any problem
with it; but I had to remove that view and, afterwards, I created it again,
with the same name, and then when I tried to use it with: "SELECT * FROM
datos_u_candidato;"

I've got the error: "The view with OID5330 cannot be found"

That's all, I don't know if this will be enough, anyway thank you all for
your previous requests.

Thanks!!




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Problems with OIDs
@ 2002-10-24 06:39 Carlos García Gómez <almah@wanadoo.es>
  2002-10-24 08:23 ` Re: Problems with OIDs Adrian Tineo <adriantineo@softhome.net>
  2002-10-24 08:42 ` Re: Problems with OIDs Jules Alberts <jules.alberts@arbodienst-limburg.nl>
  2002-10-24 10:17 ` Re: Problems with OIDs Andrew McMillan <andrew@catalyst.net.nz>
  0 siblings, 3 replies; 7+ messages in thread

From: Carlos García Gómez @ 2002-10-24 06:39 UTC (permalink / raw)
  To: pgsql-php


Hi all!

I've got the following problem: I had a view with OID 5330 that had to be
removed from the database, afterwards I created again a view (with the same
name, because I need it to be this way) and get the an error telling me that
the view with OID 5330 cannot be found, How can I solve it??

Thank u all!!




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Problems with OIDs
  2002-10-24 06:39 Problems with OIDs Carlos García Gómez <almah@wanadoo.es>
@ 2002-10-24 08:23 ` Adrian Tineo <adriantineo@softhome.net>
  2 siblings, 0 replies; 7+ messages in thread

From: Adrian Tineo @ 2002-10-24 08:23 UTC (permalink / raw)
  To: pgsql-php



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Problems with OIDs
  2002-10-24 06:39 Problems with OIDs Carlos García Gómez <almah@wanadoo.es>
@ 2002-10-24 08:42 ` Jules Alberts <jules.alberts@arbodienst-limburg.nl>
  2 siblings, 0 replies; 7+ messages in thread

From: Jules Alberts @ 2002-10-24 08:42 UTC (permalink / raw)
  To: pgsql-php

On 24 Oct 2002 at 8:39, Carlos García Gómez wrote:
> Hi all!
>
> I've got the following problem: I had a view with OID 5330 that had to be
> removed from the database, afterwards I created again a view (with the same
> name, because I need it to be this way) and get the an error telling me that
> the view with OID 5330 cannot be found, How can I solve it??

OID's change when you do a dump / restore. Never use hardcoded OIDs in
your app!



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: Problems with OIDs
  2002-10-24 06:39 Problems with OIDs Carlos García Gómez <almah@wanadoo.es>
@ 2002-10-24 10:17 ` Andrew McMillan <andrew@catalyst.net.nz>
  2 siblings, 0 replies; 7+ messages in thread

From: Andrew McMillan @ 2002-10-24 10:17 UTC (permalink / raw)
  To: Carlos García Gómez <almah@wanadoo.es>; +Cc: pgsql-php

On Thu, 2002-10-24 at 19:39, Carlos García Gómez wrote:
> Hi all!
> 
> I've got the following problem: I had a view with OID 5330 that had to be
> removed from the database, afterwards I created again a view (with the same
> name, because I need it to be this way) and get the an error telling me that
> the view with OID 5330 cannot be found, How can I solve it??

You need to redefine the thing that you do not mention which refers to
the view - possibly this may be another view.

When you recreate that, it will be created referencing the correct OID.

Regards,
					Andrew.
-- 
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for free with http://survey.net.nz/ 
---------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2002-10-28 07:43 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-24 06:33 Problems with OIDs Carlos Garcìa Gòmez <garciagca@inta.es>
2002-10-27 08:28 ` Andrew McMillan <andrew@catalyst.net.nz>
2002-10-28 07:43   ` Carlos García Gómez <almah@wanadoo.es>
2002-10-24 06:39 Problems with OIDs Carlos García Gómez <almah@wanadoo.es>
2002-10-24 08:23 ` Adrian Tineo <adriantineo@softhome.net>
2002-10-24 08:42 ` Jules Alberts <jules.alberts@arbodienst-limburg.nl>
2002-10-24 10:17 ` Andrew McMillan <andrew@catalyst.net.nz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox