PostgreSQL Database Forum

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, ...

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?

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...

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 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.

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). ...

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

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 (

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

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, can anyone help me to figure this out. Currently, i have this code: select t_stamp, num from table where num in

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:...

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(

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...

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...

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 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

I have a local copnnection with Postgres setup for development on my PC. This has been working for months with the default configuration. I recently set up to access a server and got this error when I tried to connect. I dropped the server and still got the message - I can't now connect to the server at all, and still get the listener message...

Hi , I have an array that need to be split into table columns. Ex: test_array('{"(1,2,3,4,5)","(10,20,30,40,50)"}') test_table col1 col2 col3 col4 col5

HI, Im new to postgresql i have written two procedures.procedure1 takes input from the user array of table objects and loops over them and for each row it calls the second procedure2 where the acutal filling of tables happen. My problem here is if the user passes 10 record and if record 5 fails then all the other records should be posted to...

Hello everyone When the trigger executes the function which I copy below: IF (TG_OP = 'UPDATE') THEN EXECUTE 'CREATE TABLE '||NEW.nome_tabella||' (ordinativo serial PRIMARY KEY CHECK (nome_tabella = '||NEW.nome_tabella||'::text)) INHERITS (madre);