Ron Peterson <[EMAIL PROTECTED]> writes:
> How should I create a composite type value out of columns a and b in
> table tt that I can insert into table atable?
Hm, it works for me with an explicit cast:
INSERT INTO
atable
SELECT
ROW(a, b)::atype
FROM
tt;
Perhaps we should allow this in an
hi list
i'm trying to write a custom tsearch2 trigger that checks on update if the
column value is changed. here's what i did so far:
CREATE OR REPLACE FUNCTION "forum"."tsearch2_trigger_posts" () RETURNS
trigger AS
$body$
BEGIN
IF (TG_OP = 'UPDATE') THEN
IF (NEW.p_msg_clean
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
And while we're on it, setting that variable caused the PostgreSQL
server to lock up Yast when I was restarting it that way.
John Meyer wrote:
> Okay, I read the FAQ.
>
> I looked at my postgresql.conf file and didn't see "#tcpip_socket" set,
> eithe
Okay, I read the FAQ.
I looked at my postgresql.conf file and didn't see "#tcpip_socket" set,
either to true or false.
I'm also attaching the tail of the log, even though I could connect to
the database using the command line client.
2006-11-18 19:27:22 MST jmeyer jmeyer LOG: could not connect
I'm trying to understand how to insert a composite type value. I'm
having trouble with the last sql statement below. It errors out with:
ERROR: cannot cast type record to atype
How should I create a composite type value out of columns a and b in
table tt that I can insert into table atable?
C
On Sat, Nov 18, 2006 at 01:07:15PM -0800, J. Greg Davidson wrote:
> Hello,
>
> My user-defined types are crashing the PostgreSQL server and I don't
> understand why. I've been trying to figure it out on my own for overr
> a week. I've cooked what I'm doing down to the essentials and I'm
> askin
Hello,
My user-defined types are crashing the PostgreSQL server and I don't
understand why. I've been trying to figure it out on my own for overr
a week. I've cooked what I'm doing down to the essentials and I'm
asking for help. Help: What am I doing wrong?
* Sections of this message:
** Over
