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 file
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
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
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
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 some lag in
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
Hello.
I have this problem:i'm runningthe
postgre 7.3on awindows 2000 serverwith P3 1GHZ DUAL/1gb
ramwithgood performance.For bestperformancei have
change the server for a XEON 2.4/1gb ram andformy
suprisethe performance decrease 80%.anybody have a similar
experience?does exist anyspecial
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
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
this
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
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 assume
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)
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 constraint to
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 name
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 and trav,travis can
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 ...
Just a
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
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
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 correctly
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
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
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 database and
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
'networkaddress' 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.
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
'networkaddress' 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
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
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
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
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
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 loosing
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:
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
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 tbdmovimento's toast table
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 contrib
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 note in
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
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 user
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
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 perhaps have
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
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
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.
I
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-C locales have
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 defined as
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
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-adminw=2r=1s=Run+4+postgresql+
session+on+ONE+server%3Fq=b
-Original Message-
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
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
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
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 tuple
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
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 have run
psql mybd
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
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
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
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:
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
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 datatype
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
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 logs.
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
[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 points.
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
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]
Sent:
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
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
echo
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.143
Joshua,
Hello, all!
I have agood 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 by
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 number
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
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 that user. I
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
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
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 command.
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 looking at
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:
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, POIntoInmass, Weeks,
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 IPs on
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
I have 4 tables for example
firstname | middlename | lastname | phonenumber
Now I am trying to search for multiple entries for example
SELECT * FROM phonenumbers;
I am trying to use SELECT 'not sure what here' FROM phonenumbers;
so that I can find any fields that have multiple information
On Wed, Aug 06, 2003 at 12:55:52PM -0400, Joel Burton wrote:
Reposting, with some clarification to my request. Thanks to the several
responses I received originally.
Yes, I know that a perfectly vaild PGSQL SQL file could contain only
ANSI SQL and therefore not be recognized as PG-related. In
1 - 100 of 147 matches
Mail list logo
