pgsql_call_handler,plpython2_call_handler,plpython3_call_handler,plpython_call_handler,pltcl_cal
l_handler,pltclu_call_handler}
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ENTLY). Re-creating the index might conceivably be the solution in
the end, and it's what pg_repack does behind the scenes.
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
0 0 34.9g 25g 25g S 0.0 40.4 46:36.86 postgres:
> startup process recovering 00040855004B
> 167162 postgres 20 0 34.9g 25g 25g S 0.0 40.2 17:58.38 postgres:
> checkpointer process
>
> shared_buffers = 32GB
Also, what is work_mem ?
Justin
--
Sent vi
s reading (or writing??)
consecutively (hopefully with ample OS readahead) or randomly (without).
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ore starting "explain") does it show "active" state
or waiting ?
If it's waiting, you can see what it's waiting ON by looking at pg_locks..
Maybe like: SELECT c.query, * FROM pg_locks a JOIN pg_locks b USING(relation)
JOIN pg_stat_activity c ON b.pid=c.pid WHERE a.pid=?? (fro
fragment for the line with error_severity='ERROR' ?
https://www.postgresql.org/docs/current/static/runtime-config-logging.html#runtime-config-logging-csvlog
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
d none of those inqueries resulted in a record being found".
> IIUC I'd be wondering why some form of hash join wasn't used...
Except that:
https://www.postgresql.org/docs/current/static/using-explain.html
"... the loops value reports the total number of executions of the node, and
t
ga19...@telsasoft.com
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Oct 27, 2017 at 09:24:40PM +0200, Thomas Kellerer wrote:
> Under which situation does a SELECT query change a block?
https://wiki.postgresql.org/wiki/Hint_Bits
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
On Sun, Oct 22, 2017 at 02:36:12PM -0400, Tom Lane wrote:
> Justin Pryzby <pry...@telsasoft.com> writes:
> > After installing parray_gin extension and pg_upgrading another instance,
> > \d is failing like so:
>
> > [pryzbyj@database ~]$ psql ts -c '\d pg_class'
>
an urgent problem to fix, but if someone has a workaround
for \d I would appreciate if you'd pass it along :)
Thanks in advance
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
st to the rowcount estimate being
off by a factor of 3e6.
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Oct 17, 2017 at 09:06:59AM +0300, Allan Kamau wrote:
> Is there a way to instruct psql not to try reading ~/.pgpass file?
https://www.postgresql.org/docs/current/static/libpq-envars.html
PGPASSFILE behaves the same as the passfile connection parameter.
passfile
Specifies the name of the
syscalls change
the behavior of the program being straced).
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e /sys/kernel/mm/ksm/run
I believe for us that was affecting a postgres VM(QEMU/KVM) and maybe not
postgres itself. Worth a try ?
https://www.postgresql.org/message-id/20170718180152.GE17566%40telsasoft.com
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
ql.org/message-id/20170718180152.GE17566%40telsasoft.com
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Sep 15, 2017 at 06:49:06AM -0500, Ron Johnson wrote:
> On 09/15/2017 06:34 AM, Justin Pryzby wrote:
> [snip]
> >But you might consider: 1) looping around tables/indices rather than "REINDEX
> >DATABASE", and then setting a statement_timeout=9s fo
around tables/indices rather than "REINDEX
DATABASE", and then setting a statement_timeout=9s for each REINDEX statement;
and/or, 2) use pg_repack, but I don't think it handles system tables.
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, Aug 18, 2017 at 10:47:37PM +0200, Peter J. Holzer wrote:
> On 2017-08-18 06:37:15 -0500, Justin Pryzby wrote:
> > On Fri, Aug 18, 2017 at 01:01:45PM +0200, Rob Audenaerde wrote:
> > > I don't understand why this query:
> > >
> > >se
On Fri, Aug 18, 2017 at 01:01:45PM +0200, Rob Audenaerde wrote:
> I don't understand why this query:
>
>select count(base.*) from mytable base;
>
> does return multiple rows.
>
>select count(1) from mytable base;
>
> returns the proper count.
>
> There is a column with the name
irst (so
a typical newly-inserted rows only goes through one if/case test).
Alternately, the trigger function can dynamically compute the table into which
to insert using plpgsql "format()" similar to here:
https://www.postgresql.org/docs/9.1/static/plpgsql-statements.html#PLPGSQL-Q
nularity of every table, was probably due to very large pg_statistics and
pg_attributes tables, which no longer fit in buffer cache).
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t know which partition the function value might fall
|into at run time.
[..]
.. and see an early mail on its implementation, here:
https://www.postgresql.org/message-id/1121251997.3970.237.camel@localhost.localdomain
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
ient_min_messages=DEBUG3 -c log_statement_stats=on" psql
postgres -c "ALTER TABLE t ${cols%,}" 2>/tmp/pg.err2;
~/src/postgresql.install/bin/pg_ctl -swD ~/src/postgres.dat stop; done'
..and log_statment_stats with a variation on the getrusage patch here
https://www.postgresql.o
8)
If it were allowed for children to have int columns with differing widths, then
to promote int column, we would uninherit the historic children, ALTER the
parent (and most recent tables), and then reinherit the children (unless ALTER
on its own avoided rewriting tables in such a case).
Justin
On Mon, Jun 12, 2017 at 08:46:57PM -0700, Jeff Janes wrote:
> On Mon, Jun 12, 2017 at 8:17 PM, Justin Pryzby <pry...@telsasoft.com> wrote:
>
> > I know PG 10 will have support "CREATE STATISTICS.." for this..
> >
> > ..but I wondered if there's a re
neigh_sect_id,
eric_enodeb_cellrelation_metrics_1.sect_id))))
Thanks,
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
areLock on transaction 13693494 after 7829.560
ms
session_id|593be2fd.6816
log_time|2017-06-10 01:16:37.833-11
pid|26646
detail|
session_line|2306
message|statement: RESET synchronize_seqscans
Thanks in advance for any clue or insight.
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t know if the behavior is better with recent kernel.
/sys/kernel/mm/ksm/run=2
... and maybe also:
/sys/kernel/mm/transparent_hugepage/defrag=madvise
/sys/kernel/mm/ksm/merge_across_nodes=0
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
which probably change the
(default) socket path.
Your options are to specify path to the socket (maybe in /tmp for running
PG92?), change to TCP connection, or specify server option
unix_socket_directories.
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
.us
https://www.postgresql.org/message-id/4188.1298960419%40sss.pgh.pa.us
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nting migrating a DB between
servers and this procedure will allow doing so with ~30min
downtime...pg_upgrade to 9.6 will be done afterwards, which is why PG96
pg_upgrade is installed).
Thanks,
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
f you're not re-ordering existing columns, you can use CREATE OR REPLACE VIEW
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that the bit string is not too long */
|if (VARBITLEN(arg) > sizeof(result) * BITS_PER_BYTE)
| ereport(ERROR,
| (errcode(ERRCODE_NUMERIC_VALUE_OUT_OF_RANGE),
|errmsg("integer out of range")));
Justin
--
Sent via pgsql-general mailin
(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
./src/backend/parser/parse_node.c: errmsg("target
lists can have at most %d entries",
./src/backend/parser/parse_node.c:
MaxTupleAttributeNumber)));
Thanks in advance
(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
./src/backend/parser/parse_node.c: errmsg("target
lists can have at most %d entries",
./src/backend/parser/parse_node.c:
MaxTupleAttributeNumber)));
Thanks in advance
); -- Does work. I could see the argument
for it working, but would prefer it didn't work. Should still emit a
warning its overriding a base
Since I'm returning to postgres after close to a decade, I figured I'd ask
here for feedback before posting to the hackers list.
Regards,
Justin Dearing
em stands for easy money
update tbl1
set col3=em.col3,col4=em.col4,col5=em.col5
from
(select col3, col4,col5 from tbl2 where col1=criteria) em
Regards,
Justin Tocci
Programmer
www.workflowproducts.com
7813 Harwood Road
North Richland Hills, TX 76180
phone 817-503-9545
skype justintocci
On May
at or do to correct this problem (if it can be
corrected)?
We are running postgres 8.3.4 on 64 bit Red Hat kernel
release 2.6.18-164.el5
Thanks for the help!
- Justin
but I have a number of questions is –
- Does postgres pick up this change straight away?
- Are there any caveats to my first question?
thanks,
Justin
to
another column, but this also involves code changes and lots and lots of
testing.
So my question is - does postgres take an update to pg_attribute instantly
and in a reliable manner?
thanks,
Justin.
On Fri, Nov 30, 2012 at 4:15 PM, Greg Sabino Mullane g...@turnstep.comwrote:
-BEGIN
helps. Thanks in advance.
--
Justin Naifeh Software Developer
Voice:
303-460-7111 x1 Toll Free:
877-444-3074 x1 Cell:
720-363-8874AIM, Yahoo
justinnaifeh aim:goim?screenname=justinnaifeh
www.terraframe.com/products/runwaysdk
http://www.terraframe.com/products/runwaysdk
from source using
the --with-perl --with-openssl options as well. Any thoughts on what I might
be able to do to fix or workaround this? Thanks!
- Justin
Thanks Tom and Merlin, I removed that logic from check.c, rebuilt, and it
worked fine.
On Tue, Aug 30, 2011 at 2:47 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Merlin Moncure mmonc...@gmail.com writes:
It looks like some time after 8.3 was released that function was
changed from returning
just never got pushed to the RHEL4 repository? Thanks.
--
Justin Pasher
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
).
Regards
--
Michael Justin
http://www.habarisoft.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 7/1/2010 11:08 AM, Mike Christensen wrote:
I'd like to convert a small database to UTF8 before it becomes too
large. I'm running on 8.3.x on Windows. It doesn't seem that pgAdmin
has any native way of doing this, what's the easiest way to go about
doing this? Thanks!
Mike
On 6/10/2010 4:12 AM, Thom Brown wrote:
Does anyone know if ms2pg is available from somewhere other than
http://edoceo.com/creo/ms2pg ? Attempts to download it result in not
found. Unless someone knows of an alternative attempt to automate
migration of MSSQL to PostgreSQL?
Thanks
Thom
On 6/8/2010 9:23 AM, Peter Hunsberger wrote:
On Tue, Jun 8, 2010 at 4:04 AM, John Gagejsmg...@numericable.fr wrote:
Unix is a text-based operating system with unbelievably helpful text
manipulation tools.
Postgres is a creature of Unix which happens to have unbelievable text
searching
***SNIP***
2) Its also available in chm windows help file format. Which i find
allot
more useful
http://www.postgresql.org/docs/manuals/
you could print chm to a text file.
--I'll have to boot over to XP, ugh. Will do.
There are linux chm readers
On 6/3/2010 5:43 AM, Jamie Lawrence-Jenner wrote:
Hi All
In SQL Server I could copy sql code out of an application and paste it
into SSMS, declare assign vars that exist in the sql and run.. yay
great debugging scenario.
e.g. (please note I am rusty and syntax may be incorrect)
On 5/29/2010 1:05 PM, Dennis Gearon wrote:
Is it possible to create a complex schema object in one transaction,
I'm not sure i understand what you mean by schema object
using prepared statements to protect(somewaht) against SQL injection?
In short no
Prepared statements do not
On 5/29/2010 6:26 PM, Bob Pawley wrote:
Found it in XP it doesn't seem to exist in Windows 7. I can't even
find Doc and Settings in 7.
It's a large file. I'm not sure what is needed but here is the latter
part of the file.
Bob
***Snip***
Windows 7 and vista move lots of things around
On 5/27/2010 9:04 AM, Nikolas Everett wrote:
Say I have a table that stores state transitions over time like so:
id, transitionable_id, state1, state2, timestamp
I'm trying to write a query that coalesces changes in state2 away to
produce just a list of transitions of state1. I guess it
On 5/27/2010 9:45 AM, Nikolas Everett wrote:
Sorry. Here is the setup:
CREATE TABLE test (id BIGSERIAL PRIMARY KEY, state1 INT NOT NULL,
state2 INT NOT NULL, timestamp TIMESTAMP);
INSERT INTO test (state1, state2, timestamp) VALUES (1, 1, now() -
interval '12 hours');
INSERT INTO test
On 5/24/2010 3:18 PM, Hector Beyers wrote:
Yes, I mean hide. I am approaching the problem out of the perspective
of a malicious user / hacker.
**snip***
First hiding data is not a solution to secure or block access to
information. This only slows people down it does not stop them, never
On 5/25/2010 2:58 AM, Hector Beyers wrote:
No, I have not considered encrypting or decrypting data. The reason
for this is that I am trying to /secure a database/ by thinking like a
/malicious user / criminal/. I want to hide (for example) fraudulent
data on a database where it is not
- Original Message -
From: Justin Pasher just...@newmediagateway.com
Date: Fri, 23 Apr 2010 17:46:16 -0500
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Alvaro Herrera alvhe...@commandprompt.com
CC: pgsql-general@postgresql.org
- Original Message
On 5/17/2010 12:52 AM, Yan Cheng CHEOK wrote:
The pgadmin result seems different with my machine. My friend and I are using
Windows machine. Are you using Linux machine?
Thanks and Regards
Yan Cheng CHEOK
**snip**
I use both windows and Linux using pgadmin, and on occasion use psql
On 5/12/2010 11:45 AM, Richard Broersma wrote:
Can anyone advise me if either PostgreSQL 8.3 or 8.4 is ready for
special case of production use?
I'm considering using the windows version PostgreSQL in the following
conditions:
at least 10 years of up time (with periodic power failures= 1
On 5/12/2010 12:33 PM, Richard Broersma wrote:
On Wed, May 12, 2010 at 9:18 AM, Justin Grafjus...@magwerks.com wrote:
I would do a plain text file something like XML. Given this is for
industrial use 10 years is a good number for warranty and support, but
this stuff will hang around
- Original Message -
From: Devrim GÜNDÜZ dev...@gunduz.org
Date: Tue, 04 May 2010 07:18:47 +0300
Subject: Re: [GENERAL] Latest source RPMs for 8.1.20
To: Justin Pasher just...@newmediagateway.com
CC: pgsql-general@postgresql.org
On Mon, 2010-05-03 at 10:49 -0500, Justin Pasher wrote
with the
postgresql-8.1.20.tar.bz2 tarball, update the versions in the spec file,
then build the RPM? I noticed there are other patch files installed by
the source RPM, so I didn't know if I would be missing any other
potential patch files.
Thanks.
--
Justin Pasher
--
Sent via pgsql-general mailing
- Original Message -
From: Vincenzo Romano vincenzo.rom...@notorand.it
Date: Mon, 3 May 2010 17:59:10 +0200
Subject: Re: Latest source RPMs for 8.1.20
To: Justin Pasher just...@newmediagateway.com
CC: pgsql-general@postgresql.org
2010/5/3 Justin Pasher just...@newmediagateway.com
On 4/29/2010 12:07 PM, David Wall wrote:
Big downside for the DB is that all large objects appear to be stored
together in pg_catalog.pg_largeobject, which seems axiomatically
troubling that you know you have lots of big data, so you then store
them together, and then worry about running
On 4/29/2010 1:51 PM, David Wall wrote:
Put it another way: bytea values are not stored in the pg_largeobject
catalog.
I missed the part that BYTEA was being used since it's generally not a
good way for starting large binary data because you are right that
BYTEA requires escaping across
On 4/29/2010 3:18 PM, Tom Lane wrote:
Alvaro Herreraalvhe...@commandprompt.com writes:
However, that toast limit is per-table, whereas the pg_largeobject limit
is per-database. So for example if you have a partitioned table then
the toast limit only applies per partition. With large
Hello,
Redhat EL4 update 8, 2.6.9-89.0.23.ELsmp
Quad Proc, Dual Core Xeon, 16GB RAM
Postgres 8.1.18
I'm having some trouble pinning down exactly what is causing our
Postgres cluster to run slowly. After some initial investigation, I
noticed that the disk write activity is consistently high,
- Original Message -
From: hubert depesz lubaczewski dep...@depesz.com
Date: Fri, 23 Apr 2010 23:40:35 +0200
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Justin Pasher just...@newmediagateway.com
CC: pgsql-general@postgresql.org
On Fri, Apr 23, 2010 at 03:27
I'm guessing I should just try to delete the file outright?
Err... I meant should NOT delete.
--
Justin Pasher
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
- Original Message -
From: Alvaro Herrera alvhe...@commandprompt.com
Date: Fri, 23 Apr 2010 18:28:03 -0400
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Justin Pasher just...@newmediagateway.com
CC: dep...@depesz.com, pgsql-general@postgresql.org
Justin Pasher
On 4/14/2010 9:20 AM, Satish Burnwal (sburnwal) wrote:
Index Scan using repcopy_index on repcopy a (cost=0.00..87824607.17
*rows=28* width=142) (actual time=11773.105..689111.440*rows=1* loops=1)
Index Cond: ((dm_user)::text = 'u3'::text)
Filter: ((report_status = 0) AND
On 4/14/2010 9:42 AM, Bill Moran wrote:
Man, it's hard to read your emails. I've reformatted, I suggest you
improve the formatting on future emails, as I was about to say to
hell with this question because it was just too difficult to read,
and I expect there are others on the list who did
On 4/8/2010 9:30 AM, Bill Moran wrote:
In response to Ognjen Blagojevicogn...@etf.bg.ac.rs:
Is this:
a. Lookup table
b. Classifier
c. Cypher(er)?
I'm looking for the appropriate term in English.
I try to make it an ENUM when it's very unlikely to change, i.e. day of
the week
On 3/26/2010 12:12 PM, Tom Lane wrote:
Gaietti, Mauro \(SELEX GALILEO Guest,
Italy\)mauro.gaie...@guests.selexgalileo.com writes:
This query:
select round(0.5), round(0.5::integer), round(0.5::bigint), round(
0.5::float ), round( 0.5::double precision ),round(cast(0.5 as double
On 3/18/2010 12:52 PM, Scott Mead wrote:
xtuple ERP does and the latest version of GNUCash can use postgres as
a backend too.
--Scott M
On Thu, Mar 18, 2010 at 1:11 PM, Garry Saddington
ga...@schoolteachers.co.uk wrote:
Does anyone know of a web based accounting(finance) package
On 3/16/2010 3:35 PM, Vick Khera wrote:
On Tue, Mar 16, 2010 at 3:03 PM, Jamie Kahgeejamie.kah...@gmail.com wrote:
I'm curious what people consider best practice (or how do you do it) to
help ensure these name collisions don't happen.
Do not mix data from multiple applications in
On 3/15/2010 2:40 PM, Rob Richardson wrote:
Greetings!
Our database monitors the progression of steel coils through the
annealing process. The times for each step are recorded in wallclock
time (US eastern time zone for this customer) and in UTC time. During
standard time, the difference
On 3/10/2010 11:52 PM, Chris Travers wrote:
There are two major limitations here of schemas:
1) They can't be nested leading again to possible namespace ambiguity.
2) there are a number of requests to try to get the application to
install into an arbitrary, nonpublic schema.
If schemas
On 3/10/2010 8:16 PM, Chris Travers wrote:
Hi all;
One of my applications currently has over 60 stored procedures and
future versions will likely have several hundred. I am wondering what
folks find to be helpful naming conventions for managing a large
number of stored procedures. We tried
On 3/9/2010 12:07 AM, Sam Carleton wrote:
I would like to thank both John and Scott for the help. It is very
clear to me that PostgreSQL isn't the ideal solution for my current
model. The conversation has gotten me thinking of ways the model
could be modified to work with PostgrSQL (and
On 3/4/2010 3:51 AM, Richard Huxton wrote:
On 04/03/10 01:35, Craig Ringer wrote:
http://support.microsoft.com/kb/942976/en-us
Classy. Even better - according to the linked page, the 64 bit version
is in the System32 folder - yippee!
* The 32-bit version of the Odbcad32.exe file is
On 3/4/2010 10:00 AM, Greg Stark wrote:
On Thu, Mar 4, 2010 at 2:14 PM, Justin Grafjus...@magwerks.com wrote:
To pretty much anyone outside MS, a sane human would think 64 bit apps
in SysWoW64 and 32Bit apps in System32. :'(
Ah, but you all are forgetting that the 32 here
On 3/3/2010 3:40 PM, Michael Gould wrote:
On my machine the UUID that is returned is 16 bytes and I cannot make
out any relevant numbers from the UUID key in the citystateinfo
table. I've tried this in a Windows XP machine and a Windows 7 64 bit.
Now here is the weird thing. I did a
On 3/3/2010 5:16 PM, Michael Gould wrote:
One thing I've noticed is that on my machines, when I install the odbc
driver I get no error messages but when I look in the ODBC administrator I
do not see any entry for PostGres in the drivers list.
I do know that it somehow is working because the
don't exist in a similar directory
structure (http://yum.pgsqlrpms.org/srpms/7.4/redhat/rhel-4-i386/).
Any idea where I can grab the 7.4.27 source RPMs? Thanks.
--
Justin Pasher
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On 2/10/2010 7:15 PM, paul e wrote:
Before Installed postgresql Windows7 went straight to my user account.
Now when it boots I have to go to a selection page where I choose
between my user account and a postgresql user account. Is there any
way to bypass this so it boots directly to my user
On 2/9/2010 12:47 PM, Asher wrote:
Hello.
I'm putting together a database to store the readings from various
measurement devices for later processing. Since these things (water
pressure monitors attached to very large water pipes) take readings at
200Hz and are typically deployed over
On 2/9/2010 4:41 PM, Asher Hoskins wrote:
Thanks for that, it looks like partitioning is the way to go. I'm
assuming that I should try and keep my total_relation_sizes less than
the memory size of the machine?
This depends on what the quires look like. As other have stated when
On 2/8/2010 7:09 PM, Fredric Fredricson wrote:
Hi!
New to the list with a question that I cannot find the answer to in
the manual or on the internet but I suspect is trivial. If somebody
could point me in the correct direction I would be greatful.
This is what I do (condensed, of course):
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Dec 16, 2009 at 7:20 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Really? Works for me, in everything back to 7.3.
I must be missing something, because this function fails:
CREATE OR REPLACE FUNCTION insertShort()
RETURNS VOID AS
$BODY$
DECLARE
s Short.shortCol%TYPE;
BEGIN
error
UPDATE Short SET shortCol = CAST(myVal AS (Short).shortCol) -- syntax error
Thanks in advance for any advice
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
UPDATE Short SET shortCol = CAST(myVal AS (Short).shortCol) -- syntax error
Thanks in advance for any advice.
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
--
Justin Pasher
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
pere roca wrote:
hi,
some nice tool over there to let non-SQL knowing people to construct their
queries? I'm using pgAdmin III but I know some SQL.
there is no other option than constructing an HTML with forms, drop-down
menus...?
thanks,
pERE
Your best bet which is not free is
Rich Shepard wrote:
In the early and mid-1980s we used a procedure for business
applications
involving money that worked regardless of programming language or
platform.
To each (float, real) monetary amount we added 0.005 and truncated the
result
to two digits on the right of the decimal
be different which could cause such a
drastic change?
Thanks,
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Devrim GÜNDÜZ wrote:
On Thu, 2009-09-24 at 15:43 -0500, Justin Pasher wrote:
I'm having trouble finding the source RPMs for PostgreSQL 8.1.18 on
RHEL4. I've tried looking in the following places with no luck (I can
only find the regular RPMs).
http://yum.pgsqlrpms.org/8.1/redhat/rhel-4
/
Any suggestions?
--
Justin Pasher
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 366 matches
Mail list logo
