All,
I currently need to implement a trigger in PostgreSQL that executes on the update of a row that executes the following function name in my database:
Function_Set_Authorized("ID Parame...
Dear Experts,
I need to create a trigger and subsequent function of some sort that will pass a value from a given query to a simple php script.
First, can a trigger be applied to a speci...
Hi experts!
I am currently rebuilding a reporting application using BIRT. Before developping to much, I want to be sure of the database software choice I will have to live with.
I starte...
Experts,
I have a script that creates users and assigns them to tablespaces etc. My code below:
I cannot get this script to run in PostgreSQL. It stops on line
DEFAULT TABLES...
Hi experts!
Until now, all the database developments I implemented were done using M$ SQL Server. Very much interested by the open source solutions, I recently started to use MyQSL to devel...
We're trying to install postgresql-8.3.8-1-linux-x64 on an SLES 9 box, the install runs ok, but when it proceeds to configuring the database we're getting the following error
Invalid argume...
Hi,
I have a server and i cant connect to it because it gives me the follwing error, the only thing i have changed inthe conf file was to allow certain ip addresses connect to it
I have copy of PostgreSQL Server 8.4 installed on a machine with Windows Vista. I had the server working fine for a while, but when I tried to enable external IP addresses to access the serve...
I use the sql code below to find if an existing record exist for the same resource in the same date/time range. So the resource 'Conference Room B' can not be double booked.
There is an ex...
I have a performance problem with a prepared statement. Executing the prepared statement runs 800 ms(consistently). The sql statement takes less than one ms. It appears that the prepared stat...
Is there any type of trace function or any logs that can be created and
viewed that show any/all sql sent to postgres and the results?
Please see pic be low How can i move up colum 'ProIDSerial' to be in font of 'ProId'
I want to drop a postgres using jdbc. I believe this code
Statement statement = m_conn.createStatement();
statement.execute("DROP Database "+m_project);
is logi...
Hi,
I am trying to install the Windows version of Postgresql (v8.4.1) onto a Windows Server 2003 machine that acts as our domain controller.
The issue starts when I have to create the p...
I'm using PgAdmin3 [that is what i got after installation of Postgre SQL] im a novice.
Now I can see default tables and i now want to add data into these tables. How can i do that, from the h...
hello experts,
i have a table myTable as follow :
element_id(int), date(timestamp), level(real)
i'd like to pass a query in order to recover the latest record for
every single elemen...
I'm Windows desktop application developer and have been working on client/server application with Postgresql as database. I would like to implement SSL connection with my application.
I rea...
I need to create a long text field using hibernate with postgres.
I used this statement in my .hbm.xml
<property name="hyperlink" type="string" length="2000" >
<column name="HYPERL...
Basically I want to pass a schema name as a parameter to a stored procedure, and make a select statement based on that schema name. This is what I've got:
CREATE OR REPLACE FUNCTION myFunct...
Is it possible to concatenate text field on update
Free text field may or not have text in it if it has I wish to keep what is there and add to it.
Do I need to have a select command firs...
are there any tool to hel to write store procedure in postgresql
I have a 500,000 line sql script.
update users set region_id = 9814746 where id = 101 and region_id is null;
update users set region_id = 9814731 where id = 102 and region_id is null;
updat...
I have 3 tables, A is parent of B, which parent of C.
I want to delete all C where its parent B has parent A.id=xxxx.
I tried several SQL statements posted on the web, but nothing worked...
Advice please.
We had a legacy system with between 3-4 databases (flat file) that recently converted to an sql database. Now we need to verify that all the data has been imported into the ...
Please suggest postgre manage tool that run on windows
