PostgreSQL Database Forum

hello all When i tried ´pg_dump -v -f dump.dmp dtbtransporte´ I got the error: pg_dump: restoring data for table tbdmovimento pg_dump: dumping out the contents of table tbdmovimento pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value 6935693

Hi, everybody! I am trying to create a custom GiST index in 7.3, but getting an error, that I don't know how to interpret: testdb=# create table gist_test (field int8); CREATE TABLE testdb=# create index gist_idx on gist_test using gist (field); ERROR: data type bigint has no default operator class for access method "gist"

I've noticed that the SUM() seems to overflow under some situations. The only difference is the order that the data is retrived from the database. accounting=# select sum(amount) from transactions, chart WHERE account=chart.id; sum

Hi all, I try to put into some data I backuped. export PGPASSWORD=security cat /opt/myproj/bin/mysave | /usr/bin/psql -h localhost -U myuser DB_Name I got:

I cannot determine what character is stored in a varchar... For instance: thedonnaholics=# select state from mailing_list where rec_num = 7; state ------- (1 row) If I then execute:

Should be a simple question. When selecting a field that is of type money, how can I remove the $ when selected? example: $10.00 would return as 10.00 -Robby

I would like to select a random record from a group of records so I'd end up with one random record per group: CREATE TABLE randtest ( catnum int, title varchar(32) ); INSERT INTO randtest VALUES (1, 'one.one'); INSERT INTO randtest VALUES (1, 'one.two');

Hi I am sorry for mailing this list directly, but I am planning to migrate a web application from MySQL to Postgres. I am aware of a number of applications to help in this process, ie my2pg, etc. The biggest stumbling block I face is replication. What facilities exist within Postgres to replicate data from one instance to another? Which...

Hello, We've been working to try and solve this issue. On PostgreSQL install(running on RH 7.1), we can't get CURRENT_TIMESTAMP, CURRENT_TIME, or now() to function. All the results is psql reporting the server closed the connection. I've been searching all over for clues about this, and haven't found a thing. If anyone has an idea as to...

Hi Guys, I'm currenlty involved in a port of our gateway code from a Solaris 8 environment to a HP-UX11.11 incorporating postgresql-7.3.3. We're having some problems with creation and opening of large objects and was hoping that you may be able to shed some light on them. I extracted the LO code into the test program as below and am able...

There is a query: $sqlcmd = "CREATE TEMP TABLE tmp_table1 AS SELECT " .$p_distinct. " " ..$sql_columns. " FROM " .$sql_table ; Next I have command: $sqlcmd_tmp = $sqlcmd; $tmp_res = pg_Exec( $conn, $sqlcmd_tmp ); Always it's ok, so it's execute without any problems. But sometimes I get error like this : Warning: pg_exec():Query...

I'm actually getting the mailing list mail, so I don't know what the deal is. Successful deliveries are coming from 64.117.225.209. But 207.173.200.206 has big problems. Sendmail is misconfigured in at least two ways. DNS is not even configured at all for reverse DNS. I can't whitelist the sender email addresses because spammers already...

Oops, actually ALTER GROUP "<group1>" ADD USER "<group2>"; ALTER GROUP "<group1>" ADD GROUP "<group2>"; ALTER GROUP "<group1>" ADD "< group2>"; ---------- Forwarded Message ---------- Subject: Nesting Groups Date: Sat, 9 Aug 2003 16:20:43 -0700

Utilizing Postgres 7.3.3 on RH80. Unable to nest groups; attempting the following: ALTER GROUP "<group1>}" ADD USER "<group2>"; ALTER GROUP "<group1>}" ADD GROUP "<group2>"; ALTER GROUP "<group1>}" ADD "<existing group2>"; Any work-around or something I am missing?

I need to store some sensitive data and I want to use public keys so anyone can encrypt the data but can only be decrupted by certain users. Anyhow, are there any loadable modules that do public key encryption for Postgresql ? I'd like to access these functions in plpgsql. It's probably not that hard, just don't want to re-invent the...

Dear all, for some reason I just cannot get my brain wrapped around the required syntax for the following. I think I need to either use a join or subselect(s): Situation: ---------- I have two tables (simplified here) for an international medical office application (www.gnumed.org):

Hello, all! I have a good question for PostgreSQL FAQ. How to use string functions (like UPPER()/LOWER()) for non-latin strings? Why UPPER() function doesn't work with my UNICODE PostgreSQL database whichcontains non-latin characters (like cyrillic)? How to make case insensetive search by text field which contains non-latin characters? ...

in log: IDENT authentication failed for user "band" ? pg_hba.conf local all ident sameuser host all 127.0.0.1 255.255.255.255 ident sameuser

Dear peoples, I'm setting up a database in postgres which will have light traffic writing to a few tables (and somewhat heavier traffic reading them). We'd like to mirror that databse using dbmirror to two others. Let's assume that we're humming along and the master goes down. We switch traffic to read from one of the two slaves. What...

I'm receiving the following error during startup: Aug 10 14:11:27 thunder postgres: LOG: failed to create socket: Address family not supported by protocol Aug 10 14:11:27 thunder postgres: LOG: database system was shut down at 2003-08-10 14:11:11 MDT Aug 10 14:11:27 thunder postgres: LOG: checkpoint record is at 4/E28389B4

How does one concat string literals in pgsql ? The compiler complains about the concat operator in the following code fragment: RAISE EXCEPTION ''SELECT DISTINCT "t1"."usesysid" '' || ''INTO userID '' || ''FROM "pg_user" AS "t1" '' || ''WHERE "t1"."usename" = current_user '' ||

I've been charged with investigating postGIS as a replacement for our current Informix runtime (9.3), which uses the Spatial blade. Currently we use two Sun Sparc/Ultra 80 boxes with 3 CPUS dedicated to Informix. We use our database to calculate the image files we have within a given area (ST_Union, Intersect and the like). Originally this...

Hi, I'm looking for best practices for building a multilingual database. It is for an multilingual application that will use a persistence layer. I would like to know what are the different ways to design the database and what are the differencies between the different possibilities.

how could I fix this problem: ERROR: unexpected chunk number 8 (expected 0) for toast value 6935693 It appear to be simple: update chunk_seq from 8 to 0. how to do it? in the stand alone postgres, could I copy a entire table? how to do it?

Hi: I must have missed something, but how is it possible that a join on tables A and B is faster (a lot faster) than a query to one of the tables with the same conditions? The problem seems to be with the query plan, in the case os a query to table_a only, the planner executes a "Seq Scan", in the case of a join, an "Index Scan". table_a...