On Wed, Aug 13, 2003 at 14:14:20 -0700,
expect <[EMAIL PROTECTED]> wrote:
>
> What's the big deal with importing text files? I have a 70 MB file to import
> and it's been one problem after another. I used the copy command and it appears
> that it's just not possible. I finally massaged the fil
Hi Martijn:
Thanks for your answer, I really missed something ;-)
Kind regards, Ruben.
Martijn van Oosterhout wrote:
On Mon, Aug 11, 2003 at 01:48:21PM +0200, ruben wrote:
Hi:
I must have missed something, but how is it possible that a join on
tables A and B is faster (a lot faster) than a
My Postgres databases used to have default (SQL_ASCII) encoding. I could
store any 8-bit character in it regardless of actual charset, because
all clients also used default encoding and no charset conversion was
done.
Now we started a new project with Qt3 and it's Postgres driver defaults
to UNIC
Perhaps the only way to get around the cache problem is to use an ISO-8859-x 8bit character set, but to have per table, or per column encoding attributes. And of course, ways to access what those are, in the Postgres API. Good for speed, but not for easy storing of multiple language/encodings per c
On 6 Aug 2003, Robert Treat wrote:
> On Tue, 2003-08-05 at 20:18, Dann Corbit wrote:
> > For me, I can only find these directories:
> > ftp://ftp8.us.postgresql.org/pub/pgsql/source/v7.4/
> > ftp://ftp8.us.postgresql.org/pub/postgresql/source/v7.4/
> > And both of them are empty.
>
> Might be so
Why does everyone send to the list and the author? Can someone make this stop?
Or is this the preferred method of response on this list?
The pgsql-novice doesn't seem to suffer this annoyance.
---(end of broadcast)---
TIP 3: if posting/reading throu
Hello.
I have this problem: i'm running the
postgre 7.3 on a windows 2000 server with P3 1GHZ DUAL/1gb
ram with good performance. For best performance i have
change the server for a XEON 2.4/1gb ram and for my
suprise the performance decrease 80%. anybody have a similar
experience? does
It was RH8 where I saw the issues. It was so bad that I had one server
freeze 20 minutes after reboot. And it wasn't a hardware issue; that
server is now running with several months of uptime under heavy load.
Jonathan Bartlett wrote:
What distribution are you running? I and a lot of other pe
7.4 has a --enable-thread-safety which compiles libpq and ecpg for
threading, with that flag on operating systems that need it.
---
Amin Abdulghani wrote:
> Compiling postgres client with -D_REENTRANT seems to
> remove
> th
DeJuan Jackson wrote:
I have a suspicion that the version might be different. I have the same
symptom here on two different RH 7.3 boxes one running 7.3.2 and the
other running 7.3.3
It would appear 7.3.2 is more strict about the naming of the GROUP BY
fields.
They really are the same version
Oops! [EMAIL PROTECTED] (Chris Webster) was seen spray-painting on a wall:
> Martijn van Oosterhout wrote:
>
>>Have you run VACUUM and/or VACUUM FULL and/or ANALYZE recently?
>>
> a) yes. I have it run analyze every 30 minutes or 1600 record
> additions. Records are never updated or deleted so I
Hi all, apologies if this is a dumb question - not really sure where to look
for this kind of stuff...
I have a frequently called stored procedure that needs to access some
"configuration" information to determine how it should behave.
Currently I have the configuration information in its own
Hi list,
I have been using PostgreSQL for a GIS database on different Linux
(mostly SuSE 8.1) boxes, and so far everything fine.
Now I tried to set up a "bigger" database server
(HP ProLiant DL 380-G3, 2x Intel Pentium4-Xeon, 2.8 GHz
4 GB memory and a RAID 5 system with ca. 500 GB diskspace) und
I'm receiving the following error during startup:
Aug 10 14:11:27 thunder postgres[18613]: [1-1] LOG: failed to create
socket: Address family not supported by protocol
Aug 10 14:11:27 thunder postgres[18619]: [2-1] LOG: database system was
shut down at 2003-08-10 14:11:11 MDT
Aug 10 14:11:27
On 11 Aug 2003, Ron Johnson wrote:
> On Mon, 2003-08-11 at 18:40, Roderick A. Anderson wrote:
> > On 11 Aug 2003, Ron Johnson wrote:
> >
> > > Maybe this will do it:
> > > http://www.postgresql.org/docs/7.3/static/sql-set-constraints.html
> >
> > Saw this but my take was it required the original c
On Wed, Aug 06, 2003 at 13:40:29 -0300,
The Hermit Hacker <[EMAIL PROTECTED]> wrote:
>
> just looking at the rsyncd.conf file on svr1 itself, is the following a
> valid address:
>
> hosts allow = \
> 114.73.139.66.in-addr.arpa, \
You could have an A record with a domain
On Wed, 13 Aug 2003, Dennis Gearon wrote:
> Got a link to that section of the standard, or better yet, to a
> 'interpreted' version of the standard? :-)
The standard draft yes, an interpreted version, unfortunately not (unless
Date's book covers it and I can find where my copy is.
Here are some
On 5 Aug 2003, Ron Johnson wrote:
> On Tue, 2003-08-05 at 14:42, Stephan Szabo wrote:
> > On Tue, 5 Aug 2003, scott.marlowe wrote:
> >
> > > On Tue, 5 Aug 2003, Williams, Travis L, NPONS wrote:
> > >
> > > > I have a table (lets say a,text b,text) and I want to insert the data
> > > > jim,jimmy an
On Tue, 2003-08-05 at 20:18, Dann Corbit wrote:
> > -Original Message-
> > From: The Hermit Hacker [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 05, 2003 5:01 PM
> > To: [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: [GENERAL] v7.4 Beta 1 Bundle Available for Testing ...
>
Ok, thanks for all the discussion followed, vey educational :-))
But nobody really followed up my question :-(
For example, you have a table that is displayed in the browser. You want to let
the user do sorting on one or multible columns, including those which contain
localized strings.
If the d
On 09/08/2003 01:41 Simon Windsor wrote:
Hi
I am sorry for mailing this list directly, but I am planning to migrate a
web application from MySQL to Postgres. I am aware of a number of
applications to help in this process, ie my2pg, etc. The biggest
stumbling block I face is replication.
What facil
Pavel Stehule <[EMAIL PROTECTED]> writes:
>> You probably want now() instead of that function.
> I can't use now() or others because I need actual time in transaction.
Just cast the result of timeofday() to timestamp (with time zone, likely).
regards, tom lane
--
The doc "PostgreSQL Hardware Performance Tuning" by Bruce Momjian, 16th
January 2003 says: "As a start for tuning, use 25% of RAM for cache size,
and 2-4% for sort size.", and "The default POSTGRESQL conguration allocates
64 shared buffers. Each buffer is 8 kilobytes.".
Have I understood it corr
On Tue, 5 Aug 2003, Williams, Travis L, NPONS wrote:
> I have a table (lets say a,text b,text) and I want to insert the data
> jim,jimmy and trav,travis can I do this with 1 insert into statement
> instead of 2?
Not with the current implementation of insert. There's been some
discussion of ad
seems like that shouldn't happen.
Stephen Robert Norris wrote:
I've encountered this a few times with 7.2 and 7.3.
If I do pg_dump of some large (> 100Mb - the bigger the more likely)
database, and it gets interrupted for some reason (e.g. the target disk
fills up), the source database become co
Added to TODO, to match ALTER TABLE ... OWNER:
o Add ALTER DATABASE ... OWNER TO newowner
---
Sander Steffann wrote:
> Hi,
>
> > Why would you want to do that?
> >
> > Why not do it an easier way and dump the datab
On Tue, 05 Aug 2003 15:09:00 -0400 Tom Lane <[EMAIL PROTECTED]> wrote:
> Richard Welty <[EMAIL PROTECTED]> writes:
> > what type of index is recommended when the dominant lookup on a field
> is
> > '' << ipblock
>
> I don't think we have a suitable index type at the moment; or more
> accurately,
hi,
I want to connect to database repl_isar located in host isar from host
willy. So I wrote:
String url = "jdbc:postgresql://isar/repl_isar";
conn = DriverManager.getConnection(url,username,password);
But it fails by given error both in postmaster running repl_isar and local
site willy.
java
Should be a simple question.
When selecting a field that is of type money, how can I remove the $
when selected?
example: $10.00 would return as 10.00
-Robby
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Richard Welty <[EMAIL PROTECTED]> writes:
> what type of index is recommended when the dominant lookup on a field is
> '' << ipblock
I don't think we have a suitable index type at the moment; or more
accurately, we don't have a suitable operator class. It would be an
interesting exercise to write
On Sun, 2003-08-10 at 19:43, Raymond wrote:
> Utilizing Postgres 7.3.3 and RH80.
>
> Any way to email DML errors and constraint violations from Postgres?
>
> Need something event driven; polling logs is not a good solution.
>
> Would be very effective to monitor 3rd party client incremental deve
Hey all! I had an idea to implement a very simple (IMHO) auditing mechanism for an
application I'm developing, and thought some people here could give some hints,
opinions, etc about it.
I was thinking about implementing update and delete triggers for all my tables that
I want to be audited,
On Tue, 2003-08-05 at 11:11, Jimmie H. Apsey wrote:
> Why would you want to do that?
Why would I want to change ownership of a database? I could think of
numerous reasons.
> Why not do it an easier way and dump the database and restore it into
> your new database?
Because that would mean that
[EMAIL PROTECTED] (Jason Priebe) writes:
> Note that it uses timeofday() for the default for one timestamp and
> "now" for the default for the other (we've been experimenting with the
> differences between the two, as we've seen some serious drift in the
> values returned by "now" -- but that's ano
You might want to take a look at this project:
http://gborg.postgresql.org/project/tablelog/download/download.php
There is another project similar to that one on gborg as well, but I
don't recall the name at this time.
On Thu, 2003-08-07 at 15:30, Felipe Schnack wrote:
> Hey all! I had an idea
I've been charged with investigating postGIS as a replacement for our current Informix
runtime (9.3), which uses the Spatial blade. Currently we use two Sun Sparc/Ultra 80
boxes with 3 CPUS dedicated to Informix.
We use our database to calculate the image files we have within a given area
(ST
On Sun, 10 Aug 2003 14:50:10 -0600
Robert Creager <[EMAIL PROTECTED]> said something like:
>
> I'm running 7.4Beta1 with pg_autovacuum. In one of my operations
> which is executed frequently, a REINDEX is done after a COPY. Well,
> VACUUM's are being executed by pg_autovacuum, and my app is loo
On Fri, 1 Aug 2003, Joshua D. Drake wrote:
> Hello,
>
> As a recent flurry of activity has commenced within Command Prompt we
> have released
> upon this rather unround earth, plPHP. Yes it is trigger safe, yes you
> can write UDF's in
> PostgreSQL with PHP now.
>
> Find it here:
>
> h
> How can I get that back out to bash, if I'm doing psql scripting?
> An env. variable wouldn't work, since it would go away when psql
> terminates.
Capture the stdout of the psql command and pipe it through cut in order to
get only the third word of output.
your_shell_variable=`psql -c 'insert
Did you make install?
[EMAIL PROTECTED] wrote:
I am trying to setup tsearch2 on postgresql 7.3.4 on a Redhat9 system,
installed from rpms.
There seemed to be some files required for installation of tsearch
missing so I downloaded the src bundle too.
Tsearch2 then compiled ok but now the comman
On Sat, 9 Aug 2003, Phil Howard wrote:
> | %nslookup 207.173.200.143
> | Server: neptune.hub.org
> | Address: 64.117.224.130
> |
> | Name:hosting.commandprompt.com
> | Address: 207.173.200.143
> |
> | Joshua, are there multiple IPs on that box that he might be seeing?
>
> Then is 207.173.20
"Eric Anderson Vianet SAO" <[EMAIL PROTECTED]> writes:
> pg_dump: dumping out the contents of table tbdmovimento
> pg_dump: ERROR: unexpected chunk number 8 (expected 0) for toast value 6935=
> 693
Hm. Could we see the results of
select chunk_seq,length(chunk_data) from
where chunk_id = 6935693
Dmitry Tkach <[EMAIL PROTECTED]> writes:
> I am trying to create a custom GiST index in 7.3, but getting an error,
> ...
> I have done all the setup that was required in 7.2.4:
You should not be using the 7.2 methods anymore --- there is a CREATE
OPERATOR CLASS, use that instead. (See the contri
On Tue, 12 Aug 2003, Roderick A. Anderson wrote:
> On Mon, 11 Aug 2003, Stephan Szabo wrote:
>
> > Yes. Either DEFERRABLE or INITIALLY DEFERRED must be given in order for
> > set constraints to be meaningful. This might be another good place to
> > consider a little clarification (or maybe a doc n
It does if you look at the original email. Maksim must've just
transposed a couple letters when he was writing his demo.
Jeff
Kathy zhu wrote:
If it skips "-", then RMT-* should come before RM-V*, but they don't,
why ??
Maksim Likharev wrote:
en_US locale skips? punctuation from sorting in
On Wed, Aug 13, 2003 at 01:34:00AM +, Mel Roman wrote:
> I have the same problem as Michael. I've installed postgresql and am
> running the service, but I can't log in as postgres. I just tried the
> command line "psql -U postgres template1", but I get the message
> "authentication failed for
I need to store some sensitive data and I want to use public keys so
anyone can encrypt the data but can only be decrupted by certain users.
Anyhow, are there any loadable modules that do public key encryption for
Postgresql ? I'd like to access these functions in plpgsql.
It's probably not th
On Thu, 31 Jul 2003 11:19:25 +0100, David W Noon wrote:
> On Thursday 31 Jul 2003 10:39 in
> <[EMAIL PROTECTED]>, 2trax
> ([EMAIL PROTECTED]) wrote:
>
>> It seems to me that the most flexible way is to use a text field to hold
>> everything, apart from the country which suits a varchar? and perha
Didn't know if it would be any faster..
Travis
-Original Message-
From: Ron Johnson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2003 3:00 PM
To: PgSQL General ML
Subject: Re: [GENERAL] multiple insert into's (may be NEWBIE question)
On Tue, 2003-08-05 at 14:42, Stephan Szabo wro
Danke, Spacibo, gracias, thanks.
Tom Lane wrote:
Dennis Gearon <[EMAIL PROTECTED]> writes:
You mean in his own local environment? So all his programs, console operations, etc, will have the new encoding? Or 'LANG/LC_ALL' for Posgres specifically?
I mean he needs to run initdb with C as the sel
I just got this message for all the records returned by "select * from
table", what does this mean?
(I don't have any restriction on the values in column 4...)
Regards,
BTJ
---
Bjørn T Johansen (BSc,MNIF
Postgres itself doesn't support nested transactions.
Robert Creager wrote:
On Mon, 11 Aug 2003 11:05:57 -0400
Tom Lane <[EMAIL PROTECTED]> said something like:
If you really want to rebuild only the one index, I think this will work:
begin;
lock table tab;
reindex index ndx;
commit;
Figures.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 11 August 2003 09:32, Marcelo Soares wrote:
> Hi all,
>
> I would like to know if its possible to have the SAME TABLE into two
> different databases (but in the same server). Or to create a view of a
> table of database X at the database Y.
>
Hi,
Running Postgres 7.2.1 with python/psycopg (python
interface for postgres using libpq)/webware application
server on Solaris, I get a postgres error "could not
receive data from server Error 0 " when I try to retrieve
a large text column (16 K) from a table. The query I use
is "select col
On Mon, 4 Aug 2003, Joseph Shraibman wrote:
> Tom Lane wrote:
> > Joseph Shraibman <[EMAIL PROTECTED]> writes:
> >
> >>What percentage of locales have this problem? Does latin1 have this problem?
> >
> >
> > Latin1 is an encoding, not a locale. To a first approximation, I'd say
> > *all* non-
On 11 Aug 2003, Ron Johnson wrote:
> v7.3.3
> http://www.postgresql.org/docs/7.3/static/sql-createtable.html
>
> Is "INITIALLY DEFERRED" a modifier of "NOT DEFERRABLE"? If so,
> what does it do, since they seem contradictory.
It's not allowed. An INITIALLY DEFERRED constraint must not
be defin
Dennis Gearon <[EMAIL PROTECTED]> writes:
> Uuuh, C++ can do it, PHP can do it, JAVA can do it, I just
> want to know if PL/C can do it for UDF's.
We have no animal called "PL/C". Kindly be more clear about what your
question is.
regards, tom lane
---
If you are talking about everything that lies under so called LATIN-1 (
ISO-8859-1 )
en_US encapsulates ( at least suppose to ) all those sorting rules,
do not remember about accents tho.
-Original Message-
From: Kathy zhu [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2003 4:43 PM
Yuup, always name constraints so it's easier to remove them. And if you name them meaningfully, then others might understand why they exist! (or later after a coffeeless morning)
Roderick A. Anderson wrote:
On Mon, 11 Aug 2003, Stephan Szabo wrote:
Yes. Either DEFERRABLE or INITIALLY DEFERRED m
At 01:40 PM 8/6/2003, Peter Eisentraut wrote:
You need to double-quote the names or they will be converted to lower
case.
Thank you both. The reason why the initial table creation have quoted
columns names is that it's generated by a program we use for schema
creation. I'm currently adding to it
I didn't see daemon tools mentioned anywhere in these.
Murthy Kambhampaty wrote:
It's multiple postmaster's, each with its own $PGDATA folder and TCP port.
See:
http://marc.theaimsgroup.com/?l=postgresql-admin&w=2&r=1&s=Run+4+postgresql+
session+on+ONE+server%3F&q=b
-Original Message-
F
On Tue, 12 Aug 2003, Maksim Likharev wrote:
> If you are talking about everything that lies under so called LATIN-1 (
> ISO-8859-1 ) en_US encapsulates ( at least suppose to ) all those
> sorting rules, do not remember about accents tho.
It does not work like that. Different countries in europe t
My original commit had a message stating it was an IPv6 and the kernel
didn't support it. I don't see that message in CVS anymore, but I think
we need something similar.
There was a big discussion over whether we should require IPv6 to be
enabled individually, and then throw a hard error if IPv6
Hi Guys,
I'm currenlty involved in a port of our gateway code from a Solaris 8
environment to a HP-UX11.11 incorporating postgresql-7.3.3. We're having
some problems with creation and opening of large objects and was hoping
that you may be able to shed some light on them.
I extracted the LO co
On Sat, Aug 09, 2003 at 05:45:59PM -0300, Claudio Lapidus wrote:
> > Run VACUUM VERBOSE on it; you'll no doubt see that some internal
> > tables such as pg_activity, pg_statistic, and such have a lot of dead
> > tuples. Establishing a connection leads to _some_ DB activity, and
> > probably a dead
I cannot determine what character is stored in a varchar...
For instance:
thedonnaholics=# select state from mailing_list where rec_num = 7;
state
---
(1 row)
If I then execute:
thedonnaholics=# select count(*) from mailing_list where state = '';
count
---
0
(1 row)
So, what i
> On Thu, 7 Aug 2003 [EMAIL PROTECTED] wrote:
>
> > Part1.
> >
> > I have created a dictionary called 'webwords' which checks all
words
> > and curtails them to 300 chars (for now)
> >
> > after running
> > make
> > make install
> >
> > I then copied the lib_webwords.so into my $libdir
> >
> > I
en_US locale skips? punctuation from sorting index,
so in your case
RM-791
RM-AV2100
RM-PP401
RM-PP402
RM-PP404
RM-V10
RM-V11
RM-V12
RMT-D10
RMT-D108A
RMT-D109A
RMT-D116A
RMT-V402
==>
RM791
RMAV2100
RMPP401
RMPP402
RMPP404
RMV10
RMV11
RMV12
RMTD10
RMTD108A
RMTD109A
RMTD116A
RMTV402
-Origina
Dennis Gearon wrote:
How did you solve the problem .. :-)
inlining - most chars are just ascii and there are trivial optimizations
that can lead to just as fast as moving 4x the data around.
---(end of broadcast)---
TIP 6: Have you sear
As others have said, money is deprecated. I used this function to
migrate some money data once; you could use it to reformat data if you
wanted.
CREATE OR REPLACE FUNCTION x_money(money) RETURNS decimal AS '
set moneydata $1
regsub -all {[,$]} $moneydata {} workable
return $workabl
On Fri, 8 Aug 2003, Pavel Stehule wrote:
> In this version I can't convert returned value to time. timeofday() return
> text. I need convert to timestamp before. It is normal behavior? I
> expected timestamp as returned type.
It is documented to return a string for historical reasons:
http://w
Martijn van Oosterhout wrote:
Have you run VACUUM and/or VACUUM FULL and/or ANALYZE recently?
a) yes. I have it run analyze every 30 minutes or 1600 record
additions. Records are never updated or deleted so I assume I don't
need vacuum.
b) It does it even at start up when there are fewer t
On Tue, 05 Aug 2003 18:46:47 -0400 Tom Lane <[EMAIL PROTECTED]> wrote:
> Richard Welty <[EMAIL PROTECTED]> writes:
> > hmmm. where should i go looking for sample code implementing operator
> > classes as an example?
>
> contrib. Specifically, I'd suggest looking at contrib/seg, which
> defines a
We're running on ext2 on our box, with nightly backups. There's not much
in the database we can't recreate from feeds, and we aren't doing
financials on it. I've also heard of Reiser having had some problems on
SMP systems.
Of course, our box hasn't gone down unexpectedly ever, either due to O
Bruce Momjian <[EMAIL PROTECTED]> writes:
> There was a big discussion over whether we should require IPv6 to be
> enabled individually, and then throw a hard error if IPv6 fails, but at
> this stage, it seemed best to most to just try IPv6 and soft-fail, while
> throwing a message in the server lo
Tom Lane wrote:
1. There is no provision for a single pg_proc entry to have a variable
number of arguments.
2. You can make multiple pg_proc entries referencing the same C
function. The C function can find out how many arguments it was
actually passed (use PG_NARGS()).
So you could make several di
[EMAIL PROTECTED] writes:
> tsearch2.so is located at
> /usr/local/pgsql/lib/tsearch2.so
> which is the same directory as fti.so which works.
There may be *an* fti.so there, but it's not necessarily the same one
Postgres is using.
Try "pg_config --pkglibdir" to find out where $libdir really point
I have one process which writes a single float into 300 columns once per
second. I then run 4 process, from remote computers, to query a small
subset of the latest row.
I have even commented out everything in the query programs, all they do
is sleep, and the associated postmaster still sucks u
It compiles, but does not link because of the missing fork/exec and
signals.
---
The Hermit Hacker wrote:
> On Wed, 6 Aug 2003, Robert Treat wrote:
>
> > depends on what you mean by any. I believe that the standard tarball
Is it necessary to uninstall previous version of PHP in my system. Which is
the better compatible version for Postgre 7.3.2.
Can you give any link/info for recompiling PHP
Sreedhar
- Original Message -
From: "Jean-Christian Imbeault" <[EMAIL PROTECTED]>
To: "shreedhar" <[EMAIL PROTECTED]>
Dennis Gearon wrote:
I agree with all of that except for one caveat:
all my reading, and just general off the cuff thinking, says that
processing variable width characters SIGNIFICANTLY slows an
application. It seems better to PROCESS fixed width characters (1,2,4
byte), and TRANSMIT varia
I think the question is how often are you passing data around/storing it
_in_ your application and how often are you processing it.
---
Dennis Gearon wrote:
> I agree with all of that except for one caveat:
>
> all my
What would be really cool (although a lot harder to implement) would be
the ability to generate a hierarchical XML document when using foreign key
relationships. Trying to tell PG how to format that might be a bit of an
issue, though.
Jon
On Thu, 7 Aug 2003, Gavin M. Roy wrote:
> Add an
> ech
Hi:
I must have missed something, but how is it possible that a join on
tables A and B is faster (a lot faster) than a query to one of the
tables with the same conditions?
The problem seems to be with the query plan, in the case os a query to
table_a only, the planner executes a "Seq Scan", in
On 7 Aug 2003, Neil Zanella wrote:
> of transactions as opposed to the operations taking place serially? Also, does
> PostgreSQL fully support SQL99 CHECK constraints? And if the system crashes...
Technically no. Check constraints with subselects are not supported.
Using a function gets you half
I currently have PostgreSQL 7.1 installed on a server with about 700
Mb of RAM.
I have many problems of speed with a database I created. For example,
it took almost 12 sec to run the query "select * from table" directly
from PostgreSQL, on a table with 4000 records and 60 fields ...
And the whole
In response to "Phil Howard":
>> 207.173.200.206? We aren't using that server for relaying ... we
>> *are* using: 207.173.200.143, which does reverse:
>> %nslookup 207.173.200.143
>> Server: neptune.hub.org
>> Address: 64.117.224.130
>> Name:hosting.commandprompt.com
>> Address: 207.173.200
Hello, all!
I have a good question for PostgreSQL
FAQ.
How to use string functions (like UPPER()/LOWER())
for non-latin strings?
Why UPPER() function doesn't work with my UNICODE
PostgreSQL database which contains non-latin characters (like
cyrillic)?
How to make case insensetive search
sorry about dumb ´lenght´ instead ´length´.
the length of chunk_data is 255.
tnx.
Eric
- Original Message -
From: "Eric Anderson Vianet SAO" <[EMAIL PROTECTED]>
To: "PostgreSQL general" <[EMAIL PROTECTED]>
Sent: Friday, August 08, 2003 1:14 PM
Subject: Re: [GENERAL] unexpected chunk num
Folks,
> Josh Berkus <[EMAIL PROTECTED]> does PostgreSQL support, and he is in
> SF. I am CC'ing him.
What kind of support is requested?
--
Josh Berkus
Aglio Database Solutions
San Francisco
---(end of broadcast)---
TIP 7: don't forget to inc
In article <[EMAIL PROTECTED]>, "Joshua D. Drake" wrote:
> Michael wrote:
>
>> I cannot access/create a database from root or any of the other
>> accounts I have setup for RH9. I noticed that there is a user setup
>> for postgres (I guess this part of the postgres install) but cant
>> login as
On Wed, 2003-08-13 at 11:59, Dustin Sallings wrote:
> On Tuesday, Aug 12, 2003, at 09:55 US/Pacific, Al Hulaton wrote:
[snip]
> We're looking at various databases for production use in our product
> and pricing the various solutions. My personal preference is postgres,
> but we're also loo
Dennis Gearon <[EMAIL PROTECTED]> writes:
> You mean in his own local environment? So all his programs, console operations, etc,
> will have the new encoding? Or 'LANG/LC_ALL' for Posgres specifically?
I mean he needs to run initdb with C as the selected locale. It has
nothing to do with what en
On Thu, 14 Aug 2003 07:34:55 +1000
Jason Godden <[EMAIL PROTECTED]> wrote:
> Hi expect,
>
> Best way in my opinion is to use the copy table command. This way Pg will
> actually 'massage' the data (string escapes and all) for you.
I guess we're of the same opinion. I did use the copy table com
On Wed, 13 Aug 2003, Dustin Sallings wrote:
>
> On Tuesday, Aug 12, 2003, at 09:55 US/Pacific, Al Hulaton wrote:
>
> > That's something we do here at Command Prompt. Phone number's below or
> > there's the guaranteed 4 hour response time form we have on our
> > website.
>
> We're lookin
Hello
In this version I can't convert returned value to time. timeofday() return
text. I need convert to timestamp before. It is normal behavior? I
expected timestamp as returned type.
regards
Pavel Stehule
---(end of broadcast)---
TIP 8: expla
Justin Tocci <[EMAIL PROTECTED]> writes:
> Thanks for the reply Tom, here's the rule that works:
> CREATE RULE tquotehistory_update AS ON UPDATE TO vtquotehistory DO INSTEAD
> (
> INSERT INTO tquotehistory_log ("ID", "Item", "Quote1", "DemandCost1",
> "Quote2", "DemandCost2", "DueDate", "POIntoI
On Sat, Aug 09, 2003 at 08:05:58PM -0300, The Hermit Hacker wrote:
> On Sat, 9 Aug 2003, Phil Howard wrote:
> > Then is 207.173.200.206 a spammer running Sendmail and faking these mailing
> > lists?
>
> My first guess is that the machine we are using @ CommandPrompt as a relay
> point has multiple
I have two tables in two databases (Pg 7.2.1 - yes I need to upgrade but
there are several other dependencies I have to resolve first) and I need
to update one database's tables so they can be merged into the other
database's table. I know I can drop the constraints and update the tables
(primary
Hi all,
What are the relationship/dependencies between encoding and locale settings ??
thanks,
kathy
---(end of broadcast)---
TIP 8: explain analyze is your friend
1 - 100 of 154 matches
Mail list logo
