[GENERAL] Re: Dynamic use of RAISE with USING to generate and catch non-hardcoded custom exceptions

2017-09-22 Thread mike davis
e used in the USING subclause but not outside it. The manual does seem to hint at this as "after level if any, you can write a format (which must be a simple string literal, not an expression)" Anyway, RAISE EXCEPTION USING message = v_msg, errcode = v_sqlstate; works a treat! Many thanks Tom & Pavel. Mike

[GENERAL] Dynamic use of RAISE with USING to generate and catch non-hardcoded custom exceptions

2017-09-21 Thread mike davis
I’m trying to get dynamic version of the RAISE command working so that I can use a table of custom application error messages and codes for use by all developed plpgsql functions. In this way the customer error codes and message are not hard coded into code and are defined consistently in one pl

Re: [GENERAL] Surprising results from array concatenation

2017-04-25 Thread Mike Blackwell
On Tue, Apr 25, 2017 at 12:53 PM, Tom Lane wrote: > Yeah. The core problem here is that the parser has to disambiguate the > || operator: is it "anyarray || anyelement" or "anyarray || anyarray"? > ​<...>​ > Peeking at the contents of the literal would make the behavior very > unpredictable/da

[GENERAL] Surprising results from array concatenation

2017-04-25 Thread Mike Blackwell
x27;c'] || 'd'::TEXT; ?column? --- {a,b,c,d} (1 row) The assumption that the second argument is an array constant seems surprising. __ *Mike Blackwell | Technical Analyst, Distribution Services/Roll

Re: [GENERAL] Column Tetris Automatisation

2017-01-15 Thread Mike Sofen
le, order does matter...it all ties together nicely, making it easier for other developers to follow an identical pattern across all of the database objects. All of that said, the notion of embedding Tetris functionality into a codebase makes me smile, for some reason... Mike Sofen -- Sent

Re: [GENERAL] LYDB: What advice about stored procedures and other server side code?

2016-12-28 Thread Mike Sofen
ans are created, etc. ORMs are a shortcut to getting an app talking to data, but aren't a substitute for a proper, scalable data tier. IMO...being a data specialist... :-) Mike Sofen (Synthetic Genomics) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

Re: [GENERAL] Performance PLV8 vs PLPGSQL

2016-12-28 Thread Mike Sofen
tailored the model to match. Mike Sofen (Synthetic Genomics)

Re: [GENERAL] Syntax error needs fresh eyeballs

2016-12-26 Thread Mike Sofen
g all table names and references to them, or double-quoting all identifiers. Mike

Re: [GENERAL] Storing files: 2.3TBytes, 17M file count

2016-11-28 Thread Mike Sofen
, this is all real time web app stuff. This is a model that could work for anyone dealing with large objects (text or binary). The nice part is, the original 25TB of data storage drops to 5TB – a much more manageable number, allowing for significant growth, which is on the horizon. Mike

Re: [GENERAL] initdb createuser commands

2016-10-30 Thread Mike Sofen
isn’t skilled in sql, the requests you’ve made won’t assist them at all. Mike Sofen (Synthetic Genomics)

Re: [GENERAL] Immutable datastore library?

2016-10-18 Thread Mike Sofen
small - up to 100k rows or less, and processed in under 100ms. But even when there was a network outage and we had to do a catch up load with millions of rows, it ran very quickly. IOWs, the double write overhead was very modest, especially with modern disk performance. Mike Sofen (Synthetic G

Re: [GENERAL] Graphical entity relation model

2016-09-28 Thread Mike Sofen
), and the fully comprehensive, with a very modern looking UI. In contrast, there are the over-priced dinosaurs with old ugly UIs. A while back I reviewed some of the modeling tools, and none did it for me, I went ahead and got another license to xcase. Mike Sofen (Synthetic Genomics)

Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-28 Thread Mike Sofen
From: Pavel StehuleSent: Tuesday, September 27, 2016 9:18 PM 2016-09-28 6:13 GMT+02:00 Pavel Stehule mailto:pavel.steh...@gmail.com> >: Hi 2016-09-27 23:03 GMT+02:00 Mike Sofen mailto:mso...@runbox.com> >: Hi gang, how to view the state of a transaction in flight, seeing how ma

[GENERAL] how to monitor the progress of really large bulk operations?

2016-09-27 Thread Mike Sofen
t eliminate my need: how to view the state of a transaction in flight, seeing how many rows have been read or inserted (possible for a transaction in flight?), memory allocations across the various PG processes, etc. Possible or a hallucination? Mike Sofen (Synthetic Genomics)

Re: [GENERAL] IDE for function/stored proc development.

2016-09-03 Thread Mike Sofen
From: Tim Uckun Sent: Saturday, September 03, 2016 2:37 AM Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better. I have been using the Datagrip app (from Jetbrains), from its beta release up through now v 2016.2 and lov

Re: [GENERAL] Rackspace to RDS using DMS (Postgres 9.2)

2016-09-01 Thread Mike Sofen
server that we are demoing that costs ~$100k, as long as our batch sizes don’t exceed available memory – that’s where the larger Cisco pulls ahead. The $620/mo is the on-demand price, btw…the reserved price is much lower. $100k/ $620 = 161 months of operation before cost parity. Mike S

Re: [GENERAL] UPDATE OR REPLACE?

2016-09-01 Thread Mike Sofen
ign pattern. In my mind primary keys are supposed to be static, stable, non-volatile...aka predictable. It feels like an alien invading my schema, to contemplate such an activity. I hope PG never supports that. Postgres allows developers incredible freedom to do really crazy things. That d

Re: [GENERAL] UUIDs & Clustered Indexes

2016-08-30 Thread Mike Sofen
From: George Neuner Sent: Tuesday, August 30, 2016 5:54 PM >Mike Sofen wrote: So in this scenario, I'm using >BOTH bigserials as the PK and uuids as AKs in the core tables. I >reference the bigints for all joins and (have to) use the uuids for the >filters. It's

Re: [GENERAL] UUIDs & Clustered Indexes

2016-08-30 Thread Mike Sofen
s are also design insurance for me in case I need to shard, since I'll need/want that uniqueness across servers. Mike Sofen

Re: [GENERAL] Re: Clustered index to preserve data locality in a multitenant application?

2016-08-30 Thread Mike Sofen
onster loaner Cisco UCS server. Should have that posted to the Perform list later this week. Mike Sofen (USA)

Re: [GENERAL] Stored procedure version control

2016-06-30 Thread Mike Sofen
window, allowing me directly edit/clone without leaving the editor. My coding efficiency using this model is quite high...the overhead of using git is trivial. For rollbacks, we can simply point to the prior stored proc version and recompile those. For DDL rollbacks, I have to code those scripts

Re: [GENERAL] OT hardware recommend

2016-06-18 Thread Mike Sofen
e has said, just buy a 1 TB Samsung EVO 850 for $300 (USD) and call it a day. :) Mike

Re: [GENERAL] PostgresSQL and HIPAA compliance

2016-06-17 Thread Mike Sofen
on securing PHI on relational databases, you'll find lots of details around data access roles, documentation, processes, data obfuscation, etc. Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mai

Re: [GENERAL] regarding schema only migration from sqlserver to postgres with runmtk.sh

2016-06-15 Thread Mike Sofen
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston Sent: Wednesday, June 15, 2016 1:31 PM To: Durgamahesh Manne Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] regarding schema only migration from sqlserver to postgres w

Re: [GENERAL] Alternate or Optimization for with hold cursor

2016-05-12 Thread Mike Sofen
o disk constantly. And since you're working on a single row at time, it will take forever. Convert the cursor into a normal query and you should see BIG (10-1000x) gains in speed. A cursor can always be converted to normal sql...always...it's not always easy but it's always worth the

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-04 Thread Mike Sofen
es like windowing functions. So I guess you’d say I’m in the entirely opposite camp, since it’s proven to be such an effective solution architecture for many applications that leverage relational database engines. Mike Sofen (San Diego, CA USA)

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-04 Thread Mike Sofen
a...where there is zero tolerance for slack db design that could cause scalability or performance issues. My stored functions are...relatively simple. Mike Sofen (San Diego, CA USA) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Function PostgreSQL 9.2

2016-05-03 Thread Mike Sofen
eir peers soon lose interest in collaborating with them, if you catch my drift… Mike Sofen

Re: [GENERAL] (VERY) Slow Query - PostgreSQL 9.2

2016-05-03 Thread Mike Sofen
re this table directly (requiring a change in app code that was filling it), or use it to fill a proper table that already has everything decomposed from the long full_path string via post-processing after the insert. A third consideration would be to archive off older/unneeded rows to a history table to reduce row counts. This is about proper structure. Mike Sofen

Re: [GENERAL] truncate table getting blocked

2016-04-26 Thread Mike Sofen
From: Jayadevan M Sent: Tuesday, April 26, 2016 6:32 AM Hello, I have a python script. It opens a cursor… Thanks, Jayadevan

Re: [GENERAL] Function PostgreSQL 9.2

2016-04-19 Thread Mike Sofen
save, oh, perhaps 10 years of wasted effort and 12 million emails. This is as close to bandaids on bandaids on steroids that it comes. Really – rethink your solution model. Mike From: drum.lu...@gmail.com <mailto:drum.lu...@gmail.com>Sent: Tuesday, April 19, 2016 7:40 PM Just for

Re: [GENERAL] Re: Why is the comparison between timestamp and date so much slower then between two dates

2016-04-14 Thread Mike Sofen
27;t seem prevalent in PG...instead I see people using functions within functions within functions, the cascading impact of which becomes very hard to unravel. Mike Sofen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] I/O - Increase RAM

2016-04-13 Thread Mike Sofen
d get the behaviors sorted out, then it should become obvious what needs fixing. Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] vacuum - reclaiming disk space.

2016-03-19 Thread Mike Blackwell
I have a large table with numerous indexes which has approximately doubled in size after adding a column - every row was rewritten and 50% of the tuples are dead. I'd like to reclaim this space, but VACUUM FULL cannot seem to finish within the scheduled downtime. Any suggestions for reclaiming th

Re: [GENERAL] How to delete few elements from array beginning?

2016-03-09 Thread Mike Sofen
mal sql set-based operations that are readable, understandable, maintainable and very fast/scalable. When I see row by row operations (looping or cursors) in what should be a real time query…that’s my alarm bell that perhaps the code has wandered off a valid solution path. Mike

Re: [GENERAL] regexp_replace to remove sql comments

2015-10-28 Thread Mike
', 'g') , '\s+', ' ', 'g')) as q FROM public.pg_stat_statements WHERE dbid IN (SELECT oid FROM pg_database WHERE datname = current_database()) order by query Thanks again, Mike. On 28/10/2015 22:43, Marc Mamin wrote: ', '\/\*.+\*\/

[GENERAL] regexp_replace to remove sql comments

2015-10-28 Thread Mike
is */ <-- cannot get a regex to do this FROM to_clean ORDER BY q Im now thinking it may be better to do in a pgsql function as I think if the comments are in queries then they need to be ignored. Has anyone done anything like this? Thanks, Mike. -- Sent via pgsql-general mailing list

[GENERAL] Invalid memory alloc request size

2015-08-24 Thread Mike James
1 with 102 table(s) from provider 1 2015-08-24 06:50:33 UTC ERROR remoteWorkerThread_1_1: error at end of COPY IN: ERROR: invalid memory alloc request size 1970234207 CONTEXT: COPY sl_log_1, line 97033: [image: Clutch Holdings, LLC] <http://www.clutch.com> Mike James | Manager of Infra

Re: [GENERAL] inputs into query planner costing

2015-03-31 Thread Mike Roest
Thanks for the responses For anyone searching in the future I'll answer Tom's questions and list the boneheaded fix that it ended up actually being (really painful as I've been fighting this for a week). 1) According to amazon they run stock postgres as far as the query planner is concerned. 2) Y

[GENERAL] inputs into query planner costing

2015-03-31 Thread Mike Roest
Hi there, I'm having an issue with query performance between 2 different pgsql environments. Ther first is our current production postgres server with is running 9.3.5 on Centos 5 x64. The second system is Amazon's RDS postgres as a service. On our local DB server we have a query that executes

Re: [GENERAL] 9.4+ partial log-shipping possible?

2015-03-27 Thread Mike
this helps it would be possible to separate them by tablespaces. Regards Sven -- Mike -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] ltree gist index errors and fill factor questions

2014-12-31 Thread Mike Broers
The database is not crashing thankfully. We are waiting for the errors to come back to turn up logging in the hopes of creating the reproducible set.

Re: [GENERAL] ltree gist index errors and fill factor questions

2014-12-31 Thread Mike Broers
I will do my best to provide a reproducible test case. Is there any more information I can supply in the meantime that would help?

[GENERAL] ltree gist index errors and fill factor questions

2014-12-31 Thread Mike Broers
exes) or a problem with an inadequate fill factor setting. It doesnt look like there is a specified fill factor for this index and I'm not sure what the gist default is. CREATE INDEX index_nodes_on_tree_path ON nodes USING gist (tree_path) The table in question has about 94k rows, an example of the widest tree_path tuple is 69066.69090.69091.69094 Any advice is appreciated, happy new year! Mike

Re: [GENERAL] Hostnames, IDNs, Punycode and Unicode Case Folding

2014-12-29 Thread Mike Cardwell
> which are way more reliable? In that case, you do have a 1:1 lookup > and you shouldn't have a problem. I was unaware of the different versions of IDNA. I basically started using the Perl module IDNA::Punycode in my project and assumed that this was the only type. Seems like I need

Re: [GENERAL] Hostnames, IDNs, Punycode and Unicode Case Folding

2014-12-29 Thread Mike Cardwell
possibly interesting for collaboration, let me know & I'll try > to put together the relevant people. Those functions would be very useful to me. I know a bit of C, but probably not enough to produce an acceptable patch. If there are people who would also find these functions useful, an

Re: [GENERAL] Hostnames, IDNs, Punycode and Unicode Case Folding

2014-12-29 Thread Mike Cardwell
t; > I'm not for knowing the rules of punycode but I'm not seeing what value > lower() provides here... Case insensitive matching. So that "EXAMPLE.COM" = "example.com" -- Mike Cardwell https://grepular.com https://emailprivacytester.com OpenPGP Key

Re: [GENERAL] Hostnames, IDNs, Punycode and Unicode Case Folding

2014-12-29 Thread Mike Cardwell
inal and creating an index on the punycode version. This is exactly the same method that we commonly use for performing case insensitive text searches using lower() indexes. -- Mike Cardwell https://grepular.com https://emailprivacytester.com OpenPGP Key35BC AF1D 3AA2 1F84 3DC3 B0CF 70A5 F5

Re: [GENERAL] Hostnames, IDNs, Punycode and Unicode Case Folding

2014-12-29 Thread Mike Cardwell
as input, I would just do: WHERE lower(punycode_encode(hostname)) = lower(punycode_encode('any-representation')) There doesn't need to be any extra table storage for the punycode encoded version. -- Mike Cardwell https://grepular.com https://emailprivacytester.com OpenPGP Key35

[GENERAL] Hostnames, IDNs, Punycode and Unicode Case Folding

2014-12-29 Thread Mike Cardwell
speed. I'm new to Postgres, and to this list, so if there is a better way for me to submit this suggestion or solve my problem, please point me in the right direction. [1] http://www.unicode.org/Public/UNIDATA/CaseFolding.txt Regards, -- Mike Cardwell https://grepular.com https://emailprivac

Re: [GENERAL] Problem with constraint exclusion on partitions

2014-12-19 Thread Mike Pultz
- pg_catalog | now | timestamp with time zone | | normal | invoker | stable | pgres | internal | now | current transaction time it's the timestamp at the start of the transaction- so the planner should have a set value for all rows. Am I mi

[GENERAL] Problem with constraint exclusion on partitions

2014-12-19 Thread Mike Pultz
ms (7 rows) The types match: cloud_test2=# select pg_typeof(now() - interval '24 hours'); pg_typeof -- timestamp with time zone Is there something I'm missing? Thanks! Mike

[GENERAL] pl/pgsql trigger function - compare *most* columns in NEW vs. OLD

2014-12-18 Thread Mike Blackwell
Is there a simple notation for comparing most columns in the new and old records in a pl/pgsql trigger function? Something like (new.b, new.c, new.d) = (old.b, old.c, old.d) works to compare all the columns except 'a', but is fragile in that it needs to be updated any time a column is added to t

[GENERAL] Vacuum freeze

2014-12-04 Thread Mike Blackwell
check_postgres.pl (--action=autovac_freeze) recently complained that we needed to run VACUUM FREEZE. Doing so generated a boatload of WAL files - perhaps on the order of the of the database itself. Is VACUUM FREEZE something that is normally handled by autovac? If so, how would we approach findi

[GENERAL] Estimating WAL usage during pg_basebackup

2014-10-30 Thread Mike Blackwell
I need to get an idea of how much WAL space will be required during a long (many hours) pg_basebackup over a relatively slow network connection. This is for a server that's not yet running PITR / streaming. Any thoughts? * *

[GENERAL] Any Postgres experts not afraid of the camera?

2014-09-03 Thread Mike Christensen
http://meta.stackoverflow.com/questions/270574/an-experiment-stack-overflow-tv?cb=1

Re: [GENERAL] Regular expression question with Postgres

2014-07-24 Thread Mike Christensen
Yea looks like Postgres has it right, well.. per POSIX standard anyway. JavaScript also has it right, as does Python and .NET. Ruby is just weird. On Thu, Jul 24, 2014 at 1:57 PM, Tom Lane wrote: > Mike Christensen writes: > > I'm curious why this query returns 0: > > S

Re: [GENERAL] Regular expression question with Postgres

2014-07-24 Thread Mike Christensen
, David G Johnston < david.g.johns...@gmail.com> wrote: > Mike Christensen-2 wrote > > I'm curious why this query returns 0: > > > > SELECT 'AAA' ~ '^A{,4}$' > > > > Yet, this query returns 1: > > > > SELECT 'AAA'

[GENERAL] Regular expression question with Postgres

2014-07-24 Thread Mike Christensen
I'm curious why this query returns 0: SELECT 'AAA' ~ '^A{,4}$' Yet, this query returns 1: SELECT 'AAA' ~ '^A{0,4}$' Is this a bug with the regular expression engine?

Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions

2014-07-07 Thread Mike Christensen
Sounds like you just have to wait until it finishes.. On Mon, Jul 7, 2014 at 12:56 PM, Prabhjot Sheena < prabhjot.she...@rivalwatch.com> wrote: > Hello >We are using postgresql 8.3 database for last 5 yrs for this > production database and its running fine. This is our critical database

[GENERAL] EBCDIC conversion

2014-03-27 Thread Mike Blackwell
We have a need to check certain text fields to be sure they'll convert properly to EBCDIC. A check constraint with a convert() was the initial thought, but there doesn't seem to be a default conversion from UTF8 to EBCDIC. Does anyone have an implementation they'd care to share, or suggestions on

Re: [GENERAL] PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC

2014-01-28 Thread Mike Christensen
Oh. The CREATE CAST command. Wow, I was totally unaware of this entire feature! On Tue, Jan 28, 2014 at 3:36 PM, Mike Christensen wrote: > How do you create casts in Postgres? > > > On Tue, Jan 28, 2014 at 3:24 PM, Andrew Sullivan wrote: > >> On Tue, Jan 28, 2014 at 0

Re: [GENERAL] PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC

2014-01-28 Thread Mike Christensen
How do you create casts in Postgres? On Tue, Jan 28, 2014 at 3:24 PM, Andrew Sullivan wrote: > On Tue, Jan 28, 2014 at 02:55:03PM -0800, Mike Christensen wrote: > > > I'd be curious as to what types of bugs were caused by these implicit > > casts.. > > Typically, t

Re: [GENERAL] PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC

2014-01-28 Thread Mike Christensen
es incompatible with certain ORMs out there, which is a bummer. I'm wondering if these ambiguities you speak of could be solved in other ways. Such as implicitly cast iff the intention is not ambiguous, otherwise raise some sort of "ambiguous" error or default to some behavior. Mike

Re: [GENERAL] PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC

2014-01-28 Thread Mike Christensen
reted as correct (like an implicit cast between numeric and enum and string and enum) then we wouldn't have these issues.. Mike On Tue, Jan 28, 2014 at 1:37 PM, John R Pierce wrote: > On 1/28/2014 1:20 PM, Tom Lane wrote: > >> I think you can fix it by explicitly casting you

Re: [GENERAL] question about checksum in 9.3

2014-01-14 Thread Mike Broers
see if that reveals any noticeable performance difference. Thanks again Mike On Mon, Jan 13, 2014 at 7:11 PM, Michael Paquier wrote: > On Tue, Jan 14, 2014 at 1:50 AM, Mike Broers wrote: > > Hello, I am in the process of planning a 9.3 migration of postgres and I > am > >

[GENERAL] question about checksum in 9.3

2014-01-13 Thread Mike Broers
what objects are identified by postgres as corrupt or not corrupt? Are there any other features of the checksum I am missing besides the log entry? Thanks Mike

Re: [GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-12 Thread Mike Christensen
Thanks! Got it working after messing around for a while.. I decided to check out EF for a new project I'm working on. So far, I think I like NHibernate better. A lot more control, and works flawlessly with Postgres and Npgsql. Mike On Thu, Dec 12, 2013 at 8:34 AM, Francisco Figueire

[GENERAL] Npgsql - Where can I find Npgsql.NpgsqlServices

2013-12-11 Thread Mike Christensen
dding 'Npgsql 2.0.14.1' to EFTest. Successfully added 'Npgsql 2.0.14.1' to EFTest. However, this doesn't have it. I've also tried installing the beta from: http://pgfoundry.org/frs/download.php/3494/Npgsql2.0.13.91-bin-ms.net4.5Ef6.zip No luck there. Any ideas? Mike

Re: [GENERAL] Re: corruption issue after server crash - ERROR: unexpected chunk number 0

2013-11-26 Thread Mike Broers
replication at the time of the crash have prevented this from cascading or was it already too late at that point? Thanks again for the input, its been very helpful! Mike On Mon, Nov 25, 2013 at 12:20 PM, Mike Broers wrote: > Thanks Shaun, > > Im planning to schedule a time to do the vacu

Re: [GENERAL] Re: corruption issue after server crash - ERROR: unexpected chunk number 0

2013-11-25 Thread Mike Broers
forward. I'll update the list if I uncover anything interesting in the process and/or need more advice, thanks again for your input - its much appreciated as always. Nothing like a little crash corruption to get the blood flowing! Mike On Mon, Nov 25, 2013 at 10:29 AM, Shaun Thomas wrote: >

Re: [GENERAL] corruption issue after server crash - ERROR: unexpected chunk number 0

2013-11-22 Thread Mike Broers
needs to be run in production. On Thu, Nov 21, 2013 at 5:09 PM, Kevin Grittner wrote: > Mike Broers wrote: > > > Is there anything I should look out for with vacuum freeze? > > Just check the logs and the vacuum output for errors and warnings. > > -- >

Re: [GENERAL] Browsing postgres database using the Eclipse QuantumDB plugin

2013-11-22 Thread Mike Kienenberger
ck in 2007, there was an issue with the quantum support for postgres. Perhaps that's still the case with the version I am using. On Fri, Nov 22, 2013 at 10:28 AM, Mike Kienenberger wrote: > I wanted to make sure that it wasn't a permission configuration > problem in postgres fi

Re: [GENERAL] Browsing postgres database using the Eclipse QuantumDB plugin

2013-11-22 Thread Mike Kienenberger
I wanted to make sure that it wasn't a permission configuration problem in postgres first, since all of the other databases have worked without a similar issue. On Fri, Nov 22, 2013 at 9:54 AM, Adrian Klaver wrote: > On 11/22/2013 05:46 AM, Mike Kienenberger wrote: >> >> Has

[GENERAL] Browsing postgres database using the Eclipse QuantumDB plugin

2013-11-22 Thread Mike Kienenberger
Has anyone successfully connected and browsed a postgres database using the Eclipse QuantumDB plugin? I can connect and execute sql, but the existing table list is always empty as if no meta information is ever provided to the browser plugin. At first, I thought it might be a permission problem

Re: [GENERAL] corruption issue after server crash - ERROR: unexpected chunk number 0

2013-11-21 Thread Mike Broers
for with vacuum freeze? Much appreciated, Mike On Thu, Nov 21, 2013 at 4:51 PM, Kevin Grittner wrote: > Mike Broers wrote: > > > Thanks for the response. fsync and full_page_writes are both on. > > > [ corruption appeared following power loss on the machine hosing > >

Re: [GENERAL] corruption issue after server crash - ERROR: unexpected chunk number 0

2013-11-21 Thread Mike Broers
I am planning on running the reindex in actual production tonight during our maintenance window, but was hoping if that worked we would be out of the woods. On Thu, Nov 21, 2013 at 3:56 PM, Kevin Grittner wrote: > Mike Broers wrote: > > > Hello we are running postgres 9.2.5 on RHEL

[GENERAL] Re: corruption issue after server crash - ERROR: unexpected chunk number 0

2013-11-21 Thread Mike Broers
see if there is a way to force vacuum to continue on error, worst case I might have to script a table by table vacuum script I guess.. If anyone has a better suggestion for determining the extent of the damage Id appreciate it. On Thu, Nov 21, 2013 at 2:10 PM, Mike Broers wrote: > Hello we

[GENERAL] corruption issue after server crash - ERROR: unexpected chunk number 0

2013-11-21 Thread Mike Broers
ion but Im not sure about other tables. Any suggestions for how to handle the tuple concurrently updated error? Or if a reindex is likely to help with the unexpected chunk error? Thanks Mike

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-12 Thread Mike Christensen
Oooh can we make the handle an elephant trunk? (Ok, now I'm sure I'm adding all sorts of expense - but hey you'll save so much money using Postgres you can afford an expensive coffee mug!) On Thu, Sep 12, 2013 at 5:30 AM, Andreas 'ads' Scherbaum < adsm...@wars-nicht.de> wrote: > On 09/10/2013 10

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-09 Thread Mike Christensen
How about something incredibly cheesy like SELECT * FROM Mug; On Mon, Sep 9, 2013 at 8:22 AM, Karsten Hilbert wrote: > Inside of the mug: > > - runs of 0's and 1's = data > - neatly aligned or in compartments/boxes/shelved ? > > Outside of mug: > > 10 elephants > >

[GENERAL] EF / npgsql and VIEWs

2013-09-05 Thread Mike Blackwell
I understand from one of our developers there may be issues using VIEWs with Entity Framework and npgsql. Can anyone with some experience using PostgreSQL in a .NET environment comment? __ *Mike Blackwell | Technical

Re: [GENERAL] function with unknown params

2013-07-09 Thread Mike Christensen
You passed in: 22/1/2013 Which is 22 divided by 1, divided by 2013 - which is an integer.. On Tue, Jul 9, 2013 at 10:17 AM, giozh wrote: > ok, it works. But why on error message i had that two unknown data type? if > was an error on date type, why it don't signal that? > > > > -- > View this

Re: [GENERAL] PERFORM statement

2013-07-08 Thread Mike Christensen
Ah ok that makes sense. The FAQ wasn't exactly clear about that. On Mon, Jul 8, 2013 at 9:38 PM, Tony Theodore wrote: > > On 09/07/2013, at 2:20 PM, Mike Christensen wrote: > > > PERFORM MyInsert(1,101,'2013-04-04','2013-04-04',2,'f' ); >

[GENERAL] PERFORM statement

2013-07-08 Thread Mike Christensen
4-04',2,'f' ); I get the error: ERROR: syntax error at or near "PERFORM" SQL state: 42601 Character: 1 Is the FAQ out of date or was this feature removed? I'm using 9.2.1. Thanks! Mike

Re: [GENERAL] View's plan not taking advantage of WHERE?

2013-06-05 Thread Mike Summers
d by a Rails app. We'll see what else we can come-up with. Thanks again. On Wed, Jun 5, 2013 at 9:16 AM, Tom Lane wrote: > Mike Summers writes: > > Other than the tests in the original post do you have any suggestions? > > If you're speaking of > > http://www.p

Re: [GENERAL] View's plan not taking advantage of WHERE?

2013-06-05 Thread Mike Summers
Thanks Scott, interesting. Other than the tests in the original post do you have any suggestions? Thanks for your time.

Re: [GENERAL] View's plan not taking advantage of WHERE?

2013-06-05 Thread Mike Summers
>From what I'm reading the View is frozen when it's created, including it's plan, and the usual solution is to use a set returning function... is this not true? I've double checked all schemas and the view is only defined once. Thanks.

Re: [GENERAL] View's plan not taking advantage of WHERE?

2013-06-05 Thread Mike Summers
It appears that the culprit is a cached query plan, the tables in the UNION have changed and no long match however the View does not throw a "each UNION query must have the same number of columns" error. Is there a way to force the View's query plan to be updated on each access?

[GENERAL] View's plan not taking advantage of WHERE?

2013-06-04 Thread Mike Summers
I have a VIEW that does not appear to take advantage of the WHERE when given the opportunity: db=# explain select * from best_for_sale_layouts; QUERY PLAN A

Re: [GENERAL] Success stories of PostgreSQL implementations in different companies

2013-05-23 Thread Mike Christensen
On Thu, May 23, 2013 at 2:51 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > On 05/23/2013 02:36 PM, Oscar Calderon wrote: > >> Hi, this question isn't technical, but is very important for me to know. >> Currently, here in El Salvador our company brings PostgreSQL support, but >> Ora

Re: [GENERAL] dblink does not resolve DNS, but works with IP

2013-05-15 Thread Mike Christensen
Ah, gotcha! I guess whatever sample I was originally copying from used hostaddr for some reason.. Thanks for the clarification, Tom! On Wed, May 15, 2013 at 6:08 AM, Tom Lane wrote: > Mike Christensen writes: > > Though I'm a bit curious why there's a host and host

Re: [GENERAL] dblink does not resolve DNS, but works with IP

2013-05-14 Thread Mike Christensen
Though I'm a bit curious why there's a host and hostaddr. Why can't it just resolve whatever you give it? On Tue, May 14, 2013 at 9:31 PM, Mike Christensen wrote: > Excellent! Thanks so much. > > > On Tue, May 14, 2013 at 9:25 PM, Adrian Klaver wrote: > &

Re: [GENERAL] dblink does not resolve DNS, but works with IP

2013-05-14 Thread Mike Christensen
Excellent! Thanks so much. On Tue, May 14, 2013 at 9:25 PM, Adrian Klaver wrote: > On 05/14/2013 09:17 PM, Mike Christensen wrote: > >> If I have this: >> >> CREATE OR REPLACE VIEW Link.Foo AS >>select * from dblink( >> 'hostaddr=123.

[GENERAL] dblink does not resolve DNS, but works with IP

2013-05-14 Thread Mike Christensen
If I have this: CREATE OR REPLACE VIEW Link.Foo AS select * from dblink( 'hostaddr=123.123.123.123 dbname=KitchenPC user=Website password=secret', 'select * from Foo') as ... Then it works. However, if I do: CREATE OR REPLACE VIEW Link.Foo AS select * from dblink( 'hostaddr=db.d

[GENERAL] Where in the source code does postgres write to disk?

2013-04-20 Thread Mike Levine
According to http://www.postgresql.org/docs/9.2/static/storage-file-layout.html "When a table or index exceeds 1 GB, it is divided into gigabyte-sized segments. The first segment's file name is the same as the filenode; subsequent segments are named filenode.1, filenode.2, etc." I was wondering w

[GENERAL] Where in the source code does postgres write to disk?

2013-04-20 Thread Mike Levine
According to http://www.postgresql.org/docs/9.2/static/storage-file-layout.html "When a table or index exceeds 1 GB, it is divided into gigabyte-sized segments. The first segment's file name is the same as the filenode; subsequent segments are named filenode.1, filenode.2, etc." I was wondering w

Re: [GENERAL] Fetching Server configured port from C Module

2013-04-17 Thread Mike Roest
Perfect thanks Bruce that worked. I just extern'd PostPortNumber in my module and everything seems to be working. --Mike

Re: [GENERAL] Fetching Server configured port from C Module

2013-04-17 Thread Mike Roest
> SHOW PORT; > test=> SELECT setting FROM pg_settings WHERE name = 'port'; setting - 5432 Both of these are from a query context. This is in a C module, I suppose I could run a query but there has to be a direct C function to get this data.

[GENERAL] Fetching Server configured port from C Module

2013-04-17 Thread Mike Roest
Hi There, I'm having a bit of an issue finding a C function to fetch the configured server port from a C module. We have written a C module to allow for remote clients to call a function to run pg_dump/pg_restore remotely but create files locally on the db server. Currently it works fine if th

  1   2   3   4   5   6   7   8   9   10   >