Re: [GENERAL] Best Linux Distribution

2005-01-20 Thread Jason C. Wells
in terms of postgres? if this has an answer Have you considered something other than linux? Try FreeBSD. I think one of FreeBSD's active developers is also a PostgreSQL developer. (Fournier IIRC) FreeBSD is great software and it shares the BSD license with PostgreSQL. Later

Re: [GENERAL] Problem Downloading for FreeBSD

2004-11-20 Thread Jason C. Wells
--On Saturday, November 20, 2004 7:13 PM -0700 Scott Marlowe <[EMAIL PROTECTED]> wrote: Maybe your hard drive is filling up? I had not thought of that. Thankfully, I don't have to admit to that much silliness. I have plenty of space. Later, Jason C. Wells ---

Re: [GENERAL] Problem Downloading for FreeBSD

2004-11-20 Thread Jason C. Wells
ome confirmation that wasn't some mirror problem. I'll have to dig deeper on my end. Thanks! Jason C. Wells ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Problem Downloading for FreeBSD

2004-11-20 Thread Jason C. Wells
it. Later, Jason C. Wells ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] drop column?

2000-10-04 Thread Jason C. Wells
ut the one you want to remove INTO TABLE new_table FROM old_table; DROP TABLE old_table; ALTER TABLE new_table RENAME TO old_table; Thank you, Jason C. Wells

Re: [GENERAL] Buggered Sequence

1999-12-05 Thread Jason C. Wells
On Sat, 4 Dec 1999, Ross J. Reedstrom wrote: >Jason - >Jesse's sugestion should work, but there's a setval() function for >this exact use: > >SELECT setval('people_id_seq',44); > >I usually use it like this: > >SELECT setval('"Experiments_ExptID_seq"',max("ExptID")) from "Experiments"; > >That a

[GENERAL] Buggered Sequence

1999-12-04 Thread Jason C. Wells
sequence_name|last_value|increment_by| max_value|min_value|cache_value|is_cycled|is_called -+--++--+-+---+-+- people_id_seq| 4| 1|2147483647|1| 1|f|t (1 row) After I screw