Search results for query: *

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

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...

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...

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.

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

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...

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

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.

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...

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...

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...

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...

hi there. it's me again. i'm encountering some problems to determine the insert, update and delete process in a function. currently i'm writing a function to update a column in a table called myflag. If the process is an INSERT then myflag will be udpated with 'I'. If the process is update...

sorry to bother u ppl again. another question. is it possible to execute a shell command in pl/pgsql function? please advice . and i really appreciate for those of u who replied to my thread. thanks a lot. good day.

is it possible for me to run the command Create user under a function. let's say i would like to built a function that incorporates this command. if can how can i do it coz i've been getting some errors when performing the create user command. but when i'm performing insert or update in a...

hi. it's me again =). can i know where is the data files for postgresql databases are stored? as i know when i do pg_dump, it's asking me to dump the path /usr/local/pgsql/data'. but inside the directory, i din c any meaningful data file names? thanks in advance. as for the pg_dump problem i...

I've installed Red Hat 8.0 with the SQL package. Later i found out that the version for postgresql in the sql package is 7.2.2. Then I installed version 7.3.1. now the problem i'm facing is, i can't use the pg_dump command coz it's giving me this error "pg_dump: server version...

can i know how to change the password for postgres? issit possible? coz i think the password when i first use it is null. thanks in advance.

Hi there. I need some help here. When i refresh my report in Excel, I encountered this error - 'An unexpected error has occurred' in Microsoft Excel 2000. The funny thing is, it only happens on Windows 98 machines and not on Windows NT Client machines. Therefore, I assume that, nothing is...

hi there. i'm new to developer 2000. just started 2 weeks ago. can i know how to delete an element in a listbox. i saw an example given, they fix the list index, which was not what i want. Thanks for the advice.