On 6/18/07, John K Masters [EMAIL PROTECTED] wrote:
I feel somewhat embarrassed to post this but I can't get past the first
post with Postgresql. I have installed onto a Debian testing system,
created a space for the database cluster on /usr/local/pgsql/data,
changed owner to postgres and
On 6/18/07, Jan Danielsson [EMAIL PROTECTED] wrote:
UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
Something like this?
http://www.joeconway.com/plr/
-- Cheers,
Andrej
---(end of broadcast)---
TIP 9: In versions below 8.0,
On 6/17/07, John Smith [EMAIL PROTECTED] wrote:
guys,
love both tools but php @ 2.5 *billion* google results is far more
popular than postgresql @ 25 million google results. *if* somebody's
gotto adapt it's not php. php does what it does best in a way that
stuffy academics don't get.
That's
On 6/17/07, Ron Johnson [EMAIL PROTECTED] wrote:
That's like saying that BSD or Linux should be more like
Windows because there's more Windows than Linux stuff
to be found on the web
You've not used KDE lately, have you? :)
That'll be right. I use fluxbox. :}
And while *ix might
On 6/13/07, Jasbinder Singh Bali [EMAIL PROTECTED] wrote:
Hi,
I have a Pl/Perlu function in which I have written an insert statement in
tbl_xyz.
If there's not foreign key in this table, insert works fine.
As soon as i make one of its fields refer to tbl_abc i.e field a in tbl_xyz
refering to
On 6/13/07, Porell, Chris [EMAIL PROTECTED] wrote:
Hi All,
[...]
the SQL in psql. The old server was a dual AMD opteron 2.6 GHz machine with
a RAID 5 array and 4GB memory. The new machine is a dual dual-core AMD
Opteron 2.6GHz with RAID 1 and 16GB memory.
[...]
On my new DB server, it
On 6/3/07, Andrej Kastrin [EMAIL PROTECTED] wrote:
I am experiencing difficulty in trying to copy the file structure below
into PostgreSQL table:
||001||,||Classification||,||Economics||,||N||
||001||,||Classification||,||Trends||,||Y||
etc...
Although I can preprocess the input file with e.g
On 5/25/07, Marek Lewczuk [EMAIL PROTECTED] wrote:
Good point, but from the other hand there are plenty of programing
languages but Java is the most popular :-) (source:
http://www.tiobe.com/tpci.htm).
Guess it depends on what survey you read ... there java is also ran ...
On 5/9/07, Ashish Karalkar [EMAIL PROTECTED] wrote:
Hello All,
Hi,
Can anybody please point me to Advantages and Disadvantages
of using view
The most obvious advantage (for me, anyway) is to restrict which
columns a user can see in a table.
I'm sure there are others.
With Regards
On 5/9/07, Ron Johnson [EMAIL PROTECTED] wrote:
1) Performance : If a view is defined by complex multitable
query,then simple query against that view becomes a coplecated
join, and it may take a long time to complete
I don't see that as relevant, since we know which objects are tables
On 5/2/07, David Fetter [EMAIL PROTECTED] wrote:
I prefer syslog because those logs are better suited for processing by
pgfouine and tools like it :)
I prefer syslog-ng because I can send the logs of to a
central log-host using tcp ... :)
Cheers,
Andrej
---(end of
On 5/2/07, Brad Nicholson [EMAIL PROTECTED] wrote:
Running PG8.1 - will it recognize CPU and memory that are added
dynamically to the server when the postmaster is running?
I thought that was a job for the underlying OS?
Cheers,
Andrej
---(end of
On 4/24/07, Felix Kater [EMAIL PROTECTED] wrote:
Hi,
the messages returned by PQerrorMessage() contain a trailing new line.
So, they doesn't nicely integrate into strings formatted by printf.
Is there a way to suppress the trailing new line (except for
alloc/copy to a new string)?
The alloc
On 4/24/07, Tom Lane [EMAIL PROTECTED] wrote:
Why in the world are you considering an upgrade from a six-year-old
release to a three-year-old release? Do yourself a favor and move
onto something more or less modern. If 8.2.4 is too bleeding-edge
for you, then 8.1.9.
He thought about it ...
On 4/17/07, Terry Martin [EMAIL PROTECTED] wrote:
I am using redhat and RTOS.
The packets with be coming in on a 1 GBPS port and the information is
streaming UDP packets coming in.
I need it real time.
With RH ulogd should be possible; RTOS I don't know at all.
And it will need a grunty
On 4/15/07, Anton Melser [EMAIL PROTECTED] wrote:
it might even make more sense), and with KDE/Gnome these days, I don't
think there is much difference with XP...
Of course you could use fluxbox, twm or something else less
bloated ... my window-manager has a 2MB foot-print.
Or use vim instead
On 4/13/07, Terry Martin [EMAIL PROTECTED] wrote:
I would like to know if I there is a utility to take a UDP packet which
has specific information in the payload and extract the information
from the packet and place it in the Postgres data base?
Which OS (in Linux ulogd and/or tcpdump spring to
On 4/12/07, Jonathan Vanasco [EMAIL PROTECTED] wrote:
can anyone suggest a good way to reorder the table ? everything that
i can think of involves creating a new table which means I'd have to
redo all the constraints .
The common thing to do is to write your query in such
a way that what
On 3/21/07, Bob Pawley [EMAIL PROTECTED] wrote:
Hi
I have posed this question to the Delphi list but they don't appear to be
able to help.
I am attempting to have the information in a PostgreSQL database table
trigger a function in Delphi.
I believe that you'd need to have an untrusted
On 3/21/07, Bob Pawley [EMAIL PROTECTED] wrote:
Each time the user wants a new device displayed he needs to click on the
TImage. This is time consuming and prone to error.
I guess I must be too obtuse to follow; how will the database
know when the user wants to see a new device if not by
way
On 3/20/07, Ben Trewern [EMAIL PROTECTED] wrote:
So what's he meant to do? Write a longer question just so the mandatory
disclamer that his company attaches to his e-mail takes up a lower
percentage of his e-mail? (or should he not ask the question at all?)
Maybe use a gmail account for
Sorry, but I can't seen anything postgres related in
those errors messages, all seems to point at e-Mail
issues, not database connectivity.
Cheers,
Andrej
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
On 3/18/07, Mageshwaran [EMAIL PROTECTED] wrote:
Hi,
In our company there are many postgres servers in 7.X version,we are in
the process of upgrading to 8.1 version, can anyone tell me the
method to do this upgradation.
http://www.postgresql.org/docs/faqs.FAQ.html#item3.6
Btw, I personally
On 3/7/07, andyk [EMAIL PROTECTED] wrote:
1) try to use client software, which is not depends on libpq,
or
2) divide your query into smaller parts,
or
3) use software which parses long queries, separates them into single
SQL commands and then executes this commands one by one.
4) use Postgres
On 3/6/07, Yumiko Izumi [EMAIL PROTECTED] wrote:
Hello.
Hi,
When I carried out SQL sentence in PostgreSQL7.3.8 environment,
PostgreSQL outputs the following error messages.
Can't say anything sensible regarding the error message,
but if you have to carry on using 7.x you should upgrade
to at
Please say that again in English?
On 3/5/07, Jamie Deppeler [EMAIL PROTECTED] wrote:
Hi,
Have a quick question is possible to record a primary from a insert stament
eg
xprimary := insert into schema.table(.,.,.,.) VALUES ();
---(end of
Hi Guys,
I'm currently mucking around w/ importing TAB-delimited files;
how can I import empty values into a double precision field?
COPY complains about nothing between the TABS, about \N
and other variations, as being
invalid input syntax for type double precision:
What *is* valid syntax for
On 3/5/07, Walter Vaughan [EMAIL PROTECTED] wrote:
For best help it would be good to include your copy statement. As a guess, I'd
say you need to include the following in the statement...
NULL ''
Thanks Walter, I found the cause of my troubles; it wasn't copy,
it was the data. I didn't
On 3/3/07, Laurent ROCHE [EMAIL PROTECTED] wrote:
Hi,
Does anyone know if Ubuntu 6.10 (LTS) has packages for
PostgreSQL 8.2, from a recommandable place ?
http://www.google.com/linux?hl=enq=ubuntu+postgres+8.2btnG=Searchmeta=
Cheers,
Andrej
---(end of
On 2 Mar 2007 11:20:28 -0800, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi All Esteemed Developers,
I have a requirement to have dates like ddmmmyyy. ie: 03MAR07
I want to be able to have dates returned from a query in this format
so that I can use passthrough queries from Access. I know I
On 2/26/07, Joris Dobbelsteen [EMAIL PROTECTED] wrote:
See the discussion [GENERAL] Database versus filesystem for
storing images earlier on the List.
And man, do I wish people used threading-capable mailers
and didn't do tofu-posts. :/
- Joris
Cheers,
Andrej
On 2/24/07, Dave Page [EMAIL PROTECTED] wrote:
pgRails is a distribution of Ruby, Rails, and the Ruby PostgreSQL
connector all preconfigured for use with PostgreSQL on Windows 2000 and
above.
How easy would that be to integrate on Linux?
Cheers,
Andrej
---(end of
On 2/23/07, Jim Nasby [EMAIL PROTECTED] wrote:
That depends greatly on what you're doing with it. Generally, as soon
as you start throwing a multi-user workload at it, MySQL stops
scaling. http://tweakers.net recently did a study on that.
I think I recall that wikipedia uses MySQL ... they get
On 2/23/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
Andrej Ricnik-Bay wrote:
On 2/23/07, Jim Nasby [EMAIL PROTECTED] wrote:
That depends greatly on what you're doing with it. Generally, as soon
as you start throwing a multi-user workload at it, MySQL stops
scaling. http://tweakers.net
On 2/20/07, Justin Dearing [EMAIL PROTECTED] wrote:
Hello,
I need a way to sync a postgres view with a table on a Windows CE device.
The table will be read only on the mobile device. I am seeking to replace an
access database that syncs a table with a pocket pc table via active sync. I
would
On 2/21/07, Guido Neitzer wrote:
It would be more or less the same, if you compare copy against insert
performance on PostgreSQL and state that insert should be as fast as
copy without saying why.
Btw: these guys claim to be database consultants.
Guess one should consider oneself lucky not to
On 2/21/07, Tomi N/A [EMAIL PROTECTED] wrote:
# /etc/init.d/postgresql stop
* Stopping PostgreSQL ...
start-stop-daemon --stop --pidfile /var/lib/postgresql/data/postmaster.pid
--retry -TERM//-INT//-QUIT --oknodo
/sbin/start-stop-daemon: invalid schedule item (must be
[-]signal-name,
101 - 137 of 137 matches
Mail list logo
