| From: | Thom Brown <thombrown(at)gmail(dot)com> |
|---|---|
| To: | Yadira Lizama Mue <ylizama(at)uci(dot)cu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: change of oid values? |
| Date: | 2009-11-25 19:00:27 |
| Message-ID: | bddc86150911251100k6f7e5bdcke72f355e67d34baa@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general |
2009/11/25 Yadira Lizama Mue <ylizama(at)uci(dot)cu>
> Hi,
> I'd like to know if the values of postgres's Oids can changes its values
> for the same object. I want to use them in my aplication, but I'm afraid
> they could change and I get errors.
>
> I use the field Oid of table pg_type to identify the type of a field in a
> query. It could bring me errors in the future? For example, the oid value
> associated to type int4 could change at any future time?
>
> Regards,
> Yadira
>
>
> Why don't you just use pg_typeof() to get the type? And if you want the
oid of the type, just do: pg_typeof(fieldname)::oid.
Regards
Thom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-11-25 20:27:50 | Re: BUG #5207: unable to start postgresql server services |
| Previous Message | Yadira Lizama Mue | 2009-11-25 18:49:35 | change of oid values? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2009-11-25 19:02:08 | Re: Re: I need help creating a composite type with some sort of constraints. |
| Previous Message | Bill Moran | 2009-11-25 18:56:45 | Re: limiting resources to users |