PostgreSQL Database Forum

So if you have been reading my threads you will see I could only get so far and couldn't connect two replicated databases together. When I searched for help on the 'net I found little. I get the impression most people don't use PostgreSQL Replicator. What do people use? I need a solution to handle replicating db's please.

I have a table with not nullable colunm from type char. I wont to convet column in type byte? How can I do it? Thanks,

This goes along, in some way, with my previous posting about books on functions. Is there something similar to the: SELECT * FROM table EXCEPTION WHEN NO_DATA_FOUND that can be used in Oracle? Also can you access "sqlcode" within the function? Thanks

Hi all; How can i catch end of the cursor? CREATE OR REPLACE FUNCTION "public"."fnc_rapthsbordro" (bastar date, bittar date, basmuk integer, bitmuk integer, basmak varchar, bitmak varchar, siralama varchar, tip boolean) RETURNS varchar AS $body$ declare intgelirkod integer; declare intgelirkod1 integer; declare gelircurs cursor for ...

ALTER TABLE castreq ADD COLUMN custno integer DEFAULT 0; the value of custno is "CLASS I"; can i use this statement in procudere my procedure is to add more columns in the table Please give the correct statement to add a column in procudure

Hello, I'm currently trying to decide on a database design for tags in my web 2.0 application. The problem I'm facing is that I have 3 separate tables i.e. cars, planes, and schools. All three tables need to interact with the tags, so there will only be one universal set of tags for the three tables. I read a lot about tags and the best...

postgres version 8.1.3, operating system redhat-enterprise 3 when selecting oid from tbl1, it returns nothing giving the message, "Column oid does not exist". plz any help will be appriciated

When connecting to postgresql datbase server, it says to many clients already. So what is the solution of this problem? and how can we view the client connections. Thanks, Ntech

I am trying to install PostgreSQL 8.2 on Windows XP. I get the message " The Port already in use" during installation and installation stops. When I stop the process related to Quick Heal (Anti-Virus Software) through Task Manager, the installation messaghe changed to "The data base directory is not empty". Even I uninstalled Quick Heal & Quick...

Hai, I have an Web-application developed with Oracle 10g at back end, Easy loader for Uploading Map and also make use of MapXtreme too. I would like to know what are the requirements to migrate from Oracle 10g to PostgreSQL. or Would PostgreSQL supports Easy Loader and MapXtreme.If no kindly suggest any other open source tools...

I'm looking for a good manual on stored functions in postgres. Other then using the postgres web site, I haven't really found something I can keep on my desk for a good reference. My current book "PostgresSql Developer's Handbook" should have stayed in the forest. Thanks for your help.

Hi everyone, I am new to PostgreSQL and trying to install it, My login account belongs to "Administrator Group" But I tried after creating newone as User Account(limited).. First i downloaded; postgresql-8.2.msi postgresql-8.2-int.msi upgrade.bat README.TXT

Hi all I am working on PostgreSQL-8.2.4 ,and OS of my system is fedora-6. There are other 3 systems ,having same OS(fedora-6) and we can connect them through ssh.Actually, i am new in postgresql .I have already installed postgreSQL-8.2.4 on my system successfully and working fine. But I do'nt have any idea that ,how can i make server-...

Ok. I have a bit of a dilemma here. First, please consider the following function: CREATE OR REPLACE FUNCTION recent_lab(text, labs, treatments) RETURNS float8 AS $BODY$select cast(substring(lab_result from ']*(.-]*)') as float) from labs b where $2.id = b.id and b.test = $1 and result ~ ']' and b.time < $3.time and b.time > $3.time -...

Hey Guys, I am still in a thinking stage and will like to learn from your experience, and was wondering if any of you folks have a hybrid environment i.e. Linux and Proprietary systems and what kind of issues do you run into. And also, what pieces of technology you have - which are open source and which ones you have are proprietary and any...

Dear All, I am having the latest version of PostgreSQL i.e. 8.4.2 and in order to increase the number of client connection I have increased the parameters "max_connections" and "shared_buffers" accordingly. However, I still get the same error "too many client connections". I know that there is some relation between the kernel parameters and...

I have a function written in postgresql that I want to create in sql server (UDF). After effort of full day I am seding this request to please help me, here is the function: CREATE OR REPLACE FUNCTION fn_comma_env(int4) RETURNS text AS $BODY$ DECLARE rec record; str text; comstr text; BEGIN

I have one db here and a copy of the db in another country. More often than not we lose the link between the other country. We need to find a solution to deal with the following. - To copy data from one field in a db to the other db using a trigger - can this be done with Postgres? - To determine if the link is down we use our own...

Hi team, I am creating a function that would accept an array of integer as its parameter. I have a table where one of its column is declared as an array. This is an excerpt from the script that I was creating: create or replace function insert_busshours(bigint, varchar, integer) returns integer as ' begin insert into...

Hi The Scripts team, I would like to know if there is a same function like bcp (for sybase and mssql 2k) for postgres? Is there any way that I can copy my csv datafile into the postgres database? For anyone who knows, thanks as always.

Hi all This my procedure, when i try to run the procedure it says "coitem_linenumber" is not a scalar variable. Can any one say what is the error and how i can correct it declare wotype CHARACTER; id integer;

Hi all , could you please sen me some sample scripts to convert dbf files to postgres .please help me in code i'm a beginner

Hai every body, i am using postgres 7.3 version, For a varchar (string) data column, in this column i filled the numbers (1,2,3 ...10,11,..... etc) alone. i sorted this column, but sorting values are comming 1,10,11,2,20.... etc like. but i need 1,2,3,10,22 like. please tell me the solution for this problem. thanks and regards,

hi all, i have a table with three columns. tran_event_cd, event_cd,party_cd. can i pass the column name in the function. create or replace function fn_one(int8,int8) returns setof tbl_one as '

Hi, I am trying to restore a dump from an earlier version of Postgre but it does not recognise the dump. The OK button in pgAdmin stays greyed out after choosing dump. Please help!