PostgreSQL Database Forum

I assume I'm not the first person to have encountered this, but I couldn't find anything in the FAQ or on the mailing lists recently. My apologies if this is already documented somewhere... My application logs data to a Postgres table continuously (once every 15 seconds), maintaining a persistent connection. Each datum is logged with a...

CREATE RULE "new_rule2" AS ON DELETE TO "public"."klients_view" DO INSTEAD ( DELETE FROM klients WHERE (klients.klient_id = old.klient_id); DELETE FROM klient_services WHERE (klient_services.klient_id = old.klient_id);

Hi, In 7.4.6 there is only plpgsql under pl where as 7.4.5 includes it in the main distribution can anyone tell from where plperl for 7.4.6 can be got?

I did not notice in the Install instructions that a dump restore needed to be done... This is what I got when I upgrade the v8b3 to the v8b4 FATAL: database files are incompatible with server DETAIL: The database cluster was initialized with CATALOG_VERSION_NO 200408031, but the server was compiled with CATALOG_VERSION_NO 200410111....

Hi all, Question: is there any way to use environment variables (or something similar) in my saved SQL code, and have them expanded at runtime? I can't see a way to do this in the manuals, and a colleague tells me it can't be done, but I wanted to check, because if this _can_ be done it will make my life significantly more optimal. In...

Hello Why is it that PostgreSQL chooses to have features like replication, fulltext indexing and GIS maintained by others outside of the sourcetree? I appreciate any answers. Thank you. Tim

What does this mean? WARNING: Rel pg_class: TID 17/13: InsertTransactionInProgress 106004881 - can't shrink relation ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

ERROR: could not convert UTF-8 character 0x00ef to ISO8859-1 Running 7.4.5, I frequently get this error, and ONLY on this particular character despite seeing quite a bit of 8 bit. I don't really follow why it can't be converted, it's the same character (239) in both character sets. Databases are in ISO8859-1, JDBC driver is defaulting to...

Hello, I've got one 7.4 installation and a brand new 8.0 beta4 running on the same machine. Both installations are configured to use the same port (5431) to avoid reconfiguring the apps running on top of the DB. The following paragraphs illustrate the problem:

Dear All, I have a simple join query SELECT c1 FROM t1 INNER JOIN t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3; Which gives the expected result but I get the message NOTICE: adding missing FROM-clause entry for table "t3"

I'm sure this has been answered before, but the search seems to be down again. How can I convert the results of a subselect into an array? IE: CREATE TABLE a(a int, b int, c int); INSERT INTO table_a SELECT a, b, (SELECT c FROM table_c WHERE table_c.parent = table_b.id) FROM table_b ;

Hi, I'm trying to write a recordset-returning function that returns a values from a base table, and one column from a joined table, where the joined table varies according to a field of the base table. I'm looking for an efficieint way to do this, and I don't think I know enough about Postgres' capabilities to know how to do this. I...

I'm designing a system where I'll be making frequent updates to rows, but some columns will change far less frequently than others. All columns will be read with equal frequency, though probably by means of a materialized view. Updates will happen via a stored proc. Which makes the most sense? 1. Blindly overwrite the value for all...

I need advice on archiving data from our production database. Each night I would like to save and remove a day's data from two weeks ago, from all the tables. I know how to delete the data--though our schema does not specify cascaded deletes. However, I can't figure out how to save the desired data. I'd like to save it in SQL insert statement...

exists in postgresql the way to store some tasks on server that can be executed on predefined schedule? how? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

I was just wondering why the btrim syntax that takes only a single argument is not documented in 9.4 in the documentation (I checked both 7.4 and 8.0 docs). This is in a 7.4.5 installation: pg=# \df btrim List of functions Result data type | Schema | Name | Argument data types...

Hi All, I'm unsure if this is the correct mailinglist for my question. I have a problem with CREATE DATABASE, but as the docs state that officially this is not an SQL statement, I was unsure if I should subscribe to pgsql-sql or pgsql-general. NOTE: I've searched on google, postgresql.org, FAQ's and the static/dynamic documentation, but...

Thanks to some help here on the list, I've been able to get addresses sorting pretty well, but now I have a issue with same addresses on different streets not grouping the streets. This is what I'm using a substring search in the ORDER BY statement now like in this view: SELECT tblhudsimilargroups.rems_id, tblhudsimilargroups.group_id,...

Hello folks, I have installed PgSQL8 beta4 via pginstaller to WinXP. I must tell you I am more familiar with Linux, so maybe my problem is trivial to solve: I made myself a table with PgAdmin III (I was lazy to use psql) that I tried to reach via ODBC. I created connection to my database, supplied a user, server, etc., all that...

I've sent an e-mail to Guiseppe Tanzilli about this, but maybe someone here has seen this. I'm pretty sure it's not PostGreSQL, but it is tangential. We are updating to mod_auth_pgsql2 v2.0.latest and apache 2.0.latest, in the process of updating to PostGreSQL 7.4.latest. We get the following error: > Auth_PG_grp_group_field takes one...

I am trying to track down a method of determining what a sequence name is for a SERIAL is in postgresql. For example, CREATE TABLE foo (id SERIAL PRIMARY KEY NOT NULL, bar TEXT); \d foo Table "public.foo" Column | Type | Modifiers

Just wondering - does PG support derived tables? I'm not really sure what the difference is between them and subqueries. http://www.mysql.com/news-and-events/press-release/release_2004_32.html http://www.sqlservercentral.com/columnists/rmarda/derivedtablebasics_printversion.asp __________________________________

I have 2 existing tables in my db: iss=> \d pollgrpinfo Table "public.pollgrpinfo" Column | Type | Modifiers ---------------+------------------------+----------- pollgrpinfoid | integer | not null pollgrpid | integer | not null name | character varying(100) | descript ...

Hi, My boss wants to add a special type of logging to some of our tables on update/delete/insert. I need to log who, when, table_name, field name, original value and new value for each record, but only logging modified fields, and he wants me to do this using postgres pgSQL triggers. The changes would be inserted into a second table. ...

Hello everyone: I'm a PostgreSQL newbie, working now with dates, times, timestamps and intervals. I have three questions about the above: FIRST: --------