PostgreSQL Database Forum

I have been able to crash the server a few times with the following function when it is called on a user and schema that was recently deleted. Following is a log of what happened and also the function that was called. This is 7.4.3 on Freebsd 5.2.1. It doesn't always panic when it encounters a deleted user/schema, it's kind of sporadic but...

Hello everyone. Are there any recommended ways for doing postgresql replication? Si Chen ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

Can psql be told to exit immediately after an error (especially when doing commands from a file, -f)? This is the default behaviour of the mysql client, except when we give it -f option ("force"). The problem is, when restoring a dump, a failure at the some point might cause the subsequent commands to produce wrong results (e.g. I redefine...

Hi, Just noticed something funny with the POSIX Regular expressions and wondered if it is a bug, or whether I am doing something wrong. I am using the POSIX RE in a function that is used in several places so would have to put some nasty if statement in there for this side case if there is not work around. ...

Dear my friends... I created some tables with field timestamp (datatype also timestamp). I mean, I want to have the data when each record inserted or modified in the tables. on MysQL, I just need to define the column (field) with datatype "timestamp" and that's all. each time new record inserted than the timestamp value will be inserted...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, has anyone encountered an error when running a slony_setup.pl generated script to set up a master? The problem I hit is that the xxid.v73.sql file aborts with the following error:

Hi I want to write soundex query for example: select * from student where name soundex 'vinay'; In psql it gives error at soundex. Regards Vinay -- Vinay Jain Dissertation Project Trainee DAKE Division

Hello everybody, i get strange error messages when trying to call up my function with a SELECT functionname(with or without int); varying from: ERROR: function chr(double precision) does not exist ERROR: function FUNCTIONNAME() does not exist

what does it mean when one lock mode conflicts with another like is says in the documentation? can somebody explain and maybe give an example. thanx, amir ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to...

I am getting 'postmaster does not shut down' when trying to stop the database with '.../pg_ctl -D /path/to/datadir stop -m fast. How should I proceed to get the database shut down and restarted? Are there other options besides immediate shutdown flag? I dont' want to lose everything I've worked on today :( -- Robert

I have varchar column with both numbers and letters, like 1 thru 10 and 5A thru 5G, they are unit numbers for apartments. If I have 1 thru 100, since it is a varchar field, it sorts like 1,10,11... instead of 1,2,3... Is there any way to handle this without having to make a sort order column? -- Robert

will locks work inside functions or only in transactions? will this lock? .... CREATE OR REPLACE FUNCTION public.sample(varchar) RETURNS SETOF record AS ' DECLARE row RECORD; BEGIN

Is there a way to continue a transaction after an error? I've got a situation where I have a transaction open and I'm inserting data, but some of it could fail on validation. I want to keep the good stuff, leave out the bad, and get the speed of not having to commit every record seperately. For a specific example, I'm importing a list of...

Postgresql 7.4.3-1 under Cygwin. I created a table called ServerTypes: CREATE TABLE ServerTypes( ServerTypeID SERIAL UNIQUE NOT NULL, Type TEXT PRIMARY KEY); Works fine.

I did the pg_dump with the Linux 7.4.3 version and tried to pg_restore with Win32 8beta1 version and I got: C:\TEMP>pg_restore -d desarrollo -i -U postgres xdump pg_restore: input file does not appear to be a valid archive Taken from the help "For best results, however, try to use the pg_dumpall command from

I'm looking at a database-using program (PostgreSQL/libpq and MySQL) which does the following: A daemon process opens a database connection, forks children on request, and those children access the database using that inherited connection. After one request, the child dies. It seems to me that this connection sharing cannot work because the...

Greetings, Yesterday theres was a brief discuissions about replications software for PostgreSQL. My boss and I saw only two replications for PostgreSQL that was spoken of. We found no reviews on the internet that spoke of either or compared them and we are considering PostgreSQL as an options for a movement from our present platform of...

After almost 9 months of development, the PostgreSQL Global Development Group is proud to announce that development on PostgreSQL 8.0.0 has now finished, and is ready for some serious testing. For those wondering about the 8.0.0 designation on this release, there have been several *very* large features included in this release that we felt...

-- plruby 0.4.2, ruby 1.8.1, pg 7.4.3, linux -- 1. create a valid plruby function create or replace function sqr(int4) returns int4 as ' args*args ' language 'plruby'; -- 2. test it select sqr(5);

Hello, We are having a problem where intermittently a query will not work, returning an error: ERROR: Relation "x" does not exist It will do this for a variable period, typically not lasting more than 5 minutes

Hi, I have read in this list and elsewhere the problem with indexes and big int. Still, I have an index that is used or not, depending of the parameter value used in the query. I am using PostgreSQL 7.4.3 on Linux RH ES3. Here's the table: test=> \d dmaildatum Table "public.dmaildatum" Column | Type | Modifiers...

Hi, I'm looking at the logging aof a database we'll put in production soon. I've seen some posts on this list about history tables, like mentioned in http://www-106.ibm.com/developerworks/web/library/wa-dbdsgn2.html . I think I'll go that way too, but I still have some questions on the approach: - is it possible to write only one function...

Hey folks, I'm currently evaluating an upgrade path from our current ColdFusion 5 / PostgreSQL setup to ColdFusion MX / PostgreSQL. In the current setup, we're using the Merant ODBC driver for postgres. I've installed Fedora Core 2 with Apache 2 and ColdFusion MX, and I grabbed the latest JDBC driver from the postgres website. I...

Hi, I'm trying to list views, eliminating internal ones from the output. Using 7.2, I found this simple statement : SELECT viewname FROM pg_views WHERE viewname !~ '^pg_'; It works fine, ignoring 23 pg_* tables. And I get my actual views returned. But, with 7.4, I get many (about 30) more system views, as table_constraints,...

Hello ! I have two tables with identical schema. I want to copy all data from Table A to Table B, but table B might already have some of table A:s data (each record is identified using record_numbers). I would suspect this can be accomlished using a 2 stage query, first performing a join of some kind and then the copying. But I have little...