PostgreSQL Database Forum

Hi! I am trying to port an oracle app to postgres, an I don't know what to do with package scope variables. I was looking up some documentation and it seems (IMHO) that schemas would be a nice place to put the variables in(as they already have functions, operators and types). Is this feasible? Is the dev team interested in doing this at some...

What can I run on OS X as a pgAdmin equivalment (other than the Java solutions)? ..V -- Please post on Rich Internet Applications User Interface (RiA/SoA) <http://www.portalvu.com> ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

I just read this in the MySQL manual: (http://dev.mysql.com/doc/mysql/en/InnoDB_Error_handling.html) "Error handling in InnoDB is not always the same as specified in the SQL standard. According to the standard, any error during an SQL statement should cause the rollback of that statement. InnoDB sometimes rolls back only part of the...

According to docs coming with the postgresql stuff on Linux for Fedora Core 2, pgaccess was moved into the tcl PostgreSQL package. Unfortunately, it seems that it was removed from one package and never added back in to the tcl or contrib packages. If I go to rpmfind.net I don't see any Redhat or Fedora rpms. Can anyone tell me if rpm format...

I have moved a DB from 7.4.3 to 8.0.0b2 for testing and am experiencing some problems with the void type within pl functions. I am calling a function which returns a void from within another function and have defined a variable of type void to catch the returned value. This worked fine in 7.4.x but when executed in 8 generates a...

Hi! I have some problems with the SPI memory management (at least I think this is the problem). What I'm trying to do is to get the Query related to a select statement, alter it and produce a new SPI_plan that will execute. To do so, I retrieve the query from the _SPI_plan->qtlist, alter it (seems OK in nodeToString) and then use some...

Does anyone know if there is a planned PostGreSQL 8.0 book coming out in the near future? Thank You Sim Zacks IT Manager CompuLab 04-829-0145 - Office 04-832-5251 - Fax

I'm thinking of getting this book and was wondering if anyone had anything bad (or good) to say about it? More than that I'd really like to know what version of Postgres it covers, the sample pages don't seem to say. http://tinyurl.com/5xtpp TIA.. --

Hi, I have a question about alter a column's type in a postgreSQL table. For example, I have 10, 000 records in a table name "test", I'd like to change column "machineID" type from integer to varchar. I am looking for something like: alter table test alter column machineID ... ... varchar

Can somebody clue me in on this? I've been working on this for nearly a week now and it's driving me bunkers. I am using PostGIS/Mapserver and trying to get a simple demo running with just one PostGIS layer. My layer is never drawn and the best I can tell is the results from this transaction (not the exact one this is the simplest form...

I have searched the Internet... but haven't found much relating to this. I am wondering on what the best practices are for migrating a developmemnt database to a release database. Here is the simplest example of my situation (real world would be more complex). Say you have two versions of your application. A release version and a...

I want to return multiple values, but not a set, only a single row, from a plpgsql function and I can't seem to get it to work. (I suppose I'd be happy to return a set, but I can't seem to make that work either. Anyway, what's wrong with this?) Version is: $ rpm -q postgresql

Is opening up port 5432 (R/W both directions) all that is required of a firewall in order to access a postgres database outside the firewall? -- % Randy Yates % "My Shangri-la has gone away, fading like %% Fuquay-Varina, NC % the Beatles on 'Hey Jude'" %%% 919-577-9882 % %%%% <yates@ieee.org> ...

Hi, knowing that "autonomous transaction" (Oracle concept of) are not yet implemented in PostgreSQL, has anyone found a work-around. I need to preserve database states from a potential rollback and then log them inside database tables. What about: 1) using memory structures to hold the info, then commit to the database just before exit...

Hi, I have several tables in a database and I have to grant ALL on each table to a user. How can I do it at once??? I'm doing a GRANT statement for each table... (ugly). Regards,

I would like to create two engines working as a backup to each other. Any idea how I should go about syncing them? Aharon Friedman

I'm having a problem with infinite recursion on rules. Can someone point me to what settings I need to log which rules are being executed? I'm using log_min_messages=debug5 log_min_error_statement=debug5 log_statement='all' 8.0.0beta1 on win32 compiled from source.

I am writing a plpgsql function and I have come across the situation where I want to raise an exception, but there are cursors open. Do these need to be closed before raising the exception or is that all handled for me? Thanks, Tim

I just noticed something unexpected when using psql. I had written a shell script to bulk-load some hundreds of files into a database, and move each file to success/ or failure/ directories depending on the exit status. The problem is psql exit status differs depending on if the SQL script is provided with -c or on STDIN. Try this for...

Hi, I have somehow managed to lock a row in one of my database tables, and I am now unable to unlock that row. I have tried using the ROLLBACK command, but get a notice: NO TRANSACTION IN PROGRESS. However, when I try to update or delete the record, the query never executes, and I have to cancel it manually, at which point I get the error:...

Hi, I cant seem to figure out how to use the geometric shapes in postgres: my query goes like this: select lat, lon from toperation where point'(lat,lon)' @ polygon'((50, 0),(70,10),(80,50),(50,80),(50,0))' This should fetch all values of lat and lon contained by the polygon, but I dont see how I can fetch the lat and lon values, I just...

Hello, Are the indexes inherited during table inheritance ? Thanks -- Fabien Fournier ---------------------------(end of broadcast)---------------------------

FYI, mostly. But I do have questions as to how to write code that will continue to work in subsequent postgresql versions. See code below. begintest() uses EXIT to exit a BEGIN block from within nested loops. No problem. begintest2() simplifies this, omitting the nested loops. Still no problem.

Hello, Does someone have some experiences of using the C-JDBC (database cluster middleware ) for large & middles-sized DB based on postgreSQL under i686.linux? You think it is a good idea for RAIDb? Thanks a lot! ---------------------------(end of broadcast)---------------------------

Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections). Regards, Marcelo Pereira Brasil