PostgreSQL Database Forum

Hi all, I try to visit the web site of PostgreSQL but my browser doesn't show the intro page correctly. I also tried to visit the site with mozilla. The result was the same. Spesifially, I can only view the background color and a white horizontal line. Do you know what is wrong. Thank you advance Kostas

The query below will return all of the foreign keys in the current schema, I get the ForeignKey name as FK_NAME and both the primary and foreign table's name and schema, now I just need the columns involved in the foreign key itself, there is a column called confkey in pg_constraint and it's an array? It holds the column id SELECT...

unsubscribe -- Best regards, Constantin Khatskevich. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

From Day One I have been using "money" in all of my tables, sigh, I guess it is time to change... Any suggestions on what to change to and how to conveniently do the transformation. Anything to watch out for? I have about 6 tables and the largest only has about 3300 rows. Jerry

Hello, postgresql 7.3.4 on Debian or the redhat packaged 7.3.4-8 on RHEL AS3 - same issue, so I somewhat cut out RH is playing things on me. Tested on two different PCs, too (say, one debian, one RHEL). While running UPDATE banner SET counterhalf=counterhalf+1 WHERE BannerID=50 several thousand times, the return times degrade (somewhat...

I am running Suse 9.0 and have been working with postgresql 7.3.3 When I run psql as psql -v or psql -V and even psql --help I get a relocation error psql: relocation error: /usr/lib/libreadline.so.4: undefined symbol: BC Is there anyway to fix this with out reinstalling postgresql. Thanks,

I'm used to using the DBI modules in perl. The online docs mention DBD as expiremental. I'm thinking of sticking with DBI, unless there's some compelling reason to do otherwise. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail...

Running 7.4.2, I have a pl/pgsql function with a WHILE LOOP that inserts records a set number of times. Each time, the function generates a random number and INSERT INTO a table, if that number has been used already, I need to enter all fields leaving the incremented number NULL. How can I keep track of the numbers already used, does it...

Subject: Re: Bug in function to_char() !! Message-Id: <E1Bg0y0-0004mq-00@gaul.cornfield.org.uk> From: simonw@cornfield.org.uk Date: Thu, 01 Jul 2004 13:47:04 +0100 Hi Try

I am working on a design where a location for something can have: Fully qualified address with even building names, room numbers, and booth numbers. **-OR-** GPS location **-OR-** Both Other than triggers, is there a way to enforce this using tables and

The things from February are getting beyond a joke. Can this be dealt with once and for all (even if it involves contacting pcbuddy.net and getting them to do something)? Now I get a duplicate from 2 different hosts Received: from krusty-motorsports.com (krusty-motorsports.com ) by mailhub1.une.edu.au (Postfix) with ESMTP id...

HMMMMmmmm......, There was a post running about using C_LOCALE is the only way to use LIKE, and I put something similar to the below in comment to it. It never showed up on the list. Oh well. If I wanted a multinational database capable of many langauges,and wanted the most functionality of sorts, order bys, indexes, LIKE, etc, what is...

Say I have a type defined as city (varchar, varchar(2), numeric, numeric) What would be the syntax for calling a stored procedure defined with this type as a parameter, i.e., something like CREATE FUNCTION public.city_insert(city) RETURNS ...

Dear Friends As Subject How to resolve, since i use with out problem on postgresql 7.3 Regards Luiz

Interesting article, notice the "never have to reboot it" line. http://www.smh.com.au/articles/2004/06/07/1086460218113.html?oneclick=true ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

I can't find where to get a list of who can do what on a database. You know: GRANT SELECT ON mydatabase FOR joe; How do I grab a list of everyone's capabilities either for a given database, or more than just one database? ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

If I wanted a multinational database capable of many langauges,and wanted the most functionality of sorts, order bys, indexes, LIKE, etc, what is the best encooding? I would have THOUGHT it would be UTF8, but maybe C_LOCALE? Is there a chart somewhere showing the main differences between using C_LOCALE and any other encoding? A nice simple...

/* I have a customer requirement to provide for flexibility on how vacation leave is calculated and am having trouble with executing the necessary SQL which is stored in the database as a text column. The employee table and a newly minted vacation leave formula table, shown below, are related and identify what vacation leave calculation is...

Hi everybody, I'm doing the following query: select * from messages order by random() limit 1; in the table messages I have more than 200 messages and a lot of times, the message retrieved is the same. Anybody knows how I could do a more "random" random?

subscribe ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend

Hi I want to be preserve a log of all SQL actions that change a database, (ie INSERT, UPDATE, DELETE, CREATE), to provide a full audit trail of the date, and to allow the recreation of a database at any time. I can achieve this wth ORACLE(recover and others) and MySQL(mysqlbinlog) quite easily. How do I achieve this with Postgres? Simon

Hi, I've been trying to cluster some large tables (more than 10 million records) and this is the error I keep getting: "ERROR: expected both swapped tables to have TOAST tables" and it just stops! Please can someone explain what this means? How do I fix it? I can find *no* reference whatsoever on the internet. Thanks!

Hi fellow pgsql users, I am helping my university's student union get back up and running after some major server issues they had. They had serious disk issues on a server, but not on the /var partition where all of the /var/lib/postgres/data files were. I was able to recover all of it, at the file-system level. The old machine and the...

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...

Sorry for the newbie question, but how do you get PostgreSQL to list the available databases? I know how to log into a certain database, but not list all of them. I know this must be possible because the phppgAdmin web site demonstrates it with their trial server. Thanks, Doug Hall ---------------------------(end of...