Re: [GENERAL] How to display stored image on web page?

1999-01-15 Thread Gilles Darold
Hi, You just have to use the read() function directly into your image field. I think there is an example into the documentation, perhaps the programmers guide ? If not I can send you a perl script which is doing this kind of stuff! Regards, Bernie wrote: Now that I've stored several jpg's in

[GENERAL] VIEW's on UNION's

1999-01-15 Thread Kaare Rasmussen
I miss subject. I know the answer is that I can write them myself, but I don't know where to start or end. See this construct: CREATE TABLE gl-amount ( glam_nr int, period date, entry_amount numeric(9,0), PRIMARY KEY (glam_seq,period) ); CREATE VIEW glam_curmth_v AS

[GENERAL] Representation of big integer numbers.

1999-01-15 Thread Memphisto
Hi, Is there a way to display big integer numbers splitted by periods in PostgreSQL queries? Example: 123.456.789 instead of 123456789 . Thanks in advance Sebestyn Zoltn [EMAIL PROTECTED]

[GENERAL] Query is too long

1999-01-15 Thread Silvio Emanuel Barbosa de Macedo
Hi! I was using psql to insert data into the database. I have *.sql files with the necessary scripts, eg: insert into descritor values (4992,'MARCHAS DE LISBOA','te','cl'); After many inserts... I've got this message: query buffer max length of 2 exceeded query line ignored and then, a

[GENERAL] OID

1999-01-15 Thread Clark Evans
I'm designing a database schema and have questions about OID. First, I assume that OID are system assigned? [yes] Second, Can I use OID as a primary key? [no] Third, Is the OID invariant under an import/export process? [no] Fourth, Can I create table with an OID type for referencing another

RE: [GENERAL] OID

1999-01-15 Thread Evan Howarth
I'm designing a database schema and have questions about OID. First, I assume that OID are system assigned? [yes] Second, Can I use OID as a primary key? [no] Perhaps in ignorance, I have used the system assigned OID as a non-topical primary key.

RE: [GENERAL] OID

1999-01-15 Thread Jackson, DeJuan
I'm designing a database schema and have questions about OID. First, I assume that OID are system assigned? [yes] yes - correct assumption Second, Can I use OID as a primary key? [no] yes(qualified) - incorrect assumption Currently PostgreSQL doesn't really do anything special with primary

[GENERAL] GUI

1999-01-15 Thread Paulo da Silva
I'm new working with posgres. Is there any GUI to posgresql? TIA Paulo ([EMAIL PROTECTED])

Re: [GENERAL] Query is too long

1999-01-15 Thread Bob Dusek
Hey there, One way to execute .sql scripts in your database is this: psql -e dbname script.sql That is how we recreate our databases from a dump file. "psql -ef script.sql dbname" seems to have the same problem you were having with the \i command: query buffer max length of 2 exceeded

Re: [GENERAL] Query is too long

1999-01-15 Thread Bob Dusek
Sorry, I should have been more clear: One way to execute .sql scripts in your database is this: psql -e dbname script.sql That should be done from the command line. That is how we recreate our databases from a dump file. "psql -ef script.sql dbname" seems to have the same problem

Re: [GENERAL] Query is too long

1999-01-15 Thread Silvio Emanuel Barbosa de Macedo
On Fri, 15 Jan 1999, Bob Dusek wrote: Sorry, I should have been more clear: One way to execute .sql scripts in your database is this: psql -e dbname script.sql That should be done from the command line. Yes... I imagined Anyway, Query Buffer being full I CAN understand..., but core

[GENERAL] Projects Database grows ...

1999-01-15 Thread The Hermit Hacker
I spent a good part of tonight migrating data from the old to new database, so we are up to 66 projects that are listed... I've also started to work on adding stats to the page, so that you can see the break down of Operating System used, PostgreSQL Version used and Country...