On Wed, Dec 01, 2004 at 07:51:17AM +0800, Andrew Thorley wrote:
> ive generated a user defined type: CREATE TYPE qwerty_UDT AS (abc INT);
>
> & table as: CREATE TABLE t (col1 qwerty_UDT);
Are you using 8.0? I don't think earlier versions allowed this.
> my prob is that when i try to insert int
Hi,
ive generated a user defined type: CREATE TYPE qwerty_UDT AS (abc INT);
& table as: CREATE TABLE t (col1 qwerty_UDT);
my prob is that when i try to insert into the type i.e: INSERT INTO t (col1)
Values (qwerty_UDT(123));
i get the error:
ERROR: function test_x(integer) does not exist
HIN
Richard Huxton wrote:
> Christoph Haller wrote:
> > Looks like I asked the wrong question the other day.
> > How can I achieve a session-wide autocommit off?
> > As it is possible inside a psql session via
> > \unset AUTOCOMMIT
> > I am using the libpq interface.
>
> Just BEGIN a transaction after
Christoph Haller wrote:
Looks like I asked the wrong question the other day.
How can I achieve a session-wide autocommit off?
As it is possible inside a psql session via
\unset AUTOCOMMIT
I am using the libpq interface.
Just BEGIN a transaction after connection? Or am I missing something here?
--
Johan Henselmans wrote:
Hi, I am having a problem grouping a many to many relationship with
payments and receipts, where a payment can be for multiple receipts, and
a receipt can have multiple payments. I got a list of records that are
involved in such relations, but now I don't know how to grou
am 30.11.2004, um 9:40:21 +0100 mailte Christoph Haller folgendes:
> Looks like I asked the wrong question the other day.
> How can I achieve a session-wide autocommit off?
> As it is possible inside a psql session via
> \unset AUTOCOMMIT
For psql i have a /etc/psqlrc:
\unset AUTOCOMMIT
\set AU
Looks like I asked the wrong question the other day.
How can I achieve a session-wide autocommit off?
As it is possible inside a psql session via
\unset AUTOCOMMIT
I am using the libpq interface.
TIA
Regards, Christoph
---(end of broadcast)---
TIP
