PostgreSQL Database Forum

Currently I'm running PostgreSQL 7.2.3 and having a problem sorting. I've got two colums of data, one Int4 one Varchar. When I sort ASC on the varchar I get some strange results. Here a section of data cut after running a sort. It starts with RM- then does RMT- Then goes back for more RM-. I've checked for spaces or tabs or anything else...

Hey guys, I have a need to install the DBD::Pg Perl module on many shared web servers, which do not have PostgreSQL installed. Then the DBD::Pg module will just connect to a remote PostgreSQL database, hosted elsewhere. I'm having some problems doing this. First off, I modified the Makefile.PL, and added the three following links just...

Hey guys, I have a need to install the DBD::Pg Perl module on many shared web servers, which do not have PostgreSQL installed. Then the DBD::Pg module will just connect to a remote PostgreSQL database, hosted elsewhere. I'm having some problems doing this. First off, I modified the Makefile.PL, and added the three following links just...

Is there a way in postgres to view current client connections? including statistics.. how long did it take for him to connect and disconnect.. etc TIA ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

I am trying to use the fti module to search my text. Searching through the raw text using ILIKE takes 3 seconds, searching using fti takes 212 seconds. Then i tried to turn off seq_scan to see what happens, the planner still does a seq_scan. Why does the planner not use the index? Are there any other text indexing modules i should be...

I posted earlier with a very complex example. This simple one gets to the point much faster. timeofday() seems to behave inconsistently when the timezone is set with "GMT+X" notation. foo=> select cast(timeofday() as timestamp with time zone); set time zone 'GMT+4'; select cast(timeofday() as timestamp with time zone); timeofday...

My Postgres databases used to have default (SQL_ASCII) encoding. I could store any 8-bit character in it regardless of actual charset, because all clients also used default encoding and no charset conversion was done. Now we started a new project with Qt3 and it's Postgres driver defaults to UNICODE client encoding. This time charset...

Hello gusy!!! I'm trying to compile the latest version of usogres that I downloaded from the link: http://usogres.good-day.net/install.php3 But when I try to compile (see errors below). I even changed the gcc, but no sucess, same error. Well, I hope someone can help me, thanks! I'm using Red Hat 8.0, and gcc 3.2.2-5.

Hi, I am also interesting to learn and implentaion of HLR database, u got any good web sites and good stuff material please forward to my email id. Thanking you, Regards Fyrose.

Hi there, I wonder if anyone can shed some light on a very frustrating problem. I'm running a debian linux 3.0 "woody" server, nothing special, with the latest version of postres that apt-get will allow me, which I *think* it;s 7.1 something, I don't know how to figure out the postgres version. Anywho - I'm trying to backup my databases,...

hi, I want to connect to database repl_isar located in host isar from host willy. So I wrote: String url = "jdbc:postgresql://isar/repl_isar"; conn = DriverManager.getConnection(url,username,password); But it fails by given error both in postmaster running repl_isar and local site willy.

Hi, I have a question about transactions. I am developing a Postgresql client. If I start a transaction in a Postgresql client code, and in this process a trigger is executed. Are all the processes within the trigger in the transaction too? Thank you

hi, all, I have just read Postgresql-7.3.4 documents about WAL (write ahead logging). But there are still something unclear to me. I'm not sure my understanding is right. Please let me know if there is anything wrong. Thank you all in advance. WAL means any changes to data pages shouldn't be written to disk before the its log record have...

I'm a bit confused about SET TIME ZONE and its effect on PostgreSQL's date processing. In my experience with timestamps in all other *nix-based software systems, a timestamp is always a numeric representation of the time elapsed since the epoch, in GMT. Thus, a function that returns the current timestamp should always return the same...

Hello, I was wondering if PostgreSQL has SNMP support. I'm looking into doing some performance monitoring of a Postgres instance and would like to know if there is a PostgreSQL SNMP Agent or something similar? I saw Bruce Momjian's tcl/tk monitor application at <http://gborg.postgresql.org/project/pgmonitor/projdisplay.php> but I really...

I currently have PostgreSQL 7.1 installed on a server with about 700 Mb of RAM. I have many problems of speed with a database I created. For example, it took almost 12 sec to run the query "select * from table" directly from PostgreSQL, on a table with 4000 records and 60 fields ... And the whole application built on this database is very...

Hi, Is it possible to get all the positions of a lexeme in a result-set of a query? For example, we have the table TEXT TEXT_IDX 'TSearch2 is very cool' ... 'It would be much cooler with lexeme positions'

Hi I would like to paginate the results of a query on several pages. So I use a query with a limit X offset Y to display X results on a page, ok. But for the first page, I need to run the same query with a count(*) to know how many pages I will get (number total of rows/ X). The problem is my query is very slow (maybe 5s) because there...

I have two tables in two databases (Pg 7.2.1 - yes I need to upgrade but there are several other dependencies I have to resolve first) and I need to update one database's tables so they can be merged into the other database's table. I know I can drop the constraints and update the tables (primary key, and foreign key) but was hoping I'd not...

Just loaded up 7.4Beta on a test system, to try and work out what the major changes are/improvements.... I also started up pg_vacuum as this is now working very well on our semi-live system (semi-live because we have not finished developing the system yet.....) Anyway. After trying to throw our 7.3 config file at it and it crashed badly I...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I have an old-ish Sybase dbms (SQL Anywhere v5.x) that does not offer a DUMP command. The only way to extract data is to SELECT all of it, then OUTPUT it in some format: csv, dbase2, dbase3, etc. I searched the docs and faqs for information on importing data and could not find anything...

Hi, We're upgrading an old 7.0 database to 7.3. The old 7.0 database has some high bit characters which we will assume are Latin9. We're trying to upload into a 7.3 UNICODE database. Normal pg_dump -> psql. At first we had the problem where it considered every highbit character to be a unicode sequence. So we've added: set...

What's the big deal with importing text files? I have a 70 MB file to import and it's been one problem after another. I used the copy command and it appears that it's just not possible. I finally massaged the file into a .sql file and ran that using \i db.sql but that failed too because I overlooked ' in names like D'Adario. The other...

Hello everyone, Several columns in sereval tables in my DB should always be lowercase. I now have a simple function: create or replace function code_lower() returns trigger as ' begin NEW.code := lower(NEW.code); return NEW; end'

Hello everyone. I have been using PostgreSQL for about 3-4 years now, it's wonderful how I can make it do things and write Perl programs to interface with it. Since I do all of the DBA behind the scenes on our company Intranet (Linux-Apache based), and I really prefer writing Perl programs to do my simple admin functions. I really like...