On Wed, Feb 23, 2011 at 02:30:18PM +0200,
Sim Zacks s...@compulab.co.il 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
On Wed, Feb 23, 2011 at 05:39:26PM +0530,
Gaini Rajeshwar raja.rajeshwar2...@gmail.com 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
On Tue, Jun 22, 2010 at 04:18:48PM +0530,
venkat ven.tammin...@gmail.com 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.
On Wed, Oct 28, 2009 at 05:45:14AM -0700,
Xai rellonlawre...@gmail.com 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
On Mon, May 18, 2009 at 11:33:03PM +0430,
Zico mailz...@gmail.com 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
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,
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 think that
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 you
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
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
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 information
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? I scanned the documentation
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, the
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 heavy
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 Oracle
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
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 there is
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 explicitly,
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
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
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,
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 PostgreSQL
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
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.uk'
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 XML
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 in
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
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
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
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,
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:
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
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
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
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?
That's
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 maximum
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);
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
REFERENCES Countries (id) should have
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
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 strange
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
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 it,
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(
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
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 the
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 (exceptions,
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);
CREATE
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
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()
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 do
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
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.
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
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
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
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
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 not
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
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 configure
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 root
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.
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 the
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
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
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 version
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
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
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 opportunity
'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
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 -DNOFIXADE -std -O4 -Olimit
70 matches
Mail list logo