I'm trying to produce a query which summarises a lot of data, and I'm getting it wrong. I don't know what it is I'm doing wrong, but it must be...

Simon Brooke

06-23-2006 06:54 AM
Simon Brooke

Hi! Got relatively simple (10+tables), small (some thousands of entries) database with some (5-6) users. Need to build some sort of simple interface...

Vahur Lokk

06-10-2006 09:34 AM
Daniel J. Rubin

Could someone please explain how I can get the hour difference between two time fields? I tried: SELECT ((EndTime - StartTime)/3600000) AS...

Mike the Canadian

06-07-2006 02:51 AM
Laurenz Albe

Hello NG, Sorry, I'm shure this is a faq. But I did not find an answer yet. I had a table with an automatic generated primary-key; generated by...

andreas seik

06-01-2006 11:41 PM
Thomas Antepoth

Hi there, it sometimes happens that I have to load an SQL dump into a postgres 7.4 database, that was made with postgres 8.0 or 8.1. Is there any...

Marco Herrn

05-31-2006 03:59 AM
Marco Herrn

Hello, when I try to save a float value of 1.0e-39 to a PostgreSQL-Database, I get the error type "real" value out of range: underflow I'm using...

Tino Langer

05-30-2006 03:52 AM
Laurenz Albe

Hi, I'm having trouble understanding, why a specific query on a small database is taking so long... I've ported our LDAP database to an SQL backend...

Antonio Batovanja

05-29-2006 02:46 AM
Laurenz Albe

hello, I'm looking for a function to build age brackets from a age column. Is there such a thing in postgresql ? Regards Blaise

meles

05-24-2006 02:52 AM
Laurenz Albe

Hi everyone. I am developing two applications that share the same DB on a server: one (application A) must prepare the database, fill it, etc (it is...

Pegasus86

05-23-2006 03:28 PM
Justin L. Kennedy

Anyone know what happened with the 'money' datatype that was with previous Postgresql version 8.0? I know I can use 'numeric(9,2)' instead but how...

Schmidty

05-19-2006 11:53 AM
Schmidty

applicable to PG 7.4 - posted for reference... as we know - granting privileges to a database does not filter down to the tables. the database...

kevin bailey

05-17-2006 04:30 AM
kevin bailey

I wish to create a database which will refer to users in an existing LDAP database. I've considered writing code to simulate a table which selects a...

Matthew King

05-05-2006 03:53 AM
Laurenz Albe

Hi all, I want to log all user activity. So I've created "logs" schema and duplicated all tables that I want to audit. I've also added some...

POX

05-05-2006 03:29 AM
Laurenz Albe

My question is whether there are any good reasons to choose large objects over bytea other than the bigger size limit of 2 GB. As I understand it,...

Laurenz Albe

05-05-2006 02:55 AM
Laurenz Albe

Hi everyone. I have noticed that, if a client application crashes (for example, if the PC on which it runs suddenly shuts down), its connections on...

Pegasus86

04-28-2006 04:07 PM
Pegasus86

BEGIN; UPDATE accounts SET balance = balance + 100.00 WHERE acctnum = 12345; UPDATE accounts SET balance = balance - 100.00 WHERE acctnum =...

Karen Hill

04-24-2006 03:48 AM
AT

Migrate-Data is a pure java and an extremely powerful enterprise data migration tool aimed at small and medium sized databases. It has been developed...

pravumishra

04-23-2006 11:54 AM
pravumishra

Hi group - not sure if my error is coming from the database install, or from the Perl DBI version My script used to run perfectly on a Linux server...

Syl

04-20-2006 11:10 AM
Syl

Hello, Is there anybody who can give me the file : libpq.dll version 7.2.3 ? Thanks

Franck

04-18-2006 10:45 AM
Franck

I'd really like to find multidimensional data based on a kd-tree in an efficient manner. I would need the following search operations at...

noone

04-18-2006 02:26 AM
Laurenz Albe

I have a table: CREATE TABLE resources ( "Resource" varchar(15) NOT NULL, "Active" int2 NOT NULL DEFAULT 1 ) When I try this SQL:

Mike the Canadian

04-14-2006 03:31 AM
Laurenz Albe

I have a pretty decent server - Dual Xeon 2.8 with 3GB RAM. I use it to run two sites based on PGSQL. Current load is always around 0.1 or...

Entrep

04-11-2006 03:12 PM
Ringhio

Hi everyone. I must create under Windows a PostgreSQL 8.1 db, and I have created a schema with a function linked to a C function contained in a dll...

Pegasus86

04-10-2006 02:59 AM
Laurenz Albe

Hello, I guess what MSAccess calls relationships is only another word for the definition of foreign keys. I'm running Postgresql under Ubuntu,...

tom cox

04-10-2006 02:46 AM
Laurenz Albe

I'm beginning to move a very simple set of php scripts from MySQL to Postgresql and want to know if Postgresql has anything like MySQL's rollup...

rloef@interfold.com

04-02-2006 09:37 AM
rloef@interfold.com

I have a table of questions, a table of possible responses (there are several types) and a table of subjects (people) with their answers to each...

j_mckitrick@bigfoot.com

03-29-2006 03:59 PM
j_mckitrick@bigfoot.com

I am looking for a sublease from july 06 to jan 07 . I am a indian guy , i wants to share the room preferably with Indian's. Mail me s_gupts (AT)...

Wen Hsieh

03-29-2006 10:55 AM
Michael Roach

Hi, I have created this table: "CREATE TABLE books ( book_year char(4), book_id serial, book_title varchar(50), PRIMARY KEY (book_year, book_id) )"

Pegasus86

03-29-2006 07:47 AM
Pegasus86

Hi~ I have already installed postgre 8.1 on windows XP, but I cannot use pgAdmin III to create / maintain the replication, so what can I...

calendarw@gmail.com

03-23-2006 03:22 AM
calendarw@gmail.com

hi, first off - never posted here before - but love PG - thanks for the hard work. best DB by miles. even the www.postgresql.org website is...

kevin bailey

03-16-2006 06:27 PM
kevin bailey

Hi ! I am working with PostgreSQL 8.0.1 on Debian GNU/Linux. I am kind of "fighting" with the fact that postgres won't let me alter / drop tables...

Cujo

03-09-2006 02:11 AM
Laurenz Albe

Hello. I have an SQL script that creates database structure. Besides all CREATE TABLE statements it grants ownership to tables using syntax ALTER...

alex221@pisem.net

03-02-2006 01:50 AM
Laurenz Albe

Hi all, I'm running 8.0.3 on Debian, and I have a problem I'm sure is quite simple. I'm importing data from a CSV file, and it has a first and last...

j_mckitrick@bigfoot.com

02-28-2006 05:50 PM
Ch Lamprecht

All, I have several tables that have as the last column a field that is bigserial, a primary key and references the sequence that was created at the...

rloef@interfold.com

02-23-2006 03:05 AM
Laurenz Albe

Hello. I'm working on a database structure and some of the tables in it must store bit fields. Later on it must handle queries like "give me all rows...

alex221@pisem.net

01-20-2006 06:37 AM
alex221@pisem.net

Hi I have PostgreSQL 7.4.7 on Debian 3.1 (sarge). I want to have data in /home/postgres/data and config files in /etc/postgres. But the config files...

Marek Simon

01-19-2006 09:04 AM
Marek Simon

I love the new PostgreSQL autovacuum feature. Question: is it possible to set it up so that autovacuuming only happens during a certain time of...

Chris Paul

01-19-2006 08:22 AM
Justin L. Kennedy

Alexander Schreiber <als (AT) usenet (DOT) thangorodrim.de> writes: Quite true. It's a good thing the Sarbanes-Oxley statute (a U.S. law, not an...

Karen Hill

01-16-2006 09:03 AM
Frank Hamersley

Hello, I saw lot of topics treating about the subject, but nowhere i found real solutions. Has the bug been fixed? # set ...

Amédée

01-11-2006 12:49 PM
Amédée

Hi! is it possible to pass table name as parameter to SQL function ? I want to have one function which will work as generator sth like 'SELECT...

Grzegorz

01-11-2006 02:39 AM
Grzegorz

a table is created and an index is created on that table then one row is updated what happens to the index file? ( is the index to old row deleted?)

chenb1981@sohu.com

01-11-2006 01:33 AM
chenb1981@sohu.com

Hello, I have to develop a companies search engine (looks like the Yellow pages). We're using PostgreSQL at the company, and the initial DB is 2GB...

Charles

01-09-2006 03:14 PM
Charles

I am working in team on CMS system Thetaworld MakeSite http://sourceforge.net/projects/tmakesite/ and I am searching on simple function/trigger to...

Rosario Maddox

12-29-2005 04:42 PM
Rosario Maddox

Postgresql Gurus, In Oracle to get difference between today and any date column I do the following SQL> SELECT (SYSDATE-EXPIRY_DATE)*24*60...

patilharshal@gmail.com

12-13-2005 05:33 AM
Steinar H. Gunderson

I am using Postgres 7.4.6 i have 3 tables i want to join 3 tables and return a list of route_id to which a specified user_id does NOT...

Gary Townsend

11-25-2005 04:25 PM
Gary Townsend

Mike Cox <mikecoxlinux (AT) yahoo (DOT) com> wrote: A brief web search seems to indicate that Slony1 has not been ported to Windows (yet). So I...

Laurenz Albe

11-17-2005 03:23 AM
Laurenz Albe