pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems 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