Hi,
Is anybody able to explain the following behaviour?
Server is 8.4.7 RHEL5 build. Also happens on 8.4.8 Ubuntu x64 package.
mr-russ=# SELECT 'BU'::varchar = ANY ((select '{BU,CI}'::varchar[]));
ERROR: operator does not exist: character varying = character varying[]
LINE 1: SELECT
On 23/06/10 02:16, Joshua D. Drake wrote:
On Tue, 2010-06-22 at 13:51 +, Greg Sabino Mullane wrote:
Is there any technical obstacle to anyone creating PL/PHP? I am
cruious as to why it doesn't alreay exist.
Obviously we need to improve our documentation. What led you to
Tom Lane wrote:
Vincenzo Romano vincenzo.rom...@notorand.it writes:
I tried this:
tmp1=# CREATE DOMAIN real as numeric;
[ and got confused between this domain and the built-in real ]
It looks like to me this is a bug and also the documentation seems to
confirm:
The domain
Aleksey Tsalolikhin wrote:
Hi. I just found pg_dump errors in my Apache httpd log and am really
confused. Has anybody seen this before?
My syslog.conf does not mention the httpd error_log.
How did the errors get in there?
# grep pg_dump /var/log/httpd/error_log
pg_dump: [archiver]
Yi Zhao wrote:
I want to select some column(a, b) from the table with the specified
condition, so, i can do like this:
select a, b from mytable where id = (select id from temptable where
tname = 'df' ) and stype = 'def' and range = 'afk'
How about;
SELECT a, b, count(1), sum(c) FROM
Craig Ringer wrote:
Hi
The crash occurs whether a file, system, or user DSN is being used.
I can reproduce this on two different machines. It happens with or
without SSL in use. It affects any Access 2007 database with a
PostgreSQL ODBC connection in use, including a newly created blank
rob wrote:
I am trying to build a small program with libpq as the interface to a
Postgre database. I am using the most current version. My program
uses malloc and free hooks to manage memory without having to request
memory from the system all the time. I expected that the init
function
, plpgsql and the like
for it.
Russell Smith
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Scott Marlowe wrote:
On Tue, Mar 11, 2008 at 7:33 PM, Justin [EMAIL PROTECTED] wrote:
I view updates/patches of any kind like this, if ain't broke don't fix it.
I normally only update computers with security patches only after i prove it
don't destroy installs.
But that's juast it.
that I can make indexes?
Regards
Russell Smith
---(end of broadcast)---
TIP 6: explain analyze is your friend
INTO SELECT type queries.
Is this possible or difficult? or has nobody had the inclination?
Thanks
Russell Smith
---(end of broadcast)---
TIP 6: explain analyze is your friend
get different results?
The timing may be better/worse than the results you got with hashagg off.
However it seems slightly less brute than trun hashagg off.
Regards
Russell Smith
---(end of broadcast)---
TIP 5: don't forget to increase your free
novice wrote:
I am trying to record the following entries into a table. I'm curious
to know if there's an efficient/effective way of doing this? This
entries come from an ancient datalogger (note: separated by space and
uses YY/MM/DD format to record date)
Plain file sample.dat
3665 OK
Erick Papadakis wrote:
Hello:
I am working on Windows and Unix with Postgresql (newbie, so please be
kind). I use phppgadmin on both platforms. Windows is my local
machine. Linux (CentOS as usual) is the cpanel thing that my hosting
provider offers.
Basically this setup works well and I am
of a big table was
done in multiple transactions you could reduce the effect of long
running vacuum. I'm not sure how this effects the rest of the system
thought.
Russell Smith
Bernd Helmle wrote:
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr [EMAIL
PROTECTED] wrote:
Either way. I like to create sql files with all of the DDL for creating
the view and rules.
Overtime, if I need to change my view or reconfigure the rules, I can edit
my sql file
a meaningful question...
foo bar
1 1
1 2
now, you are selecting foo, but you want to order by bar. What decision
should be made about which value of bar to pick, so you can order on it?
Regards
Russell Smith
Does anybody know how to remove duplicate rows from a subquery and order
Russell Smith
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
[EMAIL PROTECTED] wrote:
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I run
it i get the error:
ERROR: query SELECT 'INSERT INTO payment (
id,amount,accepted_date, company_id , date ,
, does the
vacuum remove all the tuples that are dead?
Is it possible to add logic for lazy vacuum that takes the lowest TID in
our database when not vacuuming shared catalogs? This may already be
the case, I don't know. Just putting forward suggestions.
Russell Smith
Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Tony Caduto wrote:
I did not have autovacuum turned on and I usually do a vacuumdb -z -a -f
-q each night but this one slipped through the cracks :-(
Strange -- autovacuum should have started an automatic
Tom Allison wrote:
Ran into a mystery that I can't seem to figure out
I want to authenticate using SSL for all external IP addresses that I
have in my subnet. I also want to be able to authenticate via non-SSL
for localhost (not unix socket).
I thought something like this would work:
Gregory S. Williamson wrote:
Dear list,
I have been banging my head against a problem for a few days now, and although
I am making progress it is painfully slow, and I am hoping that some one out
there can steer me in a better way.
I've got a medium size database (7.4), about 64 gigs of
the planer join the additional table *after* filtering? even
if it does first joining then filtering, why isn't the existing index
not used?
I would fix the above anomalies before asking these questions.
Regards
Russell Smith
---(end of broadcast
.
I know you can drop an recreate the view, but if the view has dependent
objects it becomes more difficult.
I'm currently running 8.1 when I say it's not possible.
Thanks
Russell Smith
---(end of broadcast)---
TIP 6: explain analyze is your
Tom Lane wrote:
Russell Smith [EMAIL PROTECTED] writes:
I got this error the other day, I was under the impression that vacuum could
get a concurrently updated tuple. I could be wrong. It is possible for
somebody to quickly explain this situation? Message follows;
vacuumdb
:
ERROR: tuple concurrently updated
Thanks
Russell Smith
---(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
Mary Adel wrote:
I am wondering how i can call stored procedure from php
If anyone can help it would great for me
Very small code snippet.
$sql = SELECT my_func('para');
$Result = pg_query($sql);
...
Regards
Russell Smith
---(end of broadcast
.
Regards
Russell Smith
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
to be different. I expected it to be owned by non_superuser.
Any comments welcome.
Russell Smith
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
somebody has put
pg-hier somewhere in the use flags.
Regards
Russell Smith
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Sat, 4 Jun 2005 09:25 am, Alvaro Herrera wrote:
On Fri, Jun 03, 2005 at 05:55:36PM -0500, Gerald D. Anderson wrote:
[snip]
I guess your build with the use flag wasn't successful. I think you
have two choices:
1. really build with the patch installed, and dump your data using that
for B+Tree's in implemented in PostgreSQL. It is used on index
creation, or reindex.
I don't believe it's in other places, but Others may have more to say.
Regards
Russell Smith.
Thank You
Regards
Surabhi Ahuja
---(end of broadcast)---
TIP
as the table bloats and can only
fix it with a vacuum full.
Both of these suggestions may be totally bogus. So I suppose I'm asking for
feedback on them to see if
they would be worthwhile implementing.
Regards
Russell Smith
---(end of broadcast
editing some
of the source code. I contacted Peter E about it and he said he would like into
it. I think you can run exec from both plperlu and plphpu. You may want to
look
into those to see if you can get what you want. They may even provide more
flexibility.
Regards
Russell Smith
Thank you
On Tue, 10 May 2005 07:41 pm, Julian Legeny wrote:
Hello,
I have following problem:
But I would like to sort all data as following:
NAME
---
AAA
aaa
BBB
bbb
CCC
ccc
How can I write sql command (or set up ORDER BY options) for selecting that?
On Mon, 9 May 2005 08:09 pm, ElayaRaja S wrote:
Hi,
Wrong Mailing list maybe? This is a PostgreSQL mailing list.
Regards
Russell Smith
I am using Redhat Linux 9 and I configure the samba server with
workgoup of my local
area network. when i tried to connect it was getting the error
On Fri, 6 May 2005 07:50 pm, CSN wrote:
I followed the new instructions (patch, autoconf,
configure --with-php=/usr/lib/apache/libphp5.so, etc.)
and get this error when running 'make':
make[3]: Entering directory
`/usr/local/src/postgresql-8.0.2/src/pl/plphp'
patching file php.h
It
version.
It includes my sample makefile, and the steps I went through.
Regards
Russell Smith
Thanks,
CSN
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
transactions
or so. If you do that, then there is not problem when the XID (Transaction ID)
wraps around.
Postgresql will know which transaction were in the past, and which were in the
future.
Regards
Russell Smith.
---(end of broadcast)---
TIP 9
also think there is often fault with the Gentoo user
attempting to bleed his system a little
too much for speed, without considering the stability or even understand it.
Regards
Russell Smith.
On Apr 19, 2005, at 1:01 AM, Tom Lane wrote:
Lorenzo Thurman [EMAIL PROTECTED] writes:
I'm
to ship libpq as a
seperate
tarball that you can compile without postgresql server?
Regards
Russell Smith
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
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 tunnel
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 record of type B must
On Fri, 11 Mar 2005 11:36 pm, Steven Verhoeven wrote:
Hi all
My table definition :
id | fref | mref
--+---+--
1 | 23| 25
2 | 24| 28
3 | 25| 31
4 | 26| 34
My problem :
i need a query that results in
for an
integer, or big integer. Then run a before trigger for each row. That
trigger will assign a value to the column based on the value given for
the type.
Regards
Russell Smith
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
with only getting a AccessShareLock?
Regards
Russell Smith
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Dear all,
There does not seems to be the latest version of the PostgreSQL documentation
online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from 7.4.6 - 7.4.7, and 8.0.0 - 8.0.1?
Should the site be updates?
Thanks
Russell Smith
On Sun, 13 Feb 2005 01:22 pm, Bruce Momjian wrote:
Russell Smith wrote:
Dear all,
There does not seems to be the latest version of the PostgreSQL
documentation online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from
On Sun, 13 Feb 2005 01:45 pm, Tom Lane wrote:
Bruce Momjian pgman@candle.pha.pa.us writes:
Russell Smith wrote:
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
If you want the changes to the server between releases see the Release
notes in the documentation.
I
,Third account
With 8.0.0 C local, SQL_ASCII Database, I get the expected output.
Regards
Russell Smith
---(end of broadcast)---
TIP 8: explain analyze is your friend
and
all go together.
Then when you update the function, it's all in one place.
Others may have better reasons for why they do it the way they do. But they
are mine.
Regards
Russell Smith.
---(end of broadcast)---
TIP 7: don't forget to increase your
is in the wrong place, I've been following the General
and Hackers discussions and decided to post now after
deleting the other posts.
Regards
Russell Smith.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
On Tue, 16 Nov 2004 08:01 pm, Joolz wrote:
Michael Glaesemann zei:
OIDS are a system level implementation. They are no longer required
(you can make tables without OIDS) and they may go away someday.
Out of curiosiry: how will we handle blobs once the OID's are gone?
I would guess
On Thu, 11 Nov 2004 03:31 am, Goutam Paruchuri wrote:
Hello,
I get an error in my log when connecting to postgres server on Windows.
Postgres version : 8.0.0-beta4
LOG TEXT
2004-11-10 11:22:47 LOG: invalid entry in file C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf at line
no type.
Regards
Russell Smith
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Thu, 28 Oct 2004 04:14 am, Eric wrote:
Is there something to interface postgreSQL with QMail to store mails in
pgsql instead of using mbox or maildir?
Or maybe it's not a good idea to do that?
I think there is some adavantages...
also look at http://www.dbmail.org/
On Sat, 30 Oct 2004 01:42 am, C G wrote:
Dear All,
I have a simple join query
SELECT c1 FROM t1
INNER JOIN
t2 ON t2.c2 = t1.c2 WHERE t3.c3= t2.c3;
Instead
SELECT c1 FROM t2, t1 INNER JOIN t2 ON t2.c2 = t1.c2 WHERE t3.c3=t2.c3
OR
SELECT c1 FROM t1 INNER JOIN t2 ON t2.c2 = t1.c2 JOIN
. So the kernel says out of
process space for that user.
Regards
Russell Smith
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
: postgres
sqlfilter 10.0.0.5 idle in transaction
Should VACUUM report the rows as deleted or say they could not be deleted?
Why does it report the same information for three runs in a row?
Or is something else going on that I don't understand.
Regards
Russell Smith
sqlfilter=# vacuum verbose
On Sat, 2 Oct 2004 12:42 am, Tom Lane wrote:
Russell Smith [EMAIL PROTECTED] writes:
Should VACUUM report the rows as deleted or say they could not be deleted?
Why does it report the same information for three runs in a row?
I see no pending deletions in that vacuum output:
DETAIL: 0
On Wed, 29 Sep 2004 08:16 am, Jerry LeVan wrote:
I have an srf sql function annual_report(year) that
as 14 columns, a category, 12 month numeric columns, and a total
numeric column.
The function finds monthly totals for each category (which is the
target of order by)
and the grand total
CREATE SEQUENCE acls_bannerid_seq start 1 increment 1 maxvalue 2147483647
minvalue 1 cache 1 ;
This is designed to be sent to psql, which understands \connect.
phpPgadmin does not. I would suggest restoring using psql.
Regards
Russell Smith
---(end of broadcast
63 matches
Mail list logo