Re: [GENERAL] Web-based PSQL?

2000-03-29 Thread Stan Jacobs
: > Stan Jacobs wrote: > > > is there a version of psql that runs via web interface? It seems like it > > would be rather trivial to build if it doesn't already exist, right? (And > > generally, at least to me, "trivial" means someone's already done i

[GENERAL] Web-based PSQL?

2000-03-29 Thread Stan Jacobs
hi there, is there a version of psql that runs via web interface? It seems like it would be rather trivial to build if it doesn't already exist, right? (And generally, at least to me, "trivial" means someone's already done it. *smile*) Thanks, - Stan -

[GENERAL] limit on 'text' field?

2000-03-24 Thread Stan Jacobs
Hi folks, I have an UPDATE command that's storing news articles and writing an article to a field of type 'text' and it's failing with a "query too long" error message. I tried pasting the query into psql and it's giving me the "query buffer max length of 16384 exceeded" error. So, I guess th

Re: [GENERAL] How to retrieve table definition in SQL

2000-03-19 Thread Stan Jacobs
x27;s an easy way to do this. On Sun, 19 Mar 2000, omid omoomi wrote: > Hi, > There are some system tables in any pg database which contain information > about table/field names/types and descriptions. use -e with psql command, > and look at the sql code when running /d command

[GENERAL] How to retrieve table definition in SQL

2000-03-19 Thread Stan Jacobs
Hi everyone, This probably isn't a Postgres-specific question, but I'm hoping that someone knows the answer to this off the top of their heads... :-) I'd like to retrieve the table definition via SQL. I'm using ColdFusion to access a PostgreSQL 6.5.3 database, and I'd like to retrieve the tabl

[GENERAL] Simple problem?

2000-03-01 Thread Stan Jacobs
Hi there, I must be confusing my syntax somehow, because I'm having trouble doing a simple update with returned id... As in I have two tables: an order table and an orderitems table. I need to write the order record, then use the order_id from the order record in the insert to the orderite

[GENERAL] INT4 on Linux/2.2.9 (x86)

1999-11-27 Thread Stan Jacobs
Hi, I just installed PostgreSQL 6.5.3 on Linux 2.2.9 (Intel/x86) platform. Everything went smoothly, but the regression tests failed for int2 and int4 datatypes. Repeated tests produced the same results. Should I be concerned that the SERIAL macros default to int4 for all their values? Are i