Re: [GENERAL] Duplicating a table row while honouring key constraints

2007-11-12 Thread Lars Haugseth
let the database work out the new primary key itself. If your primary key is a column named 'id' of type 'serial', you can copy a record like this: INSERT INTO my_table SELECT nextval('table_name_id_seq'), foo, bar, baz, ... FROM my_table WHERE id = -- L

Re: [GENERAL] Oracle and Postgresql

2008-09-04 Thread Lars Haugseth
ng buying these. However, I'm probably going to kill myself if I find a new edition for sale only a short while after I've bought them. Are there any plans to release an updated set in the near future? -- Lars Haugseth "If anyone disagrees with anything I say, I am quite prepared no

Re: [GENERAL] passing passords to pgsql/pg_create/pg_dump programmatically

2007-03-20 Thread Lars Haugseth
u can see, all of these command line utilities accept the -W parameter followed by the password. Alternatively you can configure PostgreSQL to allow connections from certain clients without password authentication: http://www.postgresql.org/docs/8.2/static/client-authentication.html -- Lars Haugs

[GENERAL] Compound words giving undesirable results with tsearch2

2006-05-30 Thread Lars Haugseth
s of the text being indexed. In many situations, this will lead to a lot of 'false' matches, seen from a user perspective. Ideas on how to handle this problem will be much appreciated. -- Lars Haugseth "If anyone disagrees with anything I say, I am quite prepared not only

Re: [GENERAL] Compound words giving undesirable results with tsearch2

2006-05-30 Thread Lars Haugseth
* oleg@sai.msu.su (Oleg Bartunov) wrote: | | On Tue, 30 May 2006, Lars Haugseth wrote: | | > I've setup a database using tsearch2, configured with support for compound | > words according to the excellent guide found here: | > | > http://www.sai.msu.su/~megera/

Re: [GENERAL] psql + autocommit

2004-09-16 Thread Lars Haugseth
e located in '~postgres/etc/pgsql'. -- Lars Haugseth ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] pg_dump in cycle

2004-09-17 Thread Lars Haugseth
-17 14:00 foo.pg_dump -rw-r--r--1 postgres users3326 2004-09-17 14:00 test.pg_dump -- Lars Haugseth ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] psql + autocommit

2004-09-17 Thread Lars Haugseth
* Michael Paesold: | Peter Eisentraut wrote: | > Lars Haugseth wrote: | > > Version 8.0.0beta2 supports a global configuration file. It's should | > > be located in '~postgres/etc/pgsql'. | > | > That would be pretty useless, since normal users often don'