We are using postgresql db for our web based application. We are using postgres stored procedure extensively and we have a requirement where we need to pass arrays to postgres stored procedure...
I have a postgres database setup on a remote server. The currently working DSN on my windows laptop was set up by someone else. When I run PERL programs on my laptop which query the database...
Here is the fragment of Postgresql 8.1 log - Windows 2003 server installation:
2006-04-13 10:30:33 tvman/tvman(10.0.1.197)LOG: unexpected EOF on client connection
2006-04-13 10:30:33 tvman/...
I need some examples of the mappings for Hibernate for the following scenario. I have a Postgresql function that returns a result set (rows of columns). The results of this function don't re...
in my development Linux server, i have postgres installed and am using the connection to my php web sites..,. after starting the postgress service exactly 5-6 hours.. the postgres server is ha...
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...
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...
Hi Experts,
I'm using Postgres 8.3 now and trying to use the command line createuser.exe to create a user. Ideally, I would put the password on the command line so that I can automate the in...
I am looking for a simple PostgreSQL query to show which rows that have fields in one table that are not found in another table.
select * from
(
select fieldA from schema1.table1
union ...
Ijust ordered a new server with Sever 2003 64-bit edition on it, and then we found out that one of the applications that we need to use on this server has not been tested to work in a 64-bit e...
I am outputting a table that has a user's response with the period of time that has elapsed next to it
John Smith | Yes (15 mins ago)
Bob Jones | No ( 12 days ago)
Sally Thom...
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';
...
I'm trying to connect to Postgres with my PHP program. The program is running on the same host as Postgres.
This program worked on my other apache/PHP/Postgres server, but after copying it ...
Hi Experts,
How to return dataset from a postgre sql function? I wish to know how it works.. I'm not looking for a complex solution using pl/pgSQL, just a simple sql funtion returning ...
I have a table gnr with a column country. I want a result like
USA 33
Canada 36
I try select country, sum(1) as count from gnr group by country; and get a syntax error. I am unknow...
I want to install pgadmin (the postgres admin tool) on a CentOS 4 system.
I initially just downloaded the rpm, but I ended up in rpm hell where it required wxGTK and then when I tried to in...
I am in a need to denormalize a table.
Supose the following two tables:
Jobs:
jobnumber varchar(12)
author int2
JobStatus:
jobnumber varchar(12)
status int2
statusdate timestamp
T...
We need to dump out a PostgreSQL database to import the data into another system. In trying to do that using pg_dump, we get the error "invalid page header in block 5963 of relation 'img_page...
I have the following 3 database tables:
CREATE TABLE public.courserecord
(
courserecordid numeric(38) NOT NULL,
studentid numeric(38) NOT NULL,
courseinstanceid numeric(38) NOT NU...
Hello,
I'm new to postgres and I've googled on this seemingly simple issue all morning...
FreeBSD 6.1
PostgreSQL 8.2.3
PHP 5.2.5
I want to query my table and return records (to scri...
What does this error mean?
I wanted a field that incremented itself automatically, just like mysql's auto_increment attribute. So, I did the following in pg:
CREATE SEQUENCE mytable_i...
i've been creating a function in postgres, as i would like to request a "select is_super_account(id)" with and id
and have a boolean answer to know if the id is a super account or not. ...
Gurus:
I would like to load pictures into PostgreSQL tables. I have installed PostgreSQL 8.2.4 on my linux server.
Please advise.
Thanks in advance.
How to check the database name of postgres in my linux machine
i need to take the backup for that i have to give dabase name
i only know username and password ...
this is the command :...
INSERT INTO sales_order_lines (order_line_id, order_id, part_no, quantity_ordered) VALUES SELECT(("MAX(order_line_id) + 1" AS order_line_id, '1234' AS order_id, 'P78979879' AS part_no, '5' AS...
