o the log, and if so, what log level would it be at?
If this doesn't get logged, could I make this a feature request?
Thanks!
--Richard
On Apr 15, 6:35 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm just wondering if autovacuum is ever supposed
but i can't see to problem key
Thx,
Lhaj
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On Jun 9, 8:12 am, Rodrigo De León <[EMAIL PROTECTED]> wrote:
> On Jun 8, 7:59 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> wrote:
>
>
>
> > i have 4 tables :
>
> > date_table (date_id,.)
> > A_table(A_table_id, something1,someth
i have 4 tables :
date_table (date_id,.)
A_table(A_table_id, something1,something2.)
A1_table(A1_table_id references A_Table(A_Table_id),A11,A12)
A2_table(A2_table_id references A_Table(A_table_id),A21,A22,...)
so i want to create a view with date_id,A_table_id,something1,
Hello,
I use the following command "SELECT * FROM employees ORDER BY name"
(a very simple sql statement) the main thing here is that I get a
list ordered without taking into accound the spaces. For example, I
get the following listing:
ABAB
AB CD
ABD E
AB EF
and what
On Jul 23, 6:11 am, [EMAIL PROTECTED] ("Raymond O'Donnell") wrote:
> On 23/07/2007 11:04, Andy Dale wrote:
>
> > The posgres command in the loop should look like so (not sure about the
> > password):
>
> As I understand it, you supply the password via a pgpa
We recently moved to PITR backup and recovery solution as defined in the
documentation. Our basic setup executes the backup start command, and then
takes a snapshot of the filesystem and backups wal files. However, we have
database files ( not wal files ) that change while the system is in backup
ppreciated!
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
On Jul 23, 5:18 am, [EMAIL PROTECTED] ("Gavin M. Roy") wrote:
> You might want to look at pgBouncer to pool your drupal pgsql needs. I've
> found with 2000 needed connections, I can pool out to only 30 backends and
> still push 8k transactions per second.
>
How you
On Sep 4, 10:54 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> "Phoenix Kiula" <[EMAIL PROTECTED]> writes:
> > Would appreciate any help. Why do indexed queries take so much time?
> > It's a simple DB with "10 relations" including tables and indexes.
&g
On Sep 12, 3:05 pm, [EMAIL PROTECTED] ("D. Dante Lorenso") wrote:
> Pavel Stehule wrote:
> > 2007/9/12, Jay Dickon Glanville <[EMAIL PROTECTED]>:
> >> - I write a function (it doesn't matter what language it's in:
> >> PL/pgSQL, PL/Java, e
se send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hello,
I need to import between 100 millions to one billion records in a
table. Each record is composed of two char(16) fields. Input format
is a huge csv file.I am running on a linux box with 4gb of ram.
First I create the table. Second I 'copy from' the cvs file. Third I
create the index on the
i tried to restore a dump from 8.2.5 in which i had used tsearch2 and
contains lot of tsearch2 index. when i tried to restore it to 8.3beta it
complained about 'unknow command \r\n' . i know it is from tsearch2. doesnt
8.3 have tsearch2 enabled by default?
with 8.2xx i used to create a database and
I have Apache/php/PostgreSQL on FreeBSD, all latest stable versions.
Every time, after mass import into the database (it's a development
server, so the import updates the database with full dump from the
production server) - the first several clicks on the development web
site return -
PGSQL
I initialized a database directory and it started fine. But when I tried to
create user I got this error.
Can you tell what is wrong?
thanks
createuser --superuser --createdb --createrole -P postgres
Enter password for new role:
Enter it again:
createuser: could not connect to database postgres:
Hi,
I'm currently using a PostgreSQL DB on my disk memory, but right now I need to
split this DB in this way:
a. the first DB (or first DB partion) will be stored in the Flash
memory and it will contain the system configuration values;
b. the second DB (or second DB partion) wil
Hi All,
Not sure if this is a slony issue or a postgres issue...I'm posting on
both.
I'm running slony on a one master/two subscriber system. One of the
subscribers seems to get stuck on a group of queries, and I can't seem
to figure out why. If I do a select on pg_stat_activity, I get the
foll
The C version:
http://downloads.sourceforge.net/vtd-xml/c_tutorial_by_code_examples
The C# version:
http://downloads.sourceforge.net/vtd-xml/CSharp_tutorial_by_code_exam...
The Java version:
http://downloads.sourceforge.net/vtd-xml/Java_tutorial_by_code_exampl...
Also some latest articles
Good morning to everybody,
I've to resolve this situation: I've a collection of many different databases, all identical, and the name of those databases is stored inside a table in another "central
management" database.
In an ideal world, I'd like with a single query to be able to recover the nam
Hi
I am trying to upgrade my database from 8.0 to 8.1 and am looking for a
little info/advice.
This is a production database that we are migrating and it is in CONSTANT
use, so the maintenance window must be small and hopefully mostly off-hours.
We use a PITR/LVM snapshot solution for our backup
Hi all,
I have a table like this,
CREATE TABLE mytable(
avarchar(40),
btext,
ctext,
PRIMARY KEY (a, b)
);
What I want to do is:
insert a record into a table, and when the record already
exists(according to the primary key), update it.
I know that there is a ON DUPLICATE clause
Michael Glaesemann wrote:
On Dec 24, 2007, at 22:03 , [EMAIL PROTECTED] wrote:
I have googled and currently the only way I can find is do query first
and then update or insert.
Or alternatively, UPDATE and see if you've affected any rows. If not,
insert.
Michael Glaesemann
Hi all,
I have a table like this,
CREATE TABLE mytable(
avarchar(40),
btext,
ctext,
PRIMARY KEY (a, b)
);
What I want to do is:
insert a record into a table, and when the record already
exists(according to the primary key), update it.
I know that there is a ON DUPLICATE clause
Hello All
I recently ran out of disk space on the volume hosting my default
tablespace. As it turned out, the sysad didnt allocate all of the disk to
the volume when he installed it, so he resized the volume and restarted the
database. The server came up fine so I assumed all was well ( the serv
and running.
Thanks
-bill
On Jan 4, 2008 3:42 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes:
> > lo_creat fails with:
> > ERROR: large object already exists
>
> Well, does it?
>
> What PG version i
Thank you both!! That got me back up and running ( for now ). Hopefully
this will give me enough enough time to finish the migration next week.
Thanks again!!
On Jan 4, 2008 4:21 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> > Is there anyw
Good morning everyone!
As you may have guessed from previous posts, i just recently migrated my
main database server from 7.4.x to 8.1.11. This part went pretty smoothly.
:)
One of the client machines in my architecture is a Fedora Core 4 box. I
unfortunately cannot change this so I had to buil
)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
d an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Jorge Godoy wrote:
Have you checked your code and seen what is really happening on these clicks?
I have been trying to catch the error from within php, however
PostgreSQL (in the described case) dies in a way which does not return
any error.
The error returned is that php can't connect to t
Hi,
my db structure relays on the OIDs of tables (stored as OIDs of
pg_class).
However, 'pg_dumpall -o ...' seems to save the oids of all data but not
the tableoids, so, when I restore data I get different tableoids than I
had before!
Is there anything I could do to backup and restore even the t
Hi,
what's an alternative to tableoids?
As I've learned today they are not consistant across pg_dump/restore.
I need to point to (lots of dynamically added) tables and used tableoids
before.
Are there other solutions to point to tables besides using tableoids
or wasting disk space using the st
Hi,
when committing a transaction returns with an error: Do I have to
rollback the transaction in this case?
Felix
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
; "$line.bz2"
done
'''
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hi all,
I have a large sdf file with many records of molecules and associated
data items and I want to save them in a PostgreSQL database. There are
about less than 40 data items for every molecule(the names of the data
items fore each molecule are the same, but values differ). The number
of mol
Hi
I'm experimenting with PostgreSQL 8.3.0 on Windows connecting via ODBC. One
curiosity so far is this:
If I use pgAdmin and run "SELECT catalog_name FROM Information_Schema.Schemata"
I get data back as expected.
If I connect via ODBC and issue the same query I don't see any data. SQLFetch()
Hi
My porting experiment has encountered the SQL Server UniqueIdentifier problem.
I can see one or two suggestions about this have been made over the years but
I'd like to try and stay close to the original. So:
I'm wondering if I can use a combination of a domain 'hack' for syntatic
compatibi
Hi all,
I'm trying to create a very large table with more than 0.6 billion rows,
which is really a big number, so I think I have to create partitioned
tables after some googling.
However, I have a few questions about partitioning in PostgreSQL.
1) PostgreSQL only support partition by inheritanc
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hi,
Thank you guys.
Enrico Sirola wrote:
Il giorno 18/feb/08, alle ore 17:37, [EMAIL PROTECTED] ha scritto:
1) PostgreSQL only support partition by inheritance, and rules have to
be created for each child table, this will result *a lot of* rules if
the number of child tables is large.
Are
earch2.sql:73: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
ROLLBACK
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PRO
I solved my problem :)
the problem is in the query that calls my function:
select * from calcolo_inventario('26','2008-02-22','05')
where giacenza > 0
because the resulset has a negative row that doesn't appear on screen
Thank you very much to all of you
Enrico
---(end
Hi,
I urgently need a way to simply backup the database's data on win32
(e.g. the 'data' directory).
As discussed earlier I can't use dump/dumpall since my data needs
persistent tableoids which, however, are not the same after a restore.
AFAIK stopping the server, zipping data dir, and restartin
Apologizes if this has already been announced -
http://www.scribd.com/doc/551889/Introducing-Freebsd-70
a presentation of the SMP in FreeBSD 7.0 using PostgreSQL and MySQL to
produce benchmarks.
Notable quotes -
a) MySQL degrades after utilizing all CPUs, while PostgreSQL does not
(the explana
Hi Everyone,
I am wanting to ask some opinions on implementing PL/R into V8.3 on
Win32. I have a need to be able to perform some relatively demanding
statistical functions as the basis of producing data for reports.
In short R appears to have more than enough capability to do the job
(from a stat
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Sam,
Thankyou for the suggestions. They make perfect sense to me. I
appreciate your time and input. The lack of optimiser usage was
something that I had not considered, and I thank you for making me
aware of it.
Cheers
The Frog
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
Hi Guys,
I have been testing / working with Postgres for a work project, and so
far I am really impressed with this DB system. Takes a little getting
used to, but I am really beginning to love it.
I am looking now at a scenario that does not seem to be a native
ability of Postgres, but might poss
Thanks for the help guys,
I should clear up a little what I am trying to achieve I think.
The primary users of this db and application will be located in an
office, each user with a desktop machine, all networked. They need to
work with this DB in a fairly heavy kind of way, in so far as to say
t
On Apr 14, 2:17 pm, [EMAIL PROTECTED] ("David Wilson") wrote:
> For instance, your count of distinct userids is probably not using the
> index you just created. If it still isn't using it after you ANALYZE
> the table, try rewriting the query using group by (select count(
On Apr 14, 12:34 pm, Chris Browne <[EMAIL PROTECTED]> wrote:
> If the entire purpose of your application is to run COUNT(*)
haha. no. I see your point.
I'll be doing statistical functions on group-by's. So I'll go back
and give it another try with queries like those.
Let me just start off by saying that I *want* to use postgresql.
That's my goal. I do not want to use SQLServer. I'm posting this
message not to slam postgres, but to ask for someone to help me figure
out what I'm doing wrong.
I've used postgres for several years as the backend to web
applicatio
Hi...
This is as much an apache question as anything else, but I think it's
appropriate here.
I've been using phppgadmin on my local machine. Now I've installed it
on a remote server running Ubuntu lts 8.04.
I figured I'd try and put it under ssl/https under Apache (mod_ssl).
I've created a tes
Wow...so does no one use phppgadmin on servers that they are connected
to via the internet? Or if you do, how do you go about securing it so
that no one snoops your password?
Thanks
On May 16, 12:34 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
wrote:
> Hi...
>
>
Hello,
i have the problem that postgres ist starting and stopping several (up
to 4) processes per minute, so that the error log in windows is
running full, with more than 14 entries every minute.
Does someone know, how to reduce the start and the end of so many
processes, is there a variable or
should use to ensure complete compatibility with the other software on the
system.
Thanks for your help!
--
Best Regards,
Lynn P. Tilby
Ph: 480 632-8635
[EMAIL PROTECTED]
Hello,
I am doing a query via psql on a huge database, and I want to have its
output piped to other unix processes.
As the result set is very big, I've got: "out of memory for query
result".
How can I manage that, without playing with cursors, as I do not want
to change the sql query ?
Under mysq
> Try copy (query) to stdout.
>
> For me, psql sits at 4.9mb ram on a 3x10^16 row query.
>
> klint.
>
Thanks Klint.
Can I use a 'copy to' for a query ? I thought I can only do 'copy
table to stdout'
I will do some tests tomorrow and keep you inform.
Olivier
--
Sent via pgsql-general mailing li
Please excuse my lack of mac knowledge. I installed postgresql 8.3 using the
mac os x 1 click installer onto my brand new powerbook. The install appeared
to go very smooth. If I go to Postgresql under Applications it appears as if I
can start and stop postgres and open pgadmin. I even creat
> Date: Wed, 23 Jul 2008 14:12:45 -0400
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] mac install question
> CC: pgsql-general@postgresql.org
>
> On Wed, Jul 23, 2008 at 1:58 PM, [EMAIL PROTECTED]
> <[EMAIL PROTECTED]> wrote:
> &
Hello,
I'm trying to create a messageing service, like in facebook. Basically
a member can write messages to another member. It will have three main
functions. One, basic messaging to another member. Two, notification
from system to a group of members (a list of members), Three, an
update report t
Hi,
Iam new to Postgresql, now i need to create a Dynamic SQL Query for
returning the record set
based on my Input Parameters. I looked up some of the documents and worked
out some more ...
MY Postgresql Version In Local: 7.4
MY Postgresql Version In Development: 8.2
-- DROP TYPE ORDERREPORT;
C
with your result set using FOR ..LOOP but mine
is not a normal query. it was built Dynamic based on my Input Parameters.
Please look and tell me if you are not clear with my query.
Thanks,
MuraliDharan V
From: Sathish Duraiswamy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12
Please understand.
I know I have to use FOR . LOOP for my query. But it is not a normal one .I
use to build that one dynamically.
From: Willy-Bas Loos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2008 5:46 PM
To: [EMAIL PROTECTED]
Cc: Sathish Duraiswamy; pgsql-general
On Aug 12, 8:17 am, [EMAIL PROTECTED] (ries van Twisk) wrote:
> On Aug 12, 2008, at 3:53 AM, Willy-Bas Loos wrote:
>
>
>
> > reproduced it on:
> > "PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
> > 4.2.3 (Ubuntu 4.2.3-2ubuntu7)"
> >
ot open multi-query plan as cursor
SQL state: 42P11
Context: PL/pgSQL function "fun_orderreport" line 30 at for over execute
statement
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 12, 2008 6:53 PM
To: 'Willy-Bas Loos'
Cc: 'Sathish Duraiswamy';
TE vSql
LOOP
RETURN NEXT vResult;
END LOOP;
RETURN;
END $BODY$
LANGUAGE 'plpgsql' VOLATILE;
SELECT * FROM fun_orderreport(NULL,NULL,NULL);
Thanks,
MuraliDharan V
-Original Message-
From: Gnanavel Shanmugam [mailto:[EMAIL PROTECTED]
Sen
Hi
I want to store dates / events for example birthdays (or may 5th) that
repeats every year..
what is the best way to do in postgres?
if i use timestamp it is going to be use the current year.. how do i do
this?
On Sat, Sep 6, 2008 at 10:21 AM, brian <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
>> Hi
>> I want to store dates / events for example birthdays (or may 5th) that
>> repeats every year..
>> what is the best way to do in postgres?
>> if i use t
On Sat, Sep 6, 2008 at 10:32 AM, Jorge Godoy <[EMAIL PROTECTED]> wrote:
> Em Saturday 06 September 2008 14:12:49 [EMAIL PROTECTED] escreveu:
> > Hi
> > I want to store dates / events for example birthdays (or may 5th) that
> > repeats every year..
> > what
Hi,
I know it has been posted before, but it's been some time since that
and there has been no definitive (good) answer, so: has anyone been
able to build and use PL/Ruby with postgres 8.3 on windows? I have had
no problems on my linux machine, but now I need to get it working on
windows...
Thank
Hello,
I'm wondering if you can help. We are currently enabling QLR Manager
(http://www.qlrmanager.com) to work with PostgreSQL. QLR (Query, Layout
& Report) Manager is a php server based reporting and graphing tool that
currently works with Oracle and MySQL. It runs on most any javascript
ena
unsubscribe
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
- Original message -
From: "Bill Chandler" <[EMAIL PROTECTED]>
To: "pgsql-general"
Date: Thu, 21 Apr 2005 08:11:09 -0700 (PDT)
Subject: [GENERAL] Finding cardinality of an index
All,
Is there a way to determine cardinality (size) of an
index? In general how to you que
hi,
Does anyone know of a tool for filling the database with alot of random data...
so that I can add millions of rows to test approx how well it will scale ?
tia
-
http://linuxtoday.com/news_story.php3?ltsn=2004-12-08-004-32-OS-BZ-DT-0005
snip> MS Office is popular in the same way as heart
From : "Tom Lane" [EMAIL PROTECTED]
To : "gabriele zelasco" [EMAIL PROTECTED]
Cc : pgsql-general@postgresql.org
Date : Thu, 26 May 2005 17:50:29 -0400
Subject : Re: [GENERAL] Locking rows
> "gabriele zelasco" <[EMAIL PROTECTED]&
> "gabriele zelasco" <[EMAIL PROTECTED]> writes:
> > I would like to start a transaction with a sql function.
> > When user press "edit" button on my form, i would lock the current row.
> > After user has modified data on form, pressing "sav
fessional support is available. Some enhancements should be available
in 8.1, as well as further documentation.
Best Regards, Simon Riggs
http://www.2ndquadrant.com
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
I'm sorry, but I know only the basics about DBMs, but I think is not
possible to put a image file INSIDE a database. You can put in a
database the path of the file...
(Maybe I'm wrong...)
See ya!
---(end of broadcast)---
TIP 3: Have you checked ou
Hi all.
I want to install pg with readline. ./configure told me I have no
readline. I downloaded it and installed it, but ./configure still
outputing there is no readline. How can I solve it?
Thx! Bye!
---(end of broadcast)---
TIP 6: explain analy
sorry for posting that, i already found anwser. but i wonder if client
encoding will be enought to make changes i want to..
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if
1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hi,
I have a problem with some portuguese characters like:
select translate('programação', 'aszzclóençã ',
'aszzcloenca+');
i get:
WARNING: ignoring unconvertible UTF-8 character 0xc3a3
and return is:
programaco
without 'a'
is this a problem with tabel encoding? or what? please help and
com
Hello,
we run 'out of space' in one of our columns which is smallint and we
need to make it integer.
I did some research and found out that the only way is to create a new
column with integer data type, then SET new = old, then drop old and
rename new like old [1].
Could somebody confirm i
Alvaro Herrera wrote:
On Thu, Sep 08, 2005 at 04:22:07AM +0200, [EMAIL PROTECTED] wrote:
Hi,
we run 'out of space' in one of our columns which is smallint and we
need to make it integer.
I did some research and found out that the only way is to create a new
column with integer
I just installed
Postgres 8.0 (Windows native) on a HP server with Windows 2000 Server
Service Pack 4. This database is accessed by several windows PCs with an
ODBC (ver. 7.03.02.00) through a 100Mbps intranet.
I have notice that when I run a program that requires about 2 MB of
inform
In general, I have the following questions to PostgreSQL users. - Are
there any of you who need to store and query XML data? - Do you already
use PostgreSQL to store XML data or you are
just thinking about it?
- If you store XML data in PostgreSQL, how do you do it? What tool
do you use?
- Do
I had a problem with a program that load about 2 MB of information from
de DB with a rate of data transfer about 80K. I don´t know why the 'top' of
80K, but is not harware. I still have this problem.
Then I set the "Use Declare/Fetch" opcion on the ODBC. This opcion take
the information to trans
The following errors only happen when using the "USE DECLARE/FETCH"
option in the ODBC Driver. When DECLARE/FETCH is set, the data sent to
some of our programs is reduced from 2 MBytes to 100 KBytes. We want to
achieve this reduction. But, with the DECLARE/FETCH option set,
implicit transactions ar
select date_trunc('week', '2005-01-01'::TIMESTAMP) returns '2006-01-02
00:00:00'
is this the intended result or is some kind of a bug ?
the result should not be '2004-12-27 00:00:00' ?
thanks,
Razvan Radu
---(end of broadcast)---
TIP 2: Don't
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Tom Lane wrote:
Jan Wieck <[EMAIL PROTECTED]> writes:
On 9/27/2005 12:20 AM, George Essig wrote:
We have a database with about 30 tables and some RI. The RI constraints,
however, were not named upon creation of the database 2-3 years ago and
now when we get an error it contains f
Context:FREEBSD 5.4, postgresql 8.0.3
I'm not a C newbye and I'm
having a go at compiling my first, simple C(++) program:
#include
int main()
{
PGconn *psql;
psql = PQconnectdb("hostaddr =
'127.0.0.1' port = '' dbname = 'curve' user = 'vi
return 0;
}
But
when
I compile it the following mess
aggio originale
Da: kleptog@svana.org
Data: 28-set-2005 11.44
A: "[EMAIL PROTECTED]"<[EMAIL PROTECTED]>
Cc:
Ogg: Re: [GENERAL] postgresql and
C++/C
On Wed, Sep 28, 2005 at 10:11:45AM +0100, [EMAIL PROTECTED]
wrote:
> Context:FREEBSD 5.4, postgresql 8.0.3
>
> I
Gordon Burditt wrote:
> [...stuff snipped...]
>
> MySQL permits (but it's not standard, and available in MySQL 4.1.0
> and later):
>
> INSERT INTO my.table (somefield) VALUES ('$someval') ON DUPLICATE
> KEY UPDATE somefield = '$someval';
>
> This is very useful for times when you want to count some
(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Johan Wehtje wrote:
> This is probably obvious but I am not seeing what is going wrong with
> this function definition:
>
> CREATE OR REPLACE FUNCTION "public"."cproc_hli" (bgtemp NUMERIC,
> humidity NUMERIC, wspeed NUMERIC) RETURNS NUMERIC AS
> IF ($1 < 25)
> THEN
> SELECT (10.66 * (0.28 * $2)+(1.
s entirely,
but I'm not sure how to value that in this context.
Thanks in advance for and help/info/pointers.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAI
I am having an extremely difficult time restoring the backup.gz I have
on my Desktop.
I just completed my installation of PG 8 on my Windows XP Home
notebook. I tried using PGAdminIII to do the Restore, but for some
reason it doesn't want to work.
So, I tried using PSQL, but I'm still not h
1 - 100 of 226 matches
Mail list logo
