PostgreSQL Database Forum

I've stumbled against the inability to put null values within an array. The PostgreSQL User's Guide on the subject states in part: <<A limitation of the present array implementation is that individual elements of an array cannot be SQL null values. The entire array can be set to null, but you can't have an array with some elements null and...

Greetings, In short: Using a new FreeBSD (4.9) PostgreSQL (7.3) server, can I rescue PostgreSQL data from a hard drive pulled from an older (motherboard just died) FreeBSD (4.??) PostgreSQL (7.??) server? If so, how? The long version:

Hi; Please. Could you tell me the more simple way to extract the 'date' part of a timestamp value. I guess we could extract the year, month, and day subfields and concatenate them. But, isn't there a more direct way? Best regards, Javier

Hi, I am still not sure whether the BLOBS are actually stored in the database or they have the pointer to the database for that file in the filesystem. If I remove the files (sources) for BLOBS from the directories with the BLOB still hold the data ? Also one more very intriguing part is that if BLOBS are not deleted if we delete them...

Where can I learn some more about the Rule system in PostgreSQL( ie besides the manual)? I'd also want to learn what query trees are generated by my queries? How can I get them to show up? I am using pgAdmin3.

_________________________________________________________________ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=dept/features&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca ---------------------------(end of broadcast)--------------------------- TIP 6:...

I need som ehelp concerning queries using SLEECT ... FOR UPDATE I have two tables (see description below) One is the table of reference, the other one is a table where i have daily infoirmation I want to check the differences on the two tables based on the fields omc_index and bsc for each cellname. Then when I have inconsistency, I want...

I am a self taught SQL novice, possibly beneath contempt :-) Two questions here. One is how to define two tables whose columns reference each other, the other is whether trying to do this means I have a bogus design. CREATE TABLE xyzzy (a INT PRIMARY KEY, b INT REFERENCES plugh); CREATE TABLE plugh (c INT PRIMARY KEY, d INT REFERENCES...

I am running an experimental system, my disk filled up when running a table build from a query. I mistakenly blew away the files in .../pgsql/data/base/18773 & ../pgsql/data/pg_xlog with NO BU! Recover is only bringing back 8 of about 90 files. I can rebuild the DB from scratch relatively easily... I was going to try and just do a drop...

I have the ODBC driver for windows. But I was hoping there might be an ADO provider.

I have a simple table that I'd like to query to pull out a heirarchy from a tree relationship. What is the best way to do this without a 'CONNECT BY' clause like Oracle has? Example mytable +----------+-----------+ | child_id | parent_id |

I'm looking at "TODO list for PostgreSQL" and "Fix upper()/lower() to work for multibyte encodings" has no dash (-) -- so it won't be made in 7.5 ? Another question is about WIN32 native release - currently, all win users cannot set locales, becouse Cygwin does not support it -- I hope that it will be solved in native release, so UTF-8...

Problem : When starting the postmaster ( DB Server ) we can see the following on the console : Incorrectly built binary which accesses errno, h_errno or _res directly.. Needs to be fixed. DEBUG: database system was shut down at 2003-12-17 10:40:32 IST DEBUG: checkpoint record is at 0/11C370 DEBUG: redo record is at 0/11C370; undo record is...

Hi! I am new with PostgreSQL and I want to know if this database give the possibility to verify automatically, each night, if some records are too old (by example, if session_date is older than a month) and if so delete them. Thanks for your help! Melanie

Hello All Im trying to use dblink set of functions in PostGreSql 7.3.4. My environment is WinNT and cygwin. I try to connect to a different database using dblink_connect. In my pl/pgsql statement ..... perform dblink_connect(\'dbname=generic\'); ...... When i call this function, PostGreSql throws the following error: ERROR: ...

I am running 7.1.3 at the moment and upgrading in the near future. I am noticing that some cursor declare statements are commented out in the .c after running the ecpg pre-processor with no error message or explanation from ecpg. It took me a while to figure this out when I got the 'cursor does not exist' message during execution. The...

Hi! I am new with PostgreSQL and I want to know if this database give the possibility to verify automatically, each night, if some records are too old (by example, if session_date is older than a month) and if so delete them. Thanks for your help! Melanie

I'm setting up 2 database servers. The first is on our local network which is our staging server. The second is an external server setup at my hosting company. On a nightly bases I want to copy all the data from the local Postgre database to the production server at hosting company overriding whatever was there previously. Does anyone have...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The call for participation has been issued for the 2004 O'Reilly Open Source convention, and once again, PostgreSQL has a track: http://conferences.oreillynet.com/cs/os2004/create/e_sess Proposals are due on February 9, 2004, and it would be nice to see

Hello, Sorry for just stupid question, but I need use md5 function in 7.4 When I write: select md5('text'); ERROR: Function md5("unknown") does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts where is problem???

Hello list, I have a table called pedh that looks like this: REFNO FECHA OCNUM PVD 0199 10/12/2003 5224 632 0199 10/12/2003 5224 632 1264 10/18/2003 8991 210 1264 10/18/2003 8991 210 1264 10/18/2003 8991 210

On a daily basis I place a lot of data into the empty table dailyList, and from that data update certain fields in currentList. I thought that using a function would be a good way to do this(?). However I get the following error when I run updateCurrentData(): ERROR: set-valued function called in context that cannot accept a set CONTEXT: ...

Greetings, I just had to dump and restore one of my DBs (7.4RC2), and I got an interesting message. I first did: pg_dump dbname > db_restore.sql Then at console did the following:

Hi, cobalt 2.2.16 psql 7.2.3 DBI 1.32 I get this error, as in subject:- pqReadData() -- read() failed: errno=32 and then followed by this pqReadData() -- backend closed the channel unexpectedly.

Hi list, i got an postgresql installation on linux (debian) with the htree partitions: 1- system 2- postgresql data files 3- postgresql WAL logs(pg_xferlog) Our standard file system is ext3. Now i heard, xfs is better for the data files.