PostgreSQL Database Forum

Hi, i have 3 tables calling father, child1, child2: create table father(att0 int4); create table child1() inherits(father); create table child2() inherits(father); i want to get all the instances of the hierarchy:

Over the years, I've had people ask how, as non-coders, they can help support the project, either monetarily or hardware wise. As a result, I've bit the bullet and setup a PayPal account that anyone wishing to contribute to the project can use. Mostly meant to help offset the bandwidth costs, depending on the response, we'd also like to...

When using the (tbl).field notation for selecting a specific field from a composite field then the query returning the field is executed once per field. An example is giving below. The runtime is directly related to the number of fields accessed. The following tests is done with seqscan disabled - but I have confirmed the exact same...

Hello, I've an integer column in a certain table that I need to convert into a timestamp value to finally get a day difference to the current date. >From the manual it looks like straight forward, but the following line is a great mistery for me: SELECT to_timestamp(to_char(20041217, '9999 99 99'), 'YYYY MM DD') results in a timestamp...

Hi, I need to give some partners to a read only subset of my data. I'm currently looking at schemas, not something I've looked at or used before. Can I use schemas to create a virtual DB (built by views) onto my main DB? Or is this a dead end thought? Cheers, Bob

Does anyone know what the SQL standard say (or doesn't say) about division by zero for NULL? -- dave ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Hello, We a situation with a central database that contains the data that needs to be presented at N off-line terminals (N can be 5 000 can be 15 000). Each terminal presents unique data. The central database is used for data preparation. Then the data for each terminal is exported as separate SQL file. The terminals run the same application...

Hi all! consider the following table table a (id int primary key) and a particular instance of it: id ------------------------ 5 6

Maybe it's just me, but I can't seem to get pg_restore to restore a database... I am running 8.0 beta 2 (using the dev3 installer) on Windows XP. I created a very simple database with one table and one function and dumped it out using: pg_dump -U postgres -F c -f test.dump test

Hi, Is there in Postgresql something like the all_tab_columns table in ORACLE? How can I find if a column name exists in the database? For example, I want to find all columns that have a name containing the string 'USER', in any table. How can I do this? --

I tried to use pgAdmin III to add a table to a database. Using the GUI to add the fields it ended up creating SQL like this: CREATE TABLE customer ( id serial NOT NULL, name "varchar"(80) NOT NULL, balance "numeric"(10,2) NOT NULL DEFAULT 0 ) WITH OIDS;

I have a postgresql database into which I inserted about 40 million records over a 12 hour period. I did not perform any updates or deleletes on the records. After 12 hours I stopped inserting recods and started a "vacuum verbose". The vacuuming has taken almost 2 hours now and is not even finished. What I don't understand is why there is...

Hello, I have a simple two-column table mapping names to ids. I'd like to write a select statement that will return a default value if a given name isn't found in the table. That is, I want something equivalent to the following pseudocode: if exists (select 1 from map where name = 'foo') then select id from map where name = 'foo' else

Hi, I've run into a problem. I've had postgres V8 beta on my WinXP Pro machine for some time now, and it's been running great. Now, for some reason, I cannot issue any queries to the database via psql. See snippit below... ------------ C:\Program Files\PostgreSQL\8.0-beta1\bin>createdb -U postgres test CREATE DATABASE

Hi , I have an application that ran on Oracle, and the application, for some reason requires autocommit to be true. Now, when we moved this application to postgres, we moved the blob column to LargeObjects. But PostgreSQL doesn't seem to be able to use Large Objects with autoCommit = true. Is there any other way to work around this...

Reason being I'd like to install them locally on my laptop so that when I'm lap topping it, I still have docs without the need for an Internet connection. Regards. Hadley

Converting some MySQL code to work with Postgres here. I have this query: SELECT tasks.task_id, (tasks.task_duration * tasks.task_duration_type / count(user_tasks.task_id)) as hours_allocated FROM tasks LEFT JOIN user_tasks

Hello, We develop SMS application using a proprietary framework installed on Linux server. This framework installs and creates Postgres 7.1 data base under /var/lib partition. Client notices that /var/lib partition seems too small for SMS application activity. Client would like to move postgres data files from /var/lib to a larger one....

How to import an Excel table into a Postgresql table in a simple way? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Hello, I am running into a problem with PGs case sensitivity with regard to column and table names. I am using program components that require the object names returned from database metadata queries to be in uppercase. Therefore, I am forced to use double quotes in the table creation scripts, like create table "BLA" (); However, after...

Hello, Does anyone have experience in interfacing a Postgresql database (tables? plpgsql functions? perl functions?) with the outside world through webservices? (XML-RPC, SOAP, UDDI, WSDL...) Philippe ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an...

Is there a safe way to convert varchar(n) to text, other than create a new column, update, delete column, rename? I have a number of databases that were built with varvhar(n) and which should have been done with text. They're in production, and I'd rather not take the downtime needed to convert some rather large tables - the bulk update...

Dear Sirs, I want to dump all databases, but separately each database in its own file, not all databases in one single file as pg_dumpall does. How can I implement that ? Cheers, Ilia Chipitsine

I'm new to PostgreSQL, and from the looks of it, it's a great database, and I'll be using more of it in the future. I had a quick question if anyone could clear this up. The documentation for PostgreSQL (version 7.1, the version this server is using) says that it supports multibyte character encodings like Unicode (which implies UTF-16...

Hi: Our postgres database has tables with several million rows in a server running Red Hat 8.0 with 1GB of memory. Recently we are experiencing a low performance in the access to the server via HTTP, after rebooting the server the speed is the same. I have noticed that available memory is aparently too low, according to top: 12:58pm ...