well, almost everything is in the subject !
I have to fill 2 tables (more complicated than in the example !):
CREATE TABLE A (
  id serial primary key,

The following bug has been logged online:
Bug reference:      1159
Logged by:          Ilya S. Slyzhnyak
Email address:      ilya@odt.east.telecom.kz

Platform Slackware linux 9.1/ Linux 2.6.4
I did a make distclean and ./configure --enable-thread-safety. The build
aborted with following error messages
make[4]: Leaving directory `/home/shridhar/postgresql/pgsql/src/port'

June 1 is pretty close now, so I'm asking about yet another
contrib module, pg_trgm which is rather mature and quite useful.
Is't worth to put it into 7.5 contrib ?
trgm - Trigram matching for PostgreSQL

Im getting strange errors when restoring data from pg_dump files:
ERROR:  duplicate key violates unique constraint "products_pkey"
CONTEXT:  COPY products, line 1: "98    Super Pak Ruby játék      J-0001  1502450E       Szuper Pokémon ajándékcso.. ...

i have RH7.1 box with postgres 7.0.3. i searched the internet for above mentioned subject in vain. now i'm totally confused about postgres.conf (i'm not able to find in my installation) and pg_options. cud anybody let me know how do i setup logging of postgres.
thanks in advance.

If I connect to any database with psql I can see all the other databases in table pg_database
under postgresql 7.2
What happens if I delete all the rows from this table.

  In Postgresql version 7.4.1 How does one pass new/old record in a
pl/pgsql trigger function to other functions? I tried to pass it
directly but the select/perform statement caused an error saying "NEW
used in query that is not in a rule". I've tried 'rename' in the declare

The following bug has been logged online:
Bug reference:      1158
Logged by:          Werner Bohl
Email address:      wbohl@deepdata.com

Couple of quick protocol questions:
1) What encoding is used for strings sent and received during the
startup phase? I can set client_encoding to a known value as a parameter
in the startup packet, but the protocol spec doesn't appear to say how

Frankly I don't know what should I do more. The problem is:
I've made a pg_dump from shell like that:
pg_dump -Upostgres -O -D -Fc --file=baza.sql
Copied the file to new server and from shell executed:

I have ported a PHP MySQL app to PostgreSQL, and a pg_send_query()
call is returning error code 2 (PGSQL_TUPLES_OK). Unfortunately
the PHP manual lists the error codes but doesn't indicate what
they mean, and pg_result_error() returns a blank message.

Do constraints effect performance significantly?
Thanks
Jodi

Im trying to make a stored procedure that returns * from at table, and
returns multible rows. Can you do that, and how?
basically I would like to do:
create or replace function test () returns record as '

I am wondering, if it's effective to use text arrays to store
multilanguage information.
We used to do it like this:
CREATE TABLE product (