PostgreSQL Database Forum

Hi, I installed PG 7.2 and have a database "foodsvc". I want to make a new copy - "newfoodsvc". So that I can play with the "newfoodsve" without making any change to "foodsvc. How can I do that? Thank you. GL

I've got a little issue - when I run for example "SELECT * FROM test" my result is: id name 1 first test 2 second test but when I create function:

I have a server under very light load -- just me doing some work in php. I am getting this error often and don't know why: postgresql max connections Unable to connect to PostgreSQL server: FATAL: Sorry, too many clients already my postgresql.conf had: max_connections = 8 shared_buffers = 16

Imagine I have built a program based on PostgreSQL. There is a statement that anyone can use and distribute or modify PostgreSQL software provided that he includes a document with the license statements. If I include this license statements and distribute only binaries of the modified program (it is allowed), does it mean that my program is...

Hi there, I'm coming from a MS-SQL/MySQL background, and am trying to understand the way Postgres phrases "stored procedure" type stuff. What is mystifying me, in particular, is the fact that all Postgres functions can only return one thing, even if that one thing is a bunch of similar objects. How can one phrase a stored procedure...

I want to order a text field which contains some words which begin with a single quote, if however I perform the following query, the single quote seems to be neglected: select arabic, dutch from woordenlijst order by arabic; After this query the words are ordered as if there _wasn't_ a single quote in the beginning. e.g. I get: 'arn ...

Hi there, I am a complete newbie in PostgreSQL 8.0 and I tried to install it on a W2K machine (no access to Linux sorry). I have a major problem: while installing it, I was obliged to quit the installation. Afterwards when I tried to restart the installation from zero, i couldn't go further because I don't know the default password...

I'm using ver. 7.4.6.1 from a generic install of Fedora Core 3. I always get "permission denied" error when using the COPY command to load to a table from a text file. I'm logged on to the db as Postgres, have file permissions set to RW-R--R--, and it is located in /tmp (also tried putting it in the Postgres home directory). I am able to...

Hello all, I have a table with about 400,000 records and a btree index (numeric). A simple SELECT * FROM table WHERE id = ... takes more than a second for every query and I need to query each record at least once. It helps to do an UPDATE tabel WHERE id IN (..., ...), but I don't have the patience to wait for more than 400,000 seconds to...

I want to calculate the duration of time for a timecard project. This is a sample: totaltime = (endtime1 - starttime1) + (endtime2 - starttime2) totaltime is numeric, starttime1 & 2, endtime1 & 2 are ISO time values. I am stumped so far, can anyone lend an example of the syntax? thanks, tony

Hello I have 2 databases on PostgreSQL, for instance base1, base2. I connect to psql: psql -p 3333 base1 how can I access to base2 ? for instance I wont do instruction: insert into test(a, b) values select a, b from basa2.test

Given table all_prices: product_id | company_id | price -----------+------------+------ 1 0 1 1 6 2 2 0 3 4 6 4 5 0 5 5 6 6

Hi, does anyone know about a tool (free or commercial) for object and relation view for postgres? Thanks for any help. MK

Hello group, I have some questions concerning configuring and using a JNDI DataSource with PostgreSQL and Apache Tomcat. Currently, I belive I have successfully configured a "basic" DataSource. Currently, my configuration which resides in a context.xml file is as follows: <Context className="org.apache.catalina.core.StandardContext"...

test test test

I am trying to log the results of a series of triggers that are fired when I insert into a table. It looks like the only option is to change the configuration of the postgres. What would I have to modify in my postgres.conf file? Or, is there another way? Thanks -rob

How does one import data INTO a table. I am forced to read files (\i) w/ a ton of insert statements. I am trying to import approx 800 lines into the table. However, I must bundle them into a series of files because of the bug in PGSQL (the buffer overflows). Interestingly, the literature claims that the one feature of PostgreSQL is SPEED....

Hi I'm a developer currently wondering which DB choose for my next project. I looked on the net found ofcourse Oracle but also came up with PostgreSQL. I heard quite few things about it, all good so I'm wondering how really it is. Till now I've been working on MSSQL and Interbase. So PostgreSQL and Oracle are pretty new to me. I would...

Hello :) I'm working on an internet application with MS.Net client program, which is supposed to communicate with database through PHP or ASP-based webservice. The database is to hold up to 20-30 mln records in less then hundred tables; most of the tables (holding up to 80% of all data) will be updated quite rarly (e.g. once a week...

Hi, Has anyone Pg linked to MSSQL or vice versa? I need to transfer some data MSSQL->PGSQL, but without writing a complex program. Maybe using Linked Server (MSSQL), ODBC / JDBC / OLE DB, but have no experience with this kind of jobs.

I am currently migrating from MSDE to PostgreSQL and have to rewrite the function that is calculating next date of sampling... In MSDE there is a DateAdd function. I can't find the appropriate function in postgre. Can you help me? The function in MSDE is the following: ALTER FUNCTION dbo.slisp ( @UCESTALOST_BROJ int, @UCESTALOST_JEDINICA...

Hello is anybody know how to install pg_autovacuum as a window service. i've tryed this : pg_autovacuum -I -U my_user -P my_password -H my_server i've got the message : Successfully installed pg_autovacuum as a service. but i can't start the service

We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are accessible by so called external functions exported by a DLL (dynamic link library) that we wrote in C++. Sybase supports this quite nicely. The client app can call such routines by: ...

Hello, I've got a server postgresql 7.4.6 installed from RPM for linux RH 9. Lately, I've noticed, that some queries last too long... It appears to me, that the optimizer does not use index optimizing.... This is what analyze shows: ------ explain analyze update activities set act_synch_date='2005-02-03 00:00:00' where activities.act_id=17;...

Hello. I use postgress to manage a small amount of data (ca. 25MB), but often changed. This is a mirror of several tables taken form four different databases. All data are updated once per hour (or sometimes on demand) Update of every table is closes within a transaction (constant data availability is most important):