Re: [GENERAL] Help: chinese character set support (EUC_TW to/from

| name | character varying(50) | euc_tw=# insert into contacts values('1','\345\244\251\345\244\251'); INSERT 17235 1 euc_tw=# select * from contacts euc_tw-# ; id | name + 1 | 天天 (1 row) Thanks for pinpointing the potential cause, so makes the trou

[GENERAL] cannot get build (initdb) to work after trying for a week

I am getting truly desperate! I am trying to build any version of Postgres on Windows from source. First experience with Postgres source. I have struggled for days trying to solve a problem. Would be willing to pay for the solution!!! The following error occurred when issuing a vanilla initdb c

Re: [GENERAL] cannot get build (initdb) to work after trying for a week

To respond to Alvaro's post, I did try setting TZ=PST, no luck there. As Magnus points out, the install doesn't appear complete because of the missing timezone dir. ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] cannot get build (initdb) to work after trying for a week

s to go besides the PG documentation and the pgsql newsgroups? Regards, Eric ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] Another list for windows port...

It is possible to mainteners of this list to keep this list from "/$?%/$?/? windows problems? I don't care about windows. The worst thing never made was porting an excellent product like PostgreSQL to a poor server OS like windows. Now, we are invade with users that aren't used to read the manua

[GENERAL] QMail

Is there something to interface postgreSQL with QMail to store mails in pgsql instead of using mbox or maildir? Or maybe it's not a good idea to do that? I think there is some adavantages... ---(end of broadcast)--- TIP 3: if posting/reading thro

Re: [GENERAL] Visual Designer in linux?

to make it work with postgres, I don't know if I will have a non-optimized database at the end... because DBDesigner4 won't take profit of postgres features? On Sun, 2004-11-07 at 00:29, Alvaro Herrera Munoz wrote: > On Sat, Nov 06, 2004 at 10:32:30PM -0500, Eric wrote: > > Is t

Re: [GENERAL] Visual Designer in linux?

On Sun, 2004-11-07 at 14:54, Martijn van Oosterhout wrote: > There is an ODBC driver for windows that will then talk native to the > PostgreSQL database, why not use that? Because I'm on linux :p ---(end of broadcast)--- TIP 1: subscribe and un

[GENERAL] Visual DATA MODEL Designer in linux?

age will be more accurate then the one before :) Thanks every body for your advices. Eric. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] Linux DBDesigner4 and PostgreSQL

I need help to connect DBDesigner4 linux in ODBC to postgres. I'm having a problem connecting to a remote Postgres db using ODBC from my Debian Linux laptop. I've got ODBC set up (UnixODBC). In DBDesigner I'm simply trying to set up the connection using the ODBC datasource, but I keep getting the

[GENERAL] Troubles linking with libpqxx

type_info const &)" (??0type_info@@[EMAIL PROTECTED]@@Z) already defined in LIBC.lib(typinfo.obj) MSVCRT.lib(ti_inst.obj) : error LNK2005: "private: class type_info & __thiscall type_info::operator=(class type_info const &)" (??4type_info@@[EMAIL PROTECTED]@@Z) a

[GENERAL] Error message

Hello. After I have performed several queries by an external program on the database, an error message appeared: "hard limit on result handles reached is not a valid query result" May I know how to solve the problem? Thank you ---(end of broadcast)

Re: [GENERAL] PgSQL shut down

[EMAIL PROTECTED] ("Scott Marlowe") wrote in message news:<[EMAIL PROTECTED]>... > On Thu, 2004-06-17 at 23:03, Deepa K wrote: > > Hi, > > I am using Postgresql 7.1.3. PgSQL server gets shut down once the hard > > disk space becomes full. Is thers any particular reason to shut down the > > server

[GENERAL] import mysql database...

Hi, I have a running PHPBB mySQL dump that I would like to load/import in postgreSQL... I didn't try yet but I wonder if it's straightforward and just import the mySQL dump into postgreSQL ? (Of course, I want to migrate PHPBB running on a server with mySQL to another server running with postgreS

[GENERAL] Authentication problem

I am writing a program to interface with the pgsql backend in c on a linux box. When I try to connect, it gives me the following error message: Failed to authenticate client as Postgres user 'root' using :be_recvauth: unrecognized message type: 65536 I think maybe I should use the fe_setauthsvc

[GENERAL] Problem with apostrophe

Is there any way of having an apostrophe in a data field? It is a problem because the apostrophe is the same character as the single quote, so the database gets a parser error when a name such as "O'Brian" is entered. There must be a work-around, but I can not find any solution. thank you for y

Re: [GENERAL] Problem with apostrophe

the escape character brings up the help menu, thinking that \' is not a valid option. On Wed, 17 Jun 1998, Brett W. McCoy wrote: > On Wed, 17 Jun 1998, Amos Hayes wrote: > > > > Is there any way of having an apostrophe in a data field? > > > It is a problem because the apostrophe is the same ch

[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

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

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] 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] 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

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

[GENERAL] How jsonb updates affect GIN indexes

creating a GIN index on the whole (rather large) column. Thanks, 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 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] 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

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

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

[GENERAL] Postgres : Close cursor / PerformPortalClose

un-time to choose if we want the performportalclose to raise an error or just a warning Thanks in advance for your help. Eric Rasoa

[GENERAL] archive_command with an environnement variable ?

Dear all, In Postgresql documentation we have an example of the directive archive_command (for WAL) : archive_command = 'cp -i %p /mnt/server/directory_archive/%f

[GENERAL] How to find non-unique indexes in system tables

I can find all the check constraints, primary keys and foreign keys in the information schema, but I cannot find the non-unique indexes. Is there anyplace to get that information (name, columns, etc)? Sorry if this is an FAQ. I couldn't find it with Google. -- Eric Johnson "

[GENERAL] manipulating HeapTuples in a libpq client

ning about an undefined reference. Any ideas appreciated. Thank you. Eric. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] Experiences with extensibility

What types of extensibility (possibly already available in other DBMSs) are currently missing in PostgreSQL? 3. To what extent was your choice of PostgreSQL as a development platform based primarily on its extensibility features? ** Eric Davies,

[GENERAL] Postgres DOD Certification Common Criteria Level

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

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

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

[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] 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

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] 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] 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

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] 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

[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] 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

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: 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: 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: 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

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

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

;, 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

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 (.

[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: [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?

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: [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

n exception to a rule that is generally true and aimed for, or is that just not a good assumption? 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

[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] storing large files in database - performance

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

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?

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

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

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

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

[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] 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

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

> 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

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

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

> 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] 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

[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] Is my db dead ?

Ok in fact, the times weird thing were because I copied the data dir on a 64 bits arch and it went from a 32 bit arch. On the 32 bit one : pg_control version number:812 Catalog version number: 200510211 Database system identifier: 4989617165674917617 Database clu

Re: [GENERAL] Is my db dead ?

Ok I progressed a bit, now with psql I can see my main db and some tables, but they don't contain many rows. Noticable messages in the logfile : 2008-02-05 18:01:18 CET LOG: transaction ID wrap limit is 1073748480, limited by database "wowdbu" 2008-02-05 18:01:18 CET LOG: autovacuum: processing d

Re: [GENERAL] Is my db dead ?

rrent transactions and act like if they were rolled back or something ? On Feb 5, 2008 8:47 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Eric Renard escribió: > > > pg_dump: Error message from server: ERROR: could not access status of > > transaction 3270404 > > DETAIL:

Re: [GENERAL] Schema, database, or tables in different folders?

Alan Hodgson wrote: > On Tuesday 02 June 2009, "Carlos Oliva" wrote: > >> Is there a way to create a database or a table of a database in its own >> folder? We are looking for ways to backup the sytem files of the >> database to tape and one to exclude some tables from this backup. We >> can

Re: [GENERAL] When to use cascading deletes?

ve of your data this way. Eric David wrote: > Hi there. > > When is a good time to use cascading deletes? > > Usually, for safety reasons, I prefer to not ever use cascading > deletes. But that can lead to some complex code that uses topological > sorts etc to manually delete r

Re: [GENERAL] [PERFORM] Concurrency issue under very heay loads

;for update" in your select statements? Are you setting an appropriate transaction isolation level? A better way to do this is with a sequence instead. This is guaranteed to give you a unique value: select nextval('address_serial_num_seq'); eric -- Sent via pgsql-general mailin

Re: [GENERAL] Very slow joins

t post in this thread that I recieved was the same one you mention and began with a "Re:" in the subject line as if it wasn't the first message, but I can find no sign of a message prior to it. Was this a cross-post where the thread started in another group? Or did something go awry

Re: [GENERAL] Does derby have an embedded Mode like Derby ?

different data for the same query. In particular odd situations like this arise around nulls. Conceivably this could happen between versions of PostgreSQL and running such unit tests to test your code's expectations against a real database guards against this possibility. Eric -- Sent via pg

[GENERAL] explicit JOIN faster than implicit?

ed up the query by 50%. This is using Postgres 8.3 on a database with GEQO turned off. Is this what would be expected? Does the query planner / optimizer generally do better with explicit JOIN syntax? Cheers, Eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make ch

Re: [GENERAL] explicit JOIN faster than implicit?

Um, ok. You've listed some conditions in order of how well they should perform and these generally agree with my understanding. But how does this relate to the relative performance of the semantically equivalent explicit and implicit join syntaxes? Eric Martin Gainty wrote: > here is

Re: [GENERAL] explicit JOIN faster than implicit?

ting the better performance anyway, but I'm just wondering if this behavior is expected. Eric Eric Schwarzenbach wrote: > I'm in the process taking a large SELECT statement which had been > written using implicit join syntax (that is, just listing all the tables > in the FROM clau

[GENERAL] New database or New Schema?

PostgreSQL database? I'm leaning toward creating a new schema as we already have built-in procedures to backup and restore the application database. Thanks, Eric -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [GENERAL] "Number of columns exceed limit" on a hierarchy of views

o); and you execute some select query on D, does it necessarily join A and B before joining the result to E, or might it decide to join B with E first before joining the result to A? 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] New database or New Schema?

"David Fetter" wrote in message news:20090821170259.ga6...@fetter.org... > On Fri, Aug 21, 2009 at 12:16:45PM -0400, Eric Comeau wrote: >> In the next release of our software the developers are moving to >> JBoss and have introduced the use of JBoss Messaging. They wan

Re: [GENERAL] New database or New Schema?

""Filip Rembiałkowski"" wrote in message news:92869e660908250856g62561141n557f88015cd21...@mail.gmail.com... 2009/8/25 Eric Comeau "David Fetter" wrote in message news:20090821170259.ga6...@fetter.org... > On Fri, Aug 21, 2009 at 12

[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

[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

[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

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

[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

  1   2   3   4   5   >