PostgreSQL Database Forum

Can someone point me to some more information or perhaps show an example of returning a recordset from a plpgsql function. I'd like to send an argument or arguments to the function, do some queries to return a set of records. I've done several functions that return one value of one type, but nothing that returns a set. -- Robert

I receive the error message "Try to compose a less restrictive search query or check spelling" regardless of search term when attempting to search the list "PgSQL - General" via the mailing list archive search form at: http://archives.postgresql.org/pgsql-general/ ---------------------------(end of broadcast)---------------------------...

I would like to try and build a queuing mechanism on top of Postgresql. Imagine an application where a large number of processes generate images and queue up thumbnail requests. A smaller number of processes (running on a dedicated set of machines) generate thumbnails for those images. Adding entries to the queue from multiple processes...

Hi, I'm trying to install, postgreSQL v8 beta2 on AIX5.2, and I have one problem: configure refuses to see AIX5.2 like as an OS assuming multithreading, any idea to resolve it ?

We ran into a problem with pg_hba processing recently when we upgraded from 7.3.2 to 7.4.5. We use postgres as part of a network appliance that runs on Solaris 9/intel boxes. 7.4.5 runs fine in our development environment, but when we deploy it to a production box, we get a "missing or erroneous pg_hba.conf file" error. The error in the log...

We are using a table with a primary key of type varchar. If we try to find entries with select * from <table> where <table.key> = '<text>'; entries with a key length of more than 32 characters are not found. Entries with a shorter key are found. Using "Like" instead of "=" works for varchar keys with length > 32 as well. Does anybody know...

I like to keep a local copy of this: http://www.postgresql.org/docs/7.4/static/ But the only way I see to download the whole thing is by PDF. Anyone seen a downlodable tarball of all of the HTML files? (or should I just use wget recursive to spider-grab it?) ---------------------------(end of broadcast)--------------------------- TIP...

Hi, I have been having this problem where the database size suddenly grows from the normal size of about 300Mb to 12Gb in one night. When I look up the table size, the biggest one is only 41Mb and the total of all table size is only 223Mb. But in the filesystem data directory the total size is 12Gb. I noticed there are 10 files with 1Gb...

We have an installation of PG8.0 Beta1 running on a win 2000 server box. After a normal shutdown and restart of the computer, the database service would not restart. Error message was: "Could not start the PostgreSQL Database Server service on local computer. The service did not return an error. This could be an internal Windows error...

Has anyone investigated having either high, or low urgency queries? A system I'm working on has a constant inflow of data, which has some queries gainst it which might require long sequential scans. I'm not that worried about how long those queries take, just that they don't interfere with other insertions. This is a bit DSSish, I guess,...

I'm having difficulty getting postgresql to log queries. I have the following set in my postgresql.conf: ------------------------------- # - Syslog - syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog syslog_facility = 'LOCAL0' syslog_ident = 'postgres'

Hi! I've got a function that inserts a new record if it does not already exist. The construction is very simple: SELECT INTO ... FROM tab WHERE pkey=$1; IF NOT FOUND THEN INSERT INTO tab ...; END IF;

Hi! I've installed PostgreSQL 8.0-beta2-dev3. When I try to start programs from "bin" directory, e.g. "psql" or "createdb" they require a Password. When typing user's password (or anything else!) this consoles simply get closed. I can start "psql to template1" from "Start|Programs..." but nothing else. Can anyone help me? Konstantin ...

I'm a noob SQL user, crossing over from SAS. I have a table with about 200k rows and one of the columns is empssn, which holds the employee social security number. The same empssn may appear in lots of different rows. I want to get a list of the 40 top empssns, sorted by the number of times they appear in the table. I also want a list of...

I'm a brand new PostgreSQL user -- just started today (though I've used MySQL for years). Should I just start learning with version 8, since I'm sure I won't launch any real live public projects with PostgreSQL for another few months? Any estimate when 8.0.0 will be final & production-ready? Thanks!

I just read release notes for 7.4 where it said:( in plpgsql) allows declaration of record type without %ROWTYPE So, before that, there was no way to have a record returned of arbitrary fields from a User Defined Function? ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?...

Is this the correct way to return values in a record from a UDF in 7.4.+ ? Is it ok to modify the arguments as in 'arg_int'? -- return type should be RECORD -- CREATE OR REPLACE FUNCTION test_function( int ) RETURNS RECORD AS ' DECLARE

I'm trying to unsuccessfully to drop a database using the latest CVS code for 8.0.0, getting the following error: ERROR: cannot drop the currently open database So I must have a connection open, right? So I look for connections with the command I use on 7.3.4 but see nothing: SELECT pg_stat_get_backend_pid(S.backendid) AS pid,...

I am pretty sure the answer is no, but ... is there any way to get 'ilike' to use an index? It seems like something that a lot of people would want to do. Otherwise, should I just create redundant case-mapped columns and use 'like'? Thanks, Kevin Murphy ---------------------------(end of broadcast)---------------------------

Hello list, is there a way to write in plpgsql the query that returns a set of this: create view xxx as (select '3ARR' as level, dpe_stamp from detpa where dpe_productfk=1 order by 2 desc limit 1) union all

We are currently switching to stored procedures for a lot of our database activity. The question has come up about the transactional nature of the stored procedures. I was wondering if stored procedures can have transactions in them or if you must start the transaction in your code and call the stored procedure from there to get the safety of...

Hi All, I would appreciate any input on this dilemma: 1. I have DataBase-A which is Oracle on Server A with FunctionA (PLSQL)

With the advent of postgres v8, would it be possible to change the default behaviour of psql from AUTOCOMMIT=ON to AUTOCOMMIT=OFF ? Although this might break backward compatibility, it might be acceptable on the basis that v8 is such a major release. Also adding a new command line parameter to control the AUTOCOMMIT setting for those...

My company's product uses Postgres 7.4.3. Postgres is working well for us, and we've worked through many performance issues by tweaking the schema, indexes, and posgresql.conf settings. Inheritance would be useful for our application, but we did not use this feature initially. We're about to revise part of our application, and this would be...

Does anyone know if there is an Austin, Tx Postgresql user group? If so do you have contact info? Bill Jacaruso bjacaruso@yahoo.com