PostgreSQL Database Forum

CREATE OR REPLACE FUNCTION schema._pg_object_getobjectlist(varchar) RETURNS refcursor AS ' DECLARE columnid int4; search_string varchar; temp refcursor; rc refcursor; BEGIN search_string := \'%\' || $1 || \'%\';

hi to everyone, I tried to create a function that includes a role creation with the rolename and password as parameters to be called by other function but the postgresql raises an error like that: ERROR: syntax error at or near "$1" SQL state: 42601 Character: 81 The function definition is: CREATE FUNCTION new_user (text,text) RETURNS...

I am trying to restore a postgre dump from a linux server to windows system bu t am not able to do it from pg_restore or pgadmin. in pgadmin it is saying not a valid archive and if we use pg_restore in command line then it is giving the following error “pg_restore: could not open input file: No such file or directory” is there a...

Hi I am using my c based application using libpq to connect to postgresql. I have a table called light. I want to collect the values of the table light into a varible condition so that I can check this condition if(condition ==3) and do some operation depending on this operation. Can someone guide me how this can be done. Regards MAK

Hi, we see a lot of I/O access and CPU usage when running postgres (8.2.3) on windows. This happens even with auto vaccuum off and all stats turned off. Is there a way to control this? For instance I remember seeing some option such as /numproc=1 in some forum but, I do not see that as an option for 8.2.3. Can you please suggest an equivalent...

Hi, we have recently migrated from MySQL to PostgreSQL as our embedded database. We are running into several performance issues compared to MySQL. I tried referring several sites and forums but, most of them provide tips only for postgres installed on a dedicated system. Any help on where to start to look for solutions would be greatly...

Can someone tell me what are the perfect way to backup a database and how to restore it?? thanks

I have a simple plpgsql function that loops using a cursor and performs inserts/updates on a couple of tables. When I run the SQL piecemeal in pgAdmin's SQL editor everything looks OK. However, the IF statement that uses FOUND within the loop seems to always false. Any constructive insights would be appreciated. DECLARE dcursor CURSOR...

hi friends, like oracle and sql server i want to create stored procedure in postgresql. suppose in sqlserver there is some keyword i.e CREATE PROCEDURE . but in postgresql i can't see this keyword. please send if any one knows . Thanks sshyd

I am creating a C# .NET application that uses a postgreSQL database that is on my machine locally. My problem is that I cannot figure out how to write the connectionString. I have searched the internet for the past 30 minutes trying everything I could find. Help? anyone? public class Connection { protected static SqlConnection...

hi can anybody give me the link to download the PostgreSQL Ver 7.4.5 (Windows version) I searched in the postgresql site but was not able find the download for the windows version

Hi all I have a problem Suppose i have two tables for ex AAA and BBB I want to just compare whether these two table has the same structure or not How can i do this Is there any qeury for that Thanks Prakash

I am executing the following queries: 1) begin; 1) delete from forum where id = 20; 1) insert into forum (id, name) values (20, 'test'); 2) delete from forum where id = 20; 1) commit; Queries marked with 1) are executed by process 1 and queries marked with 2) are executed by process 2.

I have a problem when upgrade to new version Postgres (v8.x.x) on Reh HAT 9.0. i was uninstall old version (Postgres 7.x.x) package with command rpm -e postgresqlxxxxx.rpm but only one package can't to erase : postgresql-libs-7xxxx.rpm bcause there are one package need this lib : perl-DBD-xxxxx. what can i do ? erase this package...

HI 2 u I’m trying to install PostgreSQL for windows XP, the version which I use is (postgresql-8-1.4-1). The problem is when I try to install it as a service I get an error message like this(Account error: Invalid username specified: logon failure: unknown user name or bad password). If I tried to install it with as not a service it works, but...

?How can I store an object defined in php in postgre sql

Hi, Thanks To Moderator for your valuable and Quick reply. I would like to start more than one transaction in single database connection using libpq 'c' interface. let explian me this one detail. here I have started Transaction 'T1' and without ending that transaction again I would like to start another transaction 'T2'. How can I achieve...

Why does the following problem occur ? external error : 08003 connection exception : connection does not exist. In my application, several processes are connection to database server. But once a while one of the processes encounter the above error and subsequently, that module remains blocked onto that query. How can this be overcome?

Hi every one Pl look into the situation Tables Product(maker, model, type) PC(code, model, speed, ram, hd, cd, price) Laptop(code, model, speed, ram, hd, screen, price) Printer(code, model, color, type, price)

hi friends, I would like to know the number of connections made with a particular database and at the same time i like to restrict the number of connections from my VC++ Application. I am Using yhe 'libpq' interface. Is it there any way to do this. ThanQ

Hi all I have a table in which i have following values id name grade city 1 aaa A hyd 2 bbb B che 3 ccc C del 4 ddd A hyd 5 eee C che

I have an .asp page that passes four variables to another .asp page by using an HTML form. A SQL query then runs against an Access database using those four variables. The variables are: "cnty", "rte", "bgn", and "nd". My current SQL statement is as follows: SQL = "SELECT * FROM Construction WHERE County='" & cnty & "' AND Route='" &...

can some one plz tell me how to merger two strings in PostgreSQL OR pl/Pgsql

Hi guys...need help here ... My problem is about pagination like <<PREV 1,2,3,4,5,6 NEXT>> Does LIMIT Function applicable in PostgreSQL? $SQL="SELECT * FROM TABLE1 LIMIT 0,5"; the sql above works in MySQL but in PostgreSQL failed... any idea how or whats the alternative way? or i just miss something?

hi i am having problem using transactions inside a function i have to insert records in two tables which have interdependent foreign keys. so the insertion should be done inside a transaction and i need to use a single stored procedure to do that. SO can someone help me by telling me how to use transactions inside a function or f...