Rod Taylor <[EMAIL PROTECTED]> writes:
> On Wed, 2004-10-20 at 14:07, Tom Lane wrote:
>> "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
>>> troels=# create table lookat_feature(
>>> troels(# feature_id char(4),
>>> troels(# status varchar(2) default 'TODO'
> I think the bug is that default
On Wed, 20 Oct 2004 14:07:29 -0400, Tom Lane wrote:
> Hmm. What's going on here is that the stored default expression is
> actually of the form
> ('TODO'::varchar)::varchar(2)
Would it be possible to check the compatibility of a default value for
the associated column? Such a check might p
On Wed, 2004-10-20 at 14:07, Tom Lane wrote:
> "PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> > troels=# create table lookat_feature(
> > troels(# feature_id char(4),
> > troels(# status varchar(2) default 'TODO'
> The alternative would seem to be decreeing that this is not a bug.
>
> C
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes:
> troels=# create table lookat_feature(
> troels(# feature_id char(4),
> troels(# status varchar(2) default 'TODO'
> troels(# );
> CREATE TABLE
> troels=# alter table lookat_feature
> troels-# alter column status type varchar(4);
> ALTER TABL
The following bug has been logged online:
Bug reference: 1290
Logged by: Troels Arvin
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0 Beta
Operating system: Linux, Fedora Core 2 + stuff from Red Hat Rawhide
Description:Default value and ALTER...TYPE
Deta
Kris Jurka <[EMAIL PROTECTED]> writes:
> On Tue, 19 Oct 2004, Alvaro Herrera wrote:
>> Huh, shouldn't the user rather do
>> SELECT func_returning_void();
> The problem is that the function may actually be a SRF so the JDBC driver
> transforms to the "SELECT * FROM" form.
It's not really any weird
Title: Nachricht
Hi,
I think there is a
bug in ODBC from PostgreSQL 8.0 Beta 3 (I think version 7.05), with
7.03.2.00 it works OK
There are no Memo
fields displayed at connected tables in Access97 (shown as text
254)
At Access97
connected tables there would not displayed diacritic
[EMAIL PROTECTED] writes:
> --tablespace option doesn't work with createdb.
Works fine for me. What did you do *exactly* ?
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an i
Sim Zacks wrote:
PGAdmin 1.2.0 Beta 2
Multi-line functions in plpythonu do not work when created using
pgadmin. The function is created but when it is run for the first time
an error of "cannot compile. syntax error on line 2" is given. The
functions have been tested and work when created with psql
Hi,
--tablespace option doesn't work with createdb.
(directory and files are created under $PGHOME/base )
but when I use
psql template1 <
10 matches
Mail list logo
