[GENERAL] large text fields

eing this error: PostgresSQL query failed: ERROR: Tuple is too big: size 1 Are there any other options other than using a BLOB datatype ? which I'm completely unfamiliar with. Kevin -------- Kevin Heflin | ShreveNet, Inc.

[GENERAL] problem with date range

ons would be appreciated. Kevin ---- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Production | 333 Texas St #175| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

[GENERAL] get the previous assigned sequence value

I've been looking through the online docs, so far have not found this information. After an INSERT, I want to retrieve the value of the sequence I use for unique_ids Any suggestions ? Kevin Kevin H

[GENERAL] questing using array

tions would be appreciated. Kevin -------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Production | 333 Texas St #175| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

[GENERAL] datetime datatype question

format it like the first example ? Kevin Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 Production| 333 Texas St #175| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http

[GENERAL] Error when creating tables

suggestions would be appreciated. Kevin ---- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #175| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

Re: [GENERAL] Upgrading from 6.3->6.4.2/6.5b1 possible

out. If I'm going to go > through that kind of labor I'll probably switch to MySQL (which has a > larger web userbase, even though I prefer postgres for it's > completeness).. > > Argh.. Are you aware of any patches to v6.3 that might improve my > stability without breaking compatibility? > > Thanks > > > Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #175| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

[GENERAL] select from into question

;/' ie: '012345' I'd like to either replace this field with this number alone or insert into another newly created field. Any suggestions would be appreciated. Kevin -------- Kevin Heflin | ShreveNet, Inc.

Re: [GENERAL] Optimizations for busy DB??

on a final release of postgresql 6.5 ? Kevin -------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #175| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

[GENERAL] applying 6.4.2 feature patch

complaining about an error using 'select' Any feedback or suggestions would be appreciated. I would like to get the LIMIT function which is provided by the feature patch. Kevin -------- Kevin Heflin | ShreveNet, Inc.

RE: [GENERAL] limit select question

n right now... Kevin ---- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

RE: [GENERAL] limit select question

he patch, anything and everything I tried in psql failed with an error on 'select' Kevin -------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619| FAX:3

[GENERAL] limit select question

; with mySQL and SELECT queries > you can LIMIT the number of results displayed to the screen. I can't > seem to find any such switch in the SELECT commands in postgres. Kevin -------- Kevin Heflin | ShreveNet, Inc.

[GENERAL] character limit on db names in PGSQL or what?

o see what happens. I just thought this was strange. Kevin -------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

[GENERAL] trouble with pgaccess

nvoked from within "main $argc $argv" (file "/usr/local/pgsql/bin/pgaccess" line 4954) Any suggestions sure would be appreciated. Kevin Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638

[GENERAL] need help separating a field

ord, and spit up the pair, and insert them back into the newly created 'username' and 'password' fields. Is this even possible? and if so, would anyone be willing to give me a hint? Kevin -------- Kevin Heflin

Re: [GENERAL] select using date

You will either have to retype this query using an explicit cast, or you will have to define the operator using CREATE OPERATOR After trying somethings, I was able to get this to work: select CURRENT_DATE -1; will subtract 1 day from the current date... which gives me what I need f

[GENERAL] select using date

by dateof desc Basically just trying to subtract 1 day from the CURRENT_DATE When I try the above I get ERROR: parser: parse error at or near "day" Any suggestions would be appreciated. Kevin ---- Kevin Heflin

Re: [GENERAL] alter table ?

'm looking for, was that when ever anything was added to the table. Regardless of whether or not the spamblock was specified, it would be set to 'TRUE' Kevin ---- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.26

Re: [GENERAL] Still the problem with the autoincrement field

is here.. but you should not have to call on the increment sequence at all durring the insert.. it's automatic Maybe it's because you are not specifying which fields to insert into like so: insert into table_name (field1, field2, field3, field4) values ('data1', 'data2'

Re: [GENERAL] How to have a autoincrement field?

) Hope that helps. Kevin -------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619| FAX:318.221.6612 [EMAIL PROTECTED]| Shreveport, LA 71101 | http://www.shreve.net

[GENERAL] importing into postgres

;team_id' I also tried adding nextval('team_id') in my .txt file for that field no luck. any suggestions? Kevin ---- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Tex

[GENERAL] date datatype

Is there an easy way to get Postgres to get the datatype of date to return a Unix timestamp Kevin Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #619| FAX

Re: [GENERAL] Re: [HACKERS] NEW POSTGRESQL LOGOS

; its shoulders, an Uzi tucked under one wing... > > > > ...and the severed head of Bill Gates under the other. Sounds good.. print it! Kevin -------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103

Re: [GENERAL] ODBC driver

t database permissions for other users. Also, don't you have to set up Postgres to accept users from another machine.. I forget exactly where you do that. Kevin -------- Kevin Heflin | ShreveNet, Inc. | Ph:31

Re: [GENERAL] extracting date information?

y initial post. Now that my dates are being retreived in this format: Sat Dec 12 00:00:00 1998 CET Is there a way to format this to leave off the "time" portion and maybe the "timezone" info ? -------- Kevin Heflin

[GENERAL] extracting date information?

"YMdl","$thedate"); But when it is displayed it always prints out this date: "1969Dec31Wednesday" Any suggestions or comments would be appreciated. Kevin -- -- Kevin Heflin | ShreveNet, Inc.