PostgreSQL Database Forum

Hello Searched around, but could not find this mentioned. I've noticed the following behaviour in 7.4.5: select * from foo where col1 = 1 or col1 = 2 or col1 = 3 or

I have the following function and I am getting an invalid syntax error when I try to run it. I have tried the function a number of ways including with named parameters and non-named parameters using the args array. I also tried it with a tab at the beginning and without. I've also tried with the $$ and with single quotes and the double single...

Hi, while upgrade to 8.0 (beta3) we got some problem: we have a database which encoding is UNICODE, when we do queries like: select upper('ÖÐÎÄ'); --select some multibyte character, then postgresql response: ERROR: invalid multibyte character for locale

Hello, Is there a way to recover from the following error? I have (had) an existing database and wish not to lose the data tables. Thanks for any help, Pete

Hello, Is there any way to reuse a column label in a select list like this: SELECT 1 + 1 AS a, a + 1 AS b; I vaguely remember being able to do something like this in oracle. Any ideas? Thanks! ~RvR

Hallo! I have a big problem, could you please help me? I am developing a DB System accociated with a File server. The DB Server schould manage directories which coulkd be, I thought, fired with after insert Triggers. I wrote a C function and compiled as -shared. But its not working. Is there somewhere any example to? Or how could I do it?

Hallo! I have a big problem, I am under time pressure to finish my project. can anybody please help me? I am developing a DB System associated with a File server. The DB Server should manage directories which could be, I thought, created through fired Triggers. I wrote a C function and compiled as -shared, created function and created...

I'm trying to add some functionality to an already existing application...this applications works fine, and uses the PHP function pg_pconnect to make a persistent connection to the database. This works very well. My part is to make a new non-persistent connection (or whatever), to a newly created database on the same server. I simply do

Is there a way to remove idle connections? My postgres server is getting serveral hundred idle connections. It's due to a postgres .NET provider not closing the connections properly. I don't want to kill them all, or restart postgres everytime the connections go crazy. -Josh ---------------------------(end of...

Is there a way to vacuum all tables in a schema? Or will I need to write a script to do it? -Josh ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

I'm not sure where to find it exactly, but does anyone know how much data a column of type "text" in a postgres DB can hold? Thanks

I am trying to download postgresql from one of the mirror sites. I get prompted for a username and password. I try anonymous login and my password and I get an error stating either the server doesn't support anonymous logins or that my email address wasn't accepted. What am I doing incorrectly? Thanks, JD

Hello ppl, Imagine some online system, based on PgSql. There are 'many' parts which depends on each other. I will give small example, but instead of simple table imagine changing tenths various tables (editing). So, 'change table A' can be work for hours. There are tables tableA and tableB. Changes are made by thin client. If you change...

Hi I tried creating the function (from sec 19.3.1). But it gives me the following error: "ERROR: type tablename does not exist". Any ideas of what i might be doing wrong? CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS ' DECLARE in_t ALIAS FOR $1; BEGIN RETURN in_t.f1 || in_t.f3 || in_t.f5 || in_t.f7;

Experimenting with Beta 8 on Windows; we got this message while running PC-SAS queries against a table with over 7 million rows. Which setting(s) should I be looking at? Thanks Mark R. Taber Database Administrator, Infrastructure and Architecture State of California

Hello, folks, I am trying to install pgsql8 on winxp. I tried first to install "as is" with pginstaller beta2-dev3, no luck, it froze, switched off Nod32, froze a little later, ran through the list of services, switched off anything that seemed to be a firewall, no luck. So I compiled beta3 with mingw, installed, and now initdb keeps...

Hello there, I am thinking how to solve another typical problem of online systems with combination of thin client... Imagine simple case, 2 users are going to edit 'same' datas. Both see on the 'screen' the same, after they started edit them. First one changes datas and submit changes (sucessfully). Database (set tables -...

I'm a first-time user with PostgreSQL so please forgive my ignorance. I've purchased (and read) Practical PostgreSQL (O'Reilly) and PostgreSQL Essential Reference (New Riders). So far, so good. I think learning PostgreSQL will not be as difficult as I thought it would be. I've also been googling for the last few days, but I have a...

I *think* I'm seeing "vacuum analyze" queries launched automatically on an 8.0.0beta3 (unless I have a rogue autovac running that I haven't spotted). Is this something new in 8.0 and to be expected? My settings: #vacuum_cost_delay = 0 # 0-1000 milliseconds #vacuum_cost_page_hit = 1 # 0-10000 credits #vacuum_cost_page_miss =...

Some time ago (May 2004), we were making changes to a Postgresql server to allow a host to connect (pg_hba.conf). When we restarted the server, and restarted the AOLserver process, there was only one table left. All the ACS tables were gone. As we were troubleshooting the problem, we found the last known good dump (I pg_dump every four...

Hello, I've just encountered a problem that I don't know how to deal with. After having a play with SlonyI, I dropped the entire slony cluster schema, and then tried to drop a schema which held some slave tables for the slony cluster. I kept getting the following error: ERROR: cache lookup failed for relation 4667548

in spite of the efforts of the french mailing list, an paper with some "grossieres" erreurs...I apolgize http://www.01net.com/article/253508.html ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Hello Does PostgreSQL provide anything comparable with the functionality of MySQL Cluster? I appreciate all information. Thank you. Tim

Hello. I have a query like: SELECT big_table.* FROM little_table, big_table WHERE little_table.x = 10 AND little_table.y IN (big_table.y1, big_table.y2); I have indexes on both big_table.y1 and big_table.y2 and on little_table.x and little_table.y. The result is a sequential scan of big_table. In order to prevent this, I've rewritten...

I need to increase the number of connections to PostgreSQL 7.2.1. I have tried changing the value of max_connections in Postgresql.conf. It was commented out (as are all other entries except "tcpip_socket = true"). Setting it to any other value that the default 32 resulted in the server failing to restart. I know we should upgrade from...