PostgreSQL Database Forum

Trying to create a plperl function to strip non-friendly mainframe characters from a string. However, when I try to add the Trademark symbol (â„¢) as a replace criteria, PG spits back an error: ERROR: Could not convert UTF-8 to ISO8859-1 Any way I get around this? CREATE OR REPLACE FUNCTION public.mainframe_description(varchar) RETURNS...

Might be of some interest to the advocacy people and new users of postgres coming from MySQL: "This month's issue includes some exciting new article, such as Rick Morris' "Migrating from MySQL and PostgreSQL". With all the events surrounding PHP and MySQL in the last few months, Rick's article is sure to generate lots of interest for anyone...

Is there any date type that can be used for 0-255 values? Like an "int1" or byte column. CSN __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

It seems so elementary, but how I get a list of which tables are available in a database. I can't find an SQL command for this, but there must be a way! Thanks. Bertwim

Is there a tool that analyzes the tables in a Postgresql database and generates a graphical representation of the tables and their relationships (e.g. inheritance, foreign key) to each other? Regards, Floyd Shackelford

I have libpq client program that repeatedly connects to a DB, queries, and then disconnects. After a seemingly random number of such successful sessions (sometimes 30, sometimes hundreds), the backend mysteriously exits after the client calls PQsetdbLogin(), and the client hangs. Any clues? Details below... Client: C program linked with...

I copied an example from the help: CREATE FUNCTION somefunc() RETURNS integer AS ' DECLARE quantity integer := 30; BEGIN RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity here is 30 quantity := 50; -- -- Create a subblock

Hi!! I am trying to compile and install plpgsh and i get this error : make: *** Error 1 I am doing this like root Somebody has a cluee?? *-------------------------------------------------------*

Is there a tool that analyzes the tables in a Postgresql database and generates a graphical representation of the tables and their relationships (e.g. inheritance, foreign key) to each other? Regards, Floyd Shackelford

Hello, How can I typecast a date generated from VARCHAR fields into a date field ie: UPDATE inventory SET date_field = vc_year||'-'||vc_month||'-'||vc_day;

hi all, im developing a site in perl with mason on a postgreSQL backend. i currently have a page that lists all items in a table, but would like to do the " << PREVIOUS 1 2 3 4 NEXT>> " sort of thing - say LIMIT of 10 records to a page.

hi! i am developing with version 7.3.2 under cygwin. my production evironment is 7.3.3 on a suse machine. language settings (lc_...) for the server are on developing and production machine the same, 'C'. now i encoutered the following behaviour. i use a union select to unify a query result with an ' (all)' entry. i used at home a space on...

Hi!! I am trying to compile and install plpgsh and i get this error : make: *** Error 1 I am doing this like root Somebody has a cluee?? *-------------------------------------------------------*

Hello, How can I typecast a date generated from VARCHAR fields into a date field ie: UPDATE inventory SET date_field = vc_year||'-'||vc_month||'-'||vc_day;

doing a restore, i get the following error... $ ./pg_restore -p 5474 -d rms74 RMS74 pg_restore: could not execute query: ERROR: could not load library "/usr/lib/pgsql/pgcrypto.so": /usr/lib/pgsql/pgcrypto.so: undefined symbol: elog the dump was from 7.4 pg_dump against a 7.3 database. the thing thats bugging me is the undefined elog...

Hi, I have question: why such condition: foofield not like '%bar%' where foofield is varchar returns false (or rather even ignore row) on record where foofield is null

After reading the below struct and free statement, I am rather confused.. Do I need to free the struct, the char *, or both? Thanks. PGnotify* PQnotifies(PGconn *conn); typedef struct pgNotify { char *relname; /* name of relation containing data */

How soon will 7.5 come out? (yes, I know, 7.4 is beta right now). How difficult is it to set up cygwin? I'd like to make a drop in Apache/Postgres/PHP application on a windows computer for someone in my organization. I'd PREFER to avoid ODBC if at all possible.

Hi!! Is there a way to execute script in OS from plpgsql??? _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to...

I'm still getting lots of SMTP hits from varying servers attempting to deliver mail to my tagged email address, used only for subscribing to this list. The delivery attempts are using the same envelope sender address style as is used by the list itself. But is this real mailing list attempts from a messed up server or network, or is it a...

I'm sure this is a concept that's been explored here. I have a table (fairly simple, just two columns, one of which is a 32-digit checksum) with several million rows (currently, about 7 million). About a million times a day we do select * from my_table where md5 = ? to verify presence or absence of the row, and base further processing on...

I have a timestamp field where I find I'm doing a lot of searching by date (YYYY-MM-DD) or using this field as a match to another table that has a date format. I wanted to create an index on the timestamp field using a date format. Is this possible? I tried: CREATE INDEX test_2 ON table1 USING btree to_char(field2, 'MM-DD-YYYY'); but I...

Is something up with gborg cvs, or have the settings changed? % cvs update cvs : connect to gborg.postgresql.org:2401 failed: Connection timed out % cat CVS/Root :pserver:anonymous@gborg.postgresql.org:/usr/local/cvsroot/libpqxx % cat CVS/Repository libpqxx

Here is a simplificated example: CREATE OR REPLACE FUNCTION ttt () RETURNS text AS ' return ""; ' LANGUAGE 'plperlu'; CREATE OR REPLACE FUNCTION qqq () RETURNS text as ' DECLARE v_text text; v_text2 text;

doing a restore, i get the following error... $ ./pg_restore -p 5474 -d rms74 RMS74 pg_restore: could not execute query: ERROR: could not load library "/usr/lib/pgsql/pgcrypto.so": /usr/lib/pgsql/pgcrypto.so: undefined symbol: elog the dump was from 7.4 pg_dump against a 7.3 database. the thing thats bugging me is the undefined elog...