PostgreSQL Database Forum

CREATE OR REPLACE FUNCTION f_customerlogininfo(varchar, varchar, varchar) RETURNS public.v_customerlogininfo AS ' DECLARE p_schm ALIAS FOR $1; p_contact ALIAS FOR $2; p_status ALIAS FOR $3; v_boolstatus boolean; BEGIN IF p_status = ''all'' THEN RETURN (select * from v_customerlogininfo where contact =...

hi all, I have a doubt in cursor.Can we use cursor for update query in procedures. I tried all the cursor concepts but i could not found it, So please help me in giving the syntax for the Update query using Curcor.

can we use the copy command to copy it in the local disk copy temp_swap TO ''c:\folder_name\";

Hey guys, for an enterprise wide deployment, what will you suggest and why among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you think, we can negotiate the support pricing down?

hai everyone, I am having a doubt in inserting data in time field. I am having a table in which in column in timestamp without time zone datatype. I want to insert a row into the table but that time field has no value if I insert omitting that column error occurs... for eg. CREATE TABLE blah ( uuid integer NOT NULL DEFAULT...

Hello I am working on PostgreSQL-8.2.4 ,and OS is fedora-6. There are other 3 systems ,having same OS(fedora-6) .Actually, i am new in postgresql .I have already installed postgreSQL-8.2.4 on my system successfully . But I do'nt have any idea that ,how can i make server- clients .There are 4 systems , I want make one system as a server and...

If some select statement has selected a single row with update lock in a transaction and there are more than one transactions running same query for same row with update lock then they are blocked until the first transaction gets completed. Now if i completes the first transaction then how the waiting two transactions will proceed. As i have...

Hi, I Have A Query Which Displyas All My User Table Names And Data Type. Now I Need A Function Which Will Read All The Table Name And Return A Insert Statement With Table Names. Pl's Suggest Some Solution. Req. Urgently

Hi , Does anyone know how to Export the data from postgresql to oracle ??

Hai, Im getting this error.There is a column by name "nr_first_name" in the table "gistl_new_request". Yet im getting as that dose not exist.Would like to now what is the cause of it. Thank You

hi I am having a startdate variable with timestamp datatype. I want to extract only the date from timestamp field........ select extract('hour' from timestamp '2001-02-16 20:38:40') this query extracts hour from the input in the same way is there any option for extracting only date. Please help as soon as possible.

Hi All , I have Implemented , MULTI MASTER REPLICATION using PGCluster-II as shown in http://pgcluster.projects.postgresql.org/1_3/sys_f.png It worked great for me. But , When I stop Cluster DB 1 , and insert rows into Cluster DB 2 and then start Cluster DB 1 , the previously inserted , rows into Cluster DB 2 were not show in Cluster DB...

So on the quest of trying to synch two or more db's I've had problems try to get two PSQL Replicator db's to connect. My requirements are as follows Two way comms - master / slave model wont work The "other" db is on another continent where the connection drops out all the time. Merging is not an issue - it must lock tables and / or...

Now I realise this might be out of scope for this forum, but maybe someone knows the answer. I've just started setting up a test PostgreSQL Replicator set of db's and when I run this command... select pgr_replica_table ('customers'); I get the following error - and yes pgrd (the daemon is running) ERROR: function...

what is the equivalent datatype in postgre for uniqueidentifier in sql . please help me

Hai, can anyone tel me what dose this error mean. 'more' is not recognized as an internal or external command, operable program or batch file.

Is there separate packages for server and client in postgresql ? In MySQL , there are separate packages for client and server ..In PostgreSQL also there are two separate packages for client and server??.... Thanks in Advance Chitranjan Singh.

what is postgreSQL explain the concept of it

Please help me:Is the Postgre replication is used for two master asynchronus replication.Is this suitable for postgresql 7.3 or 7.4 versions

hai please guide me how to append text in a forum that i had posted already.please help me i can't understand so please explain me the steps to be followed in a detailed manner. Advance Thanks, kirthika.

I want to apply a function to each of the values returned by another select statement. i.e if my fuction delete_subtree takes an integer and performs an operation (in this case deleting a node from a tree view), I want to do (this doesn't work) select delete_subtree(select node from tree where subject ~ 'poker')); to delete all records...

Hi all declare cnt integer; begin cnt=5; dbms_output.put_line(cnt); end;

Hai All, I want to import data from Oracle 10g to POstgreSQl 8.2.Would like to know if their is any way to import data from pgAdmin III. Thought of using Copy command,but for this the files needs to be either in Ascii or Binary formate. Kindly suggest me any means of importing data from oracle to postgres. Thank You

i am writing a function to return a table in the select query i am using a join and for some columns i want to give alias name but alias name given within" " is not accepting pls give me some suggestions as soon as possible select a.answer as "choice",a.answerno as "choiceno",q.questionid,q.answer as "answerno", q.solution,s.question from...

ALTER TABLE public.postcodes ALTER COLUMN machi TYPE varchar(100); Error: ERROR: syntax error at or near "TYPE"; Error while executing the query (State:42601, Native Code: 7) I am using WinSQL, Windows XP SP2 Japanese Version, PostgreSQL 8.x. I want to alter my machi field from varchar(30) to varchar(100) TYPE. This is my CREATE...