I need to reinstall/update postgres on my server, there are some path errors that appear on some tests. However it's been a long time since I've used postgres, and before backing up my databa...
Would this translation be correct
Mysql syntax
CREATE TABLE `voicemessages` (
`id` int(11) NOT NULL auto_increment,
`msgnum` int(11) NOT NULL default '0',
`dir` varchar(80) default ...
Hi,
I am assigned the task of presenting a document on the advantages and dis advantages of using PostgresSQL Vs SQL Server to my management. I would like to have valuable feedback or points ...
Hello,
I have a Dell 2850 4 GB RAM - running CentOS
I am a novice in any flavor of Linux, but yesterday when I installed the monitoring system - I noticed that I'm using 3.6GB of RAM .... s...
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 . . I've installed PostgreSQL 8.0, PgAdminIII and the Npgsql .NET data provider.
I've created a user, a database owned by that user, and set the database to accept connections.
I ca...
Hi experts,
I am trying to authenticate a user with postgres. I have created a postgres user and when I use the method below, it seems to work fine for a database installation on windows - ...
Anyone know if PostgreSQL has built-in audit trail functions? If not, can you recommend a way to do audit trails in PostgreSQL? Thanks.
this is a function in a trigger for after insert
this code works (rates_default is a table):
declare
theChargeRate numeric(8,4) := '2.9';
aniRateGroup varchar(20) := 'group_default';
...
SELECT * FROM table1
JOIN table2 USING (key2)
LEFT JOIN table3 JOIN table4 USING (key4) USING (key3)
WHERE table1.x=100
AND table2.y=200
All keys are primary keys and so indexed, and ta...
I found the following message within syslog.
< message >
postgres ERROR: missing FROM-clause entry for table ""xxxxx""
Note: ""xxxxx"" is masked.
I am not developer but manage ser...
How do I put a carriage return or line feed in a raise notice statement? I thought I could use the perl \n or \r but those do not seem to work.
raise notice 'My notice needs a new line: %\...
hey,
What is a good postgresql gui management application?
Some similar to ms enterprise for sql server.
My operating system is fedora.
Hi all,
I was wondering, if anybody experienced problems with starting PostgreSQL service after installing September windows update for Windows Server 2008?
I've installed all patches ...
Does anyone know the sql select statement to retrieve every nth row from a table? (Like, 2nd, 12th, etc....)
Hi,
I've recently upgraded to postgres 8.3.0, and when I run my java app that connects via Jdbc to postgres I am now getting the error: SET AUTOCOMMIT TO OFF is no longer supported. I'm no...
Hi,
I'm running into the following error when I try to pull data from my postgres database:
SchoolManager.java: readSchoolsFromDB(): Error while reading all schools
org.postgresql.util....
I am using rsync to mirror postgres from one Solaris server to other Solaris server.
The problem is after I run the script the data is not updated only after I restart the data.
I think beca...
I have two records for each employee. One with a 2006-12-31 datestamp, the other with a 2007-12-31 datestamp in the YR field. In the ASP, I know the latest year by performing "SELECT max(yr) a...
Dear experts,
I'm New to Linux and Postgre.
I've installed PostgreSQL 8.2 and phpPgAdmin in Ubuntu
Now, please tell me how to start phpPgAdmin
Thank you
I am trying to write a function that will give me the month's name when the numeric version is pass.
Create or replace Function nameofmonth(integer)
RETURNS text AS $$
select Case WHEN $1...
Here is part of my select statement:
((sum(totalflopbets)+sum(totalturnbets)+sum(totalriverbets))/
(sum(totalflopcalls)+sum(totalturncalls)+sum(totalrivercalls))) as agg,
Currently 'agg...
im trying to export from one postgres db to another but im having big problems
does any one know of a quick and easy tutorial for a novis linux user that explanes and shows me how to do a
...
I'm a Linux and Postgres newbie that need to figure out why I suddenly get this error message on my website:
Query failed: ERROR: could not access status of transaction 1935960436 DETAIL: Cou...
Hello everyone, I have a PostgreSQL database installed into a VMWare session on a server. I connect to the database from an application but sometimes it goes getting connection lost with this ...
