Craig Ringer wrote:
If I'm wrong about any of this (which is not unlikely, really) then if
anyone else is "lucky" enough to be using Access with PostgreSQL and
knows of a better solution or workaround, please feel free to correct me.
We have been working with the combination of a PostgreSQL ba
Adam Rich wrote:
Now user Ben has passed his mobile to user Josh and we issued Josh his
mobile on 2008-10-15.
1. Is it possible for me to write a query that will have the fields
call.call_id,
call.datetime,
mobile_custodian.user_id,
call.mobile_no
call.charge
that will use call.datetime and lo
Oh!
I have got the mistake made by me. Actually I didn't start the PostgreSQL
Scheduling Agent - pgAgent service. Now its working fine.
I also have attached the complete document of my work for the sake of knowledge
share.
Regards,
Abdul Rehman.
David wrote:
I am unable to solve the following problem.
When I start or stop PostgreSQL using pg_ctl (without the -D option) the
system works fine. No errors. I have the PGDATA environment variable
set and it points to my cluster.
When I run the /etc/init.d/postgresql-8.2 script with either o
What is the error message you are getting. Can you pass the bat file or sql
file.
Date: Wed, 19 Nov 2008 04:14:00 -0800From: [EMAIL PROTECTED]: [ADMIN]
Scheduling backup via PgAgentTo: [EMAIL PROTECTED]: pgsql-general@postgresql.org
Dear all,After installing PgAgent I have successfully crea
I am unable to solve the following problem.
When I start or stop PostgreSQL using pg_ctl (without the -D option) the
system works fine. No errors. I have the PGDATA environment variable
set and it points to my cluster.
When I run the /etc/init.d/postgresql-8.2 script with either of "stop"
or "st
Joshua D. Drake wrote:
> On Wed, 2008-11-19 at 18:40 +0900, Craig Ringer wrote:
>> Phoenix Kiula wrote:
>>
>>> I have googled but it looks like there's a whole variety of
>>> information from 2003 (when PG must have been quite different) until
>>> now--some people find stored functions slow for web
On Thu, 2008-11-20 at 15:41 +1100, novice wrote:
> omg - how embarrassing.
> so sorry :(
>
I note your name is novice.
Don't sweat it. We are here to help.
Joshua D. Drake
--
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
> >> sorry I get nothing :(
> >
> > Of course not. None of the dates you gave in the example overlap.
> >
>
> But it should still have the 1st entry with the name Ben? Am I
> missing something?
Ben's issue dates are in the year 2008. The first call entry is
in the year 2007. There are no cust
omg - how embarrassing.
so sorry :(
2008/11/20 brian <[EMAIL PROTECTED]>:
> novice wrote:
>>
>> 2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
>>>
>>> On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]>
>>> wrote:
sorry I get nothing :(
>>>
>>> Of course not. None of
novice wrote:
2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
sorry I get nothing :(
Of course not. None of the dates you gave in the example overlap.
But it should still have the 1st entry with the name Ben? Am
2008/11/20 Rodrigo E. De León Plicet <[EMAIL PROTECTED]>:
> On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
>> sorry I get nothing :(
>
> Of course not. None of the dates you gave in the example overlap.
>
But it should still have the 1st entry with the name Ben? Am I
missing
On Wed, Nov 19, 2008 at 10:03 PM, novice <[EMAIL PROTECTED]> wrote:
> sorry I get nothing :(
Of course not. None of the dates you gave in the example overlap.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
2008/11/20 brian <[EMAIL PROTECTED]>:
> novice wrote:
>>
>> 2008/11/20 Adam Rich <[EMAIL PROTECTED]>:
>>>
>>> select call.call_id,
>>> call.datetime,
>>> mobile_custodian.user_id,
>>> call.mobile_no
>>> call.charge
>>> from call, mobile_custodian
>>> where call.mobile_no = mobile_custodian.mobi
novice wrote:
2008/11/20 Adam Rich <[EMAIL PROTECTED]>:
select call.call_id,
call.datetime,
mobile_custodian.user_id,
call.mobile_no
call.charge
from call, mobile_custodian
where call.mobile_no = mobile_custodian.mobile_no
and call.datetime between mobile_custodian.issue_date
and mob
2008/11/20 Adam Rich <[EMAIL PROTECTED]>:
>> Now user Ben has passed his mobile to user Josh and we issued Josh his
>> mobile on 2008-10-15.
>>
>> 1. Is it possible for me to write a query that will have the fields
>>
>> call.call_id,
>> call.datetime,
>> mobile_custodian.user_id,
>> call.mobile_no
> Now user Ben has passed his mobile to user Josh and we issued Josh his
> mobile on 2008-10-15.
>
> 1. Is it possible for me to write a query that will have the fields
>
> call.call_id,
> call.datetime,
> mobile_custodian.user_id,
> call.mobile_no
> call.charge
>
> that will use call.datetime a
Hi,
We have two tables.
select * from
mobile_custodian;
custodian_id | user_id | issue_date | return_date | mobile_no
--+-++-+-
4 | Ben | 2008-10-11 | 2008-10-13 | 09455225998
5 |Josh | 2008-10-15 |
Hi,
Sorry I was out and late to find your report.
Lesslog replaces full page write to corresponding incremental log to
decrease the size and so you should turn full_page_writes "on" for
lesslog to work.
Did you specify "pg_decpmpresslog" as restore command? If so, I don't
see anything missing s
Sam Mason wrote:
The custom aggregate sounds the
most elegant, it's just annoying that it's so much fiddling to get it
all working to start with
Thanks.
I think I wrote it, but there's something I don't get from the docs: do
I have to call
get_call_result_type(fcinfo, NULL, &tupdesc)
every
Craig Ringer wrote:
Howard Cole wrote:
Unfortunately I am on a windows platform. Plus I am running windows
software raid so there is little tweaking allowed.
Don't write the possibility off too quickly. The driver may well accept
parameters for readahead settings etc, either through a
I'm just starting to investigate a problem where it seems data stored
in a variable from one invocation of a function is bleeding over to
the next invocation. For example, in a PL/PerlU function I'm getting
the table name with
my $table = $_TD->{relname}
and immediately print it out and all se
I'm trying to use prepared statements in an application and I'm
running into this error: "Query failed: prepared statement already
exists".
The reason is obvious. What I want to know is the best way to avoid
getting this error. The client application sets statement names as MD5
of the actual query
On Wed, 2008-11-19 at 18:40 +0900, Craig Ringer wrote:
> Phoenix Kiula wrote:
>
> > I have googled but it looks like there's a whole variety of
> > information from 2003 (when PG must have been quite different) until
> > now--some people find stored functions slow for web based apps, others
> > fi
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <[EMAIL PROTECTED]> writes:
> On Wed, 2008-11-19 at 13:54 +, Grzegorz JaÅkiewicz wrote:
>> change loging level to debug1 in postgresql.conf, it will log
>> statements.
> Why not just setting log_statement to all? (or whatever)
I think the least verbose way
On Wed, Nov 19, 2008 at 1:08 PM, Joshua D. Drake <[EMAIL PROTECTED]>wrote:
> On Wed, 2008-11-19 at 17:19 +0200, Devrim GÜNDÜZ wrote:
> > On Wed, 2008-11-19 at 08:35 -0500, Josh Harrison wrote:
> > > If so can you direct me to "the" website?
>
> Just a tip... 8.4 isn't released... it isn't even bet
"Sabin Coanda" <[EMAIL PROTECTED]> writes:
> I backup the database plain with the command:
> pg_dump.exe -U postgres -F p -v -f "backup_plain.sql" "DemoDB"
> I create a new database, and I run the script. But it rise me the error:
> ERROR: syntax error at or near "1"
> LINE 49: 1 -- any text
On Wed, 2008-11-19 at 17:19 +0200, Devrim GÜNDÜZ wrote:
> On Wed, 2008-11-19 at 08:35 -0500, Josh Harrison wrote:
> > If so can you direct me to "the" website?
Just a tip... 8.4 isn't released... it isn't even beta yet.
>
> Here is yesterday's snapshot:
>
> http://yum.pgsqlrpms.org/srpms/8.4/po
On Wed, Nov 19, 2008 at 10:10:08AM -0600, Scara Maccai wrote:
> Sam Mason wrote:
> >Do you really want the SUM of num1 and num2, because that makes it more
> >fiddly and would be where having MAX accept a record/tuple would be
> >best. If you don't, maybe something like:
> >
> > SELECT DISTINCT O
On 18 Nov., 07:40, [EMAIL PROTECTED] (Craig Ringer) wrote:
> -- Once paths is populated, extract duplicates:
>
> SELECT get_filename(path) AS fn, count(path) AS n
> FROM paths HAVING count(path) > 1
> INTO TEMPORARY TABLE dup_files;
>
> -- Creates UNIQUE index on PATH as well
> ALTER TABLE dup_fil
Sam Mason wrote:
Do you really want the SUM of num1 and num2, because that makes it more
fiddly and would be where having MAX accept a record/tuple would be
best. If you don't, maybe something like:
SELECT DISTINCT ON (date_trunc('day', mydate))
date_trunc('day', mydate), num, num1+num2
On Wed, Nov 19, 2008 at 3:51 PM, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote:
> On Wed, 2008-11-19 at 13:54 +, Grzegorz Jaśkiewicz wrote:
> > change loging level to debug1 in postgresql.conf, it will log
> > statements.
>
> Why not just setting log_statement to all? (or whatever)
there's probabl
On Wed, Nov 19, 2008 at 09:35:34AM -0600, Scara Maccai wrote:
> Well you guys are right; the problem is that the query is actually more
> complex, I tried to simplify it for the question, but ended up with a
> trivial question...
always a problem with simplification, I've done the same far too o
On Wed, 2008-11-19 at 13:54 +, Grzegorz Jaśkiewicz wrote:
> change loging level to debug1 in postgresql.conf, it will log
> statements.
Why not just setting log_statement to all? (or whatever)
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
On Wed, Nov 19, 2008 at 6:28 AM, Josh Harrison <[EMAIL PROTECTED]> wrote:
> Hi
> Is version 8.4 available for download now ? If so can you direct me to he
> website?
There's a daily snapshot available for download off the main dl tree.
Go to the download page and look for the link to browse the mi
Sam Mason wrote:
Why not just do:
SELECT * FROM mytab
ORDER BY num, mydate
LIMIT 1;
If you're trying to do more complicated things, DISTINCT ON may be more
useful.
Well you guys are right; the problem is that the query is actually more
complex, I tried to simplify it for the questio
On Wed, Nov 19, 2008 at 08:47:57AM -0600, Scara Maccai wrote:
> CREATE TABLE mytab
> (
> num integer,
> mydate timestamp
> );
>
> and I want to find MAX(num) and the "mydate" where it first happened.
>
> I guess I could use
>
> select * from mytab where num = (select MAX(num) from mytab)
Hi Scara,
This should work just fine:
select num, min(mydate) from mytab group by num order by num desc limit
1;
If you have an index on 'num' it will also be fast.
Cheers,
Csaba.
On Wed, 2008-11-19 at 08:47 -0600, Scara Maccai wrote:
> Hi all,
>
> suppose I have a table like:
>
> CREATE TAB
On Wed, 2008-11-19 at 08:35 -0500, Josh Harrison wrote:
> If so can you direct me to "the" website?
Here is yesterday's snapshot:
http://yum.pgsqlrpms.org/srpms/8.4/postgresql-8.4devel_20081118.tar.bz2
and its md5 sum:
http://yum.pgsqlrpms.org/srpms/8.4/postgresql-8.4devel_20081118.tar.bz2.md5
Erwin Moller schreef:
Craig Ringer schreef:
Erwin Moller wrote:
No, that is not the kind of chicken I was talking about. ;-)
My chicken is more along these lines:
I often have some tables to which everything is related (eg
tblcourse that contains everything belonging to a certain course).
I d
Hi Pavel,
Thanks for that.
But I already wrote a nice extension to my DB-class in PHP that uses
Thomas Kellerer's approach.
It was simple once you know how to retrieve the info from the
systemtables. :-)
Regards,
Erwin Moller
Pavel Stehule schreef:
Hello
I used this code
CREATE OR REPLAC
Hi all,
suppose I have a table like:
CREATE TABLE mytab
(
num integer,
mydate timestamp
);
and I want to find MAX(num) and the "mydate" where it first happened.
I guess I could use
select * from mytab where num = (select MAX(num) from mytab) order by
mydate limit 1;
but that would sc
Craig Ringer schreef:
Erwin Moller wrote:
No, that is not the kind of chicken I was talking about. ;-)
My chicken is more along these lines:
I often have some tables to which everything is related (eg tblcourse
that contains everything belonging to a certain course).
I don't want to make a sin
On Wed, Nov 19, 2008 at 06:40:04PM +0900, Craig Ringer wrote:
> What you really
> want is "Ensure that the form info is in the database and up to date",
> ie an UPSERT / REPLACE. There's a fairly convenient way to do that:
>
> -- If the form is already there, update it.
> -- If it's not there, t
On Wed, Nov 19, 2008 at 12:50:23PM +0200, Andrus wrote:
> Sam,
> > SELECT MAX(nullif(regexp_replace(test, '^([0-9]*).*$', E'\\1'),'')::INT);
>
> Thank you.
> This seems to work but is bit slow.
It will have to be executed against every row before you get an answer,
so if you're just after the max
change loging level to debug1 in postgresql.conf, it will log statements.
you don't have to reboot postgres for that - just reload it (either pg_ctl
reload - as opstgres user, or /etc/init.d/postgres reload).
Gustavo Rosso escribió:
> This error give me to load a file into postgres:
> ERROR: invalid byte sequence for encoding "UTF8": 0xa4
>
> I must force load data.
> How must to do?
Set client_encoding to latin1 (or latin9). How you do this is
client-dependent.
Note that you can post questions in s
I can't find what's the statement causing this warning:
2008-11-19 14:45:34 CET WARNING: nonstandard use of \\ in a string
literal at character 32 2008-11-19 14:45:34 CET HINT: Use the
escape string syntax for backslashes, e.g., E'\\'.
I mean... I know how to fix it... but how can I find the st
This error give me to load a file into postgres:
ERROR: invalid byte sequence for encoding "UTF8": 0xa4
I must force load data.
How must to do?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
2008/11/19 Josh Harrison <[EMAIL PROTECTED]>
> Thanks GJ for the 'he' information. It was just a typo.
> If so can you direct me to "the" website?
hope you don't feel offended by the joke. :P
postgresql.org is a general place. If you need to test devel release (cvs
head),
you have to be careful
Thanks GJ for the 'he' information. It was just a typo.
If so can you direct me to "the" website?
-Josh
On Wed, Nov 19, 2008 at 8:33 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>wrote:
> "he" is still in the making, so there's no 8.4 release as such yet.
> "You" have to wait, for "he" will come. ;)
"he" is still in the making, so there's no 8.4 release as such yet.
"You" have to wait, for "he" will come. ;)
--
GJ
Hi
Is version 8.4 available for download now ? If so can you direct me to he
website?
Thanks
Josh
Dear all,
After installing PgAgent I have successfully created a job for auto scheduled
backup. But it is not working. I have tried both method i.e. via .bat and via
SQL. Kindly guide me and give chance to pay thanks.
Regards,
Abdul Rehman
Output:
teste=# \d cliente_fone
Table "cadastro.cliente_fone"
Column |Type | Modifiers
+ -+
cfon_id| integer
Hi,
I have "PostgreSQL 8.3.5, compiled by Visual C++ build 1400" on Windows OS.
I try to use the COPY command to optimize the backup/restore performance,
but I found a problem. I reproduce it below.
I create a database with a simple table:
CREATE TABLE "A"
(
"Col1" integer NOT NULL,
Sam,
Maybe something like:
SELECT MAX(nullif(regexp_replace(test, '^([0-9]*).*$', E'\\1'),'')::INT);
Thank you.
This seems to work but is bit slow.
How to speed it up ?
Should I create index
CREATE INDEX test ON test ( nullif(regexp_replace(test, '^([0-9]*).*$',
E'\\1'),'')::INT );
?
On 19/11/2008 10:57, Andy Greensted wrote:
> - Is there anyway to run a newer version (8.3.5) of psql in some sort of
> 'backwards compatible' mode?
Newer versions of pg_dump are usually able to dump data from older PG
versions, so in theory you ought to be able to suck your data from the
old DB
Hi All,
I need to connect to a version 7.1 PostgreSQL database. Unfortunately, I
cannot get the 7.1.3 source to compile. configure gives this error:
checking types of arguments for accept()... configure: error: could not
determine argument types
I'm not posting to pgsql-bugs because I think thi
On 19/11/2008 10:01, Phoenix Kiula wrote:
> I am in psql. I tried "\dd" but this lists pg_catalog and stuff like
> that. Long list that I don't need.
You can add a pattern to \df, so if your functions are in the public
schema then do:
\df public.*
HTH,
Ray.
Hello
try
\df+ your_fce_name
regards
Pavel Stehule
p.s. \? show help
2008/11/19 Phoenix Kiula <[EMAIL PROTECTED]>:
> I am in psql. I tried "\dd" but this lists pg_catalog and stuff like
> that. Long list that I don't need.
>
> I scoured through this page --
> http://www.postgresql.org/docs/8.3
I am in psql. I tried "\dd" but this lists pg_catalog and stuff like
that. Long list that I don't need.
I scoured through this page --
http://www.postgresql.org/docs/8.3/static/app-psql.html -- and still
did not find how to list only my own functions? A regular "\d" shows
only tables and views it
I'd like to get my postgresql logging sent to the file
/var/log/postgresql.log, and have that file rotated to
postgresql.log.0.gz etc.
my postgresql.conf says
log_destination = 'stderr,syslog'
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
but the messages goes into /var/log/messages.
Does
Phoenix Kiula wrote:
I have googled but it looks like there's a whole variety of
information from 2003 (when PG must have been quite different) until
now--some people find stored functions slow for web based apps, others
find it is worth the maintenance.
If your web servers are very close in n
Erwin Moller wrote:
No, that is not the kind of chicken I was talking about. ;-)
My chicken is more along these lines:
I often have some tables to which everything is related (eg tblcourse
that contains everything belonging to a certain course).
I don't want to make a single simple mistake that
Are there any known issues with pg_standby in linking mode with the WAL
source on a read only filesystem?Everything works as expected until I
touch the trigger file. When it is in copy mode everything works
perfectly.
LOG: archive recovery complete
PANIC: could not open file "pg_xlog/0
66 matches
Mail list logo
