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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. totti24

    Mirroring n Fail Over

    hi guys, can postgreSQL perform mirroring or fail over?? or is there any 3rd party tool that i can use to perform these tasks when a database server fails? please advice.. thanks in advance
  2. totti24

    Database Sizing

    i also totally agree with u guys. actually we are in the process of bidding for a project. the reason y they are asking me to do the database size estimation is to know what kind of hardware setup is required for the database server, such as HD, RAM and no of processors. another word for it is...
  3. totti24

    Database Sizing

    hi guys, this is the first time i'm posting a question regarding Oracle9i. i need help about database sizing? can i know how am i suppose to estimate the size of my so-called "future database"?? i don know what my table are yet therefore i can calculate any data blocks. all i have is...
  4. totti24

    Backup question

    hi guys, some questions i would like to ask: 1. when i do a backup, will the user ids be backup as well? 2. another thing is, is it recommended to create a database with a lot of schemas? let's say around 20++. my scenario is like this. i will be handling a database that stores data for...
  5. totti24

    how to store image?

    hi all. just wondering whether sql server can store images or not? if can, how am i suppose to do the inserting process. for e.g if i'm to insert a record i will write a statement insert into ........ but for images, how to insert? thanks in advance.
  6. totti24

    Clustering??

    i know there's a clustering process (probably initialization process) to create the data directory. i want to know whether postgresql can do database clutering or not? like the RAC in Oracle where if one db server is down, automatically another db server will take over. therefore there's no...
  7. totti24

    Clustering??

    does postgresql supports clustering like oracle did? if so where can i get some info about it? thanks in advance
  8. totti24

    Report problem

    but all my tables are created with OIDs. how can i change it to WITHOUT OIDs. coz as far as i'm concern, the alter command doesn't allow that. plz advice.
  9. totti24

    Report problem

    hi all, i'm trying to build a report using excel's pivot table function. and the db i'm using is postgresql 7.3.1. i got a problem retriving data from the db bcoz i got this error mesg "No such attribute item.oid". if i retrieve directly from a table in postgresql, it doesn't give me...
  10. totti24

    how to determine whether process is insert, update or delete?

    hi guys, thanks for all the replies. i managed to work the thing out by using TG_OP var. i manage to detect whether the operation is an insert, update or delete by using TG_OP var. now the thing is working perfectly =). probably i made some mistakes early on. cheers...
  11. totti24

    how to drop a foreign key in a table ???

    i would like to know how to drop a foreign key from a table in postgresql????
  12. totti24

    Storing pictures

    hi people, is postgreSQL able to store data in jpeg or gif format?? if so, wat type of data type that i can use to store the pictures? thanks in advance.
  13. totti24

    how to upgrade?

    ok. thanks..
  14. totti24

    how to upgrade?

    hi all. i might be asking a stupid question here. but anyway how to upgrade my postgresql from 7.3.1 to 7.3.2?? coz the size of the file i downloaded is almost the same as ver. 7.3.1 (only a bit bigger for 7.3.2). issit a different set of installation file or i just need to tar it and it will...
  15. totti24

    Create user problem in function

    hi all, i'm encountering one big problem. and i would appreciate it if someone can give me some hints or idea. it happens like this, when i use the CREATE USER ... WITH PASSWORD command in the psql command prompt to create a user, i manage to create it. then i \q from pgsql and log into one of...
  16. totti24

    some questions ...

    i've created a table based on the logic provided. but i can't seem to describe my table. the error i got is "Relation pg_relcheck does not exist".
  17. totti24

    some questions ...

    cannot coz that column can only consist of 3 values which are N,A and R. and the default value should be N. any updates will make the field change to either A or R. hope u understand what i'm trying to say here. =)
  18. totti24

    some questions ...

    hi all, can i know how to set a column in a table to consist only certain values? i've use the check contraint when creating the table. but once i have created the table, i cant describe it. it says that my pg_relcheck doesn't exist. i've use the ddl below create table test (field1...
  19. totti24

    how to determine whether process is insert, update or delete?

    hi leland123, if i use the timestamp field, how do i know whether the row is an update or insert? do i still need a flag to determine it? bcoz in my tables, there will be 3 extra fields, which is audit_user, audit_date and the flag. hope u can advice me more on this. thx.
  20. totti24

    something wrong?

    create or replace function add_user() returns opaque as ' declare varname begin select myname into varname from table where myname = NEw.myname; raise notice ''user name %'',varname; update table set myage = 20 where myname = varname; return new; end; can i know what is wrong with the above...

Part and Inventory Search

Back
Top