PostgreSQL Database Forum

Hi all i am trying to write one update query which will update all rows. here i just want to write only one update statement to which i can pass arguments one by one. Is this Possible ??? Can i get count of arguments ???? thanks in advance

Hello, I am trying to understand inheritance and how to use it with PostgreSQL. For this reason i design a database in the excel file. In the 1st columns you can see the table w/o inheritance while in the 2nd part of the sheet you can see the tables with INHERITANCE. Can you give me your opinion and help on the following? 1. Which is the best...

I want to create 2 databases in 2 server and these have only one OID. Example: Server 1: database 'Test' with OID: 16384 Server 2: database 'Test' with OID: 16353 I want to edit OID of database Test on server 2 to 16384. How to do that? And how to create a database with fix OID??

Hi all, I am trying to get a PL/TCL trigger to update an audit table working. The problem is when I create the trigger on an exiting table, I get the following error "ERROR: can't read "tgname": no such variable CONTEXT: can't read "tgname": no such variable while executing ....." If I drop the table and then recreate the table and...

Hello, I want to use inheritance and I have created some tables for a program that I want to use it (see attachment). What is your opinion? Is it better to use the old way or inheritance? If I use inheritance, would it be good to use as PK for all table the ID field of LASTUPDATE table who will be the parent table of all? What is your opinion...

Hello! how to configure the replication in postgres databases please tell step by step configurations Regards, spnmuthu

ERROR: value too long for type character varying(8) ********** Error ********** ERROR: value too long for type character varying(8) SQL state: 22001 I used following script to add a Row: INSERT INTO tbluser(

Hi, I am having database in debian os. In that sum() giving expected output. I have changed my database from debian to lenny. In that sum() is not available. It shows the following error. Can any one help me to solve this ? user => SELECT cmp_id ,sum(*) as count from schedules group by cmp_id; ERROR: function sum() does not exist LINE 1:...

Hi, can anyone help me to figure this out. Currently, i have this code: select t_stamp, num from table where num in

I have tried to install postgreSQL on my WINDOWS 7 but it just does not seems to work. When installing, it stuck at "starting services". It says, "Service 'PostgreSQL Database Server 8.0.0-rc1' (pgsql-8.0.0-rc1) failed to start. Verify that you have sufficient privilleges to start system services." I have tried the solutions for Installing...

i have enabled these 1. extension=php_pdo_pgsql.dll 2.extension=php_pgsql extensions in php.ini file but i am unable to connect to the database iam facing an error Fatal error: Call to undefined function pg_connect() can any one help me!

Hi Forum, I'm trying to perform a type of concatenate function on a table and am not really sure where to start. I'd like to aggregate the values from 'field' on their ID. To explain, my table is like this: ID roadnum 1 A-1 2 B-1 2 E-1 3 N-1 4 N-3

hi dear experts, i would like to know on how to limit the size the postgre database (ex. 10MB per database)? is there any configuration needed in phpadmin or in the php code? pls help me dear experts...thank you

I've a table of cust ids where one customer can have multiple services (e.g. svc1, svc2, svc3). One cust id record contains one servicename field. So there can be duplicate cust records. e.g. custid servicename ------ ----------- 1 svc1 1 svc2 2 svc3 2 svc4 3 svc1

when executing the function as follow: select get_pms_meeting_minute (null) I get the follwing message: set-valued function called in context that cannot accept a set CREATE TABLE pms_meeting_minutes (

when I use the statment: "currval('my_seq')" in my function I get the error message like: "currval of sequence "my_seq" is not yet defined in this session" maybe someone explain this problem and give me the solution. best regards.

BEGIN; DROP TYPE structure.format_list2table_rs CASCADE; CREATE TYPE structure.format_list2table_rs AS ( "item" VARCHAR(4000) ); END;

I am a newbie to linux, postgresql and slony-i. Please forgive me. I encounter some problems while installing slony-i in SUSE. Background: SuSE Enterprise 10 Installed postgresql-8.1.4-1.3 Installed postgresql-devel 8.1.4 Installed

When i run the command SET search_path TO custom,idsystems, clientdata, configs, replication, structure, archive; then when I run SHOW search_path; it does show those schemas as the search_path. however when i restart the postgresql service, the search_path has reverted to $User, public. when i put the SET search_path function in the...

the problem is: when I create a user "user1" and give the permissions on the database "db1" to it (including login privilage), this user can access to all databases although it doesn't have the privilges (I make revoke ) in other side, any user can access to the database "db1" after login, although I make (revoke all on db1 from public). ...

when I create a user "user1" and give this user the permissions on a database "db1" (including login privilage), this user can access all databases although it doesn't have the privilges (even after implmenting the revoke command). on the other hand, any user can access the database "db1" after login, although I make (revoke all on database db1...

Can I back up all stored procedures and triggers on a database?

I need to access the structure of a table in a python script, so \d is not available -- I need to access the structure of a table using sql commands. (Also, \d is not working from psql anyway, because my workstation has the postgresql 8.2 client, while the server is running postgresql 7.4.) In sqlite, for all tables, this is easy: SELECT *...

Hi, I am trying to generate a message in function through RAISE NOTICE or RAISE DEBUG. Function runs fine but i can not see the out put message. -- Function: actacladd(text, integer, integer, text, text, text, text) -- DROP FUNCTION actacladd(text, integer, integer, text, text, text, text); CREATE OR REPLACE FUNCTION actacladd(text,...

hello all... I'm trying to convert the query which uses outer join statment from Oracle to PostgreSQL but I have some problems with this query may some one help me for this problem? SELECT ACT_ACCOUNT.ID_ACCOUNT, ACT_ACCOUNT.CODE_ACCOUNT, ACT_ACCOUNT.NAME_AR, ACT_ACCOUNT.NAME_EN, ACT_ACCOUNT.ACCOUNT_PID, ...