PostgreSQL Database Forum

Sorry for your time kitchen ceiling lights sunflower kitchen kitchen 20furniture kitchen cabinets and accessories homer laughlin colonial kitchen 'backyard kitchen' (http://kitchen-pantries.porapahat.com) small kitchen appliances 'kitchen tables sets' (http://small-kitchen-appliances.msna.info) waterman fountain pens acrylic outdoor...

Did you know that strength training is crucial for successfully losing weight and keeping it off?It doesn't have to be a huge, hulking workout where you're trying to look like Arnold Schwarzenegger in his prime, it just has to be some basic strength training. Diet adviser <a href="http://tetra.awardspace.com">Diet pill</a> <a...

Hi All, Nice to come back after a long time o the Scipts Forum , Now Can any body tell me 1 . Steps to sctivate the AUTOVACUUM thread ? 2 . Can we believe the AUTOVACUUM process ? I will be greately helpful if some one can answer my above queries.

Hello all, I've been at trying to implement custom session handlers with a postgreSQL database and am having some trouble with the garbage collection. What I've got now sure doesn't work: function gc($lifetime) { $query = "DELETE FROM sessioninfo WHERE expiration < ". time() - $lifetime; $result =...

Hi, Is there any way to know when a change in table occurs for a postgresql table to the front end , VC++ ? Please reply me soon. Anita

Would someone recommend a good tutorial on stored procedures using Postgresql. Thanks

I notice that FOUND has cropped up here before. Here is question I've just posted at ExpertsExchange very much along the same lines in 8.1.4. Is there anyone hereabouts who can shed some light on how FOUND is supposed to work?

Gang, Here is the basic issue. We have a database that was initdb'd with LANG=C in the enviroment. However, the order by results are still ignoring leading white space. Here is a sample dataset:

Hi In postgresql database how to retrieve the date in a required format ? Is ther any method to retrieve the stored date value in mm/dd/yyyy format. I don't want to set the date format in postgres databse . Whatever format the date value stored , is there any method to retrieve the date in any required format ? Pls post your replies Thank...

I used MinGW + MSys to compile PostgreSQL 8.1.4 using the sequence: ../configure --no-zlib make make install I am now trying to compile the Qt 3.3 PostgreSQL driver, which needs libpqdll.lib. However, the PostgreSQL build process did not create a libpqdll.lib, though it built libpq.dll just fine.

I volunteer for a non-for profit group and they have alot of names in a multiple databases. the problem is that some people are in multiple databases. and if they send out a mailing from multiple databases some people get 2 and 3 of the same thing. my idea was to either make or find a program that has everyone is 1 database and then make the...

Hello, I have gotten Ora2pg to work fairly well for me, but I am having an issue where mutibyte characters are being substituted with replacement characters on export from Oracle. I used both the output to a file and the direct import to a PG database and see a bunch of question marks instead of my multibyte chars. I have pulled text...

I'm told "select distinct on" or even "select distinct" is inefficient because it selects then discards rows. However, I'm stumped to find an alternative to this query : select distinct on (user_id) * from bids where auction_id = 3 order by user_id,created_at DESC; I'm trying to retreive only the last bid for each user for a given...

Hi, I am new to this group and new to PostGreSql. i am changing from MySql to PostGresql. I am unable to work with "Drop table if exists tablename" query. Is there any alternate query for that?? Please help me

I am moving from postgresql version 7.4 to 8.0. Are there any changes I have to make to my stored procedures

Hi, I'm having a performance problem with a large database table we use with postgres 7.3.4. The table is: db=> \d log Table "public.log" Column | Type | Modifiers ---------+----------+----------- hid | integer |

I know nothing about databases, SQL, or PostGreSQL :-) I installed PostGreSQL and phpPgAdmin on a web server. It looks like PostGreSQL insists that a username / password be supplied, unlike MySQL that just runs as "root". I'm trying to find out how to add a user, but apparently, this is such a stupendously simple operation that everybody...

Anyone know what happened with the 'money' datatype that was with previous Postgresql version 8.0? I know I can use 'numeric(9,2)' instead but how would I implement commas and the dollar sign into the query? Thanks... Schmidty

Hello, I have a problem using latin2 in postgresql 8 (beta2) with Delphi, with settings client_encoding = server_encoding = latin2 for database there is no way I could post special characters to database, i try with BDE ,dbexpress, delphi 5 & 7 and usualy receive: ignoring unconvertible UTF-8 character xxxxxx or message that characters...

I'm running a custom-compiled build of PostgreSQL on Solaris 8 with vacuum full analyze being run every hour. It runs fine, but after a few days of running even simple operations like create table slow down, and eventually they never return. When this occurs, a vacuum will _also_ hang. The solution is to cycle PostgreSQL; the restarted...

Well, I upgraded to Fedora Core 4 and now PostgreSQL won't start, since my data files are from a previous version. A little Googling shows that I should have exported my data before upgrading--news that would have been useful at the time. I've tried to install a 7.x version, but am having major RPM dependency issues. Has anyone figured...

I am normally the admin for our PostgreSQL servers, but someone else tried to kill a runaway query while I was out sick. Unfortunately, he tried killing the runaway query by killing the postmaster. Now we are dealing with a persistent problem that just won't go away. 1) Spontaneous back end deaths. 2) Spontaneous backend disconnects...

Does anyone have experiences running postgres with Informatica tools? More specifically, are there ways to use Informatica tools with postgres? Informatica doesn't list postgres in its supported platforms, so I guess its most likely not supported. http://www.informatica.com/products/powerexchange/supported_platforms/default.htm I want to...

Hello, I have 2 tables tab_1, tab_2 records in tab_1 are related to records in tab_2 i write records to both tables i one step. e.g. i write record do rec_2 tab_2 , this record have identifier (serial) , next i write record (rec_1) to tab_1 which is related to rec_2. How can i take identifier from rec_2 and write it to rec_1

I intend to set up a large database with PostgreSQL: about 1.3 TB, very basic queries (but 1500 per second at peak charge), and most probably only a single one index. The overall application, which is rather simple, should react in less than 3 seconds, 80% of the time. Meaning that if the database gives a mean response time of more than 0.5...