PostgreSQL Database Forum

Hello all, I have got one table with rounding values, table contains prices and round types. id price_from price_to rounding 1 0 1500 0.1 2 1500 5000 1 3 5000 15000 10 4 15000 0 100

-----Original Message----- From: Kevin Bartz Sent: Friday, August 06, 2004 8:41 PM To: 'mike@thegodshalls.com' Subject: RE: Out of swap space & memory Well, all I'm doing right now is using psql from the command line. A bit unintelligent, I know, but I want to make sure things will work appropriately before I dive into the world of...

Computer Associates (CA) issued a million dollar challenge to the open source community today, aimed at fostering the development of migration toolkits for its newly open-sourced Ingres r3 database. The cash will be distributed to developers who create solutions that enable users of Oracle, Microsoft SQL Server, Sybase Adaptive Enterprise...

Hi, I am just getting into large objects and bytea "stuff". I created a small db called pictures and loaded some large objects and then tried to do a restore. Here is how I got the dump. pg_dump -Fc -b pictures > /Users/jerry/desktop/db.comp

Hello, I searched the archives and since I'm a relatively noivce user I'll have to run the risk of repeating already asked questions. I'm having a problem to migrate from version 7.3.4 to 7.4.2 On version 7.3.4 I do: vacuumdb --analyze $PGDATABASE pg_dump -x $PGDATABASE >$DATABASE

Hi: I'm running a large database on PostgreSQL 7.1.3. 20 days ago the database failed with a threatening and not too descriptive error like: pg_exec() query failed: server closed the connection unexpectedlyThis probably means the server terminated abnormally before or while processing the request. I lost some data and had to...

What does this mean? test=> create index cache_i_gist_sl on cache using gist (r_id, sl_ids); ERROR: index row requires 8216 bytes, maximum size is 8191 Postgres 7.4.2 I have btree_gist and intarray loaded. r_id is an integer, sl_ids is an int. Does it simply mean one of the int arrays is too large? Most of them have 0,

The debug logs seem a little confusing. On sending a query something like this will show up: DEBUG: StartTransactionCommand LOG: query: select * from blah; DEBUG: ProcessQuery DEBUG: CommitTransactionCommand This is with auto commit off. My first reaction on seeing this was the auto commit setting must not work. Then I noticed that...

Hello! I'm pretty sure this is an easy thing to do but I cant still figure out how. I have a table with about 20 columns, one column being the record_number. I want to insert 100'000 new records with 1, 2, 3, 4 .... 100'000 in the record_number field. All the other columns can be left at nulls or whatever the default is. Right now I'm...

Hello all, I am new to postgres and don't really understand how the database is set-up. I am very fluent with mysql and sql2000, but postgres is new to me. If anyone can point me to some good links I would appreciate it very much. Thanks, Darkcamel

Is there a way to provide a md5 password directly to psql? I'm aware of pgpass but I would like to store a md5 password in some other location and then use it to execute commands with psql. Thanks, John DeSoi, Ph.D. ---------------------------(end of broadcast)---------------------------

In an article about IBM's releasing Cloudscape to Apache, http://www.eweek.com/article2/0,1759,1630856,00.asp eWeek says: "The developer community for Cloudscape now consists of about 80 IBM developers, Rivot said. IBM of course anticipates that population will explode when the open-source community gets its hand on the code, but just...

I have the following 2 functions and I'm getting deadlocks when I call them from multiple threads. The first, I'm not sure why because I'm doing a select for update. The second I'm doing an insert on, and I thought insert will automatically do a lock as it inserts: -------------FUNCTION 1: -------------

Hello, I have an SQL database which I create with: psql -f create.sql foodb I then access this database and perform several insertions, modifications, and deletions. Finally, I want to backup my database. I do not want to backup the schema. All I want is a set of insert statements stored in a file insert.sql which I can run on a set of...

I'm looking at ways to get batches of sequence values s faster. I don't want to set cache or increment to a large number for a variety of reasons. I need to grab id's in batches of varying numbers at various times, from 1 to several thousand at once. Doing it 1 at a time works, but more time goes into it than I'd like. I tried setting cache_value...

Hello list, Could anyone point me the rigth way to write this query: INSERT INTO ped_cam (SELECT * from ped_pro where ped_pk=lnpedpk) WHERE NOT EXISTS (SELECT ped_pk FROM ped_cam WHERE ped_pk=lnpedpk); I got this:

I have the following 2 functions and I'm getting deadlocks when I call them from multiple threads. The first, I'm not sure why because I'm doing a select for update. The second I'm doing an insert on, and I thought insert will automatically do a lock as it inserts: -------------FUNCTION 1: ------------- CREATE OR REPLACE FUNCTION...

Is there any chance that PQunescapeBytea will always have a \000 at the end of the unescaped buffer? unescvalue = PQgetvalue(lastResult, row, fieldNum); value = PQunescapeBytea(unescvalue, &size); ie is "value" a C string or do I have to make another copy so I can append a \000 byte?

in oracle 10g, you can issue: ALTER SESSION SET NLS_COMP = ansi; ALTER SESSION SET NLS_SORT = binary_ci; do you think this is an elegant solution for case insensitive sorting & searching? is there interest in seeing this in postgres? -- dave

I'm looking at ways to get batches of sequence values s faster. I don't want to set cache or increment to a large number for a variety of reasons. I need to grab id's in batches of varying numbers at various times, from 1 to several thousand at once. Doing it 1 at a time works, but more time goes into it than I'd like. I tried setting cache_value...

Hi folks My application fail with 'Non-superuser connection limit exceeded' error , the client application is connected via ODBC AND GPF MESSAGE appear there. the 'Non-superuser connection limit exceeded' what'wrong?.

Hi, I am adding image and large object support in my Cocoa postgresql browser. Are there going to be any enhanced bytea support functions coming along? It seems sorta silly to have to write customized C code to import a file into a bytea field.

Dear All: Im looking for solutions (Free Software is better) to do query result caching. Thanks to the people from #postgresql I know that postgres doesn't do that by himself and the solution should be some kind of middle ware. This is our problem: we are executing the same set of SELECT SP/queries hundreds of times, without updating the...

My company is ramping up for a long ERP conversion project from Progress RDBMS and 4GL (www.progress.com) to a Postgresql/Java solution. I'm seeking an *expert* consultant(s) to establish an relationship with. We initially need help on deciding the best allocation of hardware for the application and for postgresql specifically. I say...

Is there any reason why there isn't a predefined cast to go from a timestamp to a varchar? Is there a reason not to add one? -- Jim C. Nasby, Database Consultant jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you...