PostgreSQL Database Forum

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)---------------------------

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

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...

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...

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

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

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.

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...

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!

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...

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.

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

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"

Hi, Why does adding SUM and GROUP BY destroy performance? details follow. Thanks, David Link s1.sql: SELECT t.tid, t.title, COALESCE(s0c100r100.units, 0) as w0c100r100units,

My company offers an ASP service for advertising companies using PG. For contractual reasons, each client gets its own replicated database. This presents a problem whenever a new feature/fix requires a DDL change which must be rolled out across N databases. Currently, we keep track of these changes via a central text file in CVS with manually...

Hi all, I would like to access an Ingres database (that is running on a HP-UX box) in perl on linux, but Ingres does not exist for that OS and I cannot compile the DBD module. Do you know if it's possible to use the pgsql client to access that Ingres database ? Thank you for your help

Currently I have a table defined as such: TAL=# \d internal_keywords Table "public.internal_keywords" Column | Type | Modifiers ---------+---------+----------- keyword | text | not null pid | integer | not null Indexes: internal_keywords_pkey primary key btree (keyword, pid) Foreign Key constraints: $1 FOREIGN KEY (pid)...

Hi all, I want to take backup of our online system on daily basis using crontab. But actually the pg_hba.conf is configured with password security. How I can take the backup without setting password. Or is their any other way to take backup. TIA

Hi @ all, i'm sure there was a psql-function to transfere my Blob-Data to the server but I can't remember. I have a script like this : UPDATE xy SET z = lo_import('localpath_and_file'); but i want to execute this script from the client and so my blob-data is

Is postgresql have an axisting solution for distibuting the databse amoungst several servers, so that each one holds a subset of the data and queries are passed to each one and then collated by a master server? I have heard erServer mentioned but i got the impression this might just be for backup and load balancing, and every server would...

I never knew running indent was so damn complicated. All three of my development systems can not manage it without throughing a fault (I've absolutely no idea why indent in the shell works but doesn't in pgindent on one). Anyway, has anyone pgindented the version of tsearch2 that runs with 7.3.4? If so please email it to me. The tar file is...

I'm hoping someone can tell me I'm wrong, but I'm thinking not. Anyway, here it goes: Sequence information is stored in their individual 1-row tables, with an entry is pg_class of relkind 'S'. So you can't really get a list of sequences with last_value in a single query without a butt-ugly pile of UNIONs in a query manufactured after a...

This message was posted on 18th Sept'03 ************************************************************************ Hi I am a recruiter and have a contract position for 3+ months with our client in Los Angeles. The ideal person we're looking for has to have experience in PostgreSQL internals - somebody who's gone in and enhanced the code...

http://www.computerworld.com.au/index.php?id=1482975508&fp=16&fpid=0 -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA LUKE: Is Perl better than Python? YODA: No... no... no. Quicker, easier, more seductive. LUKE: But how will I know why Python is better than...

Hello list, That's the question, what is the equivalent data type of the msSQL image data type ? TIA, -- Josué Maldonado.