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
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
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
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
* 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/
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])
-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])
* 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'