[SQL] Possible bug? WAS :Bad (null) varchar() external representation.

2001-01-09 Thread Justin Clift
Hi, I haven't seen a mention of a maximum number of constraints of similar applying to a table. If so, then could someone please point me to it... The reason I mention this is because I've found what seems to be causing this problem I'm experiencing with Postgres 7.03 : CREATE TABLE "staff_det

[SQL] Bad (null) varchar() external representation

2001-01-09 Thread Justin Clift
Hi all, I'm getting the following problem when trying to do a simple insert statement... "Bad (null) varchar() external representation" WHY? I'm running PostgreSQL 7.03 on Linux Mandrake 7.2 (using a specially compiled version, not an RPM). Here's the table : foobar=# \d staff_details

[SQL] MATCH

2001-01-09 Thread Robert B. Easter
MATCH is not implemented? -- Robert B. Easter [EMAIL PROTECTED] - -- CompTechNews Message Board http://www.comptechnews.com/ -- -- CompTechServ Tech Services http://www.comptechserv.com/ -- -- http://www.comptechnews.com/~reaster/

Re: [HACKERS] Re: [SQL] PostgreSQL web page

2001-01-09 Thread The Hermit Hacker
Error on pgsql.com ... I was nowhere near Las Vegas on Dec 12th ... On Tue, 9 Jan 2001, Kaare Rasmussen wrote: > > > Looks OK here. Maybe a bad mirror. Do: > > Nope. But I must admit that the item about the award is there - it's just > dated November 16, where the date on pgsql.com is Dec. 12

Re: [HACKERS] Re: [SQL] PostgreSQL web page

2001-01-09 Thread The Hermit Hacker
Erk, ookay, didn't think of that ... Kaare, what URL/mirror are you hitting? Can you email Vince and let him know, so taht he can get that removed? Thanks ... On Tue, 9 Jan 2001, Bruce Momjian wrote: > > I have no graphical browser right now, and lynx isn't installed, so I'm a > > bit at a di

Re: [HACKERS] Re: [SQL] PostgreSQL web page

2001-01-09 Thread Kaare Rasmussen
> Looks OK here. Maybe a bad mirror. Do: Nope. But I must admit that the item about the award is there - it's just dated November 16, where the date on pgsql.com is Dec. 12. But the thing I really wondered about was the missing announcement of the Replication Server. I thought it was an impor

Re: [HACKERS] Re: [SQL] PostgreSQL web page

2001-01-09 Thread Bruce Momjian
> I have no graphical browser right now, and lynx isn't installed, so I'm a > bit at a disadvantage here ... but, pgsql-sql *should* be listed under > users-gallery, not devel ... devel is -hackers, -bugs, -ports, etc ... > > Beyond that, the web site is maintained by Vince ... but I thought the

Re: [SQL] PostgreSQL web page

2001-01-09 Thread The Hermit Hacker
On Tue, 9 Jan 2001, Kaare Rasmussen wrote: > I wonder why http://www.postgresql.org is not updated with news. The > latest "Latest News" is from Nov 16. I have to go to > http://www.pgsql.com to find some interesting news later than that: > 2000-12-22 PostgreSQL, Inc. Releases Open Source Replica

Re: [SQL] how to store this record ?? pg_atoi

2001-01-09 Thread Poul L. Christiansen
Could you post the SQL/CF code? What type of field is the field in the database? I've used Cold Fusion and PostgreSQL and it seems to work fine for me. Poul L. Christiansen [EMAIL PROTECTED] wrote: > Hello there > > Using coldfusion 4.5.1 together with postgreSQL 7.0.3 I try to store a new >

[SQL] PostgreSQL web page

2001-01-09 Thread Kaare Rasmussen
I wonder why http://www.postgresql.org is not updated with news. The latest "Latest News" is from Nov 16. I have to go to http://www.pgsql.com to find some interesting news later than that: 2000-12-22 PostgreSQL, Inc. Releases Open Source Replication & Database and2000-

[SQL] how to store this record ?? pg_atoi

2001-01-09 Thread juerg . rietmann
Hello there Using coldfusion 4.5.1 together with postgreSQL 7.0.3 I try to store a new record in my table. There is an inputfield type="text" with the value of 6. I get the following error when I try to add a new record to the database. How to change this ??? Thanks in advance ... jr 6 Erro