[GENERAL] Porting from FrontBase

I am looking at porting a web application from FrontBase to Postgresql. If anybody has some tips on how to deal with this, I'd appreciate hearing him. Thanks. ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [GENERAL] Porting from FrontBase

In article <[EMAIL PROTECTED]>, David Fetter <[EMAIL PROTECTED]> wrote: >FrontBase has a Perl DBI driver >, so you may be >able to use DBI-Link . > >If you try that approach, let me know how it works ou

[GENERAL] Setting Sequence Values

After porting tables and data from FrontBase I now find that I need to update all the values for the sequences that were created to reflect the data in the tables. Is there an easy way to do this? ---(end of broadcast)--- TIP 5: don't forget to incr

Re: [GENERAL] Setting Sequence Values

In article <[EMAIL PROTECTED]>, Joshua D. Drake <[EMAIL PROTECTED]> wrote: >> After porting tables and data from FrontBase I now find that I >> need to update all the values for the sequences that were created >> to reflect the data in the tables. Is there an easy way to do >> this? >Take a look

Re: [GENERAL] Setting Sequence Values

In article <[EMAIL PROTECTED]>, Greg Smith <[EMAIL PROTECTED]> wrote: >See if this helps you: >http://archives.postgresql.org/pgsql-general/2007-10/msg00969.php Yes! That's exactly what I needed. I new there had to be an easy way ;) ---(end of broadcast)-

Re: [GENERAL] Experiences with extensibility

In article <[EMAIL PROTECTED]>, Guido Neitzer <[EMAIL PROTECTED]> wrote: >FrontBase. It has an incredibly easy to configure replication and >multi master clustering support, is very reliable and can also handle >really big databases. I've been working with FrontBase a lot lately and I wouldn'

Re: [GENERAL] Postgres and MySQL Rosetta stone??

In article <[EMAIL PROTECTED]>, Erik Jones <[EMAIL PROTECTED]> wrote: >I'd suggest getting a different book that gives examples in >Postgres or, failing that, read the Postgres manual and learn >how to translate them yourself. I found O'Reilly's SQL Cookbo

Re: [GENERAL] how to list column names.

In article <[EMAIL PROTECTED]>, Rowan <[EMAIL PROTECTED]> wrote: >Postgres 8.2 using php5 > >what is the simplest way to request column names ? The pg_field_name is simple: http://us3.php.net/manual/en/function.pg-field-name.php ---(end of broadcast)--

Re: [GENERAL] New MS patent: sounds like PG db rules

only to MS environments... Interesting.. Martin - Original Message - From: Justin To: Nikola Milutinovic ; pgsql-general@postgresql.org Sent: Thursday, May 29, 2008 10:33 AM Subject: Re: [GENERAL] New MS patent: sounds like PG db rules Nikola Milutinovic wrote: St

Re: [GENERAL] Converting empty input strings to Nulls

Hi Ken- Have you looked at encode ? http://www.postgresql.org/docs/8.3/interactive/functions-string.html Anyone else? Martin - Original Message - From: "Ken Winter" <[EMAIL PROTECTED]> To: "PostgreSQL pg-general List" Sent: Saturday, May 31, 2008 1:40 PM Sub

Re: [GENERAL] Dump and restore problem

Most files systems allocate in 1k(1024) block(s) If the resource requests more.. the OS FS allocates one more 1024 block (thus the display of 2048 allocation..) hope this makes sense, Martin - Original Message - From: "Stuart Luppescu" <[EMAIL PROTECTED]> To: Sent

[GENERAL] Converting SQL to pg

I must be tired. Any suggestions on converting the following to postgresql? UPDATE IGNORE yose5_user_newflags AS flags, yose5_messages AS msg SET flags.forum_id = msg.forum_id WHERE flags.message_id = msg.message_id AND flags.message_id IN (15580, 15581, 15706, 15712, 15713, 15719, 15888) -- Se

Re: [GENERAL] Converting SQL to pg

In article , Albe Laurenz wrote: >martin wrote: >To PostgreSQL from what? Mysql unless the person try to port the code made some changes to it. >Can you explain what the statement is supposed to do? It's updating a table of what messages have been read during a thread move

Re: [GENERAL] How to force select to return exactly one row

Try wrapping the entire statement in a COALESCE((statement), ); -m 2010/6/21 Andrus > > Autogenerated select statement contains 0 .. n left joins: > > SELECT somecolumns > FROM ko > LEFT JOIN t1 ON t1.primarykey= ko.t1foreignkwey > ... > LEFT JOIN tn ON tn.primarykey= ko.tnforeignkwey > WHERE k

Re: [GENERAL] How to force select to return exactly one row

gracefully with an empty resultset. hope this helps, -m On Mon, Jun 21, 2010 at 12:32 PM, Andrus wrote: > Martin, > > Thank you. SELECT statement returns lot of columns. > > I tried > > select coalesce( (select 1,2 ), null); > > but got > > ERROR: subquery m

[GENERAL] Field size

Ok, this should be simple. How do I find the defined maximum length of a varchar field? -- http://dating.blameitonlove.com/ -- 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] Field size

hubert depesz lubaczewski <[EMAIL PROTECTED]> write: > http://www.postgresql.org/docs/faqs.FAQ.html#item4.4 That's not what I'm looking for. I want the size limit defined for the varchar field not the max size the database system can handle, e.g. if the field is varchar(4) I want the 4. -- Sen

[GENERAL] suse 9.2

hi all i try to find a new postgre rpm package for suse 9.2 but i didnt find some. plz help a newbee thx martin ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Performance Question ODBC vs C

Hi there, I have been doing some performance testing with ODBC and have found that ODBC is much slower than using C to call the Psql API I don't understand why the results are like this, I thought ODBC would slow things down a bit but not my much, all its doing in sending off SQL straight the serv

[GENERAL] FW: Installation

for fresh installation. [cid:image001.png@01D05A5D.64405360] Thanks From: selenama...@gmail.com [mailto:selenama...@gmail.com] On Behalf Of Selena Deckelmann Sent: Monday, March 09, 2015 11:31 AM To: Martin Caverly Subject: Re: Installation Please contact pgsql-general@postgresql.org

Re: [GENERAL] FW: Installation

Thanks Vincent for your response. I had used the wrong set up program. Martin -Original Message- From: Vincent Veyron [mailto:vv.li...@wanadoo.fr] Sent: Wednesday, March 11, 2015 12:57 PM To: Martin Caverly Cc: 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] FW: Instal

[GENERAL] Workaround for bug #13148 (deferred EXCLUDE constraint violation)

I submitted the following bug report through the web form a few days ago. It's causing problems in my application and I've been unable to find a way to get around it. If someone here, familiar with PostgreSQL internals, could suggest a workaround I'd really appreciate it! I have a deferred EX

Re: [GENERAL] Workaround for bug #13148 (deferred EXCLUDE constraint violation)

inside the transaction block doesn't prevent the constraint violation, either. On 28/04/2015 2:16 PM, John McKown wrote: On Mon, Apr 27, 2015 at 7:45 AM, Evan Martin mailto:postgre...@realityexists.net>>wrote: I submitted the following bug report through the web form a few d

Re: [GENERAL] Trouble setting up replication

> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: > > On 09/05/2015 11:00 AM, Chuck Martin wrote: >> Thanks for responding Adrian. >> >> After writing this, I noticed that the list is configure to reply to sender. >> I hope this is not inappropriate. P

Re: [GENERAL] Trouble setting up replication

> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: > > On 09/05/2015 02:27 PM, Chuck Martin wrote: >>> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 11:00 AM, Chuck Martin wrote: > >>>> >>>> I had

Re: [GENERAL] Trouble setting up replication

> On Oct 10, 2015, at 3:44 PM, Adrian Klaver wrote: > > On 10/10/2015 12:02 PM, Chuck Martin wrote: >> >>> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 02:27 PM, Chuck Martin wrote: >>>>> On Sep 5, 2015, at 4:

[GENERAL] Way to quickly detect if database tables/columns/etc. were modified?

If I have a query that reads from system tables like pg_class, pg_namespace, pg_attribute, pg_type, etc. and I'd like to cache the results in my application is there any fast way to detect when any changes have been made to these system catalogs? I don't need to know exactly what has changed.

Re: [GENERAL] Way to quickly detect if database tables/columns/etc. were modified?

On 31/10/2016 8:26 PM, Melvin Davidson wrote: I have tried using an event trigger to detect table creation (ie: tg_event_audit_all ) however, that does not parse the schema_name and objid as does pg_event_trigger_dropped_objects(), so I am not sure that is a practical way to audit. Event trig

Re: [GENERAL] Postgres and LibreOffice's 'Base'

cations/office/kexi/ And if that's no good http://flask.pocoo.org/ is simpler than Django. Martin -- 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] Postgres and LibreOffice's 'Base'

is an ORM simpler > than SQLAlchemy, and the Phoenix toolkit for the UI. Flask has a simple SQLAlchemy wrapper now. It is also based on bootstrap though I don't know how the widget set compares with Phoenix, Martin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Segmentation fault calling shared object file

occurs on 9.3, 9.4 and 9.5 which leads me to believe it’s an environment/architecture issue. I’m kinda stuck now! Any help gratefully received. Rgds, Martin. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] persistent db connections in PHP

test.TEMP_TABLE; ERROR 1146 (42S02): Table 'test.temp_table' doesn't exist /*this proves that a second connection cannot see temp tables created by the first connection*/ I *assume* the same is true for Postgres! HTH Martin-- This email message and any files transmitted wi

[GENERAL] LC_CTYPE and matching accented chars

Trying to understand how I can get Pg 8.2 to match 'martín' when I search for 'martin', and going through the documentation, specially http://www.postgresql.org/docs/8.2/static/locale.html http://www.postgresql.org/docs/8.1/static/functions-matching.html Here i

Re: [GENERAL] LC_CTYPE and matching accented chars

Alvaro Herrera wrote: > Martin Langhoff wrote: >> # this is apparently the right way to >> # select base character based on the "equivalence class" >> # as defined in the LC_CTYPE >> =# select * from test where value ~ 'mart[=i=]n

Re: [GENERAL] How do you handle shared memory corruption issues? (contrib/xml2)

Hi CG looks as if your 64bit box needs 64bit libraries instead of default 32 bit did you check here http://dries.studentenweb.org/apt/packages/perl-XML-LibXSLT/info.html Let us know M-- This email message and any files transmitted with it contain confidential information intended only for the

Re: [GENERAL] How do you handle shared memory corruption issues? (contrib/xml2)

message in error, please notify the sender immediately by telephone or email and destroy the original message without making a copy. Thank you. - Original Message - From: "CG" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; "postgresql listserv

Re: [GENERAL] LC_CTYPE and matching accented chars

Alvaro Herrera wrote: > Martin Langhoff wrote: >> # this is apparently the right way to >> # select base character based on the "equivalence class" >> # as defined in the LC_CTYPE >> =# select * from test where value ~ 'mart[=i=]n

Re: [GENERAL] The speed problem of Varchar vs. Char

Since VARCHAR length is run length encoded and CHAR is fixed length If your string will always be about the same size set as CHAR(MaximumLength) otherwise use VARCHAR M This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom th

Re: [GENERAL] Transactional DDL

you can use SET TRANSACTION LEVEL READ UNCOMMITTED to acquire the dirty reads From your perspective how *should* the DB handle this? M This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed.

[GENERAL] Controlling locale and impact on LIKE statements

C locales, which makes this more of an issue going forward. See the discussion with Eloy (maintainer of the schema abstraction layer) at http://moodle.org/mod/forum/discuss.php?d=78738#p350512 login as "guest" to avoid registration. cheers, martin -- ---

[GENERAL] Controlling locale and impact on LIKE statements

t what the locale is and whether to add magical additional indexes just for Pg makes me look like a loony. See the discussion with Eloy (maintainer of the schema abstraction layer) at http://moodle.org/mod/forum/discuss.php?d=78738#p350512 login as "guest" to avoid registration. cheers,

Re: [GENERAL] Controlling locale and impact on LIKE statements

On 9/5/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Martin Langhoff escribió: > > > As I have a Pg install where the locale is already en_US.UTF-8, and > > the database already exists, is there a DB-scoped way of controlling > > the locale? > > Not really.

Re: [GENERAL] Building Windows fat clients

if you have specific requirements for XYZ Db that nobody supports or protocols or device drivers that nobody has written you'll have to write the libraries yourself Martin-- - Original Message - From: "johnf" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 19,

Re: [GENERAL] Building Windows fat clients

Glad to hear that I knew Novell *was* working on a port to BSD But I havent heard about ports to other Nix platforms? M-- - Original Message - From: "Bill Bartlett" <[EMAIL PROTECTED]> To: "'Martin Gainty'" <[EMAIL PROTECTED]>; "&

[GENERAL] Filesystem crash - corupted database

Hi, It's possible to extract data directly from data files ? I have two tablespaces one for data and one for indexes. After filesystem crash I lost my /var/lib/postgresql/data folder :( All data is in /lost+found :(, I found folders with data and index tablespe that looks ok. It's possible to d

Re: [GENERAL] Autostart PostgreSQL in Ubuntu

Johann Maar wrote: Hi folks, sorry I do not get it right and I have to ask now. I manually compiled PostgreSQL on my Kubuntu machine to /usr/local/opt/ pgsql and did all this stuff like creating a "postgres" user and I have a startup script in /etc/init.d. But if I try to start PostgreSQL by ru

[GENERAL] sha1 function

We are at the moment planning on passing some passwords that are plain texted in our DB to some encrypted form as now they will be used for processes that require better security measures. We started looking at md5() but found that it's easy to crack and one of the systems uses CHAP authentica

Re: [GENERAL] not work in IE

if you give us the URL we can try from here M-- - Original Message - From: "Scott Marlowe" <[EMAIL PROTECTED]> To: "manju arumugam" <[EMAIL PROTECTED]> Cc: Sent: Friday, October 12, 2007 10:40 AM Subject: Re: [GENERAL] not work in IE > On 10/11/07, manju arumugam <[EMAIL PROTECTED]> wr

Re: [GENERAL] can I define own variables?

http://www.postgresql.org/docs/8.3/static/libpq-envars.html use environment variables PGHOST is the host for Postgres PGHOSTADDR is the Numeric Host Address for Postgres PGPORT is the port for the PostgresServer to listen on PGDATABASE is the default Database Name PGUSER is the default Username t

Re: [GENERAL] can I define own variables?

Hope this helps/ Martin-- - Original Message - From: "Andreas" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]> Cc: Sent: Sunday, October 14, 2007 1:30 PM Subject: Re: [GENERAL] can I define own variables? > Martin, > > Can you exp

Re: [GENERAL] Problem of installation on Mac

assume the tablename you want to determine privs and access is called 'TABLENAME' SELECT priv, access_lvl FROM TABLENAME WHERE user = 'pgsql' M-- - Original Message - From: [EMAIL PROTECTED] To: Shane Ambler Cc: pgsql-general@postgresql.org Sent: Friday, October 19, 2007 12:

[GENERAL] Bitmap Heap scan 8.1/8.2

I have to PG servers, one ver. 8.1.9 and the other 8.2.4. I was checking a query out and found that with the exact same DB (same data in it) and the same query I get different plans, and significantly higher time in 8.2: On 8.1 I get: test=> explain analyze SELECT * FROM prestamos WHERE bibl

Re: [GENERAL] Bitmap Heap scan 8.1/8.2

Pavel Stehule wrote: Hello I am unsure, did you check config values? Don't know which ones you are talking about, but all enable_* are set to on. Anything else? -- 21:50:04 up 2 days, 9:07, 0 users, load average: 0.92, 0.37, 0.18 -

Re: [GENERAL] Bitmap Heap scan 8.1/8.2

Pavel Stehule wrote: 2007/10/22, Martin Marques <[EMAIL PROTECTED]>: Pavel Stehule wrote: Hello I am unsure, did you check config values? Don't know which ones you are talking about, but all enable_* are set to on. Anything else? shared_buffers 8.1: 16000 8.2: 400MB

Re: [GENERAL] Bitmap Heap scan 8.1/8.2

Tomas Vondra wrote: 2007/10/22, Martin Marques <[EMAIL PROTECTED]>: Pavel Stehule wrote: Hello I am unsure, did you check config values? Don't know which ones you are talking about, but all enable_* are set to on. Anything else? shared_buffers work_mem effective_cache_

Re: [GENERAL] Bitmap Heap scan 8.1/8.2

Pavel Stehule wrote: 2007/10/22, Martin Marques <[EMAIL PROTECTED]>: Pavel Stehule wrote: 2007/10/22, Martin Marques <[EMAIL PROTECTED]>: Pavel Stehule wrote: Hello I am unsure, did you check config values? Don't know which ones you are talking about, but all enabl

Re: [GENERAL] Bitmap Heap scan 8.1/8.2

Martin Marques escribió: Pavel Stehule wrote: try set work_mem to '8MB'; and explain analyze select .. These things didn't help. What changed the plan completely was this: seq_page_cost = 5.0 # measured on an arbitrary scale cpu_tu

Re: [GENERAL] Bitmap Heap scan 8.1/8.2

Alvaro Herrera wrote: It's an arbitrary number, based on which all the other numbers are measured. Now that I read more intensively he docs I see that all the cost parameters are related one with the other. What people generally do around here is mess with random_page_cost, and leave seq_p

Re: [GENERAL] select count() out of memory

God morgen Please display these memory settings from your postgresql.conf file sort_mem shared_buffers Takk Martin-- - Original Message - From: <[EMAIL PROTECTED]> To: "Gregory Stark" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; Sent: Thursday, October

Re: [GENERAL] I want to search my project source code

Perry- Does cscope support PHP? Thanks for the link M-- - Original Message - From: "Perry Smith" <[EMAIL PROTECTED]> To: "Guy Rouillier" <[EMAIL PROTECTED]> Cc: Sent: Sunday, October 28, 2007 10:25 AM Subject: Re: [GENERAL] I want to search my project source code > On Oct 28, 2007, at

[GENERAL] nonstandard use of

I recently installed the latest non-beta version 8.2 of postgresql. I get the following warning and hint in the server status GUI: WARNING:nonstandard use of \\ in a string literal at characters 64 HINT: Use the excape string syntax for backslashes, e.g, E'\\'. The "raw" stri

[GENERAL] Client-requested cast mode to emulate Pg8.2 on v8.3

y-fuzzy-ambiguous mode to help large projects make the transition ;-) cheers, martin PS: I'm not actually in the list - CCs welcome... ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] Client-requested cast mode to emulate Pg8.2 on v8.3

Tom Lane wrote: > Martin Langhoff <[EMAIL PROTECTED]> writes: >> I say they are worrying because Moodle code has many ocurrences of >>/* bla.id is an INT8 */ >>SELECT x,y,z FROM bla WHERE id='1'; >> And we also often quote INT values for i

Re: [GENERAL] stripping HTML, SQL injections ...

Scott- In JavaScript http://www.java2s.com/Tutorial/JavaScript/0520__Regular-Expressions/StripHTM L.htm M-- - Original Message - From: "Scott Marlowe" <[EMAIL PROTECTED]> To: "A.M." <[EMAIL PROTECTED]> Cc: "pgsql-general" Sent: Wednesday, November 14, 2007 6:16 PM Subject: Re: [GENERAL]

Re: [GENERAL] stripping HTML, SQL injections ...

gt;; "pgsql-general" Sent: Wednesday, November 14, 2007 7:21 PM Subject: Re: [GENERAL] stripping HTML, SQL injections ... > Martin, > > 2000/11/15, Martin Gainty <[EMAIL PROTECTED]>: > > Scott- > > > > In JavaScript > > http://www.java2s.com/Tutorial

Re: [GENERAL] Compiled debugger plug in for windows, any one have it?

I came across this when installing mod_php under Apache be mindful that you would need to recompile for each environment e.g. Linux Cygwin Windows Keeping in mind My windows tools are at least 10 years old If you provide the link I will try and compile it here M-- - Original Message - Fr

Re: [GENERAL] automating backups with windows scheduled tasks and pg_dumpall

Hi Tom In windows you would need to include the runas command so your bat file needs to execute the command via runas as in runas /user:postgres "bin\pg_dumpall.exe -U foo_postgres" HTH Martin - Original Message - From: "Tom Hart" <[EMAIL PROTECTED]> To: &qu

Re: [GENERAL] Read-only availability of a standby server?

schema changes take a look at SLONY http://slony.info/ Anyone ?Martin--__Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender

Re: [GENERAL] Error while compiling PostgreSQL with Java

Please post errors and your full environment configurationJDK versionJRE version (if different) This would be a good time to look into loggers specifically either commons-logging or log4j Martin__Disclaimer and confidentiality noteEverything in this

Re: [GENERAL] speed up insert query

2 things tr_tran_time needs to be already in 'time format' is_ok needs to be indexed (preferably bitmapped index) HTH/ Martin - Original Message - From: "Tom Hart" <[EMAIL PROTECTED]> To: "Postgres General List" Sent: Monday, November 26, 2007 5:30 P

Re: [GENERAL] spatial composition operators for PG

Jan- check out http://postgis.refractions.net/ M-- - Original Message - From: "Galkowski, Jan" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 27, 2007 6:02 PM Subject: [GENERAL] spatial composition operators for PG Are there any standard spatial composition operators people use for P

Re: [GENERAL] Cluster using tablespaces?

start here http://www.postgresql.org/docs/8.1/static/creating-cluster.html M- - Original Message - From: "Erik Jones" <[EMAIL PROTECTED]> To: "Rainer Bauer" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, November 28, 2007 5:59 PM Subject: Re: [GENERAL] Cluster using tablespaces? On Nov 28, 2

Re: [GENERAL] full_page_writes = off?

Tomasz Ostrowski escribió: On Sat, 01 Dec 2007, rihad wrote: fsync = on; synchronous_commit = off; full_page_writes = off; Thanks for any insights or clarifying missed points. Also check whether a disks have write-caching turned off - it should. On Linux the command is: # hdparm -W /d

Re: [GENERAL] power failure....

Tom Allison escribió: I wonder what I'm supposed to do with my debian installation since there doesn't seem to be any such thing as pg_resetxlog. Or is it hiding somewhere? On one debian I have: /usr/lib/postgresql/8.1/bin/pg_resetxlog /usr/lib/postgresql/8.2/bin/pg_resetxlog ---

Re: [GENERAL] power failure....

Joshua D. Drake escribió: On Sat, 01 Dec 2007 15:22:38 -0500 I wonder what I'm supposed to do with my debian installation since there doesn't seem to be any such thing as pg_resetxlog. Or is it hiding somewhere? I don't recall if it is in contrib or not.. try?: apt-file is your friend: apt

Re: [GENERAL] full_page_writes = off?

Greg Smith escribió: > On Sat, 1 Dec 2007, Tomasz Ostrowski wrote: > >> You can also use "hdparm -I" to check this - look for a "Write >> caching" in "Commands/features" section. If it has a "*" in front >> then it is enabled and dangerous. > > Right; using -I works with most Linux hdparm version

Re: [GENERAL] Vacuum output redirect

does psql have write access to the folder? M- - Original Message - From: Wim Chalmet To: pgsql-general@postgresql.org Sent: Tuesday, December 04, 2007 10:27 AM Subject: [GENERAL] Vacuum output redirect Hi, Sorry for my basic question here, but I can't figure things out.

[GENERAL] cannot dump structures

Hello, I have on db server Postgresql 8.2.5 pg_dump (data and structures) works well. I have copied pg_dum file (and libpq.so.5) to other server, into chroot where is apache and phppgadmin. And there is problem. Dump of structures doesnt work, onlydata OK. I have wrote 2 minimalistic php scri

[GENERAL] Re: [GENERAL] cannot dump structures

ername -h hostname -s -i'; pg_dump out of chroot work in chroot doesnt work...mystery regards Martin Korous ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Creating Aggregate functions in PLpgSQL

MG>obligatory toppost > > http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html > > is for > > 8.3 where there were some changes to the number of > > arguments an aggregate > > could take. I believe it's also more descriptive > > documentation. > > > > of course for things like avera

Re: [GENERAL] thank you

2 questions NDA...what NDA?? I would suggest concentrating on implementing your contact page (in other words publish the page only when it works correctly..) M-- - Original Message - From: "Kevin Kempter" <[EMAIL PROTECTED]> To: Sent: Tuesday, December 18, 2007 9:31 PM Subject: Re: [GEN

Re: [GENERAL] pgsql cannot read utf8 files moved from windows correctly!

it seems the use of BOM in UTF-8 is discouraged http://unicode.org/faq/utf_bom.html#BOM FF FE is UTF16-Little Endian FE FF is UTF16-Big Endian Please verify- Bedankt/ Martin- - Original Message - From: "Trevor Talbot" <[EMAIL PROTECTED]> To: Sent: Sunday, December 2

Re: [GENERAL] pgsql cannot read utf8 files moved from windows correctly!

o: Sent: Sunday, December 23, 2007 1:55 PM Subject: Re: [GENERAL] pgsql cannot read utf8 files moved from windows correctly! > On 12/23/07, Martin Gainty <[EMAIL PROTECTED]> wrote: > > > it seems the use of BOM in UTF-8 is discouraged > > http://unicode.org/faq/utf_bo

Re: [GENERAL] pg_ctl start fails on Windows

are you using the same username that you use to start postgres??? M-- - Original Message - From: "Abraham, Danny" <[EMAIL PROTECTED]> To: Sent: Monday, December 24, 2007 9:37 AM Subject: [GENERAL] pg_ctl start fails on Windows The error message is "could not open PID file". I can man

[TLM] Re: [GENERAL] pg_ctl start fails on Windows

are you using the same username that you use to start postgres??? M-- - Original Message - From: "Abraham, Danny" <[EMAIL PROTECTED]> To: Sent: Monday, December 24, 2007 9:37 AM Subject: [TLM] [GENERAL] pg_ctl start fails on Windows The error message is "could not open PID file". I c

Re: [GENERAL] Hinting the planner

Not the planner but you can hint the query as in this example select /*+ ordered use_hash(code1)*/ * from table_1;Martin __Disclaimer and confidentiality noteEverything in this e-mail and any attachments relates to the official business of Sender

[GENERAL] PITR - filter by database?

ared HW there's a big downside in memory footprint and disk IO to running many Pg instances. cheers, martin -- ------- Martin @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/

Re: [GENERAL] Prepared Statements

CallableStatement Multiple sets of input parameter values may be associated with a callable statement and sent to the DBMS together. (For procedures) http://java.sun.com/j2se/1.4.2/docs/api/java/sql/CallableStatement.html Viel Gluck Martin - Original Message - From: <[EMAIL PROTECTED]> To:

Re: [GENERAL] How to automate password requests?

the name of env var is PGPASSWORD http://www.network-theory.co.uk/docs/postgresql/vol2/EnvironmentVariables1.h tml Viel Gluck Martin- - Original Message - From: "Marten Lehmann" <[EMAIL PROTECTED]> To: Sent: Thursday, January 10, 2008 6:48 PM Subject: Re: [GENERAL]

Re: [GENERAL] Sun acquires MySQL

es is a very long and tedious uphill climb Comments? Martin - Original Message - From: "walterbyrd" <[EMAIL PROTECTED]> To: Sent: Sunday, January 20, 2008 9:34 AM Subject: Re: [GENERAL] Sun acquires MySQL > > > IsMySQLa direct competitor to Oracle? For the peo

Re: [GENERAL] changing the default directory

i agree and if your postgres data folder will be constant I would set PGDATA environment variable to the folder location M- - Original Message - From: "Raymond O'Donnell" <[EMAIL PROTECTED]> To: "User Map" <[EMAIL PROTECTED]> Cc: "pgsql" Sent: Thursday, January 24, 2008 8:18 AM Subject: R

Re: [GENERAL] Disk configurations....

64 bit? http://www.postgresql.org/docs/8.2/interactive/install-procedure.html M- - Original Message - From: "Nathan Wilhelmi" <[EMAIL PROTECTED]> To: Sent: Thursday, January 24, 2008 2:21 PM Subject: [GENERAL] Disk configurations > Hello - Typically case of a software guy needing t

Re: [GENERAL] plpyhton

depends on the configuration implemented to enable caching capability for each type *usually* fastest access can be achived by implementin a Procedure which loads into Procedure Cache allowing consequent accesses to the Procedure 'in memory' (vs Disk I/O) Mar

Re: [GENERAL] [BUGS] postgresql-8.4 error

m bug at all. Can you please open a Debian or Ubuntu bug report, with the output of ls -ld /sbin /bin /usr/sbin /usr/bin ? The error message suggests that one or more of these directories are world-writable. Thank you, Martin -- Martin Pitt| http://www.piware.de Ubun

Re: [GENERAL] A question about timezone

Good Afternoon select to_char(current_timestamp, 'Day') at time zone 'CET' produces Wednesday for Berlin Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentia

Re: [GENERAL] Web Hosting

Gentlemen- Go-daddy *claims* to support postgres http://help.godaddy.com/article/2330 YMMV Martin-- __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene

[GENERAL] ..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language..

..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language.. to whom might you be alluding to ??? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich

Re: [GENERAL] How can I tell if pg_restore is running?

> My extension has a config table that is dumped by pg_dump and > populated by pg_restore. > However, this table has triggers on it that I would like not to do > anything if the table is being populated by pg_restore. I want the > triggers to operate only if the user is manipulating the table >

[GENERAL] Bi-Directional replication client awareness

automatic client failovers, in the case there is a server side failover. Anyone who knows if there is anything in progress regarding this? Kind regards, Martin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Bi-Directional replication client awareness

12 jul 2014 kl. 04:58 skrev Craig Ringer : > On 07/12/2014 02:42 AM, Martin Gudmundsson wrote: >> Hi all! >> I was wondering if there are any specific load balancing/failover >> functionality planned for client drivers connection to a BDR group. In my >> case th

  1   2   3   4   5   6   7   >