PostgreSQL Database Forum

(Please CC me on any replies as I'm not on the list) Hi, After a recent power failure, a program that uses a pgsql backend (netdisco) started to send me nastygrams. I tried the author's suggestion of running a VACUUM FULL ANALYZE VERBOSE;, but it still sends me the messages. The data in the database isn't too important, i.e. I'm willing...

Dar Friends , what is the exact Minimum System Requirement (hardware and software ) of PostgreSQL 8.x ? thanks. Ali

Hello all I've been approached by the development people about removing the 'public' schema. They complain about having to manually remove the 'public_' tag from table names generated by their development software whenever they link to PG via ODBC. Renaming or using another schema is not what they're after either. 1. If it is...

I am doing connectivity to PostgreSql from asp.net 2.0 using odbc but i am not able to connect i got error Data source name not found and no default driver specified. code is written for connectivity is like... con = new OdbcConnection("Driver={PostgreSQL};Server=Ip Address;Port=5432;Database=database name;Uid=user id;Pwd=;"); from google...

Hi, I have had a site working for the last 2 years and have had no problems until at the weekend I replace my database server with a newer one. The database migration went like a dream and I had the whole db changed over in 1 hour. Since the upgrade I have been getting the following error message sporadically.

I need to convert array elements to rows. Suppose that I have the array {5,77,39,19}. I need it as a table with the index in one column and the element in the other column:index | element ------+-------- 1 | 5 2 | 77 3 | 39 4 | 19Which command does this?

Hello. I am trying to port an old java application from MS SQL Server to PostgreSQL running on Mac OS X. I have access to the java source code and can make modifications. I have tried with PostgreSQL version 7.4.2 and 8.0.0beta2, but get the same error. I am using pgdev.305.jdbc3.jar for 8.0.0beta2. The PostgreSQL installation are standard,...

On 7.4.6, is there any problem with defining one column of a view to be a string literal? For example ... $ psql -c "create view fooview as select 'bar' as footype" WARNING: column "footype" has type "unknown" DETAIL: Proceeding with relation creation anyway. CREATE VIEW Or is this warning just noise in this case?

This may have been better posted in the advocacy list but I am not a subscriber. We recently purchased Dreamweaver MX and I was a little surprised to find that one of its pre-defined scripting systems is PHP + MySQL. I haven't done much exploring of what is actually offered but wondered whether any one had tried to convince Macromedia to...

I've been scouring the PostgreSQL web site and have found several references to a Database Migration Wizard. I was unable, however, to find any details. Would someone be kind enough to explain what and where it is? I need to migrate an Oracle db to PostgreSQL.

I am rather new to PostgreSQL.What I am looking for ist this: An example database that demonstrates the usage of all the core PostgreSQL features. It is one thing to read extensive documentation, but it is much more intuitive for me to see an example database, that demonstrates the whole thing interacting. I mean, not just the basic...

I am working at a company that has been using MS SQL Server, and we are going to be switching over to postgresql next week. (Getting off of Windows will be a relief!) I am very familiar with SQL Server's "Enterprise Manager", which is their GUI for accessing the db. I have been acquainting myself with pgAdmin. There are a number of things...

Hi I need to store accented characters in a postgres (7.4) database, and access the data (mostly) using the postgres JDBC driver (from a web app). Does anyone know if: 1) Is there a performance loss using (multibyte) UNICODE vs (single byte) SQL_ASCII/LATINxxx character encoding? (In terms of extra data, and searching/sorting speeds).

dear all, i have to modify the datatype of a column of a table. the datatype of the column is varchar(2). i need to increase the length to 20. can u provide the query to change it TIA

Hello I have postgresql latest version running on RH 9. I want to write a windows based application to interact with postgresql server. For that I plan to use libpq i.e. using C. I can work with the linux version but try as I might I am not able to locate a source for compiled ( static ) version of libpq and its header files for Windows.

Hi, I need to do something like this: select * from sms where message ilike 'foo%'; Message is a bytea field with UTF-8 content. The charset is actually not important for me, it would be enough if it could just treat it as us ascii. The statement does not work because postgresql can not convert bytea to text. But this works:

I'm trying to get a feel for what most people are doing or consider best practice. Given a mod_perl application talking to a PostgreSQL database on the same host, where different users are logging onto the web server using LDAP for authentication, do most people 1) have the web server connecting to the database using its own user account...

I have been looking for an interactive PL/pgSQL for Postgres with no luck. Does anybody know of one open source or commercial? If not then I would like to know if there is currently a debugging API that can be attached to for writing such a debugger? And finally... If there isn't any debugging API how many people are interested in...

(PostgreSQL 8.0 beta 4 on Mac OS X 10.3.6) I'm working on a function which creates and populates a temporary table, then returns the number of records it has inserted. I'm getting an error, though, after successive invocations of the function (I can call it once successfully, but on the next call I get an error). I've been able to...

i have instaled postgesql 7.1.11 on red hat el 5.3 after installtion its worked. when i change the line in /etc/rc.d/init.d postgresql as export PGDATA=/var/lib/pgsql/nampetdb (export PGDATA=/var/lib/pgsql/data) after that i could not restart the postgresql the contents of postgresql log id The files belonging to this database system...

I'm trying to build a table that will store a history of records by enumerating the records. I want the newest record to always be number ZERO, so I created a trigger on my table to handle the assignment of version numbers: CREATE TRIGGER "trg_audio_file_insert" BEFORE INSERT ON "public"."audio_file" FOR EACH ROW EXECUTE PROCEDURE...

Is there a visual designer (open source) in linux for database? I would like to developp my data model on the computer... I see "dia" with uml library but... it won't export to SQL. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

I have many tables created in the "public" schema and I would like to migrate these into an "x001" schema. Unfortunately there is no ALTER TABLE construct for this... The following SQL would seem to move the "zxc" table from "public.zxc" to "x001.zxc": UPDATE pg_class SET relnamespace = (SELECT oid FROM pg_namespace WHERE nspname =...

I HAVE A PROBLEM REGARDING DECLARATION/ INITIALISATION OF VARIABLES IN POSTGRESQL FUNCTIONS AND PROCEDURES. MY CODE PRESENTLY LOOKS LIKE CREATE FUNCTION ins_into_std_values() RETURNS void AS $BODY$ myflag CHAR(1) :='y'; dbms_output.put_line('enter the values sequentially'); loop if myflag='n' then exit; end if;

Hello list, What's the "right" way to uninstall postgres 7.4 in Linux (RH 8)?. Thanks in advance -- Josué Maldonado