PostgreSQL Database Forum

Hi everyone, how to encrypt functions in Postgresql so i can hide all my business logic ? is there any option like with encryption present in MS SQL ? Regards, Yogesh.

Is it possible to read postgres sql connection string by coding it in C#? Im trying to make a system that will automatically read postgres sql connection string when the program loads. Im always using different computers and always changing my password to adopt to postgres. Im thinking is it possible?

hello every one i have aproblem in postgresql programm it was running easily and right but suddenly it isn't work when i make connect to server it appear connection failed any one have asolution to this problem please

I am having a problem in displaying the image. Image is stored perfectly but not able to retrieve and display...i tried to knowledge but still not able to get it.. my code is: display.php <img src="displayimg.php?co=<?php echo $t;?>"> \\$t is some id value i am sending to displayimg.php displayimg.php

I am having table which contains 2 columns (qid,round) and both columns can have repeated values but one constraint is for each 'round' the 'qid' values should not be repeated. example: round:1,1,1,2,2 qid:1,2,3,1,2---should be unique for each round... can any body suggest me a query for this..??

Hi, I am trying to return a resultset from a function and not sure how to do it but below is the function I created. create or replace function sp_servicer_piechart_testing() returns varchar as $$ select top 10 * from data where r='xxx' $$

hi all, i'm using postgresql 8.0.0 and i want to use the lead and lag window functions but it says "function doesn't exist when i run the following command select lag(selling_rate,1,'0') from currency and i again run the following command select selling_rate, lead(selling_rate) over ( order by selling_rate asc) from currency then it...

Hi Please assist, I got an error from a server that's running PostgreSQL 7.3.4 on CentOS5 Problem started with the database not starting up showing the following error: LOG: database system was interrupted at 2010-04-19 07:55:47 SAST LOG: ReadRecord: unexpected pageaddr 44/E43D8000 in log file 68, segment 239, offset 4030464

I am using PostgreSQL 7.3.4 running on Redhat5 there is a table that has a broken row, but now I don't know which one is broken. the table has about 20974 pages. is there a command to find this because I used select commands like: select * from table order by column desc limit X ; select * from table order by column asc limit X; but as soon as...

Hi How would I fix an error below: server.log file :

I have two data base A, & B. If a table updated or inserted or deleted means then that data have to update in table which is in data base B. I tried with dblink module, it is not workig fully. One table only getting updated... If u know the the solution let me know it...

CREATE TABLE books ( book_id bigint, book_title varchar(100), CONSTRAINT books_book_id_pkey PRIMARY KEY (book_id) )WITH OIDS; CREATE TABLE authors ( id bigint,

I've a program running on a local machine which automatically pushes images from a camera to our webserver (linux/mysql) through FTP. I want to store those images in the database so I think I need some perlscript running as a deamon that looks for new incoming images. I tried to find a script which does the job but with no success. I've...

Hi I'm using the option \o to put the query output into a file. This task is scheduled to run every night. Is there a way to automatically put the current date at the end of the name of each file? Thanks

I've installed postgresql from source code successfully on opensuse11.2. and I launch gdb to debug postgresql. when I try to "run", I get the following result: "Starting program: /usr/local/pgsql/bin/postgres Missing separate debuginfo for /lib64/ld-linux-x86-64.so.2 Try: zypper install -C...

Hi all, I need to backup and restore a DB. In this particular case the data in the database is not important (strange hum...) but only the schema to put new data... I m thinking use the pg_dump: pg_dump -c -C -s schema > file.out With this i have in file.out the schema, correct?

Hello I'm a student and I'm tring to undestand the easier way to create a new index ( ARB-Tree ) into Postgres 8.4. I found information about all tables ( PG_AM , PG_CLASS ...) to use and I found some C code sample but I need information about this points : - What do I need to compile code in Windows XP ? - How can I debug code while I'm using...

Hi I am junior Database Administrator, I would like to know how to handle an error like below , please explain in simple terms . This error appears very often in our client's database (Postgres 7.3.4) running on Linux - CentOS : # cat /tmp/postgres.log LOG: database system was interrupted being in recovery at 2010-03-05 16:39:17 SAST...

Hi... I'm having trouble with my postgresql function and i'm using php script to access the function. I want to insert data into a table that consists of 25 columns through the function. But i only have two columns/fields in my php script that will insert into the table and the rest columns/fields are inserted through the function itself...

Hi everybody, Iam doing my project which is just like an online examination where many users write their exam and if they qualify they have to write another exam.so,my doubt is how should i maintain the tables for every round??every thing the answers by different users should be stored.I need to store the answers made for...

Hi Friends, I am working in Postgresql 8.3. In that I have one table A, this table contains number of attributes and we already put indexing on Id, liveId attributes. But this table also contains the insertedDate and one more and very important things is that in every seconds approx 30 hits occurred in this table. When we are fetching the...

I have a BEFORE UPDATE trigger on a table that calls the tsvector_update_trigger() built in function to update a tsvector field. Since this trigger is called for every update to the table, the trigger function will be called even when the tsvector related field is not updated. My question is, does the index on that tsvector column get updated...

I am trying to develop a sales report coming off our postgresql server and am rumming into some problems. Basically I just want to group by the customer name and view a customers orders and sales from the previous month compared to the current month. I know in Access I could use an IIF command, but it isn't supported in Postgres. I think I need...

I m working on postgresql8.2.4 and struts. Earlier a report based on join queries was displayed faster. But as the no. of records go on increasing the report is not displayed completely. I tried to increase the shared_buffer parameter in postgresql.conf. But it didn't help much . Please guide me . Its urgent. Thanx n regards, Aradhana

hi all, can i pass field name of a table as a parameter in a function created in postgres, what i mean is i have one table :student with field names id name add. can i create a function where i can pass either of the fieldname as a parameter. so that 1 function can be used for either of the conditions.