Re: [GENERAL] Data types for IP address.

On Wed, Feb 23, 2011 at 05:39:26PM +0530, Gaini Rajeshwar wrote a message of 52 lines which said: > I wanted to store ip addresses in table. I wanted to support the following 3 > types of ip addresses. > > *1. Wildcard format :* 1.2.3.* > * > * > *2. CIDR format:* 1.2.

Re: [GENERAL] Data types for IP address.

On Wed, Feb 23, 2011 at 02:30:18PM +0200, Sim Zacks wrote a message of 97 lines which said: > a regular varchar or text field. Very bad idea since they don't support canonicalization (2001:db8::1 == 2001:db8:0:0:0:0:0:1) or masking (set_masklen(address, 20)). -- Sent via pgsql-general maili

[GENERAL] Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL

On Tue, Jun 22, 2010 at 04:18:48PM +0530, venkat wrote a message of 39 lines which said: > I want to insert and retrieve multilingual (Hindi) into database.is > PostgreSQL supports that ? [Currently, I'm storing arabic texts in a PostgreSQL database.

Re: [GENERAL] Emal reg expression

On Wed, Oct 28, 2009 at 05:45:14AM -0700, Xai wrote a message of 2 lines which said: > i want to create a type for an email field but i'm not good with regx Do not even try. http://stackoverflow.com/questions/201323/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] Restoring a database from original files (Was: Need help

On Mon, May 18, 2009 at 11:33:03PM +0430, Zico wrote a message of 74 lines which said: > No, I don`t have any data of Postgres "data" directory. Next time, do not forget backups... > As far as i can remember, my postgre files were in /usr/share/postgresql/8.3 > > as i am using the Debian di

Re: [GENERAL] Multi Lingual problem

On Tue, Dec 02, 2008 at 05:35:35PM +0530, ravi kiran <[EMAIL PROTECTED]> wrote a message of 19 lines which said: > I am using the psqlodbc driver to connect to postgresql... But this > is not supporting all the languages that UTF should support.. An important thing: the Unicode character set,

Re: [GENERAL] PostgreSQL 8.3.5 client_encoding WIN1251 trouble

On Tue, Nov 25, 2008 at 04:19:27PM +0300, Dr.ONE <[EMAIL PROTECTED]> wrote a message of 22 lines which said: > I have database in KOI8-R encoding. ... ERROR: character 0x8b9a of > encoding "MULE_INTERNAL" has no equivalent in "WIN1251" Are you sure it is KOI8? The KOI8 encoding is monobyte and

Re: [GENERAL] Problem with langage encoding

On Thu, Nov 27, 2008 at 02:34:17AM +0900, Craig Ringer <[EMAIL PROTECTED]> wrote a message of 188 lines which said: > > ERROR: character 0xc3bd of encoding "UTF8" has no equivalent in "WIN1251" > > Which it does not; that character is "???" (HANGUL SYLLABLE SSYEG) No, I don't think so. I th

Re: [GENERAL] Urgent - Grant

On Tue, Nov 18, 2008 at 11:46:07AM -0300, Gustavo Rosso <[EMAIL PROTECTED]> wrote a message of 68 lines which said: > PostgreSQL 7.4 informix1.8 on i686-pc-linux-gnu, compiled by GCC gcc > (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21) > Is it old version? It is still in Debian "stable"

Re: [GENERAL] How to know the password for the user 'postgres'

On Tue, Oct 28, 2008 at 07:13:38AM -0700, Tim Bruce - Postgres <[EMAIL PROTECTED]> wrote a message of 41 lines which said: > Wouldn't it be better to add the line 'sudo su - postgres' as the > entry (command) for the user(s) in the sudoers file? Simpler, set the "runas" parameter: jsmith ALL

[GENERAL] Re: should i need to install xml library in postgresql inorder to work on xml file?

On Mon, Jul 28, 2008 at 06:47:43PM +0100, Stephane Bortzmeyer <[EMAIL PROTECTED]> wrote a message of 19 lines which said: > Side question: is there any way (SELECT * FROM > pg_compilation_options?) to retrieve this information from an already > installed PostgreSQL?

[GENERAL] Re: should i need to install xml library in postgresql inorder to work on xml file?

On Mon, Jul 28, 2008 at 06:36:48PM +0100, Raymond O'Donnell <[EMAIL PROTECTED]> wrote a message of 30 lines which said: > Are you in a position to see whether this was done on your installation? Side question: is there any way (SELECT * FROM pg_compilation_options?) to retrieve this informatio

Re: [GENERAL] procedure to load xml file data in postgesql

On Sat, Jul 26, 2008 at 02:32:05PM -0700, aravind chandu <[EMAIL PROTECTED]> wrote a message of 149 lines which said: > I have to load xml file data into postgresql database > table using a stored procedure,but I didn't have any > idea how to start it. Well,

Re: [GENERAL] XML Support related questions

On Thu, May 22, 2008 at 11:49:38AM -0700, Brijesh Shrivastav <[EMAIL PROTECTED]> wrote a message of 251 lines which said: > 2) Is there plan in near future to support XML schema validation i.e > to ensure inserted xml document conforms to a preregistered set of > XML schemas. It seems quite he

Re: [GENERAL] C function

On Tue, May 13, 2008 at 02:18:47PM -0400, Vjy <[EMAIL PROTECTED]> wrote a message of 16 lines which said: > I wrote a C function that will connect to oracle Bad idea. > when there is a insert in table A , the C function is not called at > all, any reason why ? Yes, that's because you use Or

Re: [GENERAL] how to insert values into complex type field

On Fri, Apr 04, 2008 at 04:32:36PM +0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote a message of 74 lines which said: > INSERT INTO attribute2005 > VALUES(1,(23,'ee','ttt',('2005-01-01','2005-12-31'))); And why did you not post the error message? Because it is very clear: ERROR: malformed

Re: [GENERAL] Unicode comment on Postgres vs Sql Server

On Sun, Mar 02, 2008 at 11:50:01AM -0800, Swaminathan Saikumar <[EMAIL PROTECTED]> wrote a message of 30 lines which said: > Postgres has this encoding setting at the database level. Which is simpler, IMHO. "One encoding to rule them all" > I am using UTF8 Unicode for most of my data, but the

Re: [GENERAL] initdb - encoding question

On Mon, Dec 03, 2007 at 12:51:27PM -0500, Josh Harrison <[EMAIL PROTECTED]> wrote a message of 63 lines which said: > The encoding you selected (UTF8) and the encoding that the > selected locale uses (LATIN1) do not match. Indeed. > Rerun initdb and either do not specify an encoding explicit

Re: [GENERAL] SQL Query

On Wed, Dec 05, 2007 at 11:43:08AM +, Steve Grey <[EMAIL PROTECTED]> wrote a message of 153 lines which said: > First work out the maximum number of times each value of X will occur in the > table A better solution, when you do not know this maximum number, is CREATE AGGREGATE (http://www

Re: [GENERAL] running postgres

On Thu, Oct 18, 2007 at 10:50:02AM -0500, Scott Marlowe <[EMAIL PROTECTED]> wrote a message of 18 lines which said: > Personally, I found it quite easy. > > apt-get install postgresqlp8.2 > sudo /etc/init.d/postgres-8.2 start > sudo su - postgres > psql > > 4 whole steps. Although I regard

[GENERAL] [ANNOUNCE] echoping 6, with a PostgreSQL plugin

echoping is a program to test and monitor the response time of network servers, for instance DBMS servers. It is typically used from the command-line or called repetitively by a monitoring framework such as SmokePing (http://www.smokeping.org/). http://echoping.sourceforge.net/ The new version, v

Re: [GENERAL] Native type for storing fractions (e.g 1/3)?

On Thu, Mar 15, 2007 at 07:41:18AM +0100, Peter Eisentraut <[EMAIL PROTECTED]> wrote a message of 22 lines which said: > His goal may be to store and compute rational numbers exactly. The > answer is that there is no data type in PostgreSQL that supports > this. But he can write one in Postgr

Re: [GENERAL] Version/Change Management of functions?

On Fri, Jul 07, 2006 at 02:08:08PM -0600, Michael Loftis <[EMAIL PROTECTED]> wrote a message of 28 lines which said: > Since there's no way to directly control whats in the DB via a VCS, > further, how do you verify that what is in the DB is also in the > VCS, etc? This is not a PostgreSQL-spe

Re: [GENERAL] How to optimize query that concatenates strings?

On Fri, Jul 07, 2006 at 04:29:51AM -0700, badlydrawnbhoy <[EMAIL PROTECTED]> wrote a message of 48 lines which said: > I've got a database of URLs, and when inserting new data into it I > want to make sure that there are no functionally equivalent URLs > already present. For example, 'umist.ac.

Re: [GENERAL] XML Support

On Tue, Jun 20, 2006 at 02:17:28PM +0100, Essam Mansour <[EMAIL PROTECTED]> wrote a message of 35 lines which said: > In my research project, I need a DBMS that supports XML storage and > retrieval, and provides ECA rule support. (No idea about ECA.) > - whether Postgresql DB could be used as

Re: [GENERAL] UTF8 problem

On Thu, Jun 08, 2006 at 07:25:35AM -0400, Douglas McNaught <[EMAIL PROTECTED]> wrote a message of 29 lines which said: > I would think it would (at least potentially) vary with each > message. The dbmail software should really set client_encoding > based on the Content-Transfer-Encoding header

Re: [GENERAL] Question about stored procedures

On Thu, Oct 13, 2005 at 04:20:39AM -0700, Josephine E. de Castro <[EMAIL PROTECTED]> wrote a message of 49 lines which said: > Is there no 'trusted' way of doing this? By definition, certainly not. A "trusted" procedure can be installed by an ordinary user so it MUST NOT play outside of the s

Re: [GENERAL] Email Verfication Regular Expression

On Thu, Sep 08, 2005 at 12:16:36PM -0600, Cristian Prieto <[EMAIL PROTECTED]> wrote a message of 66 lines which said: > res = res_query(name, C_IN, T_MX, answer, sizeof(answer)); Besides Randal Schwartz' excellent remark (do not forget the records, too), remember that the Internet is not

Re: [GENERAL] Email Verfication Regular Expression

On Wed, Sep 07, 2005 at 12:21:45PM -0700, Steve Atkins <[EMAIL PROTECTED]> wrote a message of 26 lines which said: > /[EMAIL PROTECTED]@(?:[EMAIL > PROTECTED])?[a-z0-9-_]+\.(?:a[defgilmnoqrstuwz]|b[abdefghijmnorstvwyz]|c[acdfghiklmnoruvxyz]|d[ejkmoz]|e[ceghrst]|f[ijkmorx]|g[abdefhilmnpqrstuwy]

Re: [GENERAL] Get postgresql workin in french...

On Tue, Aug 30, 2005 at 09:39:40AM -0400, Guy Doune <[EMAIL PROTECTED]> wrote a message of 28 lines which said: > for getting postgresql accepting my entry with accent an all the > what the french poeple put over there caracter while they write... I use PostgreSQL with French data (names, addr

Re: [GENERAL] wanting to use postgres with python - WHAT am I doing wrong?????? AGGGHHHH

On Wed, Aug 03, 2005 at 09:49:18AM -0600, Ronni <[EMAIL PROTECTED]> wrote a message of 24 lines which said: > I want to use postgres with python This is too vague. Do you want: 1) To do server-side programming in Python (creating functions in Python instead of plPgSQL or SQL)? If so: http://

Re: [GENERAL] Implement updated column in all tables

On Thu, Jul 07, 2005 at 04:25:31PM +0300, Andrus <[EMAIL PROTECTED]> wrote a message of 11 lines which said: > I have the following column in all my tables which contains data of > last update of this row: Me too. > I have about 100 tables and don't like to write 100 triggers. I use a temp

Re: [GENERAL] How to uninstall PostGreSql from linux

On Fri, Jul 01, 2005 at 06:09:37PM +0530, Ajay Dalvi <[EMAIL PROTECTED]> wrote a message of 14 lines which said: > Please tell me the procedure to uninstall PostGreSql You did not indicate the operating system, just its kernel (Linux). If the operating system is Debian: apt-get remove postgre

Re: [GENERAL] Postgresql 7.4.7 docs(PDF)

On Thu, May 19, 2005 at 10:38:27AM -0400, Hrishikesh Deshmukh <[EMAIL PROTECTED]> wrote a message of 12 lines which said: > If someone can email Postgresql 7.4.7 docs(PDF). It will be a big > help. I am unable to get pdf docs for this version on debian system. Beginner in Debian system adminis

Re: [GENERAL] Increasing number of postgres connections

On Mon, May 16, 2005 at 11:42:13AM -0700, Akash Garg <[EMAIL PROTECTED]> wrote a message of 12 lines which said: > How do you recompile postgres to allow more than 1024 connections? Do you really need to recompile? I find in the man page: -N max-connections Sets the maxim

Re: [GENERAL] Distinguishing between connections in pg_hba.conf

On Mon, May 16, 2005 at 03:31:27PM -0500, Scott Marlowe <[EMAIL PROTECTED]> wrote a message of 48 lines which said: > > but how do you assign it so that requests from apache appear on > > the db box as one IP address, and requests coming through stunnel > > appear as the second IP address? > >

Re: [GENERAL] REFERENCES ignored when there is inheritance?

On Fri, May 13, 2005 at 11:57:08AM +0200, Stephane Bortzmeyer <[EMAIL PROTECTED]> wrote a message of 49 lines which said: > I have 240 countries in the database. Because of a programming error, > contacts were entered with a country > 240. I thought that the > "R

[GENERAL] REFERENCES ignored when there is inheritance?

I have a table to store localization information: CREATE TABLE Localization ( ... zipcode TEXT NOT NULL, ... country INTEGER REFERENCES Countries (id) NOT NULL The table Countries is like: CREATE TABLE Countries ( id SERIAL UNIQUE, name TEXT UNIQUE NOT NULL, code CHAR(2) UNIQUE NOT NULL);

Re: [GENERAL] GUITools update

On Mon, Apr 18, 2005 at 04:26:56AM -0400, Brennan Stewart <[EMAIL PROTECTED]> wrote a message of 37 lines which said: > Sample list (just a few from my own) * Freeness of the code (which is much more important than price: switching tools is *hard* because of the lack of standards, so a small p

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Thu, Apr 28, 2005 at 02:04:29PM +0200, Marco Colombo <[EMAIL PROTECTED]> wrote a message of 146 lines which said: > No. NULL is NOT 'None', nor 'undef', and definitely not NULL as in > C. Thanks for the very good and detailed explanation of NULL in SQL. Curious people may note that the stra

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Wed, Apr 27, 2005 at 05:04:07PM +0200, Sebastian Böck <[EMAIL PROTECTED]> wrote a message of 24 lines which said: One is enough :-) v > CREATE TABLE table x ( > name TEXT NOT NULL, > address INET > ); > > CREATE UNIQUE INDEX na ON x (name, address); > C

Re: [GENERAL] After insert trigger question

On Wed, Apr 27, 2005 at 08:45:44AM -0600, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote a message of 21 lines which said: > I am concerned about how reliable is an before insert trigger, i > made some computation in my trigger and i want that no matter what > happens inside the trigger (exception

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Wed, Apr 27, 2005 at 09:36:57AM -0500, Scott Marlowe <[EMAIL PROTECTED]> wrote a message of 18 lines which said: > Often the best bet here, btw, is to declare it not null then use > something other than null to represent null, like the text > characters NA or something. Yes, but it defeats

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Wed, Apr 27, 2005 at 04:50:23PM +0200, Sebastian Böck <[EMAIL PROTECTED]> wrote a message of 48 lines which said: > CREATE UNIQUE INDEX na ON x (name, address) WHERE address IS NULL; No, because it prevents two tuples with the same value of "name". ---(end of broadc

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Wed, Apr 27, 2005 at 10:26:30AM -0400, Tom Lane <[EMAIL PROTECTED]> wrote a message of 9 lines which said: > If that's what you want, declare it as UNIQUE not PRIMARY KEY. As shown by Patrick TJ McPhee, it does not work: tests=> create table x ( tests(>name TEXT NOT NULL, tests(>a

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Wed, Apr 27, 2005 at 05:19:32AM +, Patrick TJ McPhee <[EMAIL PROTECTED]> wrote a message of 37 lines which said: > but you should know that in SQL, unique constraints don't apply to > rows containing null values May be I should but I didn't. > your table definition will be as you want

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Tue, Apr 26, 2005 at 03:48:44PM -0500, Scott Marlowe <[EMAIL PROTECTED]> wrote a message of 26 lines which said: > Here's a quote from the SQL1992 spec that's VERY clear: Yes, PostgreSQL is right and implement the standard. Now, what's the rationale for the standard? I understand it for a s

Re: [GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT

On Tue, Apr 26, 2005 at 03:22:40PM -0500, Guy Rouillier <[EMAIL PROTECTED]> wrote a message of 37 lines which said: > "The primary key constraint specifies that a column or columns of a > table may contain only unique (non-duplicate), nonnull values. > Technically, PRIMARY KEY is merely a combi

[GENERAL] PRIMARY KEY on a *group* of columns imply that each column is NOT NULL?

If I define a primary key: name TEXT NOT NULL, address INET, PRIMARY KEY(name, address) the definition (seen by \d) becomes: name | text| not null address | inet| not null "address" is now not null, which I d

Re: [GENERAL] Immutable attributes?

On Tue, Apr 26, 2005 at 09:49:05AM -0400, Mario Soto Cordones <[EMAIL PROTECTED]> wrote a message of 45 lines which said: > Hi for all , plese a question ,this function can be write in pl/pgsql > ??? I do not understand, it IS pl/pgsql. > > CREATE OR REPLACE FUNCTION check_immutable()

Re: [GENERAL] Immutable attributes?

On Sun, Apr 24, 2005 at 10:05:53PM -0600, Michael Fuhr <[EMAIL PROTECTED]> wrote a message of 85 lines which said: > This wouldn't solve all your problems, but you could write a generic > trigger function in a language like PL/Tcl or PL/Python (or PL/Perl > in 8.0 and later) and pass the column

Re: [GENERAL] Immutable attributes?

On Sun, Apr 24, 2005 at 10:05:53PM -0600, Michael Fuhr <[EMAIL PROTECTED]> wrote a message of 85 lines which said: > CREATE FUNCTION check_immutable() RETURNS trigger AS ' > for col in TD["args"]: Ah, yes, much better than mine. Thanks. ---(end of broadcast)--

Re: [GENERAL] Immutable attributes?

On Sun, Apr 24, 2005 at 02:53:51PM -0700, David Fetter <[EMAIL PROTECTED]> wrote a message of 21 lines which said: > > PostgreSQL 7.4, switching to 8.0 would be difficult. > > Now is easier than later. Do you mean that PostgreSQL 8 has immutable attributes ? I do not find that.

[GENERAL] Immutable attributes?

To protect the database from programming errors (there is a team working on the project and some beginners may produce bugs), I would like to flag some attributes as immutable, meaning non modifiable in an UPDATE. (Typical examples are ID or creation time.) Currently, I use triggers: CREATE OR RE

Re: [GENERAL] Installing PostgreSQL in Debian

On Wed, Apr 13, 2005 at 03:48:59PM -0700, erico <[EMAIL PROTECTED]> wrote a message of 112 lines which said: > Lendo Lista de Pacotes... Pronto > Construindo Árvore de Dependências... Pronto Before posting on an english-speaking mailing list, I suggest to set your locale to C... ("export LC_ME

Re: [GENERAL] Encoding Issue with UNICODE

On Tue, Apr 12, 2005 at 03:39:45AM -0700, Fritz Bayer <[EMAIL PROTECTED]> wrote a message of 53 lines which said: > I mean unicode itself is 16 bit long. This is completely false. Unicode itself is just a table and, since it contains more than 100,000 characters, you cannot index them with 16

Re: [GENERAL] Inheritance and such

On Fri, Apr 01, 2005 at 09:51:25AM -0600, John Hughes <[EMAIL PROTECTED]> wrote a message of 49 lines which said: > I ran into a brick wall when I realized that inheritance in postgres > isnt really there... I have a problem which MAY be in the same category. CREATE TABLE base ( id serial n

Re: [GENERAL] [Auth] 'ident' method and LDAP user accounts

On Thu, Mar 03, 2005 at 01:20:35PM +0100, Florian Pflug <[EMAIL PROTECTED]> wrote a message of 47 lines which said: > Seems so.. you could try to start the postmaster via strace -f, and > capture the log ... > Then try to connect, and see what happens - you should see the > postmaster open your

Re: [GENERAL] [Auth] "ident" method and LDAP user accounts

On Thu, Mar 03, 2005 at 12:00:51PM +0100, Marco Colombo <[EMAIL PROTECTED]> wrote a message of 39 lines which said: > Does Debian include and activate SELinux? Not at all. ---(end of broadcast)--- TIP 2: you can get off all lists at once with th

Re: [GENERAL] [Auth] "ident" method and LDAP user accounts

On Thu, Mar 03, 2005 at 04:03:25AM -0500, Tom Lane <[EMAIL PROTECTED]> wrote a message of 21 lines which said: > pass = getpwuid(peercred.uid); > > so it sure looks like we *are* using getpwuid. You're right but I do not understand why it fails only with PostgreSQL. -

Re: [GENERAL] [Auth] "ident" method and LDAP user accounts

On Thu, Mar 03, 2005 at 10:04:32AM +0100, Florian G. Pflug <[EMAIL PROTECTED]> wrote a message of 114 lines which said: > Might it be that the postgres user is not allowed to read > /etc/ldap.conf - or however your nss_ldap config file is called? myriam:~ % ls -ld /etc/*ldap* drwxr-xr-x 2 ro

Re: [GENERAL] [Auth] "ident" method and LDAP user accounts

On Wed, Mar 02, 2005 at 02:16:29PM -0500, Tom Lane <[EMAIL PROTECTED]> wrote a message of 8 lines which said: > > It is of course very inconvenient to duplicate my LDAP database into > > pg_ident.conf. Is there a better way? > > Perhaps you can find a PAM plugin that talks to LDAP, and configu

[GENERAL] [Auth] "ident" method and LDAP user accounts

I manage a Debian/Linux machine which runs PostgreSQL 7.4.7. All the user accounts, including mine, are in a LDAP database. Thanks to NSS (Name Service Switch) all applications have access to the LDAP accounts (getpwuid(3) and getpwnam(3) use LDAP). But not PostgreSQL. When I connect locally (Lin

Re: [GENERAL] Postgres C functions documentation

On Fri, Jul 16, 2004 at 10:03:56AM +0200, Najib Abi Fadel <[EMAIL PROTECTED]> wrote a message of 37 lines which said: > Is there any documentation explaning the C functions (syntax) used > in postgres.h library ?? http://www.postgresql.org/docs/7.4/static/libpq.html --

[GENERAL] Re: 7.1beta4-2 Debian packages... help!

On Tuesday 6 February 2001, at 10 h 50, the keyboard of DaVinci <[EMAIL PROTECTED]> wrote: > I have tried to install experimental Debian packages of Postgresql > 7.1beta4, but get a dependency error with libssl09. > My system is Debian inestable. You mean 'unstable' :-) The PostgreSQL versi

Re: [GENERAL] Re: [HACKERS] 8Ko limitation

On Thursday 20 July 2000, at 10 h 0, the keyboard of Karel Zak <[EMAIL PROTECTED]> wrote: > And what is a "large database"? 1, 5 .. 10Gb? If yes, (IMHO) the PostgreSQL > is good choice. Even on Linux? I'm studying a database project where the raw data is 10 to 20 Gb (it will be in several t

Re: [GENERAL] proposed improvements to PostgreSQL license

One thing to keep in mind: for a very long time, PostgreSQL was the *only* free ("free as in free speech, not free as in free beer") DBMS. I told dozens of people to consider PostgreSQL instead of, say, MySQL, for that very reason. Whichever free software licence you preferred, there was no re

Re: [GENERAL] What distribution?

On Thursday 25 May 2000, at 18 h 56, the keyboard of "planx plnetx" <[EMAIL PROTECTED]> wrote: > Help me I don't wanna run the debian whith his diabolique > dselect & apt-get I run PostgreSQL on Debian without problems, it's much simpler than on Tru64, it works fine and I seize the opportu

Re: [GENERAL] Timezones on Tru64 (Digital Unix)

On Tuesday 23 May 2000, at 14 h 17, the keyboard of Stephane Bortzmeyer <[EMAIL PROTECTED]> wrote: > PostgreSQL 6.5. And for those who wonder why I don't use 6.5.3, it's because, unlike 6.5, it doesn't compile on Tru64: cc -I../../../include -I../../../backend -DN

[GENERAL] Timezones on Tru64 (Digital Unix)

'set time zone 'GMT';', or any other 'set time zone' (even with numeric time zones), is completely ignored on my Tru64 machine (I always get dates in local time, UT+2). On Debian, everything is fine. Did I forget something when compiling PostgreSQL? Is there som