PostgreSQL Database Forum

Hi all, I have a question regarding the RECORD type in plpgsql functions. How do I assign a RECORD variable to another RECORD variable? For example, DECLARE rs1 RECORD;

CORRECTION, even if I define a stupid "hello world" trigger function the problem is present: for example CREATE FUNCTION sns_action () RETURNS TRIGGER AS ' BEGIN RAISE NOTICE ''hello world!''; RETURN NEW;

True, if you're running microsoft browsers ..... http://www.cnn.com/2004/TECH/biztech/09/16/microsoft.security.ap/index.html ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Hi, I have a problem with plpgsql and postgres8.0.0beta2 When I execute an insert on "mytable" the psql client returns me the following: **** server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Is there a function like IS_VALID_REGEX() to check whether a pattern is valid (i.e. it compiles)? I'm storing a list of regex patterns in a table. It would be nice to be able to add a CHECK constraint to ensure that all the regexes are valid. If there isn't any, can I suggest Postgres add one? Although I know this can probably be done in...

Hello everybody, i'm having a hard time trying to install an i-spell dictionary into tsearch2... i do exactly as i'm being tol don the website: http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound_words everything goes fine until i try the examples like:

I have the following problem: 1) I have one master table with a primary key. 2) In addition I have *several* slave tables, all refering to a primary key in the master table (no two slave tables refer to the same master key) I wan't to make sure that no keys in the master table are unreferred, that is:

Hi, I got the following scenario in a database. CREATE TABLE persons ( id char(15), name varchar(80) ); CREATE TABLE customer(

Hi! I created a table in postgres with varchar values in it, and I noticed that postgres lexicographical ordering is weird in the sense that it ignores whitespaces. please look at the result I got: select * from tablename order by columnname; cloumnname ------------------------------------- one 1

Hello everybody, After installing the tsearch2 nice and smoothly and following the steps provided on Oleg"s and Teodor"s page i come to an abrupt end after: # Compile and install dictionary cd PGSQL_SRC/contrib/dict_fr make make install

Hi, I'm a Postgis user, and I have a problem restoring data from 7.4 to 8.0..0beta2. I use the postgis_restore.pl script that comes with postgis distribution. I do the following for the dump: pg_dump -Fc mydb >mydb.sql and the script does the following restore operations: .... some commands ... open( PSQL, "| ./psql -a dbname") || die...

I have a small training database: sql_tutorial. It works fine but the spacing between the output lines is too much. This is the way it looks when I copy and paste from the Konsole to this email: sql_tutorial=> SELECT prod_name FROM Products; prod_name...

A couple of days ago I announced that I wrote a JDBC driver that adds table partitioning features to databases accessed via JDBC. I also wrote: > In case you think this could be of any interest if integrated > in Postgresql (I mean if it was a core functionality of Postgresql, > not just a JDBC driver) let me know. But nobody seemed to...

Is it possible to have a sequence across two columns. For example table1 +---+---+ | a | b | +---+---+ | 1 | 1 | | 1 | 2 | | 1 | 3 | | 2 | 1 |

I was looking through the docs, ECPG looks like a great tool for developing client applications. Anyone know if it's possible to set it up for use with Objective C in XCode on Mac OS X? XCode allows you to set your own custom build tool, which I could replace with a shell script that calls ecpg, saves a converted file, which it then passes...

Hello ! I have several functions that are compiled as .so and runs pretty well under PSQL. However I would like to be able to return errors (for debugging) using something like this fprintf(stderr, "BEGIN command failed\n"); Problem is I don't know where this would show up..? In some Postgres log maybe ? I am not directly calling these...

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

Hello! One can restrict access to DATA in databases and tables by setting permissions, but is there a way to prevent a user from seeing table definitions, users, groups etc. when using ODBC-connection or pgAdmin? Allowing access to a database for a user in pg_hba.conf still reveals all database names, users and groups. Regards, Matti

Hi, My Database have a lot of locks not granteds during a day. I want to returns this from pg_locks: All the not granted locks (user and table) and who is locking. Like: User Granted Table PID ---- ------- ----- ---

I was reading "Don't be lazy, be consistent: Postgres-R, a new way to implement Database Replication" and I found this: "5.1 General configuration PostgreSQL uses a force strategy to avoid redo recov*ery, flushing all dirty buffer pages at the end of each transaction. With this strategy, response times are very poor. This makes it...

Our open-source project (http://opensims.org) uses PostgreSQL as the reference implementation, but we've found that the bulk of installation issues have to due with getting PostgreSQL up and running. Is there any kind of a 'quick-start' guide for getting PostgreSQL up and running? I'm specifically thinking of something that would cover gotchas...

Hi, I've been trying to spec a new server for my company's database for a few weeks and one of the biggest problems I've had is trying to find meaningful performance information about how PostgreSQL will perfom under various disk configurations. But, we have now taken the plunge and I'm in a position to do some benchmarking to actually...

Hello, pg_dump started failing for one of my databases, so I looked in to it and it appears that I have some corrupted data or something. I assume this is related to a failed hard disk that was part of the linux software raid mirror. I backed up the entire data directory, and did a pg_resetxlog, but that didn't help. I found the specific...

Is it possible to have a sequence across two columns. For example table1 +---+---+ | a | b | +---+---+ | 1 | 1 | | 1 | 2 | | 1 | 3 | | 2 | 1 |

I am running PostgreSQL 7.4.5 and have a trigger on a table called tblriskassessors which inserts, updates or delete a corresponding record in tblinspectors by lookup of a contact id and license number match. The INSERT and DELETE work fine. The UPDATE works good unless I update the license number. The error, at the bottom of this message,...