Hi!
Could you please answer me whether PostgreSQL v7.4.7 (on x86 platform)
is compatible with FreeBSD v5.3 or its safer to use FreeBSD v4.11?
Excuse me for my English. Thank you in advance!
On Mon, Mar 21, 2005 at 12:35:22AM -0600, Thomas F.O'Connell wrote:
> The number of lines depends merely on where you place your line breaks.
>
> IF(days_complete <= 120, job_price, 0)AS Days_120
>
> could be written as:
>
> CASE WHEN days_complete <= 120 THEN job_price ELSE 0 END AS Days_120
>
Test
Hi,
I have installed previous version of postgresql. 8.x. I uninstalled it.
Then remove the superuser in My Computer ( right click ) --> Properties
--> in tab Advanced --> Settings button. I try to install postgresql
8.0.1. In service configuration, I checked the install as service
checkbox. Fille
The number of lines depends merely on where you place your line breaks.
IF(days_complete <= 120, job_price, 0)AS Days_120
could be written as:
CASE WHEN days_complete <= 120 THEN job_price ELSE 0 END AS Days_120
There might be somewhat less syntactic sugar, but this is not a five
line expression a
I don't remember such problem ? What's your tsearch2 setup ?
Oleg
On Thu, 17 Mar 2005, Justin L. Kennedy wrote:
The short question is why does this:
select to_tsvector('default', coalesce(name, '') ||' '||
coalesce(description, '') ||' '|| coalesce(keywords,'')) from link_items;
give different resu
On Tue, 15 Mar 2005 08:39 pm, Andrus wrote:
> >> > I have table containing different types of documents (type A, B and C).
> >> >
> >> > Each document type must have separate sequential ID starting at 1
> >> >
> >> > ID of first inserted record of type A must be set to 1
> >> > ID of first inserted
On Mon, 21 Mar 2005 02:50 pm, Bruce Momjian wrote:
> Stanislaw Tristan wrote:
> > It's a possible to compress traffic between server and client while server
> > returns query result?
> > It's a very actually for dial-up users.
> > What is solution?
There is always the possibility of using SSH to t
"Alex Adriaanse" <[EMAIL PROTECTED]> writes
> This seems to work, except there exists a race condition. Consider the
> following series of events (in chronological order):
>
>1. Initially, in the codes table there's a row with id=1, revision=1,
> and a row with id=2, revision=2
>2.
On Tue, 15 Mar 2005, Suma Bhat wrote:
> I'm need to be able to insert a byte[] of size upto 25MB.
> With Heap size upto 512m this is failing, with a java.lang.OutOfMemoryError
>
You need to use an 8.0 JDBC driver and a 7.4 or 8.0 server.
Kris Jurka
---(end of broadca
To fetch all updates since the last synchronization, the client would
calculated a value for $lastrevision by running this query on its local
database:
SELECT max(revision) AS lastrevision FROM codes;
It would then fetch all updated rows by running this query against the
server:
SELECT * FROM c
Stanislaw Tristan wrote:
It's a possible to compress traffic between server and client while server
returns query result?
It's a very actually for dial-up users.
What is solution?
You could use an SSH tunnel with compression to achieve this.
-Neil
---(end of broadcast)-
Bruce Momjian wrote:
Stanislaw Tristan wrote:
It's a possible to compress traffic between server and client while server returns query result?
There are a couple of solutions.
1. Mammoth PostgreSQL supports this for libpq, and jdbc based clients.
2. You can use a web services model that use
Stanislaw Tristan wrote:
> It's a possible to compress traffic between server and client while server
> returns query result?
> It's a very actually for dial-up users.
> What is solution?
No, unless SSL compresses automatically.
--
Bruce Momjian| http://candle.pha.pa.
Hello,
I resolved this issue already.
The trigger now works fine.
I was looking at the wrong structure.
Thanks,
Peter
Michael Fuhr wrote:
On Tue, Mar 08, 2005 at 11:37:14AM -0800, peter Willis wrote:
I have a trigger function written in C.
The trigger function is called via:
CREATE TRIGGER after
Hello,
I've dumped the content of MS-Access 2002
SP3 tables on a PC with Windows XP Pro in French localization.Then I
COPY these files, on the same PC hosting an PostgreSQL 8.0.1 database.I've
problems with the accents !? Why ?
What kind of encoding must I use to create the PG
database under
I use a bash script (similar to following example) to update tables.
psql -v passed_in_var=\'some_value\' -f script_name
Is it possible to pass a value back from psql to the bash script?
Thanks,
Paul Cunningham
---(end of broadcast)---
TIP 4: D
Hello,
This issue is resolved.
I was using the wrong struct.
Peter
Tom Lane wrote:
peter Willis <[EMAIL PROTECTED]> writes:
I have a trigger function written in C.
...
Since the trigger is called after each row update the actual row data
should be available in some way to the trigger.
Su
Hi,
i dumped my database on server1 with pg_dump -Fc ..., copied the dump to
server2, both same pgsql version 7.4.6
pg_restore says
pg_restore: [custom archiver] could not uncompress data: incorrect data check
But it "seems" that almost any data was restored.
What does this error mean. I didn
>> > I have table containing different types of documents (type A, B and C).
>> >
>> > Each document type must have separate sequential ID starting at 1
>> >
>> > ID of first inserted record of type A must be set to 1
>> > ID of first inserted record of type B must be also set to 1
>> > ID of secon
In article <[EMAIL PROTECTED]>,
"Rick Schumeyer" <[EMAIL PROTECTED]> writes:
> These results are for a single process populating a table with 934k rows,
> and then performing some selects. I also compared the effect of creating
> indexes on some of the columns.
> I have not yet done any testing
Mark Rae wrote:
I would say that doing the concurrency tests is probably the most
important factor in comparing other databases against MySQL, as
MySQL will almost always win in single-user tests.
E.g. here are some performance figures from tests I have done in the past.
This is with a 6GB databse
Hi all.
We have a setup with Zope and a remote Postgresql server. We're storing
blobs in largeobject files.
What we need to do is to be able to do the transfer of blobs between
Zope and postgres. I thought it was possible to use lo_* functions, by
creating a largeobject, and then sending the da
The short question is why does this:
select to_tsvector('default', coalesce(name, '') ||' '||
coalesce(description, '') ||' '|| coalesce(keywords,'')) from link_items;
give different results than this:
update link_items set linksfti=to_tsvector('default', coalesce(name, '')
||' '|| coalesce(desc
Hi,
I'm need to be able to insert a byte[] of size upto 25MB.
With Heap size upto 512m this is failing, with a java.lang.OutOfMemoryError
Any help resolving this issue will be greatly appreciated.
Thanks,
Suma
---(end of broadcast)---
TIP 9: the
It's a possible to compress traffic between server and client while server
returns query result?
It's a very actually for dial-up users.
What is solution?
---(end of broadcast)---
TIP 8: explain analyze is your friend
Title: Message
I use AS Tcl 8.4.9
on Windows and I would like to use Pg8 (since it is now native to Windows). What
do I need on the Tcl side of things?
Robert
HicksNorthrop Grumman
Mission Systems
Defense Mission SystemsSystems
Administrator (LIMS)304.264.7939 (Office)
304.264.2664
(Fax
Michael Fuhr wrote:
On Tue, Mar 15, 2005 at 10:46:09PM +, Paul Moore wrote:
The long and short of it is that I believe you just use \n to delimit
lines on Windows, just like anywhere else.
Many thanks -- your test results contain the info we've been seeking.
Thanks a lot Paul.
Micheal, you we
I'm working on an application where we have a central database server
and a bunch of clients that are disconnected most of the time, need to
maintain a local copy of the central database. The client databases are
based on One$DB since it has to be lightweight. The client does not
access the s
Hello
I need Help on ODBC driver testing. We have written ODBC
driver for our new
SQL engine. I have to test ODBC driver in linux only. I need
some web links
where i can get some free codes in linux for ODBC testing.
Can you refer me
any sites or weblinks where i can get some ODBC driver test codes
"Vern" <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]:
> Marc G. Fournier wrote in Msg <[EMAIL PROTECTED]>:
>
>> it can't *hurt* to have the group ...
>
> I respectfully disagree with you, Marc. :)
>
> The PGSQL* hierarchy is now well distributed, and there is no need
> for a comp.* group
Folks,
I'm a kind new bye with linux & related stuffs. I'm trying to install PG on a FC3 using "postgresql-8.0.1-2PGDG.i686.rpm", but after to issue rpm -ivh and the rpm file I've got a message telling it "error: Failed dependencies: libpq.so.3 is need". I take a look at the documentation and it
Hello all.
In the tail end of converting an app from MySQL to psql. I have this code :
IF(days_complete <= -120, job_price,0) AS Days_120,
IF(days_complete BETWEEN -119 AND -90, job_price,0) AS Days_90,
IF(days_complete BETWEEN -89 AND -60, job_price,0) AS Days_60,
IF(days_complete BETWEEN -59 AND
The short question is why does this:
select to_tsvector('default', coalesce(name, '') ||' '||
coalesce(description, '') ||' '|| coalesce(keywords,'')) from link_items;
give different results than this:
update link_items set linksfti=to_tsvector('default', coalesce(name, '')
||' '|| coalesce(d
> Mean is just sum(col)/count(col)
You can also just use avg(col).
Either way, be careful because nulls may not be treated as you want for
such calculations.
The stats package R can access Postgres databases, and can be used for
robust statistical analyses of the data.
See:
http://sourceforge
FIRST CALL FOR VOTES (of 2)
unmoderated group comp.databases.postgresql
Newsgroups line:
comp.databases.postgresql PGSQL Relational Database Management System.
Votes must be received by 23:59:59 UTC, 9 Apr 2005.
This vote is being conducted by a neutral th
tm <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
> Woodchuck Bill <[EMAIL PROTECTED]> wrote:
>
>> The proponent certainly left a bad taste in my mouth after his
>> little ...
>
> Too much information.
>
LOL. Get your mind out of the gutter. ;-)
--
Bill
---(
Dnia Sat, Mar 19, 2005 at 06:36:27PM +0100, [EMAIL PROTECTED] napisal(a/o):
> 1. I've a master table containing about 4 records. A count(*) provides
> me the exact number.
> 2. I've create a table based on from the master. I copied a fraction from
> the master into the new table using a where c
Hi there folks,
I've just had pg_dump fail on me for the first time ever, and I'm not sure why.
It generates 24MB of dump before bombing out with:
pg_dump: socket not open
pg_dump: SQL command to dump the contents of table "activity_log"
failed: PQendcopy() failed.
pg_dump: Error message from se
On Sun, Mar 20, 2005 at 10:10:14AM -0800, Jason Leach wrote:
> hi,
>
> I'm having a bit of trouble with my SQL query. It takes about 26h to
> run on a 3Ghz PC. I'd really like to speed this up.
>
> I put this query in a loop to iterate over 20 tables (each table
> including summary has 400k reco
[I've tried to send this message to pgsql-general several times now,
but even though I'm subscribed to it I never saw the message show up
in the mailing list, so I'm trying to send it from a different account
now. If you get several copies of this message, I apologize.]
I'm working on an applicat
Oleg Bartunov wrote:
On Sun, 20 Mar 2005, Joshua D. Drake wrote:
My understanding is that 8.1 will have a much more mature
implementation of
stored procedures versus UDFs (Which we have had forever).
What's the difference between UDF and stored procedure ?
Here are a couple of GGIYF references:
Oleg Bartunov writes:
> Hmm, the only real difference I see - is that SP are precompiled.
> I think we should clearly outline what is SP and what is UDF and do we
> are working on SP or just improving and extending our functions.
AFAIR, the only person who's actually stated any intention to work
On Sun, 20 Mar 2005, Joshua D. Drake wrote:
My understanding is that 8.1 will have a much more mature implementation
of
stored procedures versus UDFs (Which we have had forever).
What's the difference between UDF and stored procedure ?
Here are a couple of GGIYF references:
http://builder.com.c
My understanding is that 8.1 will have a much more mature
implementation of
stored procedures versus UDFs (Which we have had forever).
What's the difference between UDF and stored procedure ?
Here are a couple of GGIYF references:
http://builder.com.com/5100-6388-1045463.html
http://blogs.pingp
hi,
I'm having a bit of trouble with my SQL query. It takes about 26h to
run on a 3Ghz PC. I'd really like to speed this up.
I put this query in a loop to iterate over 20 tables (each table
including summary has 400k records), each time the table name changes.
I this case it's m_alal. Each tabl
On Sun, 20 Mar 2005, Joshua D. Drake wrote:
Oleg Bartunov wrote:
On Sun, 20 Mar 2005, Bruce Momjian wrote:
Tony Caduto wrote:
Hi,
I read in a article/interview on
http://madpenguin.org/cms/html/62/3677.html
that work was being done on improving/adding support for sql standard
compliant stored proc
Sarah Ewen <[EMAIL PROTECTED]> writes:
>> Is this repeatable? What shows up in the postmaster's log when it
>> happens? What platform is this on, and what version of Postgres?
> This is postgresql-7.4.6-1.FC2.2 running on RedHat Fedora Core 2.
> The logs don't reveal anything, and it happens co
Oleg Bartunov wrote:
On Sun, 20 Mar 2005, Bruce Momjian wrote:
Tony Caduto wrote:
Hi,
I read in a article/interview on
http://madpenguin.org/cms/html/62/3677.html
that work was being done on improving/adding support for sql standard
compliant stored procs/functions
Does anyone know exactly what t
On Sun, 20 Mar 2005, Bruce Momjian wrote:
Tony Caduto wrote:
Hi,
I read in a article/interview on http://madpenguin.org/cms/html/62/3677.html
that work was being done on improving/adding support for sql standard
compliant stored procs/functions
Does anyone know exactly what that means?
Does it mean
Hi Stephan,
I figured out what happened:
The master table contained duplicates, but the insert statement seems to
be very smart by selecting just the unique ones.
Peter
>-- Oorspronkelijk bericht --
>Date: Sun, 20 Mar 2005 01:46:19 -0800 (PST)
>From: Stephan Szabo <[EMAIL PROTECTED]>
>To: [EMAIL
Hi Alvaro, thanks for your reply!
Alvaro Herrera wrote:
psql:db_backup.sql:1548: ERROR: invalid byte sequence for encoding
"UNICODE": 0xe12020
CONTEXT: COPY country, line 5, column namespanish:
"Canad?"
Hmm. The sequence looks like latin1 interpreted as utf8. This seem
Tony Caduto wrote:
> Hi,
> I read in a article/interview on http://madpenguin.org/cms/html/62/3677.html
> that work was being done on improving/adding support for sql standard
> compliant stored procs/functions
>
> Does anyone know exactly what that means?
>
> Does it mean that Postgres will hav
Michael Ben-Nes wrote:
> I recomend you to compile PG from source so you can use the new 8.0.1
PostgreSQL 8.0.1 is available in the Debian experimental suite, package
name "postgresql-8.0".
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcas
Sorry it took me so long to respond. I've been out for a couple days.
While certain things may be permissible in a language, I think it is also
important to look at the context at which the language is applied and make a
determination if it will practically turn up in relevant code. If the answer
Hi there Tom, thanks for your reply.
pg_dump: socket not open
pg_dump: SQL command to dump the contents of table "activity_log"
failed: PQendcopy() failed.
pg_dump: Error message from server: socket not open
pg_dump: The command was: COPY public.activity_log (
TO stdout
Is this repeatable? What
On Sun, 20 Mar 2005 [EMAIL PROTECTED] wrote:
> That's what I tought the problem was, but I created a table afterwards
> without
> inheritence. Could it have something to do with the max size of the schema
> or oid's?
I can't think of a reason it would, so can you send a self-contained
full exam
That's what I tought the problem was, but I created a table afterwards without
inheritence. Could it have something to do with the max size of the schema
or oid's?
>-- Oorspronkelijk bericht --
>Date: Sat, 19 Mar 2005 14:55:50 -0800 (PST)
>From: Stephan Szabo <[EMAIL PROTECTED]>
>To: [EMAIL PROT
58 matches
Mail list logo
