PostgreSQL Database Forum

I can't find a reasonable explanation for this. I have a table game, with primary key gameid (an int). If I use a where involving gameid and <, or >, or <=, or >=, then I get a sequential scan. If I use =, then of course I get an Index scan. More surprising to me is the fact that using BETWEEN, I get an Index scan!!

Hi all, Someone asked me today if there are tools to migrate a 4D database to PostgreSQL. Any clue? Some googling turned up a tool to go the other way round and the archives got me an unanswered post about migrating from 4D to PostgreSQL, so I guess there's not much chance... Cheers.

Hi, I'm using PostgreSQL version 7.1.3. I would like to change the data type of a column from VARCHAR to TEXT. Is this possible? If possible, how should I do it? Can anyone throw some light on this. - Gnanam

I'm getting the following error message when I try to create a user or database on postgresql 7.2.2 on Freebsd 4.7, I installed it from the ports directory but I'm stumped when I got the following error message. When I do a /usr/local/etc/rc.d/010.pgsql.sh start all I get is this: freebsd# sh 010.pgsql.sh start pgsqlfreebsd#

Hi, I migrated one table from oracle to postgresql. I used a PgadminII. But the table allocated, in Oracle, 152MB and in Postgresql , after migration, the space was 568MB. Anybody help me? Tkank you! Jlopes

There used to be instructions on the web site about becoming a mirror - can't find it anymore. Does the project still need mirror sites? -------------------- Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114

Hi list I am working with postgresql 7.1.3 and 7.3.4 and German characters. I use only unicode databases. When importing data from iso-latin-1 via psql I tried drop table test; create table test(nr int, text1 text, text2 text) ;

Hello All, I was just updating a table in oracle9.2 by hand and bumped into this. Following seems to be the valid syntax in oracle. Update foo set somefield=NULL where somefield >9; Now I am not sure having something equalled with NULL is a good thig logically. I would say

How to install Cygwin PostgreSQL as NT Services on Windows 2000. i have do all procedure in postgresql-7.3.4.README file but i found error $ net start postmaster The postmaster service is starting. The postmaster service could not be started. The service did not report an error.

Hi all, the docs are not clear for me. If I want (in version 7.1.x, 7.2.x) to help the analyzer AND free unused space do I have to do a vacuum vacuum analyze or is a

Hi, I've just installed postgres on the Linux server. It is supposed to start automatically which I think it does since I can run an sql stmt right away. When I'm trying to connect from a remote machine I get a message that the remote machine IP address is not specified in pg_hba.conf, that there is no record of that machine there....

Hi guys, just a quick and probably stupid question. When I make a cluster based on an index on a table, how can I remove it later? Should I 'create' a new one by using the primary key index? Also, can I have more than 1 cluster on my table? Let me explain ... can I put for instance the record with, let's say, age between 10 and 20 on a...

http://www.ucomics.com/foxtrot/2003/09/14/ -- Jeff Boes vox 269.226.9550 ext 24 Database Engineer fax 269.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise

Is there a way to make Postgresql case-INSENSITIVE? Thanks

In this issue the following statement is made: "In plpgsql, you cannot run a dynamic SELECT statement and be able to do anything with the selected data. You cannot assign the selected value to a variable or return the selected value from the function. You can, however, easily construct INSERT, UPDATE and DELETE statements as well a DDL...

Hi, Would anyone able to advise how can I call a function/Stored procedure? what command to issue? Thanks. Best Regards _______________________

After installing PostgreSQL 7.4 beta 1 from source, I decided to install the /contrib module tsearch2. I cd to the tsearch2 directory and typed "make", however I get an error that yy_current_buffer is an undeclared identifier in wordparser/parser.c (which is apparently autogenerated with flex from parser.l). I looked online, and it seemed...

Hi, I am using the following to write data from an access table to a postgres table. I need to create an index on the "partnumber" field in the Bpb (odbc pg database) so I can seek on that field. Need to be able to locate and update records that already exist in the postgres table. It appears that the "partnumber" field is a memo field. ...

I posted it to the pgsql-hackers list, but I did not seem to get through. Not even sure if this is a bug or a feature :) When I create a temp table and then try to copy some data into the table, if the data is corrupt and the synchronization is lost - the table also seems to get lost. For example create temp table words(aa...

I've got a problem which I think may be a bug in Postgres, but I wonder if I'm missing something. Two tables, A & B have foreign key relations to each other. A 3rd table C, inherits from A. A stored procedure updates a row in C, adds a row each in B & C. I get an integrity violation. All the foreign keys are deferrable, and the stored...

I need examples of stored procedures returning datasets. Can anyone point me to some examples?

Hi: I'm very new to PostGreSql database and actually looking to evaluate for one of our project needs. Below please find some questions. I'm hoping if I can get some insight into these questions. Thanks. Ish...

I've got a problem which I think may be a bug in Postgres, but I wonder if I'm missing something. Two tables, A & B have foreign key relations to each other. A 3rd table C, inherits from A. A stored procedure updates a row in C, adds a row each in B & C. I get an integrity violation. All the foreign keys are deferrable, and the stored...

Hey, I've searched for MD5 crypting function in PG, but I did not find it. Anyone knows how to implement this function in PG ? Best wishes, Marek L. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Hey, I've searched for MD5 crypting function in PG, but I did not find it. Anyone knows how to implement this function in PG ? Best wishes, Marek L. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?