Hi,
if i have a table and a rule like this
CREATE TABLE user (id SERIAL, name text);
CREATE RULE startaccount AS ON INSERT
TO user
DO INSERT INTO account (name) VALUES
(new.id, new.name);
(i didnt check the syntax, hope you still get the point)
i get problems because it seems to
Itzinger, Oskar [EMAIL PROTECTED] writes:
CREATE TEMPORARY TABLE junk (col1 SERIAL, more cols)
and check \ds, the implicitely created sequence is shown but \di doesn't
show the implicitely created index.
\d and \di don't show temp tables and indexes.
The sequence object should be temp as
How do you mean, Tom?
Vilson farias [EMAIL PROTECTED] writes:
Does anyone know what is this error?
ERROR: cache lookup for userid 26 failed
Evidently pg_shadow has no entry with usesysid 26. Add it back...
regards, tom lane
I dont have a pg_shadow file, I use a passwd file
David D. Kilzer [EMAIL PROTECTED] writes:
Attached please find a patch to cast (convert) the MONEY type to any one
of the following types:
INT2, INT4, INT8, FLOAT4, FLOAT8
Hmm. It strikes me as a rather bad idea to introduce implicit casting
of MONEY to all these other types --- I suspect
Patrick COLLIN [EMAIL PROTECTED] writes:
I need to update 300,000 records with many tests on each before
updating.
I first tried a global update on each column, but I have not enough
memory and swap to do that.
If this is 7.1, I'd be interested to see the query and the table
schemas.
If it
Vilson farias [EMAIL PROTECTED] writes:
Evidently pg_shadow has no entry with usesysid 26. Add it back...
I dont have a pg_shadow file, I use a passwd file instead.
Yes, you do have a pg_shadow table. If you think you can have PG users
who aren't listed in pg_shadow, you've just found out
Sorry, I do have a pg_shadow file, but it's empty.
I have a pg_pwd too with this text inside :
[postgres@bxsgalena data]$ cat pg_pwd
postgres0 x x x x 1 \N
What is it used for? I couldn't find info about this file in html docs. I have another