[GENERAL] massaging data from multiple timezones

I inherited a system which I need to now extend. It's like a security system, collecting event times from many sources. When the system was built all the sources were local, so timezones didn't matter. But now we're working in more areas, so they do. The raw data comes in as UTC, and the current

Re: [GENERAL] Postgress and MYSQL

[EMAIL PROTECTED] ("Joshua D. Drake") writes: >>BTW, I've asked this before but where are the 7.4 docs in PS or PDF format? If >> > > They are being worked on ;) > >>any one needs or wants them, I do have the 7.3.2-US books (admin, user, >>programmer & reference) in PS with the duplexing code. Th

[GENERAL] UNICODE-encoded database does not accept umlaut-characters.

Created a new 7.4 database. # create database foo with encoding = UNICODE; Then tried to restore my dump from pg 7.2 which was SQL-ASCII or Latin1 encoded (cant tell which of the two, only got the dump of the old database left after upgrading postgresql.) Succeeded creating the objects, but no da

[GENERAL] Tool to ease development of plpgsql

What's the best way to ease development of plpgsql. My largest issues with plpgsql pertain to the quoting of course. Bill McMilleon ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining

Re: [GENERAL] sequence incrementing twice

"dan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have 2 tables, tab1 ( integer incremented sequence , col2, col3 ) > and tab2 ( integer from tab1, col4, col5 ). When I call this function > to add a record to each table: > > LOOP > select nextval('sequence') into id_ca

Re: [GENERAL] Tool to ease development of plpgsql

Would a tool like www.presicient.com/teraforge be of value ? I'm thinking of making a Pg portif interested, please let me know, and let me know what kind of features you'd like to see... -- Dean Arnold Presicient Corp. www.presicient.com "Richard Huxton" <[EMAIL PROTECTED]> wrote in message

Re: [GENERAL] check date validity

On Fri, 2004-01-16 at 06:58, Harald Fuchs wrote: > In article <[EMAIL PROTECTED]>, > "LitelWang" <[EMAIL PROTECTED]> writes: > > I need this function : > > CheckDate('2002-02-29') return false > > CheckDate('2002-02-28') return true > > Why would you want to do that? Just try to insert '2002-02-2

[GENERAL] Tool to ease development of plpgsql

  What’s the best way to ease development of plpgsql.   My largest issues with plpgsql pertains to the quoting of course.   Bill McMilleon  

Re: [GENERAL] Huge Data

On Wednesday 14 January 2004 18:09, Sezai YILMAZ wrote: > Richard Huxton wrote: > >PG uses MVCC to manage concurrency. A downside of this is that to verify > > the exact number of rows in a table you have to visit them all. > > > >There's plenty on this in the archives, and probably the FAQ too. >

[GENERAL] Detecting database corruption

My company is developing a PostgreSQL 7.4 application. We don't want our customers to have to manage the database. If the database ever becomes corrupt, we have procedures for restoring the database from backup data. The question we've been wondering about is how to detect a corrupt database. Fals

[GENERAL] about postgres odbc on wondows

After I installed the driver I found three DLL files from windows(2000) ODBC manager : psqlodbc.dll psqlodbc25.dll psqlodbc30w.dll What's the difference ? Thanks . ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregiste

[GENERAL] Data recovery!

Hallo. This is the log. This is postgresql 7.4.0. The problem appeared after few hang-ups because of phisical memory problem. Is there any way to recover the data? 2004-01-07 21:18:05 LOG: statistics collector process (PID 886) exited with exit code 1 2004-01-05 15:12:23 LOG: could not create IP

Re: [GENERAL] What Version Installed?

[EMAIL PROTECTED] (Phil Campaigne) writes: > How can I determine what version of postgresql is installed. Can't > find answer in archives. How to determine the version is well documented here... -- let name="cbbrowne" and t

[GENERAL] pg_catalog permission problem

I'm using Postgres 7.4. I have a database called tracking and user called test5. From the Red Hat command line test5 can psql tracking and run: SELECT * FROM Customers; Not surprisingly, a list of customers is shown. I have a Visual Basic application is accessing the same database. The same

[GENERAL] when I create a table, postgresql creates a new type

Good day, I´m testing PostGresql, I would like to Know why when I create a new table, postgresql create a new type with the same name of the table. Where I can find more information about this?. ---(end of broadcast)--- TIP 7: don't forget to in

[GENERAL] Integer ranges in PostgreSQL

Does exist a syntax in PostgreSQL for integer (INT) number ranges? It could be useful for queries like "SELECT * FROM table WHERE id IN (range from 1 to 20)" Thank you! Marco ---(end of broadcast)--- TIP 2: you can get off all lists at once with t

[GENERAL] transactions in c api (libpq)?

Is it possible to write C code (presumably using libpq) to carry out transactions? I can't seem to find functions in this API which start and end a transaction. If this is not possible, what other programming interfaces will allow me to write transaction code? Thanks ---(

Re: [GENERAL] What Version Installed?

There are several answers to this. If you use a package manager like rpm (e.g., RedHat, SuSE, Mandrake), try: tallac$ rpm -q postgresql postgresql-7.3.4-3.rhl9 Most (all?) binaries take a the standard-ish --version flag, like this: tallac$ initdb --version initdb (PostgreSQL) 7.4.1 ta

[GENERAL] Finding if a function / stored procedure updated the database

Hi All, I am implementing a "poor mans" peer-to-peer replication system for a php web application and need to know if there is an easy way of figuring out if a function makes / made a change to the database. If there isn't an easy way, what would be the best / recommended way? Thanks for any fee

[GENERAL] newbie question on database structure

I want to design a data base that can hold the following structure struct { unsigned short a; unsigned short b; unsigned int len; unsigned char *data; } myObject; a and b describe the type of object, len is the number of bytes that are required to hold the object. and of course da

[GENERAL] Solution to UPDATE or INSERT Problem

I've seen a couple of questions here in the past about how to update an existing row or insert a row if it doesn't exist without race conditions that could cause you to have to retry a transaction. I didn't find any answers to this question in the archives however, so I thought I'd post my solutio

[GENERAL] How should I get started?

I've been programming web applications in PHP/MySQL for a few years. It's worked decently, but I've been getting annoyed with the lack of more advanced features lately. After some reading, I've decided to switch to Perl/PostgreSQL. I'll be discarding all database data for other reason anyway, s

[GENERAL] unique index creation failure in 7.4.1 - bug?

Did a pg_dump of a 7.2 DB and am now trying to restore to 7.4.1. Index creation on a table fails: db=# CREATE UNIQUE INDEX person_info_username_ix ON person_info USING btree (username); ERROR: could not create unique index DETAIL: Table contains duplicated values. Of course, this index existed

Re: [GENERAL] Postgress and MYSQL

""Bob Powell"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > To whom it may concern: > > I find the recent articles in various trade publications a little > disturbing due to the lack of PostgrSQL mention. I continue to see > articles about how IBM may be considering MYSQL for dev

Re: [GENERAL] Some basic SQL Questions

"Steven O." <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] > First, this may not be the correct newsgroup. I have some relatively > basic questions on SQL. I tried to find a newsgroup that was > specifically just about SQL, and was surprised to find that all the > SQL-related newsgroups seem to be

[GENERAL] Error with tablefunc in postgres 7.4.1

I am having problems with contrib/tablefunc in postgresql 7.4.1 on freebsd when i try to make install i get the errors below. I am unable to make the 7.3 -> 7.4 transition until i can get the connectby function to work as i use it all the time. Can anyone suggest anything that i can do to get t

Re: [GENERAL] Any real known bugs about wrong selects?

David Teran wrote: The real question was: are there open known bugs where a select statement does not return a correct result, meaning a wrong number of rows? Were there a lot of errors like this? We are asking this because this makes trouble with the database we are currently using. Of course w

Re: [GENERAL] what we need to use postgresql in the enterprise

First I would be happy to help get these things in postgresql. I'm not a c/c++ programming guru and would have to learn a bit before I could do the coding. I would be happy to test or talk about what's needed or anything like that. Or just keep the fire burning on these issues that I think are

[GENERAL] Connecting using an existing socket (libpq).

I have a 3 tier client/server application where the client connection to the server which then uses PostgreSQL. I'd like to extend the client to have direct access to PostgreSQL but do not want to open up postgresql to the internet. So, I'd like to tunnel the libpq connection over the existing se

[GENERAL] Survey: Motivations to Contribute

Hi all! I'm doing a research project on the motives of free software / open source software developers. This survey follows a somewhat different approach than some earlier studies and tries to incorporate concepts of social psychology to better understand the internal motivation of developers.

[GENERAL] Compile postgre 7.1 on Redhat 9?

Hi. I just upgraded an older machine I have that I don't use often to redhat 9. I however, in my infinite wisdom, forgot to dumpall the postgres db. I now find myself wanting to get some data out of the old 7.1 database. The original data directory is still intact, so I tried downloading the 7.

Re: [GENERAL] cross-table unique constraint

So how might I go about doing this. 3 tables: a, b, and c When these 3 tables are joined, there is a combination of 3 fields, one field from each table, that should be unique. Should there be a trigger that checks this condition on inserts/updates on each of these tables? Randall Bruno Wolff