PostgreSQL Database Forum

Hi all, As announced previously I am currently working with other people on the translation of PostrgreSQL to French, applications and manuals. We have stumbled on a couple of concepts which are not very clear to us and thus do not know very well how to translate. Can someone explain the following: msgid "the target relation %u is nailed"

I'm finding that column defaults are not being assigned to nulls when I do an insert by way of a an ON INSERT rule on a view. For example, the following script \set ON_ERROR_STOP ON \c template1 --DROP DATABASE testdb; CREATE DATABASE testdb; \c testdb

This is a blanket email. Many of the people I know are not keeping their systems up to date. You may be not knowledgable about how to do that, or not know that it is necesary to update regularly. As a result, you are getting attacked by viri; I am receiving lots of viris infected emails, possibly from you.

groovy feature request: I think comments on COLUMNs should be inherited from the "parent" table when the "child" table is created. If you make use of inheritance, this would be a big time saver. I just brings out the sweetness in inheritance. Of course you should be able to ALTER the COLUMNs later. While on inheritance.... Does...

Howdy: Has anyone used the Ora2Pg tool for exporting data to PostgreSQL? I'm trying to move data over, and my perl script to insert records into the PostgreSQL table is going very slowly. Suggestions? Thanks!

I'm having troube doing a left outer self join on a table. The sent column shows the number of items sent to each recipient from each source. The received column (generated by the outer join) is incorrect because although it is summing the number of messages by recipient, these need to be filtered by source too. How can I do a join on two...

Hello list, I have a trigger that loop for each column in a table, is there a way to identify a dropped column from within a PLTCL trigger? Thanks in advance -- Josué Maldonado.

Where are PL/pgSQL functions stored? I want to retrieve the text of a function that I've created. Thanks. -David

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Please consider the following situation. CREATE TABLE test_table ( ~ id SERIAL PRIMARY_KEY, ~ tag BOOLEAN, ~ field1 INTEGER );

Hi gurus, Anyone knows how to solve this? I was playing around with triggers on my own machine which runs 7.3 and there it works okey, but when trying it on 7.2 I get an error about duplicate keys. Upgrading to 7.3 on the other machines is not possible yet. Any help on getting it to work with 7.2 would be appreciated. <snip> create...

I have the following packages installed on my system: libpq3: 7.3.2r1-5 python-pygresql: 7.3.2r1-5 postgresql: 7.2.1-2woody2 postgresql-client: 7.2.1-2woody2 In my application, which is written in python, I get a "server closed the connection unexpectedly" exception after executing a few sql commands. I print each query before I execute...

Dear Sir: I am trying to analyse the source code in " /backend/paser". And I am really puzzled about the node "PaserState",especially the meaning of p_namespace and p_joinlist! Would you please explain it for me ?? Thank you ! your sincere zhai

Look at this: http://www.zend.com/images/survey/14.gif I belive that there is only one reason why most of people are using MySQL - it has native, very easy to install version for windows. ---------------------------(end of broadcast)---------------------------

Does anyone know if I can connect to a PostgreSQL database with Toad? Thanks, Ron

postgres 7.3.2 I store unicode-data in postgresql. The data is retrieved via webinterfaces, processed with perl and then stored in postgresql (and viceversa). All is going nice with one problem. If performing a "select * order by field"-query the result is not what I expected. German umlauts (ie: Ö) are stored as doublechars ("Ö" is...

unsubscribe ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly

Hi list I have any problems with Postgres 7.0 and a DataBase. When I do a select to the database it works well, but when I try to insert or to update it remains hooked and I couldn't work with it. Problems started 2 days ago after I done a vacuum in one table (only). Since this day I have several processes such as: /usr/bin/postgres...

Hi all, Maybe it's a question or report to bug section, but i'm not sure :-) I have a database in UTF-8 encoding filled with text in czech laguage. Everything looks correctly ... by hand translation from UTF8 2 latin2 and back is correct. But When i make any LIKE or ILIKE comparsion it sometimes fails. It's realy weird because for example...

I am trying to use Redhat Linux 9, J2sdk 1.4.2 and Postgresql 7.3.2 to do my setting. But, I cannot access the database to set/get data through the java program. Please help give me some suggestions. Here is what my setting and problems: http://hk.geocities.com/daisy_nhy/java_postgresql2.html Thanks

Hi all, Maybe it's a question or report to bug section, but i'm not sure :-) I have a database in UTF-8 encoding filled with text in czech laguage. Everything looks correctly ... by hand translation from UTF8 2 latin2 and back is correct. But When i make any LIKE or ILIKE comparsion it sometimes fails. It's realy weird because for example...

hi, i'm new in this copmmunity. i usualy use ms sql 2000 to develope Database in every project. But since Microsoft make an office in my city, there is big difficulties to get a copy of ms sql 2000 cd in my city (illegally hehehe). i think postgresql more powerfull than ms sql 2000, but i didnt get any information about DSN less according to...

hi, i'm new in this community. But i have a question about DSN. Is there possible to use DSN-Less in order to connect to Postgresql RDBMS (under redhat machine) ? i didnt find any information about DSN-Less in http://gborg.postgresql.org/project/gborg/projdisplay.php Thanks _____________________________________________________________...

hi, i'm new in this copmmunity. i usualy use ms sql 2000 to develope Database in every project. But since Microsoft make an office in my city, there is big difficulties to get a copy of ms sql 2000 cd in my city (illegally hehehe). i think postgresql more powerfull than ms sql 2000, but i didnt get any information about DSN less according to...

Does anybody know how to detect a NULL in a geometric box type? When I execute the following sql statement (coords is a box type) autotest=# select coords from dlg_control limit 1 autotest-# \g coords -------- (1 row)