I turned on log_connections and that is indeed the problem. Looks like it's my
software and not pg.
Thanks all!
Cheers,
Ovid
--
IT consulting, training, international recruiting
http://www.allaroundtheworld.fr/.
Buy my book! - http://bit.ly/beginning_perl
Live and work overseas -
cause this works (password in .pgpass, though
the fact that I'm connecting suggests that my password is fine):
$ psql -U veure_user -d veure
psql (9.1.11)
Type "help" for help.
Cheers,
Ovid
--
IT consulting, training, international recruiting
http://www.allaroundtheworld.fr/.
And in the above, by "veure_user" in the pg_hba.conf, I obviously meant
"some_user".
Cheers,
Ovid
--
IT consulting, training, international recruiting
http://www.allaroundtheworld.fr/.
Buy my book! - http://bit.ly/beginning_perl
Live and work overseas - http://ww
privileges on the "mydatabase" database.
Can someone point me in the right direction?
Cheers,
Ovid
--
IT consulting, training, international recruiting
http://www.allaroundtheworld.fr/.
Buy my book! - http://bit.ly/beginning_perl
Live and work overseas - http://www.overseas-exile.com/
INSERT INTO temp_person (name) VALUES ('ovid');
SELECT * FROM temp_person_two;
person_id | name | has_default
---+------+-
1 | ovid | en
(1 row )
Finally, alter the parent table by adding a new, unrelated column. Attempt to
insert da
until this mornings 'stack depth' errors. Can anyone
give
me a pointer as to what's going on? Is there more information I can provide to
help diagnose this?
Cheers,
Ovid
--
Buy the book - http://www.oreilly.com/catalog/perlhks/
Tech blog- http://blogs.perl.org/use
* id 5
* id 9
* id 7
How would I work that out? Can I do that in straight SQL or should additional
information be added to this table?
Cheers,
Ovid
--
Buy the book - http://www.oreilly.com/catalog/perlhks/
Tech blog- http://blogs.perl.org/users/ovi
LEAST function! I love you (platonically, of
course. My fiancée might have issues otherwise).
Cheers,
Ovid
--
Buy the book - http://www.oreilly.com/catalog/perlhks/
Tech blog - http://blogs.perl.org/users/ovid/
Twitter - http://twitter.com/OvidPerl
Official Perl 6 Wiki - http://www.perlfoundation
id = row.id
END LOOP
But, of course, doing that for four percentages (with at least one having a
different increment value than .1)
Cheers,
Ovid
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
END IF;
RETURN;
END;
$$ LANGUAGE plpgsql;
Better yet, am I approaching this entirely the wrong way? If there is a
simpler solution to gradually increase those variables over time, I'd welcome
it.
If this is not clear, please let me know and I can try to explain mor
ECT id INTO :parent_id FROM refers WHERE name='';
INSERT INTO refers (name, parent_id) VALUES ('yyy', :parent_id);
Obviously the above is gibberish, but hopefully it makes clear what I'm trying
to do :)
Oh, and "parent_id" is NOT NULL because I hate the lo
11 matches
Mail list logo
