search for: pg_encoding_to_char

...But I run in into a problem when trying to install the ruby-postgres gem. I get this error Building native extensions. This could take a while... ERROR: Error installing ruby-postgres: ERROR: Failed to build gem native extension. blah blah blah etc postgres.c:31: error: conflicting types for ‘pg_encoding_to_char’ /usr/include/postgresql/libpq-fe.h:518: error: previous declaration of ‘pg_encoding_to_char’ was here postgres.c: In function ‘pgconn_s_escape_bytea’: postgres.c:370: warning: pointer targets in passing argument 1 of ‘PQescapeBytea’ differ in signedness postgres.c: In function ‘pgconn_s_unescape_b...

...or gethostbyname() in -linet... no checking for gethostbyname() in -lnsl... yes checking for sys/un.h... yes checking for socket()... yes checking for hsterror()... no checking for gethostname()... yes checking for PQsetdbLogin() in -lpq... yes checking for PQsetClientEncoding()... yes checking for pg_encoding_to_char()... yes checking for PQescapeString()... yes creating Makefile # make gcc -I. -I. -I/usr/lib/ruby/1.8/i386-linux -I. -DHAVE_SYS_UN_H - DHAVE_SOCKET -DHAVE_GETHOSTNAME -DHAVE_PQSETCLIENTENCODING - DHAVE_PG_ENCODING_TO_CHAR -DHAVE_PQESCAPESTRING -I/usr/local/pgsql/ include -fPIC -c postgres.c gc...

...sr/bin/ruby extconf.rb install ruby-postgres -- --with-pgsql-include-dir=/usr/ local/pgsql/include/ --with-pgsql-lib-dir=/usr/local/pgsql/lib/ checking for main() in -lpq... yes checking for libpq-fe.h... yes checking for libpq/libpq-fs.h... yes checking for PQsetClientEncoding()... no checking for pg_encoding_to_char()... no checking for PQfreemem()... no checking for PQescapeString()... no creating Makefile make gcc -I. -I. -I/System/Library/Frameworks/Ruby.framework/Versions/1.8/ usr/lib/ruby/1.8/universal-darwin9.0 -I. -DHAVE_LIBPQ_FE_H - DHAVE_LIBPQ_LIBPQ_FS_H -I/usr/local/pgsql/include -fno-common -arch...

...or gethostbyname() in -linet... no checking for gethostbyname() in -lnsl... yes checking for sys/un.h... yes checking for socket()... yes checking for hsterror()... no checking for gethostname()... yes checking for PQsetdbLogin() in -lpq... yes checking for PQsetClientEncoding()... yes checking for pg_encoding_to_char()... yes checking for PQescapeString()... yes creating Makefile make i386-redhat-linux-gcc -fPIC -I. -I/usr/lib/ruby/1.8/i386-linux -I/usr/lib/ruby/1.8/i386-linux -I. -DHAVE_SYS_UN_H -DHAVE_SOCKET -DHAVE_GETHOSTNAME -DHAVE_PQSETCLIENTENCODING -DHAVE_PG_ENCODING_TO_CHAR -DHAVE_PQESCAPESTRING...

...m getting the following error message: # pg_dump -U postgres database > database.out pg_dump: SQL command failed pg_dump: Error message from server: ERROR: relation "pg_user" does not exist pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, datpath FROM pg_database WHERE datname = 'database' Thank you for your help! Andy

...ge: > > # pg_dump -U postgres database > database.out > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: relation "pg_user" does not > exist > pg_dump: The command was: SELECT (SELECT usename FROM pg_user WHERE > usesysid = datdba) as dba, pg_encoding_to_char(encoding) as encoding, > datpath FROM pg_database WHERE datname = 'database' Googling for the error message (*hint hint*) indicates this is most often caused by a version mismatch between your pg_dump, psql, etc, and the actual postgres database you are connecting to. Is that the case?...

...all_db.php?subject=server&action=export&server=%3A5432> Reports<http://124.43.200.74/phpPgAdmin/reports.php?subject=server&server=%3A5432> *SQL error:* ERROR: relation "pg_user" does not exist *In statement:* SELECT pdb.datname AS datname, pu.usename AS datowner, pg_encoding_to_char(encoding) AS datencoding, (SELECT description FROM pg_description pd WHERE pdb.oid=pd.objoid) AS datcomment FROM pg_database pdb, pg_user pu WHERE pdb.datdba = pu.usesysid AND NOT pdb.datistemplate ORDER BY pdb.datname Why . Pls...

...) in -lssl... yes Using PostgreSQL include directory: /opt/local/include/pgsql8 Using PostgreSQL lib directory: /opt/local/lib/pgsql8 checking for PQsetdbLogin() in -lpq... yes checking for libpq-fe.h... yes checking for libpq/libpq-fs.h... yes checking for PQsetClientEncoding()... yes checking for pg_encoding_to_char()... yes checking for PQescapeString()... yes checking for PQfreemem()... yes creating Makefile zmac11:/cd/rubythings/ruby-postgres oracle$ export DESTDIR=/ zmac11:/cd/rubythings/ruby-postgres oracle$ make gcc -fno-common -I/usr/include/openssl -I/opt/local/include/pgsql8 -I. -I/opt/local/lib/rub...