PostgreSQL Database Forum

Hello Harrison Fisk from MySQL claims in this thread: http://forums.mysql.com/read.php?35,3981,4245#msg-4245 That there are no major differences between InnoDB and MVCC concurrency. Is this true?

Hi Posgres users/developers, Can anyone explain why PosgreSQL (version 7.4.5 on Linux) does a full table scan to compute a count(*) on a base table after a vacuum analyze has been done with no following updates that might have outdated any statistics. Strangly the explain command does give the correct number of tuples instantaniously from...

I'd like to ensure that the creation of a department also implies the creation of two to eight projects; no more, no less: CREATE TABLE departments ( department text primary key not null ); CREATE TABLE projects ( project text primary key not null, department text not null

We are running Postgres 8.0 beta (ver 3), and are running into the following message while accessing the table through ODBC from PC-SAS: CLI describe error: Out of memory while reading tuples. We've followed the ODBC documentation and changed (well, actually, didn't *have* to change) the settings for the ODBC to avoid this problem. Any...

hi, can anyone give me some info on the caracteristics of object relational databases and their advantages as well as disdvantages! thanx in advance.

Background Info: I have a table with a approx 2.5 million rows. The table often gets 200-300 inserts per second. We are see that the database (7.4.1 Red Hat Enterprise ED 4 way Xeon) will periodically lock up all of a sudden and force the database to queue up hundreds of queries. The database comes to complete halt until eventually it...

Hello ! To kill a session i used KILL -INT <PID>. This command wasn't successfull. The processus is still here when an 'ps ax' or a 'select * from pg_stat_activity' Is there an other way to kill this process only because a web server 24/7 use postgres and cannot stop postgresql now.

Hi, I am using postgresql 7.1.3 in RedHatLinux 7.2. Can anyone tell me how to connect with postmaster through TCP socket (it is started with -i option) using libpq from an external application. (written in C) -- regards, Deepa K ---------------------------(end of broadcast)---------------------------

After 4 weeks of work, involving alot of bug fixes, and documentation improvements, to the source tree, we have just released our 4th Beta of 8.0.0. Most of the items on Bruce's Open Items list have been completed, but we still have a half dozen or so Windows related items still open. For a complete list of changes/improvement since Beta 1...

Hi: I'm trying to dump tableA and restore it to tableB: $ ./pg_dump -Fc -t tableA databaseA -f tableA.dump -v $ ./pg_restore -t tableB -d databaseA tableA.dump -v pg_dump creates tableA.dump aparently well, but after running pg_restore without errors I cannot find any "tableB", what am I doing wrong?

I have a process that hangs doing a "drop schema cascade delete". This happens in a slonik command, which runs fine if I run it directly from the command line, but hangs if run from inside my process. I'm pretty sure I'm doing something silly and it's not a slony-specific thing, and I'm hoping that somebody can point me to a server debugging...

Hi, In the 7.4.5 version, the code is now trying to use a much larger value for shared_buffers. I can certainly set this to a lower number with the -B option. However, my guestion is: What is the performance issue with setting shared_buffers to something like 45? In doing some timing on my system, I cannot tell any difference with 45...

Hi, I am using postgres 7.4.5 on Redhat Enterprise Linux 3. My background is really on Oracle, and I am porting a largish database over to postgres. Here is my problem: On oracle, I had a table with an "on update or delete" trigger that

I'm running into some problems with arrays in my SQL which're giving me fits. I've got some SQL statements that I'm issuing from my app using the PQexecParams() C call. All the parameters are passed in as literal string parameters (that is, the paramTypes array entry for each placeholder is set to 0) letting the engine convert. The...

How can I combine these two queries? # select viewerid,count(*) from viewer_movies group by viewerid order by viewerid; viewerid | count ----------+-------- 22964835 | 3055 22964836 | 1291 22964837 | 3105 22964838 | 199

Hello, If I do something like: SELECT * FROM sometable ORDER BY somerow DESC LIMIT 1 OFFSET 2; ... and there are multiple rows in sometable where somerow is identical, am I assured that the values will always come back in the same order? ...... Or do I need to ensure that a second sort (such as the oid?) is used?

unsubscribe abstractryan@yahoo.com unsubscribe ryan richards _______________________________ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com

Note : you may use illustrations and diagrams to enhance explanations. XYZ Company is a car Production Company. It has four factories and many distribution outlets spread across the country. The company keeps online records of the sales of its cars. It also creates batched production schedules on the basis of the sales of the car. The...

Hi all, I have a text field which I'll be doing LIKE searches against so I wanted to set up an index on it. The data itself is too long to create a full index, so I can't just: chris=> create index blah on ff_index(icontent); ERROR: index row requires 21216 bytes, maximum size is 8191

I have a table with about 1,400,000 rows in it. Each DELETE cascades to about 7 tables. When I do a 'DELETE FROM events' I get the following error: ERROR: Memory exhausted in AllocSetAlloc(84) I'm running a default install. What postgres options to I need to tweak to get this delete to work? Also, if my tables grows to 30,000,000...

I am writing functions and I find it curious that CREATE FUNCTION does not do syntax checking. Example: test=# CREATE FUNCTION foo(INTEGER) RETURNS BOOLEAN test-# AS 'this is total crap' LANGUAGE plpgsql; CREATE FUNCTION test=# select foo(1); ERROR: syntax error at or near "this"

I need to have an exact copy of a postgres install on a testing computer. I don't want to do slony. Is it feasible/reasonable to think that I could just rsync to the devel boxen from the pg server? Or is slony "The Way to Do It"(tm)? \<. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all...

In order to address a recent security report from iDefence, we have released 3 new "point" releases: 7.2.6, 7.3.8 and 7.4.6 Although rated only a Medium risk, according to their web site: "A vulnerability exists due to the insecure creation of temporary files, which could possibly let a malicious user overwrite arbitrary files." Also in...

The Slony-I team is proud to present the 1.0.4 release of the most advanced replication solution for the most advanced Open Source Database in the world. The release tarball is available for download http://developer.postgresql.org/~wieck/slony1/download/slony1-1.0.4.tar.gz There are a limited number of "new features" this release largely...

Hi all, I have upgraded my cygwin installation and it has replaced my old 7.3 postgresql. My questions are the following: How can I use the old files with the newer version? If this is not possible, how can I migrate my database to a newer version without the old database engine?