PostgreSQL Database Forum

Hi Is there some one who was able to create ukrainian or russian-urainian stemmer dict for tsearch v2? -- WBR, sector119 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your

Hi, anyone could provide free hosting for open source project called NextGenCMS ? It requires, pl/pgsql, php+(jpeg/png/gif). SF is out of question they do not provide postgresql database :( You can read project's info on: http://www.sf.net/projects/nextgencms Thank you for consideration, Dan

I'm running PostgreSQL 7.3.4 on Windows 2000/Cygwin (AMD Athlon XP+ 1800, 512MB RAM). I want to insert about 500 records into a table. The table is heavily indexed (has about 10-12 indices created on it). The insert is performed in a transaction block. If I keep the indices on the table, the insert takes about 12 seconds. If I drop the...

Hello, I need to collect some information on changes in database structure for further analysis. I'm interested in the following information: - new and dropped tables and views; - new and dropped table columns; - new and dropped primary and foreign keys; - timestamp of such a change;

What is that I have to return in a delete trigger?? return OLD or NEW???? _________________________________________________________________ Add MSN 8 Internet Software to your current Internet access and enjoy patented spam control and more. Get two months FREE! http://join.msn.com/?page=dept/byoa ---------------------------(end of...

Dear list, First of all I want to say sory, if my question was answered somewhere. Or if it is my fault. If so, please, give me link/hint. My own search fails :( I have experimence with MySql, MsSql and Oracle (and MS Access huch :) I am new to PgSql. We are running server - OpenBSD 2.9, latest apache, latest PHP, latest PgSql, latest...

Hi!! I wanna take a whole database running in a box1 pg7.3.4 and moving to another box2 with 7.3.4 too. There is a fast way to do that?? Which??/ *-------------------------------------------------------* *-Edwin Quijada

Hi!! I got error about a length field varchar. I have a table with a field type varchar(20) but if I try to set to this field more than 20 characters I got error. I did a function to control the length of data and put it on trigger but when it ocurrs I got the error anyway and the trigger not works. This error is over than trigger...

I am looking for an experienced DBA in the North Texas area who would be available for a brief (probably about a day) consultation on database design and optimization in PostgreSQL. Please contact me if interested, Stuart Johnston sjohnston@haisolutions.com

What I am trying to do is select all the rows out of the categories table (see below) and select the sum of j_amount out of the judgment table. Right now it is only returning the categories that are in the judgment table. I want it to return those fields with the amounts out of the judgment table, but also the all the other categories from...

Hello all, First, let me explain hat I'm an absolute database novice. The reason I've made so much progress sofar with postgresql is that it is an amazing software suite with exceptional documentation. So if I'm asking an idiotic question, I apologize... but atleast tell me what the obvious is. I just downloaded the...

Hello, I have the following problem working with DatabaseMetaData. There is a database with table and attribute names in Russian. Database cluster was initialized with appropriate ru_RU.KOI8-R locale. All the databases were created with KOI8-R encoding. No problems were encountered in accessing database table data with JDBC.

I get this when I try to start up a freshly compiled beta4 on OS X 10.2.6: FATAL: could not create shared memory segment: Invalid argument I saw a previous thread on this for beta2. It sounded like this was a bug that was to be fixed in beta3, but I'm still having this problem with beta4. Thanks,

unsubscribe

Hi everybody, can anyone tell me if there's a way to retrieve the select instruction executed from the catalogs, or maybe via some structure in a trigger? The reason is that i have some selects constructed on-the-fly (just part of it) and i want to save that in a table in order to know what are the most used for optimizing them. Another...

Hi! We're trying to call a set-returning stored procedure from Excel (MS Query). To do this we type: select * from getStudents() (where getStudents() is the stored procedure). The problem is that MS Query interprets this as if getStudents was a table, and complains that there is

Hi, could you help me? I am reading documentation on RelOptInfo in version 7.3.4 and have come across "RT indexes" in the explanation. Could you tell me what they are? They are mentioned in file src/include/nodes/relation.h in version 7.3.4. They seem to be some kind of unique identifiers of relations, but I have not been able to find a...

Hi, does anybody out there have experience with the several PL's which are available for PostgreSQL? I am currently evaluating several databases (commercial as well as free & open source) for a new project and would just like to hear some feedback. PL/Java seems to be developed by a fairly small team - no updates on their website since...

Multiple database services and multiple versions on Red Hat Linux systems The way it works is that we require a specific service script for each database service (that is listening on each port). Each of these services has a init script in /etc/init.d and a corresponding configuration file in /etc/sysconfig. We use the 'chkconfig' utility...

I was just wondering, what are the "cache_value", "long_cnt", and "is_cycled" sequence columns used for? I couldn't find anything in the docs or Google. select * from test_id_seq; sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called...

Hi, I can't seem to retrieve a comment on a table column. The following copy from psql should I think return a comment: ==================== mydatabase=> COMMENT ON COLUMN car.manufacturer IS 'manufacturer name'; COMMENT mydatabase=> SELECT relnamespace FROM pg_class WHERE relname='car'; relnamespace

I have a query that uses the same view 6 times. It seems that the database engine is calculating the view each time. The result is very poor performance. The same query takes 2 sec with MS SQL, and more than 10 sec with PostgreSQL. Is there a method to improve the performance besides merging the components of the view into one table? I...

Hello, I know that PostgreSQL, like most database management systems, has a function call called NOW() that returns the current date. Is there a way to return a datein PostgreSQL such that the output is in ISO 8601 format (Unix 'date -I' format)but such that the date is not "today"'s date but the date two days ago or five days ahead of...

I'm a consultant for a large company and they are looking at a database to use. I made the suggestion about going with Postgresql. I told him about it's MVCC design, he liked that ideal, but wanted to know exactly HOW did it handle the multiple versions of records. He's concerned because he was burn very early on by another database that...

Greetings, I was doing some tests with timestamps and intervals and I've discovered, for my surprise, that I can't set precision for resulting fields of type interval when I'm executing a query. Please follow my tests : bxs=# select CAST('10:32:14.553243' AS interval); interval ----------------- 10:32:14.553243