[GENERAL] Extract from text id other table - PG 9.1

Hi guys, I've got tableA with 3 columns. id(seriaL) | type(character varying(256)) | string(character varying(256)) I have the type/string value stored in another table, and from that i would like to get the id. Example: http://dbfiddle.uk/?rdbms=postgres_9.6=15c571caa36876f00a0a2eaace703a2b

Re: [GENERAL] Unable to install EASM postgre due to error 8023

Hi Scott, Thank you so much for your prompt response. Have a great day ahead. *Regards, * *Garry Sim* Professional Service Consultant *NETRUST PTE LTD* 70 Bendemeer Road #05-03 Luzerne Singapore 339940 DID: +65 6212 1393 | Fax +65 6212 1366 |Website http://www.netrust.net

Re: [GENERAL] Unable to install EASM postgre due to error 8023

Hi Scott, Is there a difference between postgre and Entrust Authority Security Manager Postgresql Database? But even if end of support, anyway of letting me have a better understanding of the error code ? *Regards, * *Garry Sim* Professional Service Consultant *NETRUST PTE LTD* 70

Re: [GENERAL] Writing a C function to return the log file name

Kouber Saparev wrote: > I am trying to write a function in C to return the log file name by given > timestamp. I > will use that later to make dynamic creation of a foreign table (file_fdw) to > read the csv > logs themselves. The thing is I do now want to hardcode neither the format, > nor the

Re: [GENERAL] Extract from text id other table - PG 9.1

On Tuesday, June 6, 2017, Patrick B wrote: > > I have the type/string value stored in another table, and from that i > would like to get the id. > JOIN ON (expression) ? David J.

Re: [GENERAL] Redo the filenode link in tablespace

On 06/06/2017 02:07 PM, tel medola wrote: rai=# select oid, * from pg_class where oid = 5214493; result: oid | relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid

Re: [GENERAL] Redo the filenode link in tablespace

Lets go: In my plsql: rai=# select oid, * from pg_class where relfilenode = 5214489; Result: oid | relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid | relhasindex |

Re: [GENERAL] Redo the filenode link in tablespace

On 06/06/2017 04:40 AM, tel medola wrote: Lets go: In my plsql: rai=# select oid, * from pg_class where relfilenode = 5214489; I was looking for: select oid, * from pg_class where oid = 5214493; Result: oid | relname | relnamespace | reltype | reloftype | relowner | relam |

Re: [GENERAL] Redo the filenode link in tablespace

I will not be able to recover my information any more, right? 2017-06-06 10:37 GMT-03:00 Adrian Klaver : > On 06/06/2017 04:40 AM, tel medola wrote: > >> Lets go: >> In my plsql: >> rai=# select oid, * from pg_class where relfilenode = 5214489; >> > > I was looking

Re: [GENERAL] Redo the filenode link in tablespace

On 06/06/2017 11:09 AM, tel medola wrote: I will not be able to recover my information any more, right? That is what I am trying to figure out. The last error you got was: " Returns the error below: Missing chunk number 0 for toast value 10259186 in pg_toast_9277966 " This is related to the

Re: [GENERAL] Redo the filenode link in tablespace

rai=# select oid, * from pg_class where oid = 5214493; result: oid | relname | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid | relhasindex | relisshared | relpersistence |