Re: [GENERAL] archive_command not being executed

pick up the activity covered in the WAL files. From: Jeremy Schneider Sent: Monday, November 13, 2017 3:56 PM To: eric...@hotmail.com Cc: PostgreSQL General; Paul Jungwirth Subject: Re: [GENERAL] archive_command not being executed Hi Eric, Thanks for using PostgreSQL! On Fri, Nov 10, 2017 at

Re: [GENERAL] archive_command not being executed

before. From: Michael Paquier Sent: Monday, November 13, 2017 6:01 PM To: Jeremy Schneider Cc: eric...@hotmail.com; PostgreSQL General; Paul Jungwirth Subject: Re: [GENERAL] archive_command not being executed On Tue, Nov 14, 2017 at 8:56 AM, Jeremy Schneider wrot

[GENERAL] archive_command not being executed

I have a standby db server (SB1) that will soon become the master. SB1 is set up with streaming replication from the current master. I'm trying to set up a third server (SB2) as a slave/standby to SB1, so that when SB1 becomes the master, there will be a standby for it. First step is to get W

Re: [GENERAL] Aquameta 0.1 - Request for reviews, contributors

Thanks Nico. I definitely like this syntax better. -- Eric Hanson CEO, Aquameta Labs 503-929-1073 www.aquameta.com On Fri, Sep 8, 2017 at 4:26 PM, Nico Williams wrote: > > Here's a review comment. Just one for now. > > Looking at the meta module, I see things like this: &g

Re: [GENERAL] Performance issue with Pointcloud extension

> Another idea, if you haven't tried it already, is to run these test cases > in a server built with --enable-debug and --enable-cassert. The memory > clobber stuff that's enabled by the latter is very good at turning coding > errors into reproducible, debuggable crashes ;-) > >

Re: [GENERAL] Performance issue with Pointcloud extension

On 06/08/2017 10:41 PM, Éric wrote: > > > >> Have you experimented with other queries that don't involve PostGIS? >> I'm wondering if your hook-installation code fails to work properly >> unless PostGIS was loaded first. This would be easier to credit if >> there are hooks both extensions try t

Re: [GENERAL] Performance issue with Pointcloud extension

On 06/08/2017 07:27 PM, Moreno Andreo wrote: > Il 08/06/2017 19:10, Eric Lemoine ha scritto: >> >> How can such a thing happen? Thanks for any insight on what could cause >> this. >> >> > I'd try raising shared_buffers to 1 GB or something near 40% of the

Re: [GENERAL] Performance issue with Pointcloud extension

> Note that the execution time is 46 ms when the query is wrapped in an > explain analyze (while it's 3 s when it's not!) Actually, it seems to me that the performance issue is not on the query itself, it is on the fetching of the data returned by the query. Which explains why the query is fast

Re: [GENERAL] Performance issue with Pointcloud extension

> Lots of missing information here ... > > Is there an index on public.sthelens.points? Yes, there are. lopocs=# \d sthelens; Table "public.sthelens" Column |Type| Modifiers ++-

Re: [GENERAL] Performance issue with Pointcloud extension

> Looks like you also have postgis and pointcloud_postgis in mix. I would > say this may get an answer sooner here: > > http://lists.osgeo.org/mailman/listinfo/pgpointcloud/ I am actually one of the developers of the Pointcloud extension. I haven't been able to debug this up to now. -- Éric L

[GENERAL] Performance issue with Pointcloud extension

Hi We have a rather strange performance issue with the Pointcloud extension [*]. The issue/bug may be in the extension, but we don't know for sure at this point. I'm writing to the list to hopefully get some guidance on how to further debug this. [*]

Re: [GENERAL] storing large files in database - performance

nd(); }) .catch(function(err) { callback(err); pgp.end(); }); }; Thanks very much! Eric -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Another point, some googling turned up https://www.npmjs.com/package/pg-large-object which is definitely someth

Re: [GENERAL] storing large files in database - performance

Thanks, Merlin - lots of good information here, and I had not yet stumbled across pg-large-object - I will look into it. Eric -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Thursday, May 18, 2017 9:49 AM To: Eric Hill Cc: Thomas Kellerer ; PostgreSQL General

Re: [GENERAL] storing large files in database - performance

My apologies: I said I ran "this query" but failed to include the query. It was merely this: SELECT "indexFile"."_id", "indexFile"."contents" FROM "mySchema"."indexFiles" AS "indexFile" WHERE "indexFile&q

Re: [GENERAL] storing large files in database - performance

6MB per second, not 76. Do you suppose pgAdmin 4 and I are doing similarly inefficient things in querying bytea values? Thanks, Eric -Original Message- From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Wednesday, May 17, 2017 10:21 AM To: Thomas Kellerer Cc: PostgreSQL Gener

Re: [GENERAL] storing large files in database - performance

OK, thanks very much. It seems like my process is somehow flawed. I'll try removing some layers and see if I can figure out what is killing the performance. Eric > > Do these numbers surprise you? Are these files just too large for > storage in PostgreSQL to be practical?

[GENERAL] storing large files in database - performance

driver in between my code and the database. Thanks, Eric

Re: [GENERAL] PDF files: to store in database or not

On 12/06/2016 02:40 PM, Joshua D. Drake wrote: On 12/06/2016 11:12 AM, Eric Schwarzenbach wrote: On 12/06/2016 01:34 PM, Joshua D. Drake wrote: On 12/06/2016 10:30 AM, Rich Shepard wrote: My thinking is to not store these documents in the database, but to store them in subdirectories

Re: [GENERAL] PDF files: to store in database or not

On 12/06/2016 01:34 PM, Joshua D. Drake wrote: On 12/06/2016 10:30 AM, Rich Shepard wrote: My thinking is to not store these documents in the database, but to store them in subdirectories outside the database. Your thoughts? Due to the widely variable size of a PDF document, I would say

Re: [GENERAL] PDF files: to store in database or not

don't know that we had any real data that this should have been a concern, and I suspect you could ameliorate if not eliminate this as an issue by careful design. I'd loved to hear this idea confirmed or debunked by someone who has more expertise (and ideally, done actual testing).

Re: [GENERAL] How to manually force a transaction wraparound

On Fri, Apr 29, 2016 at 10:16 PM Thomas Munro wrote: > On Sat, Apr 30, 2016 at 10:48 AM, Eric Ridge wrote: > > I want to force my database to wraparound, just to see what happens. How > > can I do this without consuming a few billion transactions? > > Take a look at t

[GENERAL] How to manually force a transaction wraparound

I want to force my database to wraparound, just to see what happens. How can I do this without consuming a few billion transactions? My google-fu is failing me. :( Thanks for your time! eric

Re: [GENERAL] Proper relational database?

On 04/22/2016 06:21 AM, David Goodenough wrote: On Thursday 21 April 2016 13:36:54 Guyren Howe wrote: Anyone familiar with the issue would have to say that the tech world would be a significantly better place if IBM had developed a real relational database with an elegant query language rather t

[GENERAL] How jsonb updates affect GIN indexes

creating a GIN index on the whole (rather large) column. Thanks, Eric

Re: [GENERAL] Domain check constraint not honored?

On 10/30/2015 09:53 AM, Jim Nasby wrote: On 10/29/15 5:29 PM, Eric Schwarzenbach wrote: I'm just now converting that path to use a custom domain (along with custom operators) instead of just being a string. (The custom operators allow the paths to be sorted properly without each segment ne

Re: [GENERAL] Domain check constraint not honored?

Thank you! (Slapping head) Your regexp seems to do the trick. On 10/29/2015 01:49 PM, Rob Sargent wrote: On 10/29/2015 11:41 AM, Eric Schwarzenbach wrote: I have created a custom type as a domain based on text, which adds a check constraint using a regexp to limit it to containing digits and

Re: [GENERAL] Domain check constraint not honored?

e paths to be sorted properly without each segment needing to be filled with zeros to a fixed length.) (Also FWIW, the latest version of this regexp is now '^([0-9]+.)*[0-9]+$') Cheers, Eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chan

Re: [GENERAL] Domain check constraint not honored?

Thank you! (Slapping head) Your regexp seems to do the trick. On 10/29/2015 01:49 PM, Rob Sargent wrote: On 10/29/2015 11:41 AM, Eric Schwarzenbach wrote: I have created a custom type as a domain based on text, which adds a check constraint using a regexp to limit it to containing digits and

[GENERAL] Domain check constraint not honored?

result is the same. It lets me store letters in a column defined to be of this type. The version() function tells me "PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit" Thanks, Eric -- Sent via pgsql-general mailing list (pgsql-genera

[GENERAL] express composite type literal as text

ot;,42,1.99)'; select * from on_hand where item=$$("fuzzy dice",42,1.99)$$; How do I express a composite type literal as text? Any workarounds? The text-based representation of values is a hard requirement in my project... Thanks, Eric

[GENERAL] express composite type literal as text

ce",42,1.99)$$; How do I express a composite type literal as text? Thanks, Eric

Re: [GENERAL] express composite type literal as text

n exception to a rule that is generally true and aimed for, or is that just not a good assumption? Thanks, Eric

Re: [BUGS] [GENERAL] express composite type literal as text

that you can't use composite types in a REST interface or any other string-based interface, unless the POST handler look up the type of all columns and checks for the special case, to add the explicit cast. It adds a lot of overhead that is 99% unnecessary. Thanks, Eric

Re: [GENERAL] express composite type literal as text

On Sun, Feb 22, 2015 at 11:47 AM, Tom Lane wrote: > Eric Hanson writes: > > How do I express a composite type literal as text? > > The rules are given in the manual ... > > > I can't use the ROW() notation, because all values need to be represented > > as text

Re: [GENERAL] express composite type literal as text

n exception to a rule that is generally true and aimed for, or is that just not a good assumption? Thanks, Eric On Sun, Feb 22, 2015 at 11:42 AM, Adrian Klaver wrote: > On 02/22/2015 10:07 AM, Eric Hanson wrote: > > Hi, > > > > How do I express a composite type literal as text?

[GENERAL] express composite type literal as text

ERROR: input of anonymous composite types is not implemented I've tried various forms of quote escaping and dollar quoting as the docs suggest, but they all produce that same error: select * from on_hand where item='(\\\"fuzzy dice\\\",42,1.99)'; select * from on_hand where item=$$("fuzzy dice",42,1.99)$$; Thanks, Eric

Re: Fwd: Fwd: [GENERAL] Problem with pg_dump and decimal mark

thanks for your support, Eric 2014-12-10 15:27 GMT+01:00 Adrian Klaver : > > On 12/10/2014 01:32 AM, Eric Svenson wrote: > >> So, one more success... >> >> I have taken a part of the backup SQL file which fills the table >> >> COPY dev_my_settings (.

Re: Fwd: Fwd: [GENERAL] Problem with pg_dump and decimal mark

;, 123, 123.345); Value 123.345 can be read from pg_admin. SHOW ALL shows English_United States.1252 for all lc_ settings (but I have tried it with German and C locale with same results) Regards, Eric 2014-12-08 22:57 GMT+01:00 Adrian Klaver : > On 12/08/2014 06:53 AM, Eric Svenson wrote: > &

Re: Fwd: Fwd: [GENERAL] Problem with pg_dump and decimal mark

dev_my_settings table, everything is ok. 2014-12-10 10:23 GMT+01:00 Eric Svenson : > > The restore left you with two empty tables. What happens if you log into > Postgres > via psql and then INSERT one set of values containing floats > into say, >dev_my_settings? > >

Re: Fwd: Fwd: [GENERAL] Problem with pg_dump and decimal mark

TEXT: COPY file_item, line 54, column fi_latitude: "48.2000829" WARNING: errors ignored on restore: 2 Regards, Eric 2014-12-05 16:22 GMT+01:00 Adrian Klaver : > On 12/05/2014 01:13 AM, Eric Svenson wrote: > >> >> >> Hi Adrian, >> >> Is the above

Re: Fwd: Fwd: [GENERAL] Problem with pg_dump and decimal mark

viewed with pg_admin. The table definitions for dev_my_settings and file_item contain lots of BIGINTS, smallints and integers, and several double precision values. All other tables do not contain any double precision values. Regards, Eric 2014-12-08 15:22 GMT+01:00 Adrian Klaver : > On 12/08/2014

Fwd: Fwd: [GENERAL] Problem with pg_dump and decimal mark

"ERROR" (english) "KONTEXT" (german, one line below) ?? To add further confusion: I have a report that the error also appeared on a non-VM native PC with Windows 7 Enterprise. Unfortunately, I dont have the exact error message, but I try to get it ASAP. regards, Eric Svenson

Re: Fwd: [GENERAL] Problem with pg_dump and decimal mark

dev_my_settings, line xxx, column xxx: "0.2" ERROR: invalid input syntax for type double precision "15.776653623" Regards, Eric Svenson 2014-12-04 11:00 GMT+01:00 Eric Svenson : > > So what if you load to the VM Postgres using the psql from the host? > > I tried

Fwd: [GENERAL] Problem with pg_dump and decimal mark

r did you use the psql on the host? psql on the VM > Was the Postgres/psql on the host the same as the VM? Same Version (9.2.1) > What are you using for virtualization? VM Ware Player 6.0.2 > What is host OS? Windows 7 Enterprise SP 1 (see above) Again, thank you for the support. Regards, Eric Svenson

Re: [GENERAL] Problem with pg_dump and decimal mark

OSIX, but we keep LC_NUMERIC set to "C" to force it to >> only believe that "." is decimal point. >> > > Not sure if this makes a difference but if I am reading the original post > correctly the OP was trying a plain text restore via psql. This is correct. regards and thanks for your support, Eric Svenson

[GENERAL] Problem with pg_dump and decimal mark

precision: 0.1001) When I change the value in the sql file manually to 0,1001 the and try again, the restore resumes until the next double value. How is this possible? Does psql really expect comma-seperated decimal values in the sql file? How can I change this behaviour? Regards, Eric

Re: [GENERAL] postgresql for small business

On 11/19/14, 6:54 AM, "Ernesto Quiñones" wrote: >Hi friends > >I am looking for a postgresql solution in an "appliance" for small >business > >know somebody who is selling this kind of solutions? > >thanks > >-- If you are OK with a cloud based solution, Amazon RDS might be a decent fit for yo

Re: [GENERAL] PANIC: could not create file "pg_xlog/xlogtemp.7884": No space left on device

-hi' (for inodes). You might have ran out of inodes... Eric signature.asc Description: OpenPGP digital signature

Re: [GENERAL] can't restore database created with pg_dump

Thank you for the help! Regards, Eric On Sep 20, 2014, at 6:55 AM, Adrian Klaver wrote: > On 09/19/2014 07:51 PM, Eric Smith wrote: >> All, >> >> I created a backup using pg_dump, postgres 8.3. I'm trying to restore that >> into a new postgres 9.3.5 i

[GENERAL] can't restore database created with pg_dump

s, and on some it fails. All installations are moving from 8.3 to 9.3.5. Any ideas? Thanks, Eric -- 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] GiST index question

Thank you both, I will look into alternative data types. I don’t think ltree will work for my purposes but I am going to try out some others that might; like cube. — Eric Fleming On Thu, Sep 4, 2014 at 3:42 AM, Giuseppe Broccolo wrote: > Hi Eric, > As Michael said, path data type do

[GENERAL] GiST index question

te an index on the path data type or do I need to enable an extension for this to work? Thanks in advance for your help. — Eric Fleming

[GENERAL] Memory leak with CREATE TEMP TABLE ON COMMIT DROP?

all is well, but I was very shocked to see Postgres behaving badly here. Any thoughts? And thanks for your time! eric PROPRIETARY AND COMPANY CONFIDENTIAL COMMUNICATIONS The information contained in this communication is intended only for the use of the addressee. Any other use is strictly pr

[GENERAL] problems with permissions

so the user that installed postgres initially. Any help is much appreciated!! Regards, Eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Need help with upsert

Hi, I need some help with upsert. Some info on what I want to do: Each day I create a table for my firewall logs. I have one entry for one occurrence of all the field except sum, which is the number of occurrence I have of each log that match all the field. My table has the f

Re: [GENERAL] Need help with upsert

LINE 3: ... a WHERE NOT EXISTS (SELECT * FROM upsert b WHERE b.firewall... As you can see it is b.firewall where b is alias to table upsert. That's why I don't understand the error. From: Serge Fonville [mailto:serge.fonvi...@gmail.com] Sent: December 4, 2013 12:53 P

[GENERAL] Need help with upsert

Hi, I need some help with upsert. Some info on what I want to do: Each day I create a table for my firewall logs. I have one entry for one occurrence of all the field except sum, which is the number of occurrence I have of each log that match all the field. My table has the f

Re: [GENERAL] v9.3.0: bug with pgdump -s?

. Too bad. eric PROPRIETARY AND COMPANY CONFIDENTIAL COMMUNICATIONS The information contained in this communication is intended only for the use of the addressee. Any other use is strictly prohibited. Please notify the sender if you have received this message in error. This communication is

[GENERAL] v9.3.0: bug with pgdump -s?

o be invalid Additionally, the operator classes seem to be incomplete in pg_dump's output: CREATE OPERATOR CLASS box_ops DEFAULT FOR TYPE box USING gist AS ; ... CREATE OPERATOR CLASS text_ops DEFAULT FOR TYPE text USING btree AS ; I'd expect them to be fully sp

[GENERAL] Need help with Inet type

e more than 1 row return from the second select. Is there a way to achive that? Thanks. ___ Eric Lamer IT Security Specialist INTACT Financial Corporation (450) 778-9580 ext. 3744

Re: [GENERAL] create database from template requires the source database to be unused

sessions were idle, or > to abort all transactions and roll them back. I've read that postgres uses MVCC for transactions, and that it creates snapshots of the database for each transaction. Couldn't the create database command just use that snapshot? eric -- Sent via p

Re: [GENERAL] retrieving function raise messages in ecpg embedded sql code

> -Original Message- > From: Jeff Davis [mailto:pg...@j-davis.com] > > On Mon, 2012-06-18 at 21:35 +, Haszlakiewicz, Eric wrote: > > I'm trying to get some additional information back from a trigger to > > my embedded SQL program, to essentially emulate I

[GENERAL] retrieving function raise messages in ecpg embedded sql code

2; I can't figure out how to retrieve the message raised by the trigger. I know it's available in some cases, because I see the message when I insert a row through psql, but even things like this: printf("%s\n", PQerrorMessage(ECPGget_PGconn(mydb))); return nothin

[GENERAL] Can postgres be configure for GSS/Kerberos authentication without a keyfile?

tgres.conf? If not do I have to set any krb5 postgres.conf parameters? -- Eric (alias buckwheat) CONFIDENTIALITY: This email (including any attachments) may contain confidential, proprietary and privileged information, and unauthorized disclosure or use is prohibited. If you received this email

[GENERAL] Can postgres be configure for GSS/Kerberos authentication without a keyfile?

is unknown or unreachable (80090303) Do I have to set the "krb_server_keyfile" in the postgres.conf? If not do I have to set any krb5 postgres.conf parameters? -- Thank you for your time Eric (alias buckwheat) CONFIDENTIALITY: This email (including any attachments) may contain

[GENERAL] [RFE] auto ORDER BY for SELECT

I'm not sure if this is the right list to discuss this, but, I have a suggestion: ORDER BY clause, as defined in the SELECT documentation says: "If ORDER BY is not given, the rows are returned in whatever order the system finds fastest to produce" This order is usually not wanted, as it is not p

Re: [GENERAL] adding a column takes FOREVER!

Tom, Well... there's a lot of data hiding in each of those rows... as much as 4MB in each. I'll make allowances in my code so that adding a column without a default is a workable solution. Thank you, Eric On Nov 1, 2011, at 8:27 PM, Tom Lane wrote: > Eric Smith writes: >

Re: [GENERAL] adding a column takes FOREVER!

running on Mac OS 10.7) Thanks again, Eric [tableString setString:@""]; [tableString appendString:@"create table images (\"imageID\" varchar(11) primary key,"]; [tableString appendString:@"\"patientID\" varchar(11) null,"];

[GENERAL] adding a column takes FOREVER!

he table has ~ 50 columns. Thanks, Eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

On Wed, Oct 5, 2011 at 1:24 AM, Dave Page wrote: > > > On Wednesday, October 5, 2011, Thomas Kellerer wrote: > > Dave Page, 04.10.2011 21:46: > > >> > >> We updated our build system to use BitRock 7 today (for unrelated > >> reasons) which has new features for ACL management. We're going to > >>

Re: [GENERAL] Global Variables?

On Tue, Oct 11, 2011 at 04:26:47PM +0200, Alban Hertroys wrote: > On 11 October 2011 16:06, Eric Radman wrote: > > When writing unit tests it's sometimes useful to stub functions such > > as the current date and time > > You could create a table for such "constant

[GENERAL] Global Variables?

PLACE FUNCTION ... before each assert() current_time := '2012-01-01'::timestamp SELECT assert(5, (SELECT count(*) FROM expired_accounts)::integer); -- Eric Radman | http://eradman.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] OS X 10.7, psql, and tab completion?

Hi! What's the incantation one needs to recite before compiling Postgres 8.4.x on OS X 10.7 such that psql's tab completion will work? I love my Mac, but Apple really dorked up libedit/readline and I just can't figure out what I'm supposed to do. Any hints will be greatl

Re: [GENERAL] error when compiling a c function

c-c.html (I can't comment on the OP's actual problem) eric -- 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] What's eating my space ?

n) > Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > Since he used pg_total_relation_size(), according to the manual ( http://www.postgresql.org/docs/current/interactive/functions-admin.html) indexes and toast should be included in the numbers reported for the tables. Unfortunately, I don't have any insight as to why pg_database_size() is returning a number roughly 5x larger than the sum of pg_total_relation_size() here. -Eric

Re: [GENERAL] How to handle bogus nulls from ActiveRecord

David suggested using a guesstimate default date along with a boolean to indicate when you're using guesstimates. I think this is a solid approach, but if the default expected_by idea doesn't work for you, a boolean would still make this a lot easier on the Rails side. It sounds like you're using

Re: [GENERAL] Massive delete from a live production DB

Am 12.05.2011 16:38, schrieb Phoenix Kiula: On Thu, May 12, 2011 at 10:33 PM, Eric Ndengang wrote: Am 12.05.2011 16:23, schrieb Phoenix Kiula: Hi Been reading some old threads (pre 9.x version) and it seems that the consensus is to avoid doing massive deletes from a table as it'll crea

[GENERAL] Index bloat with "USING GIN(varchar[])" index?

this, but it smells like index bloat. Are GIN indexes known for bloating, especially if they're on a varchar[]? Any suggestions for how to prove/disprove that it's index bloat? eric -- 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] converting databases form SQL_ASCII to UTF8

f the lack of being able to check encoding errors at the database level doesn't bother you, and you're fine with risking bigger pain later in order to avoid pain now, then I see no compelling reason to move away from SQL_ASCII. -Eric

Re: [GENERAL] pg_dump generating unrestorable data (8.4)

error if a dump from a database with SQL_ASCII or some non-unicode encoding failed to restore to a UTF8 encoded database in this manner, for example. And 2nd, does specifying the client encoding when making the backup, with 'pg_dump -E UTF8', produce behavior closer to what you would have expected? -Eric

Re: [GENERAL] Inserting data from one database to another using stored functions

SELECT > sp_insert_detailtable('|| pActivityId ||', '|| pserialnumber ||')');* in > this line. > > > > Your help is highly appreciated! > > > > Thanks and Best Regards, > > Benjie > dblink_exec is only for commands which return no result. Try replacing that line with the following and see if it helps: PERFORM dblink('SELECT sp_insert_detailtable('|| pActivityId ||', '|| pserialnumber ||')'); -Eric

[GENERAL] Postgres DOD Certification Common Criteria Level

ld be greatly appreciated-- Thanks, Eric McDonaldSr Network AdministratorPDC

Re: [GENERAL] Any advice on debugging hanging postgresql-8.1.21 (many postmaster's)

Specifically look into setting. log_min_duration_statement (integer) in the postgresql.conf file. -Original Message- From: Robert Gravsjö [mailto:tekniksupp...@blogg.se] Sent: Monday, October 04, 2010 7:22 AM To: Alexander Farber Cc: pgsql-general@postgresql.org Subject: Re: Any ad

Re: [GENERAL] Exclusion constraint issue

On Tue, Sep 28, 2010 at 4:07 PM, Jeff Davis wrote: > On Tue, 2010-09-28 at 12:18 -0600, Eric McKeeth wrote: > > > This is ugly, but it does seem to enforce the constraint I need, of > > non-overlapping dates where sharing an endpoint is not considered an > > overlap. >

Re: [GENERAL] Exclusion constraint issue

On Fri, Sep 24, 2010 at 3:22 PM, Tom Lane wrote: > Eric McKeeth writes: > > why would I get the following error, since the period() function is in > fact > > declared as immutable? > > > test=# ALTER TABLE test3 ADD exclude using > > gist(period(effe

[GENERAL] Exclusion constraint issue

_date::timestamptz, expire_date::timestamptz) with && ); ERROR: functions in index expression must be marked IMMUTABLE Thanks in advance for any assistance. -Eric

[GENERAL] unexpected EOF on client connection

ow i could solve this issue? Thanks in advance -- Eric Ndengang Junior Datenbankentwickler Affinitas GmbH | Kohlfurter Straße 41/43 | 10999 Berlin | Germany email: eric.ndengang_fo...@affinitas.de | tel: +49.(0)30. 991 949 5 0 | www.edarling.de Geschäftsführer: Lukas Brosseder, Da

[GENERAL] pgcrypto pgp_pub_decrypt() fails with secret key password

th were built with OpenSSL support) I've verified my SQL code via psql and I feel pretty confident it's OK, since I have it narrowed down to where the only difference is whether the gpg exported keys were originally assigned with a passphrase, or not assigned a passphrase (just pres

Re: [GENERAL] Feature proposal

On Wed, 2010-08-25 at 17:06 +0200, Denis BUCHER wrote: > Le 25.08.2010 09:15, wstrzalka a crit : > > I'm currently playing with very large data import using COPY from > > file. > > > > As this can be extremely long operation (hours in my case) the nice > > feature would be some option to show opera

Re: [GENERAL] How to refer to computed columns from other computed columns?

Is this the best possible solution? Thanks for the help. Matt You can also use the ' with Queries ' option to solve this Problem like this: with table_1 as (select a,b, a-b as c from foo) Select a,b, c, case when c<0 then 'no' else 'yes' end as d

Re: [GENERAL] Read Committed Transaction Isolation and SELECT ... UNION ... SELECT

ed, but wanted to make sure. eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Read Committed Transaction Isolation and SELECT ... UNION ... SELECT

ne query issued by the client, are the two SELECT statements still operating within the same snapshot? Is the above considered to be one command? I think the answer to those questions is "Yes", but I'd appreciate some clarification. Thanks in advance! eric -- Sent via pgsql-gener

[GENERAL] Recovering Data from a crashed database

orage device. We do have the files under /data/base. pgfsck looked like the right tool for the job, but seems to be outdated and lacking support for 8.3 I'm open to all options including outsourcing the data recovery. Any help is appreciated. Thank you, Eric

[GENERAL] Recovering Data from a crashed database

orage device. We do have the files under /data/base. pgfsck looked like the right tool for the job, but seems to be outdated and lacking support for 8.3 I'm open to all options including outsourcing the data recovery. Any help is appreciated. Thank you, Eric

Re: [GENERAL] Cannot access various Postgres sites

On Sat, Apr 17, 2010 at 1:42 PM, Adrian Klaver wrote: I can get to both sites and telnet also. Must be something on your end :( > Yup, it was. :( I appreciate the confirmation that it was me, thanks! eric

Re: [GENERAL] Cannot access various Postgres sites

It's not DNS. I can resolve the hostnames just fine. In fact, those two both resolve to the same IP: 200.46.204.71 They just don't respond. $ telnet 200.46.204.71 80 Trying 200.46.204.71... just hangs indefinitely. :( eric I could read the release notes for 9.0 b

[GENERAL] Cannot access various Postgres sites

ek inside the JDBC driver sources before I join their mailing list and ask a bunch of dumb questions, but jdbc.postgresql.orgisn't responding either. I've also seen intermittent connectivity issues with planet.postgresql.org, but it seems to be working today. Is it just my network or is something up with these hosts? eric

Re: [GENERAL] GROUP BY column alias?

On Feb 18, 2010, at 5:52 PM, Scott Bailey wrote: > SQL name resolution rules are that column names have higher precedence than > aliases and variables. So it will always bind to the column not the alias. That explains it. Thanks. Breaks the rule of least surprise, but it is SQL.

Re: [GENERAL] GROUP BY column alias?

queries I'm dealing with are machine generated, and that's what the generator does, in all cases. eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] GROUP BY column alias?

boggles my mind, especially when you consider the case above it, where "day" is aliased as "bar" and grouping by "bar" works as expected. eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

  1   2   3   4   5   >