On Oct 11, 2012, at 4:48 PM, Ken Tanzer wrote:
> Hi. I recently ran a query that generate the same error as this:
>
> SELECT * FROM generate_series(1,10) ORDER BY 'foo';
> ERROR: non-integer constant in ORDER BY
> LINE 1: SELECT * FROM generate_series(1,10) ORDER BY 'foo';
>
> The query was g
On Sep 4, 2012, at 4:30 PM, Aram Fingal wrote:
>
> On Sep 4, 2012, at 4:18 PM, Misa Simic wrote:
>
>> Inside PL/R you can take the same table as it is (unpivoted) as your
>> data.frame and then pivot it inside R using reshape package,,, And then
>> inside PL/R function do whatever you would l
On Jan 30, 2012, at 2:40 PM, Scott Frankel wrote:
>
> Hi all,
>
> What's the best/correct way to cause the PostgreSQL server to startup
> automatically when rebooting on OSX 10.7 Lion?
>
> I'm using a macports install of postgres 8.4 and went through a couple
> grueling days, sudo'd up to
On Jan 18, 2012, at 2:15 PM, Scott Marlowe wrote:
> On Wed, Jan 18, 2012 at 11:21 AM, Igor Polishchuk
> wrote:
>> Here is an article on a recently discovered Oracle flaw, which allows SCN to
>> reach its limit.
>> http://www.computerworld.com/s/article/9223506/Fundamental_Oracle_flaw_revea
>> l
On Jan 18, 2012, at 12:25 PM, salah jubeh wrote:
> Hello,
>
> Thanks for the info, I have already solved this by writing the following
> function. Also, i think it is better than changing the schema tables directly
>
> Regards
>
It doesn't look like the procedure handles grant options (W
On Jan 18, 2012, at 8:48 AM, salah jubeh wrote:
> Hello,
>
> I have create a table from another table such as
>
> CREATE TABLE tmp_XXX AS SELECT * FROM XXX;
>
>
> The tmp_XXX tables has no permissions assigned to it and I want to assign
> it with the same owner and access privileges o
On Jun 30, 2011, at 2:40 PM, Dmitry Koterov wrote:
> Hello.
>
> I need to create an auto-increment field on a table WITHOUT using sequences:
This problem pops up a lot for invoice sequence numbers for the tax office and
related cases. (Search for "gapless sequence".)
Since the numbers are re
On Mar 29, 2011, at 10:18 AM, hook wrote:
> I have a simple table with a varchar(32) field that I am trying to extract
> data using regular expressions.
>
> select * from spam where inetaddr like '100.%'
> row | inetaddr | tdate
> --+--+-
On Feb 15, 2011, at 12:25 PM, Carlos Mennens wrote:
> I'm trying to figure out how I can have users in the office connect
> their Microsoft Office 2007 clients to our company database server
> running PostgreSQL 8.4.7. I've configured PostgreSQL to accept
> incoming connections and allow users to
On Jan 24, 2011, at 10:50 AM, Fredric Fredricson wrote:
> I have been fighting with a select and can find no satisfactory solution.
>
> Simplified version of the problem:
>
> A table that, in reality, log state changes to an object (represented as a
> row in another table):
>
> CREATE TABLE t
On Jan 19, 2011, at 5:36 PM, Kevin Grittner wrote:
> "A.M." wrote:
>
>> Most PLs include some session-specific storage. In PL/Perl, it is
>> %_SHARED. Setting a flag there should do the trick. If you are
>> using a PL which does not have such a notion (like
On Jan 19, 2011, at 4:59 PM, Kevin Grittner wrote:
> We've been running for about ten years on a framework which fires
> triggers similar to database triggers in a Java tier close to the
> database, and we're now trying to convert these to actual PostgreSQL
> database triggers. Our biggest hitch
Hello,
The following statement replaces an asterisk in a string with a double-escaped
asterisk:
SELECT regexp_replace('*',E'\\*',E'\*');
I got this result through experimentation and I am at a loss to explain why so
much escaping is necessary for the third argument. Is there a better wa
Hello,
In an attempt to implement ACLs at the application layer (for resources stored
outside of the database), I am evaluating using aclitem[] as a column type. All
the functions I would need seem to be in place: aclcontains, aclexplode,
aclinsert, aclitemeq, aclitemin, aclitemout, aclremove,
On Jan 6, 2011, at 3:52 AM, Stuart Bishop wrote:
> Maybe I should start a business in providing UUID collision insurance?
Your ideas are intriguing to me and I wish to subscribe to your newsletter.
-M
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
On Dec 21, 2010, at 5:06 PM, Merlin Moncure wrote:
> A postgresql based game, that you can play from psql! Written by Abstrct
> (Josh)
>
> http://www.schemaverse.com/
Finally, a game which makes it look like I am doing work!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
On Nov 17, 2010, at 11:32 AM, Ivan Voras wrote:
> On 11/17/10 02:55, Josh Berkus wrote:
>>
>>> If you do wish to have the data tossed out for no good reason every so
>>> often, then there ought to be a separate attribute to control that. I'm
>>> really having trouble seeing how such behavior wo
On Oct 28, 2010, at 12:04 PM, Daniel Verite wrote:
> A.M. wrote:
>
>> In PostgreSQL, query canceling is implemented by opening a
>> second connection and passing specific data which is received
>> from the first connection
>
> With libpq's PQCancel(), a
On Oct 28, 2010, at 11:08 AM, Michael Clark wrote:
> Hello all.
>
> Thanks a lot for the responses, they are appreciated.
>
> I think I now understand the folly of my loop, and how that was negatively
> impacting my "test".
>
> I tried the suggestion Alex and Tom made to change my loop with a
On Oct 20, 2010, at 7:44 PM, Gabi Julien wrote:
> Hi,
>
> Here is my problem: I have a postgresql C function that looks like this:
>
> Datum filter(PG_FUNCTION_ARGS);
>
> It takes identifiers and queries a bunch of tables and ends up returning true
> or false. So far nothing difficult except
On Oct 7, 2010, at 5:34 AM, Devrim GÜNDÜZ wrote:
> On Thu, 2010-10-07 at 12:23 +0300, Peter Eisentraut wrote:
>> This is really something that psycopg2 should work out for you. I
>> suggest you take up a discussion on this on their mailing list.
>
> ...which is down over the last 3 weeks or so:
I found some surprising behavior with the new EXCLUDE constraint in 9.0.0- it
seems that EXCLUDE constraint names have to be unique across tables:
test=# BEGIN;
BEGIN
test=# CREATE TABLE a(a INTEGER);
CREATE TABLE
test=# CREATE TABLE b(b INTEGER);
CREATE TABLE
test=# ALTER TABLE a ADD CONSTRAINT
On Sep 9, 2010, at 8:31 PM, Jeff Davis wrote:
> On Thu, 2010-09-09 at 17:07 -0400, A.M. wrote:
>> Is there a technical limitation which prevents DO from being used in rules
>> or am I missing something with this?
>>
>> CREATE RULE test_update AS ON U
Is there a technical limitation which prevents DO from being used in rules or
am I missing something with this?
CREATE RULE test_update AS ON UPDATE TO test DO INSTEAD DO $$
BEGIN;
I am experimenting with exclusion constraints via Depesz's excellent
introduction here:
http://www.depesz.com/index.php/2010/01/03/waiting-for-8-5-exclusion-constraints/
In the example, he uses non-overlapping (day) dates for hotel booking. In my
case, I would like to use the same datatype but
On Aug 25, 2010, at 11:31 AM, Joshua D. Drake wrote:
> On Wed, 2010-08-25 at 11:15 -0400, A.M. wrote:
>> I am using pgsql9.0b4 (but pgsql8.4 exhibits the same behavior) on MacOS
>> 10.6.4 and initdb fails:
>> initdb: removing data directory "/Volumes/Data/pgsql90b"
I am using pgsql9.0b4 (but pgsql8.4 exhibits the same behavior) on MacOS 10.6.4
and initdb fails:
/usr/local/pgsql90beta/bin/initdb -D /Volumes/Data/pgsql90b/ -E UTF8
The files belonging to this database system will be owned by user "agentm".
This user must also own the server process.
The datab
On Aug 23, 2010, at 10:18 PM, Craig Ringer wrote:
> On 08/24/2010 06:43 AM, Bruce Momjian wrote:
>> A.M. wrote:
>>> There is a new pg_notify function in pgsql 9.0 but no pg_listen
>>> equivalent? Why? It sure would be handy to pass quoted strings...
>>
>>
There is a new pg_notify function in pgsql 9.0 but no pg_listen equivalent?
Why? It sure would be handy to pass quoted strings...
Cheers,
M
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
I have encountered an odd behavior involving rules which the following script
demonstrates (in postgresql 8.4.3). Note that at the end of the run, the "dud"
table contains one row "spam1" when the update rule clearly contains two
inserts to the "dud" table. It seems that the update rule
On Jun 23, 2010, at 6:01 PM, A.M. wrote:
> Hello,
>
> I am trying to make a query which will flatten pg_auth_members into a table
> with two columns "user" and "group" which will recurse inherited roles so
> that each login role is associated once with a
Hello,
I am trying to make a query which will flatten pg_auth_members into a table
with two columns "user" and "group" which will recurse inherited roles so that
each login role is associated once with any inherited roles (assuming all
associated roles are inherited).
This query does not do wh
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Apr 10, 2009, at 10:15 AM, Justin Funk wrote:
Team Amazing,
I am building a massive database for storing the syslogs of a room of
servers. The database gets about 25 million entries a day, and need
to keep
them for 180 days. So the total siz
On Mar 12, 2009, at 5:50 PM, James B. Byrne wrote:
...
and c.date_effective_from >=
and c.date_superseded_after <=
Have I understood things aright?
The one problem I foresee is that changes to the commodity_tax_rates
table may not reflect in transaction dates that have passed. What
On Feb 5, 2009, at 6:08 AM, Greg Stark wrote:
On Wed, Feb 4, 2009 at 6:42 PM, Simon Riggs
wrote:
As A.M. says elsewhere, it would be good to have a trigger that
fired a
NOTIFY that was picked up by a scheduled job that LISTENs every 10
minutes for certain events.
We need a place for
On Feb 3, 2009, at 11:55 PM, Guy Rouillier wrote:
Craig Ringer wrote:
An internal job scheduler with the ability to fire jobs on certain
events as well as on a fixed schedule could be particularly handy
in conjunction with true stored procedures that could explicitly
manage transactions.
On Nov 4, 2008, at 4:14 PM, Tom Lane wrote:
Tom Allison <[EMAIL PROTECTED]> writes:
I tried getting a source install on my mac book yesterday and today.
It's not a normal *nix installation. The location of the files are
all
non-standard.
'make' is prefixed by /Developer/usr/bin/.
The que
On Jul 23, 2008, at 2:19 PM, [EMAIL PROTECTED] wrote:
> 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 PROTE
On May 12, 2008, at 4:02 PM, Chris Saldanha wrote:
Hi,
We'd like to ship PostgreSQL as part of a product that runs on both
PPC and
Intel Macs, but the database files are tied to the build settings and
endianness of the computer that the database was initialized on.
Is there any way to caus
On Feb 22, 2008, at 10:16 AM, Martijn van Oosterhout wrote:
On Thu, Feb 21, 2008 at 11:14:58AM -0800, Jeff Davis wrote:
I have looked for a standard related to the locale behavior and I was
surprised that I couldn't find one. Is a given locale, e.g. en_US,
supposed to have identical behavior o
On Feb 21, 2008, at 12:01 PM, Tom Lane wrote:
Pascal Cohen <[EMAIL PROTECTED]> writes:
The fact is that works on Linux and win but under Mac I always get
the
ordering with 'default' C locale (I displayed all the lc_* and all
are
right set)
Yeah, this has been complained of before, eg her
On Feb 21, 2008, at 10:20 AM, Terry Lee Tucker wrote:
Greetings:
We have been working diligently toward integrating Slony into our
production
databases. We've been having trouble with various tables, although
being
replicated perfectly in the initial replication stage, afterwards,
gettin
On Jan 29, 2008, at 2:36 PM, Andrew Sullivan wrote:
On Tue, Jan 29, 2008 at 01:56:35PM -0500, A.M. wrote:
The postgresql from eight years ago is also quite rusty.
No, it's not, which is my point. If you don't need any of the
features you
mention, and are aware of the l
On Jan 29, 2008, at 1:07 PM, Andrew Sullivan wrote:
On Tue, Jan 29, 2008 at 08:14:28AM -0800, David Fetter wrote:
I wouldn't trust that library or anything that depends on it if I
were
you. It's been unmaintained for a *very* long time.
Because code rusts when it's sitting around on a h
On Dec 6, 2007, at 2:22 PM, Weber, Geoffrey M. wrote:
I've been trying for quite a while to get Postgresql tuned for use
as an OLTP system. I have several PL/pgSQL functions that handle
inserts and updates to the main table and several near-real-time
daemons written that access the data a
On Dec 3, 2007, at 4:16 PM, Brian Wipf wrote:
We have a dual 3.0 GHz Intel Dual-core Xserve, running Mac OS X
10.5.1 Leopard Server and PostgreSQL 8.2.5. When we disconnect
several clients at a time (30+) in production, the CPU goes through
the roof and the server will hang for many second
On Nov 14, 2007, at 4:23 PM, Scott Marlowe wrote:
On Nov 14, 2007 2:40 PM, madhtr <[EMAIL PROTECTED]> wrote:
Quick question, are there any native functions in PostGreSQL 8.1.4
that will
strip HTML tags, escape chars, etc?
I can't think of a lot of native functions, but it's sure easy enoug
On Sep 6, 2007, at 21:10 , Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
The PostgreSQL Conference Fall 2007 is shaping up nicely. We are now
seeking more speakers. Here is the current lineup:
What's the difference between the conference groups at http://
www.
On Sep 5, 2007, at 18:57 , Liam Slusser wrote:
I've been trying to replicate a database but each time I
replication it the
performance of the copy is about 100 times slower (~100ms to ~8
seconds for
the same query). The only way I have found to replicate it and
keep the
same performanc
: could not receive data from client: An operation
was attempted on something that is not a socket.
2007-08-19 03:33:34 LOG: incomplete startup packet
Thanks
- Original Message -
From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
To: "Muhyiddin A.M Hayat&quo
Dear all,
i'm unable to connect postgres server with error :
C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres siakad
Password for user postgres:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the
Dear all,
i'm unable to connect postgres server with error :
C:\Program Files\PostgreSQL\8.2\bin>psql -U postgres siakad
Password for user postgres:
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the
On Aug 15, 2007, at 13:27 , Naz Gassiep wrote:
Hi all,
I am still, after quite some time, wrangling over the time zone
system in my app. I have sorted out all the internal handling,
however I am still uncertain as to what the best way to get the
user to select their time zone is.
Hi,
I have a CMS where I display the timezone for international meeting
dates. I store the dates as follows:
startdate | timestamp with timezone
timezonename | text
This works fine until I hit daylight-savings time when the name of
the timezone changes. So, given a "timestamp with timezone
On Jul 5, 2007, at 13:20 , Andrew Sullivan wrote:
On Sun, Jul 01, 2007 at 11:11:30PM +0200, Alexander Todorov wrote:
The question was is there something else that exists in PostgreSQL
and
will do the same job.
Why re-invent the wheel, and make it square? But also, if you don't
care whethe
On May 24, 2007, at 20:39 , Andrew Sullivan wrote:
On Thu, May 24, 2007 at 03:25:52PM -0400, A.M. wrote:
Wouldn't it be a cool feature to persists transaction states
across connections so that a new connection could get access to a
sub-
transaction state?
You could do this usi
On May 24, 2007, at 18:21 , Chris Browne wrote:
Jan Wieck had a proposal to a similar effect, namely to give some way
to get one connection to duplicate the state of another one.
This would permit doing a neat parallel decomposition of pg_dump: you
could do a 4-way parallelization of it that w
On May 24, 2007, at 18:12 , PFC wrote:
Indeed. Wouldn't it be a cool feature to persists transaction states
across connections so that a new connection could get access to a
sub-
transaction state? That way, you could make your schema changes and
test them with any number of test clients (
On May 24, 2007, at 15:57 , Alvaro Herrera wrote:
A.M. wrote:
Indeed. Wouldn't it be a cool feature to persists transaction states
across connections so that a new connection could get access to a
sub-
transaction state? That way, you could make your schema changes and
test them wit
On May 24, 2007, at 14:29 , Wiebe Cazemier wrote:
On Thursday 24 May 2007 17:30, Alexander Staubo wrote:
[2] Nobody else has this, I believe, except possibly Ingres and
NonStop SQL. This means you can do a "begin transaction", then issue
"create table", "alter table", etc. ad nauseum, and in
On Mar 29, 2007, at 10:47 , Jasbinder Singh Bali wrote:
Hi,
I've written a function using cursors as follows:
can anyone please comment on the text in red.
--
CREATE OR REPLACE FUNCTION sp_insert_tbl_email_address(int4, text,
text, text)
On Mar 16, 2007, at 10:54 , Jasbinder Singh Bali wrote:
just wondeng why doesn't it let me put
my $dbh=DBI->connect("dbi:Pg:dbname=dbunmask; host=192.168.0.120;
port=5432;", "", "");
in eval
says
Global symbol "$dbh" requires explicit package name at line ever dbh is used>
There is a ma
On Jan 17, 2007, at 9:52 , k.novo wrote:
Hello,
I have strange question and idea.
Use PostgreSQL in embedded PC (with Linux) as data storage for
collection measure data.
Problem is in limited Write cycle in Compact Flash HDD (about 100.000)
My idea is collect data to temporary table in RAM
On Thu, July 13, 2006 11:03 am, Tony Caduto wrote:
> Spendius wrote:
>
>> Hi,
>> I've been trying to perform a connection to an Oracle DB for a while,
>> to no avail. Here is what I get at my psql prompt: postdb=# Select
>> dblink_connect('login','hostaddr= port=1521 \
>>
> If you are trying to con
On Wed, June 28, 2006 5:31 am, [EMAIL PROTECTED] wrote:
> Date and Pascal hate nulls. One even goes so far as to say that if you
> permit NULLs in a database, then the results from *every* query is suspect.
> So they turn perform backflips suggesting ways to avoid nulls.
> None, so far, seem appeal
On Thu, June 22, 2006 7:41 am, Philippe Lang wrote:
> Hi,
>
>
> I would like to access a cpan perl module (FSA::Rules) in a perl
> procedure, inside Postgresql 8.1.4. FSA::Rules is a library that allows you
> to define a finite state machine in perl. No disk access.
>
> In order to to that, I need
On Tue, June 20, 2006 10:44 am, Tom Lane wrote:
> 78 would be ASCII 'N', but that's not really significant AFAICS. The
> problem here is that the frontend and backend have lost sync: the server is
> expecting to find a message beginning at a place in the frontend data
> stream that evidently isn't
On Tue, June 20, 2006 10:20 am, Geoffrey wrote:
>
> We considered that and have verified that we are not closing it. But,
> the question came up, should we be passing it by reference or value? We
> are doing the following:
>
> my $conn = Pg::connectdb ("dbname=$db port=$port"); .
> .
> my $retVa
> Now, there's another thing that makes it amazingly hard to displace:
> imagining what would be better *enough* to justify the many millions of
> people-years and even more billions of dollars needed to move away from
> it. Despite Date's many whines over the decades, his still-vaporware
> Relati
>> Yes, and all SQL products worth their salt include some languages to
>> provide iteration and other processing that SQL can't do or doesn't do
>> well. Why must the rules be different for a truly relational db. (see
>> http://dbappbuilder.sourceforge.net/Rel.html)
> I may get interested if some
On Fri, June 9, 2006 11:45 am, David Fetter wrote:
> On Fri, Jun 09, 2006 at 05:20:46PM +0200, Martijn van Oosterhout wrote:
>
>> On Fri, Jun 09, 2006 at 07:09:12AM -0400, Agent M wrote:
>>
>>> Well, the Date argument against NULLs (and he never endorsed them,
>>> or so he claims) is that they are
On Fri, June 9, 2006 11:17 am, Adam Witney wrote:
>
>
> Martijn van Oosterhout wrote:
>
>> On Fri, Jun 09, 2006 at 03:59:52PM +0100, Adam Witney wrote:
>>
>>> Hi,
>>>
>>>
>>> Im trying to upgrade from 7.4 -> 8.1 but it is failing with Unicode
>>> errors. The offending character is the greek charac
Also, Date mentions the notion that tables don't have to be mapped to
individual files. For example, if the types of queries are known in
advance, it could be possible to rearrange the data to be optimal for
those queries. Currently, tables are just big serialized arrays.
On Fri, June 9, 2006 9:55
Is there a function to convert a row record into an array (discarding
column info)?
-M
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
By accident, a colleague came across something unexpected. Here is a
simple example:
create table testo(gonk integer,spoodle text);
CREATE TABLE
agentm=# insert into testo values(1,'hello');
INSERT 0 1
agentm=# insert into testo values(2,'text');
INSERT 0 1
agentm=# select testo from testo;
tes
It would be great if by default postgres used NOTIFY after any schema
changes. Then, listening UIs could be aware of changes behind the scenes
without polling or manual refreshing.
-M
---(end of broadcast)---
TIP 5: don't forget to increase your f
You will need to provide more information about the data requirement- such
as column types, what you need to search for, and the actual queries and
execution plans.
Purely as a guess, it seems like you haven't tried partial indexes:
http://www.postgresql.org/docs/8.1/interactive/sql-createindex.ht
Just to round out the suggestions, if I remember correctly, the OP
mentioned something about chat. For entirely dynamic, disposable data,
perhaps a reliable database isn't what is called for at all. If the power
shuts off, it may not matter that some chat log is lost.
I suggest to use the right to
On Thu, April 20, 2006 4:21 pm, Tom Lane wrote:
> "A.M." <[EMAIL PROTECTED]> writes:
>
>> It seems I am stuck so please allow me to propose an extension:
>> SET SESSION AUTHORIZATION user [WITH PASSWORD 'password];
>>
>
> This idea is extremel
Hello,
I have written a crontab-like daemon which accepts jobs from users through
a table and executes SQL statements after certain events or intervals.
This daemon maintains a persistent connection to the database as a
superuser.
The problem is that I wish to run arbitrary SQL as an unprivileged
Dear all,
I Have This table
Table Billing:
id
trx_date trx_time depart payment_method
billing_amount amount_paid
balance creator
1 10/09/2003
21:55:02 Resto
Visa 13.800,00
How to install Cygwin PostgreSQL as NT Services on
Windows 2000.
i have do all procedure in postgresql-7.3.4.README
file but i found error
$ net start postmasterThe postmaster service
is starting.The postmaster service could not be started.
The service did not report an error
82 matches
Mail list logo
