Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rski
  • Order by date
  1. rski

    How to implicitly allow update with no explicit grant

    You can use option SECURITY DEFINER when create function.
  2. rski

    Select on multiple servers

    Maybe use dblink module
  3. rski

    How convert array elements to rows?

    Sorry I forget the CODE tags. It looks better rski=> select i, (ARRAY[11,22,33])[i] from generate_series(1,array_upper(ARRAY[11,22,33],1)) i; i | array ---+------- 1 | 11 2 | 22 3 | 33 (3 rows)
  4. rski

    How convert array elements to rows?

    Like that rski=> select i, (ARRAY[11,22,33])[i] from generate_series(1,array_upper(ARRAY[11,22,33],1)) i; i | array ---+------- 1 | 11 2 | 22 3 | 33 (3 rows) If you know the dimension of a table you can replace array_upper with it.
  5. rski

    plperl problem

    I've installed postgres v. 8.2.4 with plperl support (--with-perl option with configure). But when I try to create plperl languge (createlang plperl) i've got an error createlang: language installation failed: ERROR: could not load library "/usr/ocal/pgsql/lib/plperl.so"...
  6. rski

    error when running trigger (TG_OP not recognized)

    Maybe just put TG_OP outside the quots
  7. rski

    Drop column only if it exists

    U mean how to do it with pl function? All information about database u can find in information_schema tables and views. With an IF statement and NOT FOUND 'constant' u can check if specified table contains given column. (see more on postgresql.org)
  8. rski

    insert or update in row level after insert or update trigger

    When u use triggers u have can use two additionals tables OLD and NEW inside functions. Maybe try to modify them. If u use after i think u should modify NEW and then return NEW.
  9. rski

    Relation "<table>" Does Not Exist

    I think u should write nextval('propack_order_order_id_seq'::text) (whitout quots)
  10. rski

    Where does Postgres store databases?

    I didn't user postgres under windows?, don't u use postgres under Cygwin?
  11. rski

    Where does Postgres store databases?

    The database cluster is the place where u'r tables, views etc lies (I gues u didn't use tablespaces). So u can try just copy hole cluster (environment variable PGDATA show u the cluster's path), but I don't now if it works (I didn't try it). The best way to move database is to backup it...
  12. rski

    Cannot get "WHERE" clause in query to work

    How do U write this query?
  13. rski

    Update multiple ranges of info

    My mistake of course update pay set pay_amount = 732 where (job between '0101' and '0116') or (job between '0118' and '0120') .....
  14. rski

    Update multiple ranges of info

    Maybe in this way update pay set pay_amount = 732 where job between ('0101' and '0116') or job between( '0118' and '0120') .....
  15. rski

    CREATE GLOBAL TABLE really supported?

    I think u have to use global or local with temp or temporary options ex. create global temporary table ...

Part and Inventory Search

Back
Top