Re: [ADMIN] PG 7.2 tarball

Just a note: $ tar --version tar (GNU tar) 1.13.25 $ tar -zxf test.tar.gz $ tar zxf test.tar.gz Both work fine. $ tar -fxz test.tar.gz tar (child): test.tar.gz: Cannot open: No such file or directory ... $ tar fxz test.tar.gz $ I just learned today that if I use the '-', then f needs to be la

Re: [ADMIN] PG 7.2 tarball

Try: tar xfz postgresql-7.2.tar.gz or: tar xf postgresql-7.2.tar.gz If you use Netscape to download it, it is already un-gziped. If both of the commands above do not work, then you may need to re-download it. |On 020207 09:52 |Simone Tellini ([EMAIL PROTECTED]) wrote the following... | |Hi th

Re: [ADMIN] Persistent Connections with PHP and PostgreSQL

PHP will close the connection at the end of the script. I always call pg_close() when I'm done accessing the db. If your script is short and quick, then it should not be a problem. If it does some more processing on the data after you finished with the connection, why keep it open? |On 020206 1

Re: [ADMIN] Persistent Connections with PHP and PostgreSQL

Its a bug in PHP. Also, PHP 4.1.1 is the latest version. I have not tried it with this new version yet. I switched from pconnect to just connect and I did not see much difference. I dont run into the out of connections problem any more so I'm happy. |On 020206 10:00 |Felipe Nascimento ([EMAIL

Re: [ADMIN] What erd tool supports pgsql??/

|On 020124 11:53 |Chris Pesko ([EMAIL PROTECTED]) wrote the following... | |Looking for a ERD tool that support pgsql. Anyone know of any? http://techdocs.postgresql.org/oresources.php has some links to a few, check out the Database Design section. -- BOFH Reason of the day: We've picked COBOL

Re: [ADMIN] drop column?

This is something I have been wanting for a long time. The ability to update or drop a column from a table. Right now you have to select the columns you want into a temp table and drop the working table and rename the temp table to the working table. |On 020123 12:15 |Jodi Kanter ([EMAIL PROTEC

Re: [ADMIN] Primary Key Problems

quot;Tony Reina" <[EMAIL PROTECTED]> wrote in message |[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... |> [EMAIL PROTECTED] (Phill Kenoyer) wrote in message |news:<[EMAIL PROTECTED]>... |> > Here is a good one. I have three fields set for my primary key. Now I |> &

Re: [ADMIN] Odd behavior with NULL value

I think that this page will explain it all: http://www.postgresql.org/idocs/index.php?functions-comparison.html |On 011220 17:05 |Bob Smith, Hammett & Edison, Inc. ([EMAIL PROTECTED]) wrote the following... | |See example below of using NULL values with type DATE. It behaves |strangely in expres

Re: [ADMIN] Primary Key Problems

I took your advice and checked the string size using char_length() and octet_length(). They are the same. octet_length | stock| octet_length | inventory_type | client_id 5 | 10725 |4 | used |60 5 | 10725 |4 | use

[ADMIN] Primary Key Problems

Here is a good one. I have three fields set for my primary key. Now I thought that a primary key was unique, and dups can not be inserted. CREATE TABLE "inventory" ( "stock" character varying(50) NOT NULL, "inventory_type" character varying(20) DEFAULT 'unknown' NOT NULL,

Re: [ADMIN] installing

|On 04 07:10 |Aleksander Kopanchuk ([EMAIL PROTECTED]) wrote the following... | |PostgreSQL (on FreeBSD 4.3). |Install's procedure can't find library crt1.o on during the installation |PostgreSql . |I can't run script ./configure with options - I get message: command not |found. |Example: ./co