Nolan,
And my pet peeve of the month is software source distributions that
include the documentation ONLY in HTML, which is OK IF you have Apache
running on the system you're building the sources on and are willing to
make the documentation directory available to Apache, but otherwise
Hello,
And, to avoid the connotation of bias, whomever writes such a
migration
tutorial might want to suggest using the PEAR:DB abstraction layer to
avoid migration hassles in the future. http://pear.php.net/
I don't like very much PEAR::DB since they have a HUGE lack in the
errors
On Monday 23 Jun 2003 10:06 pm, Jonathan Bartlett wrote:
Is there a link to some of these discussions?
Go to http://archives.postgresql.org/ and search for coercion or implicit
coercion or implicit cast or similar on the hackers list.
--
Richard Huxton
---(end of
On Mon, 23 Jun 2003 15:16:28 -0400
Carlos [EMAIL PROTECTED] wrote:
start:
Executing /etc/rc.d/init.d/postgresql start ..
Starting postgresql service: -sh: [: ==: unary operator expected
[ OK ]
do:
ls -l /bin/sh
it is supposed to be a symlink pointing fo /bin/bash
if it's not, check if
??? You can look at an HTML file directy with any browser. If you're SSH-ing
in to a remote system, use Lynx. Though I agree that providing both man and
html would be nicer.
Try accessing a HTML file on a Linux system from a PC-based browser.
Unless you have some kind of file sharing
Dennis Gearon wrote:
so,
if Postgres were to have a manual like PHP's OLD manual(more next),
that would be a worthwhile contribution?
the new manuals seems to be drifting to using only GOOGLE listings.
MUCH less information on one page, not nearly as good search results as
the old one. I
(cross-posting to HACKERS)
Reuven M. Lerner wrote:
I'm creating a new OpenACS package that uses PostgreSQL, and in doing
so have encountered what seems to be a problem in PostgreSQL.
[...snip...]
CREATE OR REPLACE FUNCTION add_news__test
(integer,varchar,timestamptz,varchar,varchar,varchar,
Excellent -- thanks so much for your help. I just tried the function
with the right arguments, and it worked just fine.
Yet more proof of named parameters being a good thing...
Reuven
---(end of broadcast)---
TIP 7: don't forget to increase your
Joe Conway wrote:
I get nanswers = 16777216, so right off the bat 67MB or so is allocated.
Then there's this:
snippet
/* compute the cross product from right to left */
for (;;)
{
oneres = (Oid *) palloc0(FUNC_MAX_ARGS * sizeof(Oid));
/snippet
I'm guessing this gets executed
Hello ,
I have table directory with 3 columns (id,url,title)
I want to list all entries with duplicate urls.
I tried this:
select id,url,title from directory where url IN
(select url from directory group by url having count(url) 1)
ORDER by url;
but this takes 30 seconds with 25.000
Uros wrote:
(B
(B I want to list all entries with duplicate urls.
(B
(B I tried this:
(B
(B select id,url,title from directory where url IN
(B (select url from directory group by url having count(url) 1)
(B ORDER by url;
(B
(BTry:
(B
(Bselect id,url,title from directory where
On Tue, Jun 24, 2003 at 12:16:43PM +0200, Uros wrote:
Hello ,
I have table directory with 3 columns (id,url,title)
I want to list all entries with duplicate urls.
I tried this:
select id,url,title from directory where url IN
(select url from directory group by url having count(url)
Josh Berkus wrote:
Matt,
The quality of the material is very good, so please don't get me wrong, I
just think it's hard to find stuff. Both PHP and MySQL have well laid out
docs, with PHP being the better of the two.
I certainly agree ... one of my goals (shared with some other people) is to
Hello Martijn,
Tuesday, June 24, 2003, 12:32:53 PM, you wrote:
MvO On Tue, Jun 24, 2003 at 12:16:43PM +0200, Uros wrote:
MvO How about:
MvO Duplicate urls would be given by:
MvO select url from directory group by url having count(*) 1;
MvO To get all the entries with those urls, something
On Tue, Jun 24, 2003 at 01:12:05PM +0200, Uros wrote:
Hello Martijn,
MvO select id,url,title from directory,
MvO (select url from directory group by url having count(*) 1) as list
MvO where list.url = directory.url;
MvO I hope I got the syntax right.
I tried that before but got
Hi,
I think this could be good :
select d1.id, d1.url, d1.tittle
from directory d1
where exists (select url from directory d2 where d1.url=d2.url and
d2.oidd1.oid)
order by d1.url;
Hope this will help,
Regards,
Le Mardi 24 Juin 2003 12:16, Uros a écrit :
Hello ,
I have table
Hello Hervé,
Thanks a lot for help. Both Martijn van Oosterhout and yours do job god.
Execution time is now about 1 to 2 seconds. I also figured myself what i
was doing wrong with join and error i got.
If enybody need this here is both three solutions.
select distinct d1.id,d1.url,d1.title
Read thread:
http://fts.postgresql.org/db/msg.html?mid=1359513
Jochem van Dieten wrote:
I was wondering if there is any reason not to define the functions from
tsearch as immutable. What I am trying to achieve is that I don't have
to create a separate field to index as is explained in the
Hi Tom,
This log has the error but I do not understand why it occurs. Attached
is the file also
+ PGVERSION=7.3
+ INITD=/etc/rc.d/init.d
+ . /etc/rc.d/init.d/functions
++ TEXTDOMAIN=initscripts
++ TEXTDOMAINDIR=/etc/locale
++ umask 022
++ export PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
Hi,
What chars must be escaped in string and how exactly?
LF - \\n
CR - \\r
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I'm a Postgres and PHP newbie. I'm having a great deal of success with
my latest development effort having moved most of the logic from a
perl/php logic 'core' to postgres using plpgsql functions. (Thanks for
all that help, Josh).
I have a few comments to make on the idea of introducing people,
[EMAIL PROTECTED] wrote:
??? You can look at an HTML file directy with any browser. If you're SSH-ing
in to a remote system, use Lynx. Though I agree that providing both man and
html would be nicer.
Try accessing a HTML file on a Linux system from a PC-based browser.
Unless you have some
Jan Wieck wrote:
If you work on Unix systems remotely on a regular base, you
should have
a Unix system as a workstation too. That way you can use ssh(1) to
forward your X11 connections through a secure channel.
A second PC can be implemented as a memory+disk upgrade
together with
a
[EMAIL PROTECTED] writes:
And while i'm on the subject, the only book (hard copy) I've got on
PostgreSQL is the O'Reilly 'Practical PostgreSQL' book, now a bit dated,
which has one of the worst indexes I've seen in a computer manual in years.
It may be the worst index I've ever experienced
I have created a
table using the following command
CREATE TABLE metricsreporttable(id
VARCHAR(150) NOT NULL,sitename VARCHAR(155),title VARCHAR(160),type
VARCHAR(165),count INTEGER,categoryid
VARCHAR(170));
When I start
inserting rows into this table I get the following error message in
Arjen van der Meijden wrote:
Jan Wieck wrote:
If you work on Unix systems remotely on a regular base, you
should have
a Unix system as a workstation too. That way you can use ssh(1) to
forward your X11 connections through a secure channel.
A second PC can be implemented as a memory+disk
Carlos Oliva [EMAIL PROTECTED] writes:
This log has the error but I do not understand why it occurs.
Starting postgresql service: + su -l postgres -s /bin/sh -c
'/usr/bin/pg_ctl -D /var/lib/pgsql/data -p /usr/bin/postmaster -o
'\''-p 5432'\'' start /dev/null 21'
-sh: [: ==: unary operator
I'm working on pgSQL integration with Domino6 (DECS, LCLSX) (there will be
documentation in the coming weeks).
I have a question a couple of questions for you:
1) Are you using Domino 6 or 5.x
2) In your DSN setup on (NT?) do you have the valid
account information to connect to Pg?
3) If you
Hi,
Seems that everytime I use the word 'desc' I got an error. For example, this
query:
SELECT code, desc FROM or_code_table WHERE tr = 'FORMAT'
gave me
ERROR: parser: parse error at or near desc
When I created the table I got the same error too. I got around that by
creating the table using
On Tue, 24 Jun 2003, Reuben D. Budiardja wrote:
Hi,
Seems that everytime I use the word 'desc' I got an error. For example, this
query:
SELECT code, desc FROM or_code_table WHERE tr = 'FORMAT'
gave me
ERROR: parser: parse error at or near desc
When I created the table I got the same
The xserver in cygwin works just fine on all the systems I have tested, I
have several linux boxen at home all headless, and I use Cygwin and XDMP to
select which box I what to connect to and manage, seems as fast as using a
local screen etc. Webmin is also a good tool, as it also has a POSTGRESQL
Hi Tom,
Thank you very much for your help. In order to get the pg_ctl trace at
start up, I would appreciate it if you could advise me on how to modify
the postscrpt script. The line in question in the script is:
su -l postgres -s /bin/sh -c /usr/bin/pg_ctl -D $PGDATA -p
/usr/bin/postmaster -o
Hi !
We had this problem in GnuMed (www.gnumed.org). Eventually, we
decided that it is only really solvable automatically for fixed
strings. That is, strings that are known at database creation.
User supplied strings need user supplied translations as well.
The translation mechanism works for
At 19:15 24.06.2003, Antonios Christofides said:
[snip]
'description' is no longer enough; it must be possible to add
translations to _any_ language and to any number of languages.
I've thought of a number of solutions, but none satisfies me to the
point
On Tue, 24 Jun 2003, Alan Williams wrote:
hs.exon.2= \d ga_psr_transcript_1
Table public.ga_psr_transcript_1
Column| Type | Modifiers
--++---
id | integer| not null
parent |
I get an error during config I have redhat 7.2. readline library and Zlib
library not found...they are installed with the latest version how do I fix
this?
-Dan
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister
In looking at your ideas, a thought came to mind.
This issue is something I've been looking at neediing to address, so any comments are
welcome.
Whatever the first entry of a string entered becomes the reference string. You could add a field for that.The design below needs a unique index on:
Red Hat (and most other RPM based distros) split libraries into
runtime and development halves. In order to actually compile
software against the libraries, you must install the development half.
So, to compile against readline, you must also install the
readline-devel RPM.
Daniel E. Fisher
I have a big ascii text file that I would only like to import columns 1, 3 and 7 from.
I know I can filter it through cut, but I wonder if there is an undocumented way to
do it with COPY. Sybase has a useless function called filler() that you use for
fields you want to ignore. For example
On Tue, 24 Jun 2003, Stephan Szabo wrote:
hs.exon.2= explain select * from ga_psr_transcript_1 t,
ga_psr_exon_1e where e.parent = t.id;
QUERY PLAN
On Tue, 24 Jun 2003, Daniel E. Fisher wrote:
I get an error during config I have redhat 7.2. readline library and Zlib
library not found...they are installed with the latest version how do I fix
this?
you need the -devel versions of those RPMs. i.e. readline-devel etc...
We are actually considering not honoring locale for initdb encodings, so
it might make no sense to do this --- that another reason for the
question mark, but until we decide, it is an open issue.
---
Lincoln Yeoh wrote:
At
I thought it was more correctly we were considering not using the the
system locale automatically, but that if someone wished to use
--locale=en_US we'd let that work, right?
I would assume that if someone actually went to the bother of setting a
locale, then it should be the deciding factor
On Tue, 24 Jun 2003, Alan Williams wrote:
On Tue, 24 Jun 2003, Stephan Szabo wrote:
hs.exon.2= explain select * from ga_psr_transcript_1 t,
ga_psr_exon_1e where e.parent = t.id;
QUERY PLAN
Paul Ramsey wrote:
Red Hat (and most other RPM based distros) split libraries into
runtime and development halves. In order to actually compile
software against the libraries, you must install the development half.
So, to compile against readline, you must also install the
readline-devel
I go 7.3.3 installed Paul thanks...here is what is left
I am trying a php bulletin board by phpbb. I don't think I have the server
configured all the way yet. Any help is appreciated on how to get this
straight
Warning: Unable to connect to PostgreSQL server: FATAL: No pg_hba.conf entry
for
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to capture the user,
current datetime and the query statement. My thought
was to accomplish this by creating
Although I group my data topically in databases, most
of the data is integrated on the client side
(MSAccess). That is, tables from different databases
are often joined together during analysis.
I'm thinking of simplifying analysis and
administration by consolidating the databases and
separating
Le Mardi 24 Juin 2003 20:17, Andrew Gould a écrit :
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to capture the user,
current datetime and the query
snip
This is in the pg_hba.conf file
www.websiteIamusing.com all themachine'sIP 255.255.255.255
trust
I am sure I need to edit something yet.
host is a keyword (for tcp/ip connections as opposed to keyword
local for local domain socket connections), it is not a hostname.
Try:
host
Guillaume LELARGE wrote:
Le Mardi 24 Juin 2003 20:17, Andrew Gould a écrit :
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to capture the user,
current
Good point.
---
scott.marlowe wrote:
I thought it was more correctly we were considering not using the the
system locale automatically, but that if someone wished to use
--locale=en_US we'd let that work, right?
I
Joe Conway wrote:
Guillaume LELARGE wrote:
Le Mardi 24 Juin 2003 20:17, Andrew Gould a écrit :
I would like to create a audit log of update and
delete queries against a table. I want the log on the
server side, since access will be done using various
clients via ODBC. I would like to
If that's true, then termcap-devel should probably be added to the SRPM
dependencies. Isn't the RPM maintainer on this list? (wink wink)
Wes
Mike Mascari [EMAIL PROTECTED]@postgresql.org on 06/24/2003 03:32:22 PM
Sent by:[EMAIL PROTECTED]
To:Paul Ramsey [EMAIL PROTECTED]
cc:
Hi out there,
I am wondering what is the right dimension for a server I have to layout
an mantain. So, here are the specifiactions I know as far as I can know
them already:
- approx. 15 Users - at end of month many of them at the same time
online
- ca 30-40 gb data overal (few but big tables)
-
Has anyone used PostgreSQL with Drbd
(http://www.complang.tuwien.ac.at/reisner/drbd/)?
They claim it works with PostgreSQL. Do the PostgreSQL hackers forsee
any issues with this type of replication method?
Do you think this method (combined with some other HA utilities) could
work well as a
I haven't used this. It would probably work, but there's also another
way just using plain SCSI. You can attach both your main machine and a
hot standby to an external RAID array. When the main machine goes down,
just mount the RAID array yourself. However, you should also install a
serial
http://gborg.postgresql.org/project/tablelog/download/download.php
or
http://gborg.postgresql.org/project/audittrail/download/download.php?branch=devel
I haven't used either, but table_log seems to be one that I may start
using in the near future.
On Tue, 2003-06-24 at 13:17, Andrew Gould
On 24 Jun 2003, Joern Muehlencord wrote:
Hi out there,
I am wondering what is the right dimension for a server I have to layout
an mantain. So, here are the specifiactions I know as far as I can know
them already:
- approx. 15 Users - at end of month many of them at the same time
online
Wasn't a 'set' command also discussed to override locale?
On Tue, 2003-06-24 at 16:02, Bruce Momjian wrote:
Good point.
---
scott.marlowe wrote:
I thought it was more correctly we were considering not using the the
I know the current method for specifying alternate drives for PG tables is
by using symlinks. I had some ideas for simple ways to do this in PG
code, but wanted to know if anyone was working on this right now. I'd
hate to take the time to start messing with this if others were already on
it.
There's already a DateStyle guc that can be set. Would that be the one,
or would we need something else?
On 24 Jun 2003, Ron Johnson wrote:
Wasn't a 'set' command also discussed to override locale?
On Tue, 2003-06-24 at 16:02, Bruce Momjian wrote:
Good point.
Patch applied. Thanks.
---
Jeffrey W. Baker wrote:
On Mon, 2003-06-09 at 23:08, Tom Lane wrote:
Jeffrey W. Baker [EMAIL PROTECTED] writes:
This is the strace of a process which is deleting rows from four tables,
They make 15k disks now.
Max memory and fastest disk seem to keep people happy :-)
Joern Muehlencord wrote:
Hi out there,
I am wondering what is the right dimension for a server I have to layout
an mantain. So, here are the specifiactions I know as far as I can know
them already:
- approx.
64 matches
Mail list logo