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
column alone (CREATE INDEX
CONCURRENTLY). 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
ostgres 20 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
-
and see if it'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
_pid() before 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
log),
can you send the log 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
sulted 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
the actual time an
719174507.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:
http://www.postgres
On Sun, Oct 22, 2017 at 02:36:12PM -0400, Tom Lane wrote:
> Justin Pryzby writes:
> > After installing parray_gin extension and pg_upgrading another instance,
> > \d is failing like so:
>
> > [pryzbyj@database ~]$ psql ts -c '\d pg_class'
> > ERROR: ope
---+--
(0 rows)
Is this to be considered an issue with parray_gin or with psql ?
I don't think that's 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
the query to see which one is contributing most 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 fi
27;ve seen its interruption to 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
SM ?
echo 2 |sudo tee /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@postg
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 for each REINDEX
round 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:
> > >
> > >
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 'count'
ted first (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#PLPG
daily* partition
granularity 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
|since the planner cannot 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-g
quot;-c client_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://w
ows=2140 width=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 c
On Mon, Jun 12, 2017 at 08:46:57PM -0700, Jeff Janes wrote:
> On Mon, Jun 12, 2017 at 8:17 PM, Justin Pryzby wrote:
>
> > I know PG 10 will have support "CREATE STATISTICS.." for this..
> >
> > ..but I wondered if there's a recommended workaround in earlier
cs_1.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
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
and I don'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 chan
libraries, 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
25%40sss.pgh.pa.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
I'm currenting 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
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
|/* Check 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
(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 i
(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 i
arning.
CREATE DOMAIN public.int CHAR(50); -- 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
s
-
which is missing the last 2 columns defined by pg_attribute and \d.
Any ideas on what I can look 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
migrate 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 wrote:
>
> -
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
s_hash index, right? Maybe my settings
are wrong or I'm making an incorrect assumption about Postgres behavior.
Any pointer in the right direction helps. Thanks in advance.
--
Justin Naifeh Software Developer
Voice:
303-460-7111 x1 Toll Free:
877-444-3074 x1 Cell:
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 wrote:
> Merlin Moncure writes:
> > It looks like some time after 8.3 was released that function was
> > changed from returning 'record'. This is making me wonder if
;record"
Failure, exiting
The binaries for the 8.3.4 install were built 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
perhaps the
changes 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
>
***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
http://www.linux.com/news/sof
On 6/8/2010 9:23 AM, Peter Hunsberger wrote:
> On Tue, Jun 8, 2010 at 4:04 AM, John Gage 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 and manipul
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 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 ar
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 pro
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 tes
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/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
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, neve
- Original Message -
From: Justin Pasher
Date: Fri, 23 Apr 2010 17:46:16 -0500
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Alvaro Herrera
CC: pgsql-general@postgresql.org
- Original Message -
From: Alvaro Herrera
Date: Fri, 23 Apr 2010 18:28:03
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
On 5/12/2010 12:33 PM, Richard Broersma wrote:
> On Wed, May 12, 2010 at 9:18 AM, Justin Graf 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 w
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 failur
- Original Message -
From: Devrim GÜNDÜZ
Date: Tue, 04 May 2010 07:18:47 +0300
Subject: Re: [GENERAL] Latest source RPMs for 8.1.20
To: Justin Pasher
CC: pgsql-general@postgresql.org
On Mon, 2010-05-03 at 10:49 -0500, Justin Pasher wrote:
I'm looking for the latest source RPM
- Original Message -
From: Vincenzo Romano
Date: Mon, 3 May 2010 17:59:10 +0200
Subject: Re: Latest source RPMs for 8.1.20
To: Justin Pasher
CC: pgsql-general@postgresql.org
2010/5/3 Justin Pasher :
I'm looking for the latest source RPMs for Postgres 8.1.20 on RHEL. I ca
h 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-gener
On 4/29/2010 3:18 PM, Tom Lane wrote:
> Alvaro Herrera 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 objects you'd
> fall ove
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
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 run
- Original Message -
From: Alvaro Herrera
Date: Fri, 23 Apr 2010 18:28:03 -0400
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Justin Pasher
CC: dep...@depesz.com, pgsql-general@postgresql.org
Justin Pasher wrote:
Agh... I used pg_stats_reset (with an s
> 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: hubert depesz lubaczewski
Date: Fri, 23 Apr 2010 23:40:35 +0200
Subject: Re: [GENERAL] Postgres stats collector showing high disk I/O
To: Justin Pasher
CC: pgsql-general@postgresql.org
On Fri, Apr 23, 2010 at 03:27:55PM -0500, Justin Pasher wrote:
haven&#
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, an
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
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 (repor
On 4/8/2010 9:30 AM, Bill Moran wrote:
> In response to Ognjen Blagojevic:
>
>>
>> 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\)" 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
>> precision )),round(cast(0.5::do
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) pa
On 3/16/2010 3:35 PM, Vick Khera wrote:
> On Tue, Mar 16, 2010 at 3:03 PM, Jamie Kahgee 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 one database.
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 differe
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 sc
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
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 (an
On 3/4/2010 10:00 AM, Greg Stark wrote:
> On Thu, Mar 4, 2010 at 2:14 PM, Justin Graf 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 a
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.ex
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 t
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 c
RPMs 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 subscrip
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 us
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
partitio
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 ove
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 cour
--
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 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
SELECT longCol I
DATE Short SET shortCol = CAST(myVal AS Short.shortCol%TYPE) -- syntax 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
error
UPDATE Short SET shortCol = CAST(myVal AS Short.shortCol%TYPE) -- syntax 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
he LANG variable directly in
your call to ls, since it's just running a shell command.
--
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
t might 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/red
hel-4-i386/
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 377 matches
Mail list logo
