On Oct 28, 2013, at 6:50 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 10/28/2013 04:36 PM, Perry Smith wrote:
On Oct 28, 2013, at 6:13 PM, John R Pierce pie...@hogranch.com wrote:
On 10/28/2013 3:58 PM, Adrian Klaver wrote:
The docs do a good job of illustrating:
http
When I execute the SELECT statement directly I get:
psql:table.sql:28: out of memory for query result
I've read the way around this is to use cursors. So I read and I see that I
can use a FOR statement but I need that inside a function.
So far, I've come up with this:
CREATE OR REPLACE
On Oct 28, 2013, at 4:11 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Oct 28, 2013 at 4:06 PM, Perry Smith pedz...@gmail.com wrote:
When I execute the SELECT statement directly I get:
psql:table.sql:28: out of memory for query result
psql will do this automatically if you tell
On Oct 28, 2013, at 5:21 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 10/28/2013 02:27 PM, Perry Smith wrote:
On Oct 28, 2013, at 4:11 PM, Merlin Moncure mmonc...@gmail.com wrote:
On Mon, Oct 28, 2013 at 4:06 PM, Perry Smith pedz...@gmail.com wrote:
When I execute the SELECT
On Oct 28, 2013, at 6:13 PM, John R Pierce pie...@hogranch.com wrote:
On 10/28/2013 3:58 PM, Adrian Klaver wrote:
The docs do a good job of illustrating:
http://www.postgresql.org/docs/9.3/interactive/plpgsql-cursors.html
thats for cursors created within a plpgsql function.
I think
With make I can do make -n and it just tells me what it would do but
doesn't actually do anything.
How could I do that with SQL?
I want to write a really complicated (for me) SQL UPDATE statement. I'm sure I
won't get it right the first time. Is there an easy way to not really make the
On Oct 1, 2013, at 12:23 PM, Adrian Klaver adrian.kla...@gmail.com wrote:
On 10/01/2013 10:16 AM, Perry Smith wrote:
With make I can do make -n and it just tells me what it would do but
doesn't actually do anything.
How could I do that with SQL?
I want to write a really complicated
The direct question is: what is the advantage of an immediate constraint?
My habit is to add constraints to my databases and my first lesson was to make
them deferrable. But a recent fight with pg_restore taught me that to do a
pg_restore that is complex, you need to defer the constraints. I
I am doing a restore:
pg_restore --no-owner -L /tmp/db.list --single-transaction
--dbname=condor3_production $DBFILE
and I get this error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2056; 0 35202 TABLE DATA
adv_ptf_release_maps
On Aug 2, 2013, at 12:29 PM, Perry Smith pedz...@gmail.com wrote:
I am doing a restore:
pg_restore --no-owner -L /tmp/db.list --single-transaction
--dbname=condor3_production $DBFILE
and I get this error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver
Hi,
I'm curious what the design assumptions of the LISTEN / NOTIFY are. For
example, would it work to have a thousand LISTEN channels open at the same time
or would that be abusing the assumptions that were made? In short, I'm trying
to understand if I need a few central LISTEN / NOTIFY
I tried posting this from Google Groups but I did not see it come through after
an hour so this may be a duplicate message for some.
The current testing technique for things like Ruby On Rails has three choices
but all of the choices will not work in my case.
The first choice is truncate
or loading an SQL file is you can have
various files for different tests.
On Mar 12, 2013, at 10:09 PM, Joe Van Dyk wrote:
On Mar 12, 2013, at 8:42 AM, Perry Smith pedz...@gmail.com wrote:
I tried posting this from Google Groups but I did not see it come through
after an hour so this may
I hit bug 5665. I see threads like this:
http://archives.postgresql.org/pgsql-bugs/2011-01/msg00241.php
Where / how can I find the diff that went in to fix this? Mostly I'm curious.
I can work around the problem but wanted to create a patch file for myself to
make deploying to other servers
On Jul 14, 2012, at 2:19 PM, Peter Geoghegan wrote:
On 14 July 2012 18:56, Tom Lane t...@sss.pgh.pa.us wrote:
I can no longer reproduce a failure when building out-of-tree from a
tarball on my Fedora 16 box. That's still make 3.82, but Fedora is
carrying half a dozen patches to the upstream
On Jul 6, 2012, at 7:56 PM, Steve Crawford wrote:
On 07/06/2012 02:34 PM, Perry Smith wrote:
Hi Guys,
This isn't a PostgreSQL specific question but just a SQL question. If this
is not an appropriate question for this list, please let me know.
It is also, perhaps, a really silly
Hi Guys,
This isn't a PostgreSQL specific question but just a SQL question. If this is
not an appropriate question for this list, please let me know.
It is also, perhaps, a really silly question.
This query (without the 'explain' keyword) , when executed takes forever and a
day:
...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Perry Smith
Sent: Thursday, April 14, 2011 7:29 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Normalize or not?
I hope this is reasonably easy to follow. I'm looking forward to your
thoughts and comments.
Thank
application language you are
using; not rules.
On Apr 15, 2011, at 8:45, Perry Smith pedz...@gmail.com wrote:
Mostly, this entire project is for me to learn. What started out as a toy
has gown into something that about 40 people use each day but it is
definitely not normal production stress
considered. The Names and Types of Associations tables I think of as
a type of constants which will be defined and rarely change.
I hope this is reasonably easy to follow. I'm looking forward to your thoughts
and comments.
Thank you,
Perry Smith
--
Sent via pgsql-general mailing list
I have five tables each with a name field. Due to limitations in my user
interface, I want a name to be unique amoung these five tables.
I thought I could first create a view with something like:
SELECT name, 'table1' as type from table1
UNION ALL
SELECT name, 'table2' as type from table2
On Apr 5, 2011, at 5:50 PM, Rob Sargent wrote:
On 04/05/2011 04:02 PM, Perry Smith wrote:
I have five tables each with a name field. Due to limitations in my user
interface, I want a name to be unique amoung these five tables.
I thought I could first create a view with something like
with the || operator)...
The second approach is to create a large object first but that seems
inefficient too. Its also not clear that I can pass a reference to a
large object in place of document text either.
Thank you,
Perry Smith
On Oct 27, 2007, at 3:02 PM, Seneca Cunningham wrote:
On Sat, Oct 27, 2007 at 12:56:37PM -0500, Perry Smith wrote:
On my Mac systems, this work. On my AIX system it does not. I get:
createdb dog -E utf8
createdb: too many command-line arguments (first is utf8)
Try createdb --help for more
ctags or etags. There is exuberant ctags here:
http://ctags.sourceforge.net/
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems
---(end of broadcast
On Oct 28, 2000, at 9:41 AM, Martin Gainty wrote:
Perry-
Does cscope support PHP?
I don't think so. Exuberant tags suppose a lot of languages but it
does not do references (I think) -- just definitions.
Thanks for the link
M--
- Original Message -
From: Perry Smith [EMAIL
For some odd reason, Rails decided to call createdb as:
createdb foo_database -E utf8
On my Mac systems, this work. On my AIX system it does not. I get:
createdb dog -E utf8
createdb: too many command-line arguments (first is utf8)
Try createdb --help for more information.
Has anyone else
On Oct 27, 2007, at 1:41 PM, Michael Glaesemann wrote:
On Oct 27, 2007, at 12:56 , Perry Smith wrote:
On my Mac systems, this work. On my AIX system it does not. I get:
Versions?
My AIX is 5.3 close to the latest. Postgres is 8.2.4 I built all of
the open source stuff myself using
, dropdb, createdb, and psql. It would be
nicer if this could be done via a database connection.
The psql piece I believe is fairly easy. But I don't know where to
begin with the pg_dump piece of it. I took a glance at the pg_dump
code and it is hugh... so I got scared and ran away.
Perry
On Aug 5, 2007, at 6:07 PM, Michael Glaesemann wrote:
On Aug 5, 2007, at 16:31 , Perry Smith wrote:
I'm trying to help out the rails people. Currently they have
rake scripts which call pg_dump, dropdb, createdb, and psql. It
would be nicer if this could be done via a database connection
On Aug 5, 2007, at 7:37 PM, Tom Lane wrote:
Perry Smith [EMAIL PROTECTED] writes:
I find it odd that you are resistant to the idea. To me, the
advantages are clear if it can be done without a tremendous amount of
work.
Well, it can't. pg_dump is an enormously complicated and frequently
On Aug 5, 2007, at 7:37 PM, Tom Lane wrote:
PS: *please* see if you can get them to take out the usage of
pg_dump's
-i switch. Having code invoke that blindly borders on criminal
negligence.
http://dev.rubyonrails.org/ticket/9198
Thank you again.
Take care,
Perry Smith ( [EMAIL PROTECTED
is an optional text string containing zero or
more single-letter flags that change the
function’s behavior. Flag i specifies case-insensitive matching,
while flag g specifies replacement of each
matching substring rather than only the first one.
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc
First, you can specify a password with -P (I think --password works
also). psql --help for optins.
Usually the DB defaults to trusting everything local (if I'm not
mistaken -- someone please correct me if I'm over simplifying).
As far as getting your data into the database, I would look
On Jul 23, 2007, at 8:32 AM, Raymond O'Donnell wrote:
On 23/07/2007 14:22, Perry Smith wrote:
First, you can specify a password with -P (I think --password
works also). psql --help for optins.
-P doesn't specify the password - see below:
C:\Documents and Settings\rodpsql --help
).
Thank you all for helping,
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems
---(end of broadcast)---
TIP 9: In versions below 8.0
but
that seems like a waste. I tried the above and I got a syntax error.
Any suggestions?
Thank you,
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems
On Jul 20, 2007, at 9:06 AM, Michael Fuhr wrote:
On Fri, Jul 20, 2007 at 08:57:25AM -0500, Perry Smith wrote:
I want to do something like this:
ALTER TABLE companies ADD CONSTRAINT fk_companies_item_id
FOREIGN KEY (item_id, 'Company')
REFERENCES item_bases(item_id
On Jul 20, 2007, at 7:01 PM, Jeff Davis wrote:
On Fri, 2007-07-20 at 09:27 -0500, Perry Smith wrote:
On Jul 20, 2007, at 9:06 AM, Michael Fuhr wrote:
On Fri, Jul 20, 2007 at 08:57:25AM -0500, Perry Smith wrote:
I want to do something like this:
ALTER TABLE companies ADD CONSTRAINT
Right now, it would be nice if I could get a check constraint to be
deferred. Its a long story. I want a circular constraint. The way
things are set up right now, it would be easy if I could defer my
check constraint. I'm doing a polymorphic relation. One direction
is a simple
On Jul 16, 2007, at 3:08 PM, Gregory Stark wrote:
Perry Smith [EMAIL PROTECTED] writes:
Right now, it would be nice if I could get a check constraint to
be deferred.
Its a long story. I want a circular constraint. The way things
are set up
right now, it would be easy if I could defer
I'm trying to clearly understand how foreign key constraints work. I
still need some help.
The PostgreSQL documentation says:
ROW EXCLUSIVE
Conflicts with the SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE, and
ACCESS EXCLUSIVE lock
modes.
The commands UPDATE, DELETE, and INSERT acquire this lock
). Network delays does not seem like a valid
reason this is not working.
My thought is to not use triggers but to use rules. These operate
inside the db engine.
I hope this helps,
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk
On Fri, Jul 06, 2007 at 08:02:54PM +0400, Viatcheslav Kalinin wrote:
# select start_date from show_date
# order by
# case when start_date CURRENT_DATE then start_date end desc,
# case when start_date = CURRENT_DATE then start_date end asc;
I am very novice, but that looks odd to me. I would
On Jul 7, 2007, at 2:15 PM, Tom Lane wrote:
Perry Smith [EMAIL PROTECTED] writes:
On Fri, Jul 06, 2007 at 08:02:54PM +0400, Viatcheslav Kalinin wrote:
# select start_date from show_date
# order by
# case when start_date CURRENT_DATE then start_date end desc,
# case when start_date
On Jul 6, 2007, at 2:31 AM, PFC wrote:
I am doing a project using Ruby On Rails with PostgreSQL as the
database. I have not seen the term polymorphic used with databases
except with Rails so I will quickly describe it.
Instead of holding just an id as a foreign key, the record holds a
type
On Jul 6, 2007, at 8:01 AM, David Fetter wrote:
On Thu, Jul 05, 2007 at 09:56:12PM -0500, Perry Smith wrote:
I am doing a project using Ruby On Rails with PostgreSQL as the
database. I have not seen the term polymorphic used with databases
except with Rails so I will quickly describe
replied to David as well. You both have similar ideas. I will
work on this over the weekend and I hope I can give an update when
I'm done.
Thank you very much. You have helped me a lot.
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk
with real databases is very
possible. If nothing else, as extensions to Rails.
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems
On Jul 6, 2007, at 9:57 PM, Michael Hogarth wrote:
Hi folks.
I successfully compiled/built pg 8.1.9 using --with-openssl on a Mac.
I modified the startup config files to enable ssl.
Server starts without problems, but when I try to require SSL from
pgAdminIII, I get server does not support
,
Perry Smith ( [EMAIL PROTECTED] )
Ease Software, Inc. ( http://www.easesoftware.com )
Low cost SATA Disk Systems for IBMs p5, pSeries, and RS/6000 AIX systems
51 matches
Mail list logo