| |
thread by: rajeev85 |
last post Apr 8 '07 by: rajeev85
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 || \'%\';
|
thread by: jsmith31 |
last post Apr 8 '07 by: michaelb
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...
|
thread by: ranganathanp |
last post Apr 5 '07 by: michaelb
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...
|
thread by: makhan |
last post Apr 5 '07 by: michaelb
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
|
thread by: Nirmal Ferrer |
last post Apr 5 '07 by: michaelb
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...
|
thread by: Nirmal Ferrer |
last post Apr 5 '07 by: michaelb
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...
|
thread by: sebouh181 |
last post Apr 5 '07 by: michaelb
Can someone tell me what are the perfect way to backup a database and how to restore it??
thanks
|
| |
thread by: kkoster |
last post Apr 3 '07 by: jshanab
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...
|
thread by: subbaraos |
last post Apr 3 '07 by: michaelb
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
|
thread by: smurphy811 |
last post Apr 2 '07 by: nmadct
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...
|
thread by: ranganathanp |
last post Apr 2 '07 by: michaelb
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
|
thread by: 123456prakash |
last post Mar 28 '07 by: michaelb
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
|
thread by: math1985 |
last post Mar 27 '07 by: michaelb
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.
|
thread by: zaky |
last post Mar 24 '07 by: zaky
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...
|
thread by: elsheh |
last post Mar 23 '07 by: michaelb
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...
|
| |
thread by: sreekantan |
last post Mar 23 '07 by: michaelb
?How can I store an object defined in php in postgre sql
|
thread by: gouse |
last post Mar 19 '07 by: michaelb
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...
|
thread by: manwanirg |
last post Mar 16 '07 by: michaelb
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?
|
thread by: gazeatvara |
last post Mar 16 '07 by: michaelb
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)
|
thread by: gouse |
last post Mar 14 '07 by: michaelb
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
|
thread by: 123456prakash |
last post Mar 14 '07 by: michaelb
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
|
thread by: valntyn via DBMonster.com |
last post Mar 9 '07 by: HansH
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='" &...
|
thread by: gauravgmbhr |
last post Mar 9 '07 by: ronverdonk
can some one plz tell me how to merger two strings in PostgreSQL OR pl/Pgsql
|
| |
thread by: exoskeleton |
last post Mar 8 '07 by: michaelb
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?
|
thread by: gauravgmbhr |
last post Mar 6 '07 by: gauravgmbhr
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...
|