Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3 - Mailing list pgsql-general

From Patrick Baker
Subject Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3
Date
Msg-id CAJNY3ivB87P1VJtr9-YHBpvnNjcqQN0+UR0YN56mchVtNbET3A@mail.gmail.com
Whole thread Raw
In response to Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view


-- Creating the backup table with the essential data
 INSERT INTO table2 (row.note_id, row.size, row.file_id, row.full_path)

.....

Still not seeing what the JOIN to table3 t3 gets you?

Any way the function works.


I changed the function to use row.note_id, row.size, etc... think it's more intelligent that way! :)


 Is there any way to create another function to restore the data back?

Example:


select function_data_1_restore(123414);

Where 123414 = file_id

How can I tell the function to get the file_id that I'll insert into the call?
Can you please guys tell me?

cheers

pgsql-general by date:

Previous
From: Venkata Balaji N
Date:
Subject: Re: Slave claims requested WAL segment already removed - but it wasn't
Next
From: Nick Cleaton
Date:
Subject: Re: Slave claims requested WAL segment already removed - but it wasn't