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...
Hi Experts,
Looks like a bug in Postgres - I just installed 8.3.1-1, hoping it was fixed... I added a column in PGAdmin III - I do a query (select * from mytable limit 1) and I get a row wh...
hello. im trying to query between dates for example:
select * from bookings where date between '12/28/2008' and '12/29/2008'
date is a timestamptz datatype.
how do i do this in postgres?
Groupshield is using a PostgreSQL database this process: "postgress.exe" is taking huge number I/O reads and it is causing the server to perform slow.
Background scanning and proactive scanin...
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...
Problem : Sometimes the database shuts down unexpectedly with little warning. The logs show different procedure calls each time, some only selects but all ending in "LOG: received fast shutdow...
Hi Experts,
Currently I am able to psql into a database without a password. I don't want this - I want to be prompted for a password - what's the fix?
Thanks,
Mike
Hi,
I want to create a trigger that will update a column when an INSERT tries to insert a row with a duplicate key.
Take this query for example:
INSERT INTO sessions SET
data = 'so...
Hello All,
I'm running a postgresql 8 server on a centos 5 system. I've created a table with a couple of fields using the DATE data type. When I try to insert data I get an error "...incorr...
I am using "PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" on Windows 2003 server . While I am trying to update a prmary key It is failing with the ...
Hi
Is it possible to backup the structure of a Postgres Database, I normally use the pgdump command for a backup but then the structure and the data is backup. I want to replicate the DB ...
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....
Sometimes I get this error when working with PostgreSQL for several hours (reloading one page all the time). "FATAL: connection limit exceeded for non-superusers"
How can this be fixed?
Hi,
I would like to optimize postgres for the best possible performance for a single query. I am not going to use it in a multi-user environment, but performance of a single query is most imp...
Hi experts,
I am working on VS2005 and Back end is PostgreSql8.2. Here i am using PostgreSQLDirect .NET Data Provider as the connectivity between VS and postgre. I am not able to get th...
i have a table called road
It has
select count(*) from road;
count
---------
1098822
I want to fire this query in the database
select name, astext(the_geom) from road where ...
I need to select some rows from a table based on a certain field, something like
select * from table where ts=100
On these rows, I need to edit the value in ts to current value (100 in t...
hello. im trying to create some funtions to simplify a complex sql query. can someone show me an example of how to create a function that takes in some arguments and use it in a sql query and ...
Hello,
I am working on a libpqxx project within visual studio. Having connected to a database, is there some function or method I can call that will :
A. Return the current database pass...
Guys,
I was given instructions to start a postgre database:
su - postgres
cd /usr/local/pgsql/bin/
./postmaster -D ../data -l /var/log/postgresql/postgresql-8.1-main.log
But I'm gett...
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 ...
What are the disadvanteges of using Firefoxdb over postgre or myswql?
Hello,
I have to load an xml data file into postgresql database table.For that I need to write a pl/sql procedure to load xml file data in postgresql table.And it should for any...
Hi experts,
Is it Possible for a postgresql function to return multiple value? If possible how do I do that. I have to use the two return values as two columns of a VIEW. One column is a floa...
Hello Experts,
I ran this once, but I lost the instruction, and I googled it but with no luck. Does any of you know what is the instruction on PostgreSQL for knowing how many current open c...
