PostgreSQL Database Forum

Hiya I have written a PL/PGSQL function which tots up users accounting information from their RADACCT data on the fly. So each insert or update modifies their totals. This has worked without error when I have tested it by hand with hand crafted inserts and updates, however when I put it on the actual live accounting server (both systems...

I'm getting a slew of these repeatable errors when running ANALYZE and/or VACUUM ANALYZE (from an autovacuum process) against a 7.3.4 cluster on HP-UX B.11.00: 2004-09-29 18:14:53.621 ERROR: Memory exhausted in AllocSetAlloc(1189) This error is in the FAQ, but that answer does not appear applicable. The error is occurring on 2...

Hi everybody, Is there any way to connect a Java application to user defined functions (which use SPI)? I have an already implemented Java app that I want to use in order to pass arguments to my functions and receive results (e.g. tuples). I'm thinking of JNI and/or JDBC but I haven't reached a conclusion yet on whether it can help me do the...

Hello folks, I am trying to install pgsql 8 beta 2 via pginstaller. dev 2 and dev 3 do the same - none of these complete the installation process. I tried to compile beta 3 via mingw, the installation failed - initdb says my time zone supports leap seconds (sk_SK, GMT+01). I set the time zone to something else, nothing helps. Any idea,...

The interaction of rules with views can be complicated, so here's a short sample file which illustrates the main points. -- Richard Huxton Archonet Ltd === BEGIN rule_test.sql === DROP TABLE foo CASCADE;

Hi all i am running PostgreSQL 7.3.2, i have a VIEW for which i implemented multiple RULES on UPDATE. The weird think is that the Update Query corresponding to one of the rules is updating MULTIPLE ROWS even though it should only update one ROW !! THE WEIRDEST is that when i remove 2 of the update Rules on the VIEW The Update Query Works...

Hi all, I want to get what roles/groups that the current user is member of. I tried to use the following commands but they both returned no rows. SELECT * FROM information_schema.enabled_roles SELECT * FROM information_schema.applicable_roles Anybody know how to solve this ? or anybody has a certain function that look up for user's...

I'm interested to know a little bit more about the postgres implementation of indexes. I'm specifically wondering what it means in the output of EXPLAIN when a filter is applied. I'm trying to decide whether it makes sense to use indexes on expressions rather than relying on a left-anchored LIKE for date filtering. Here's what I've got:

Got this error on a pg_dumpall file dumped from a postgresql-7.4-0.3PGDG database and imported into 7.4.5-3 database. ERROR: zero-length delimited identifier at or near """" at character 37 From looking at the output, I think maybe this is the line that caused the error. CREATE SCHEMA "MSV80" AUTHORIZATION "";

I would like to be able to initdb to get a clean database to test backups. Reading the Debian version of the Postgresql README, I see that I should use the --debian-conffile option with initdb. Problem though. I have to run initdb as user postgres, but I need to be root to edit the stuff in /etc. So I can't run initdb as root or postgres. ...

I'm trying to write two custom recursive functions: one that selects, and the other that selects/updates. I've been looking around the internet for examples for they're so limiting and completely off track from what I need to do. The best examples I can find is in the source code for Postgres, but that's so complicated I barely have an...

Hi, I was wondering if PGSQL has a function similar to binary_checksum() of MS SQL Server 2000. It is pretty handy when it comes to compare rows of data instead of having to write long boolean expressions. binary_checksum() takes a list of fields and it returns an integer value which sumarize the row content. Thanks, Fed

after an improper shutdown (power failure) the postgres service cannot be restarted. simply restoring the postmaster.pid does not allow the postgres service to start. also, is there somekind of data integrity check built in with postgresql that can notify me of any data corruption resulting from the 'crash'? thanks.

I am trying to create an installer that will run PostgreSQL as a service onto a Windows machine( 2000 or Server 2003). The problem that I am having is that I need to have the database be initialized by a restricted windows user. However, I do not want to demand that the user log out and then log back in again as this restricted user. Also, I...

create type my_type (my_test text, my_int integer); create function my_function(my_type) returns timestamp as 'begin return (current_timestamp); end; ' language 'plpgsql';

Dear peoples, I've got a problem which seemed to be neatly solved by the use of schemas, and in fact it mostly works, but I have tried to go one step too far, perhaps. Rather than have the application do SET search_path TO f12057; SELECT * FROM parcel-owners WHERE ... ; SET search_path TO public;

Quick question, hopefully... How do you store a date in Postgresql using Java date format, i.e. 2004-00-01 where that would be January 1, 2004 (looking for the 00 as Jan.) I've googled but only found someone else with the same problem. ---------------------------(end of broadcast)---------------------------

I am in the process of testing PostGreSQL for our sales and product database and I am a little confused about SQL scripting and various available languages. (My background is mostly MSSQL Server). I am using the PGAdmin tool and I would like to write a script to update all sequences to the current max value in the table. Do I need to use...

In Postgres 7.3.5 - When we try to insert a new record into our parties.party table which is then meant to fire off a trigger to update a column in the table with some de-normalised information, we get the following error: ERROR: FLOATING POINT EXCEPTION! The last floating point operation either exceeded the legal ranges or was a divide by...

good day everyone! i am using postgresql-8.0beta2-dev3 windows port, with postgis-0.9 add-on. anyway, while trying to insert a table using shp2pgsql, i get this error: psql:temp.sql:38: ERROR: Unicode characters greater than or equal to 0x10000 are not supported

I've been looking through the archives for guidance on whether or not we should create our tables WITHOUT OIDS. I've seen some discussions about making WITHOUT the default for user tables, and seen some caveats about the oid int value wrapping, etc., but I haven't been able to find a discussion of the relative merits (I'm sure there's been...

From 11.5 in the docs: "The syntax of the CREATE INDEX command normally requires writing parentheses around index expressions, as shown in the second example. The parentheses may be omitted when the expression is just a function call, as in the first example." But when I try this: db=# CREATE INDEX expression_idx on some_table(...

I have an srf sql function "annual_report(<year>)" that as 14 columns, a category, 12 month numeric columns, and a total numeric column. The function finds monthly totals for each category (which is the target of "order by") and the grand total for the specified year. I have another sql function annual_profit_loss(<year>) that...

Hi, I am trying to deal with a deadlock situation caused by foreign key references on insert and I was wondering if anyone knows what order the foreign keys are locked (or evaluated) in for a particular table? Deferring the locks is unfortunately not a good option for me... Thanks, Shawn ---------------------------(end of...

subscribe end hai sir i am using the postgresql 7.2 my doubt is what is the command of to see the list of databases i create a database named "jntuoes" database created it's displayed but i want to know the command so please give me the replay