Re: [GENERAL] Oracle to PostgreSQL

On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote: > You can create a composite type in PostgreSQL: > CREATE TYPE complex AS (r integer, i integer); > You would use an array in this case: > DECLARE > carr complex[]; I've once faced the same thing, and did as Laurenz suggested. You will like

Re: [GENERAL] Trigger based logging alternative to table_log

s that I only log values of changed fields. I like that but it makes the trigger overhead bigger. Greetings from Berlin Felix -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] utf8 issues

I've got the followin issue with postgres 9.3, trying to restore a backup from sql script: invalid byte sequence for encoding “UTF8″: 0xc2de how can i solve it?

Re: [GENERAL] Getting a delta of two json-typed objects? (a breeze w/ hstore)

for: http://schinckel.net/2014/05/25/querying-json-in-postgres/   Ahoi Felix Gesendet: Donnerstag, 22. Januar 2015 um 20:37 Uhr Von: Wells Oliver wellsoli...@gmail.com An: pgsql-general@postgresql.org pgsql-general@postgresql.org Betreff: [GENERAL] Getting a delta of two json-typed objects? (a breeze w

Re: [GENERAL] table versioning approach (not auditing)

Brusselback adambrusselb...@gmail.com An: Felix Kunde felix-ku...@gmx.de Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Betreff: Re: [GENERAL] table versioning approach (not auditing) Felix, I'd love to see a single, well maintained project. For example, I just found yours

Re: [GENERAL] table versioning approach (not auditing)

harddisk consuming.   If there are more users following a similar approach, I wonder why we not throw all the good ideas together, to have one solution that is tested, maintained and improved by more developpers. This would be great.   Felix   Gesendet: Montag, 29. September 2014 um 23:25 Uhr Von

Re: [GENERAL] table versioning approach (not auditing)

of the database and commit their changes to the production state. As I've got a unique history ID for each table and each row, I should be able to map the affected records. Have a look and tell me what you think of it. Cheers Felix   Gesendet: Montag, 29. September 2014 um 04:00 Uhr Von: Abelard

[GENERAL] memory issues with BYTEAs in JSON and hstore

hints. Cheers, Felix -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] comparing two JSON objects in 9.3

solution? Did i trapped into some YouShouldNots? Regards! Felix Kunde

[GENERAL] How to convert a double value to a numeric datum type in pgsql?

Hi all, I'm talking about the source code of pgsql and I want to know how the typing system works in pgsql. A few functions can help us do the type conversion, for example: Int32GetDatum -- convert a integer to a datum Float8GetDatum -- convert double to a datum cstring_to_text -- convert a

Re: [GENERAL] Temporary table already exists

I had a similar problem once. The pool is reusing connections and the temporary tables are still there. Now I always create new temporary tables with a unique name like this: tmpTableId = TMP + Math.abs(generateUUID().hashCode()); if (tmpTableId.length() 15) tmpTableId =

[GENERAL] What is the correct way to get the content of a varchar field in pgsql's source code

Hi all, I've learnt from the source code to open a table and scan it, like this: Relation qma = try_relation_open(qmappersta, AccessShareLock); if(qma!=NULL){ HeapScanDesc scan= heap_beginscan(qma,SnapshotNow,0,NULL); HeapTuple tup; TupleDesc tupDesc= RelationGetDescr(qma); Datum

[GENERAL] Breakpoints are not triggered in analyze.c (debugging Postgresql in Visual studio)

Hi all, I've set up a developing environment on my windows using Visual Studio 2012, everything works fine, except that the breakpoints set in analyze.c are not triggered in debug mode (breakpoints in main.c and some initialization code worked well), and I'm sure that line has been executed since

[GENERAL] How are pg_operator and pg_type related with each other?

Hi all, I'm studying pg_statistic table and I find that column staop is related to pg_operator, and different data types relate to different staop, but I don't know where pgsql stores the mapping between pg_type and pg_operator, does anyone have any idea about it? thanks!

Re: [GENERAL] How are pg_operator and pg_type related with each other?

but text[] is found in the query. Thanks very much! 2014/1/15 Amit Langote amitlangot...@gmail.com On Wed, Jan 15, 2014 at 11:08 PM, Felix.徐 ygnhz...@gmail.com wrote: Hi all, I'm studying pg_statistic table and I find that column staop is related to pg_operator, and different data types

[GENERAL] Audit database to recreate former states using JSON functions

/) for giving me the advice to use JSON functions. This made the whole developement way more easy. Have a great day. Felix

Re: [GENERAL] How to specify/mock the statistic data of tables in PostgreSQL

I see, thanks. I'm looking into the source code of statistic part now, and I'm a little confused about the column staop presented in table pg_statistic, in the pg_statisitc.h, the comment says: /* * To allow keeping statistics on different kinds of datatypes, * we do not

[GENERAL] How can I detect if a schema exists?

search_path. I suppose I shouldn't rely on undocumented features ... -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found

Re: [GENERAL] How can I detect if a schema exists?

with the users and permissions, but that sounds like it could be a feature; the code wants to know if the user can use the schema. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860

Re: [GENERAL] Feature discussion: Should syntax errors abort a transaction?

, but note I do not offer to do the work. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's

Re: [GENERAL] Feature discussion: Should syntax errors abort a transaction?

or obvious, and something that has always frustrated me when I find programs which try to do so. Then I saw the idea of BEGIN INTERACTIVE and lost sight of the discussion. My apoligies for stepping in so badly. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch

[GENERAL] Slow COMMIT statements

= on checkpoint_segments = 40 Regards, Felix

[GENERAL] Gentoo, 8,2 --- 8.4, and /var/run/postgresql in mode 770

? Maybe this was a gentoo thing. What should the permissions be for this? Or does gentoo do their own thing and there is a different standard way of handling this? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe

Re: [GENERAL] Gentoo, 8,2 --- 8.4, and /var/run/postgresql in mode 770

with this myself. Ahh ... I skipped 8.3 and didn't see that message. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933

[GENERAL] Database schema dumper

. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Database schema dumper

PostgreSQL only, not any chance of converting it for use with other databases. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933

Re: [GENERAL] Database schema dumper

it a bit tonight. Looks like a lot of work has gone into it. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / fe...@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found

[GENERAL] Alias name from subquery

Hi, I would like to set an alias name for a column from a subquery, i.e. something like this: SELECT entry AS (SELECT name from colnames WHERE id=1) from entries ; Obviously it doesn't work _this_ way, but is there _any_ way to do it? Kind regards, Felix -- Sent via pgsql-general mailing

Re: [GENERAL] Alias name from subquery

want to give the alias explicitely, instead it should be taken from a second table 'colnames', i.e. something like the line I sent in my initial mail. Any idea? Thanks again, Felix BTW, here's what I get from your command: test=# select (SELECT name from colnames WHERE id=1) as entry from

Re: [GENERAL] Alias name from subquery

Raymond O'Donnell wrote: select entry from (select name from colnames where id = 1) as entry_with_different_name; ...maybe? Thanks Ray! No, entry_with_different_name should be the result of SELECT name FROM colnames WITH id=1. Kind regards, Felix -- Sent via pgsql-general mailing list

Re: [GENERAL] Alias name from subquery

to know whether it's possible or not. Kind regards, Felix -- 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] Alias name from subquery

Thanks to Scott and Taras for pointing me to the crosstab functions. I only had a quick look but they seem very helpful! Kind regards, Felix -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [GENERAL] psqlodbc on Vista Ultimate 64

- From: Lucas Felix To: pgsql-general@postgresql.org Sent: Saturday, August 09, 2008 12:00 AM Subject: [GENERAL] psqlodbc on Vista Ultimate 64 Olá, estou com um problema, o Windows Vista não reconhece o odbc do PostgreSQL, alguma dica? Hello, I have a problem, Windows Vista does

[GENERAL] psqlodbc on Vista Ultimate 64

Olá, estou com um problema, o Windows Vista não reconhece o odbc do PostgreSQL, alguma dica? Hello, I have a problem, Windows Vista does not recognize the odbc of PostgreSQL, any hint? -- Lucas Felix de Sousa Técnico em Informática [EMAIL PROTECTED] Se enxerguei mais longe que outros homens

[GENERAL] query large amount of data in c++ using libpq

Hi all, i am using PQexecParams() to SELECT about 3 million record in C++, and it takes several minutes to make it done with used memory dramatically incresed(about 200MB). it seems when i using PQexecParams(), i can't use the query result before all the data is sent to client. is there something

[GENERAL] query large amount of data in c++ using libpq

Hi all, i am using PQexecParams() to SELECT about 3 million record in C++, and it takes several minutes to make it done with used memory dramatically incresed(about 200MB). it seems when i using PQexecParams(), i can't use the query result before all the data is sent to client. is there something

Re: [GENERAL] Wider than float8

hard this would be. I don't have the sources right at hand. Is all float8 code in one source file, and would it be a pretty simple matter to add float 12 with a search and replace and not much more? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow

[GENERAL] How access table by tableoid

that by peforming two queries: The first to retrieve the table's name from pg_class via its OID, the second to select the wanted columns from that table using the table's name as usual. Can I do it in one go using the table´s OID? Thank You Felix ---(end of broadcast

Re: [GENERAL] pg_contraint: 'action code' ?

On Tue, 08 May 2007 10:03:24 -0400 Tom Lane [EMAIL PROTECTED] wrote: * the FKCONSTR_MATCH_xxx constants defined in parsenodes.h. True! ;-) Thank you so much. Felix ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] are foreign keys realized as indexes?

them. Thanks again. Felix ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

[GENERAL] are foreign keys realized as indexes?

Hi, I like to keep my pg interface small: Can I replace foreign keys by using indexes somehow? (This is at least possible for primary key columns which can be replaced by suitable indexes.) Thank You Felix ---(end of broadcast)--- TIP 1

Re: [GENERAL] are foreign keys realized as indexes?

loose the referencial integrity (whereas for unique contraints there *is* a full replacement using indexes)? Felix ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [GENERAL] are foreign keys realized as indexes?

be replaced by any other pg function (I am of course not taking into account things like multiple queries bound together by transactions...) then I have to go though it and implement it into my pg interface (looking at the information_schema: This seems to be quite a bunch of work...). Thank You Felix

[GENERAL] pg_contraint: 'action code' ?

Hi, where are the 'action code' (type char) of foreign keys defined for ON DELETE resp. ON UPDATE for the actions NO ACTION, RESTRICT, CASCADE, SET NULL, SET DEFAULT in pg_contraint? In the manual (8.2) it is mentioned but not explained. Thank You Felix ---(end

[GENERAL] binary representation of date and numeric

'. If there is no documentation and I need to examine the sources, could anyone point me to the needed files or sections? Thank You Felix ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] PQerrorMessage: suppress trailing new line?

On Tue, 24 Apr 2007 11:14:43 +1200 Andrej Ricnik-Bay [EMAIL PROTECTED] wrote: On 4/24/07, Felix Kater [EMAIL PROTECTED] wrote: Hi, the messages returned by PQerrorMessage() contain a trailing new line. So, they doesn't nicely integrate into strings formatted by printf

[GENERAL] PQerrorMessage: suppress trailing new line?

Hi, the messages returned by PQerrorMessage() contain a trailing new line. So, they doesn't nicely integrate into strings formatted by printf. Is there a way to suppress the trailing new line (except for alloc/copy to a new string)? Thank You Felix ---(end of broadcast

[GENERAL] unique ID across all columns

-- I removed and added some columns and it seems that already used values are not used again. Felix ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] postgresl for mysql?

similar for MySQL 3 and PG 7.something. What an interesting name! I don't know much Italian other than what I've picked up from a few movies, but I think I now know what Pazzo means ... -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket

Re: [GENERAL] Tabbed data in tab-separated output

. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---(end of broadcast

[GENERAL] Tabbed data in tab-separated output

, but that gives me the shudders. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I

[GENERAL] How to split a table?

Hi, I want to split a table to 2 small tables. The 1st one contains 60% records which are randomly selected from the source table. How to do it? Regards, Felix

[GENERAL] Any documatation about porting from Oracle to PostgreSQL

Hi all, I'm a newbie of PostgreSQL. I'm searching materials about porting from Oracle to PostgreSQL. Anyone can share with me some good documatations? Thanks and regards, Felix

Re: [NOVICE] [GENERAL] How to split a table?

to do some statistics analysis. 2006/10/17, Andreas Kretschmer [EMAIL PROTECTED]: Felix Zhang [EMAIL PROTECTED] schrieb: Hi, I want to split a table to 2 small tables. The 1st one contains 60% records which are randomly selected from the source table. How to do it?Why do you want to do

[GENERAL] Is it possible to have multiple names for a column?

on. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o

[GENERAL] Query optimization and indexes

is probably the same? WHERE B=2 AND D=4? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found

Re: [GENERAL] Query runs fast or slow

of using a generic parameterized plan. OK, here is the new explain analyze. I eliminated cache effects by dumping the tables and picking random values with an editor. felix= PREPARE foo(TEXT, INT, INT) AS SELECT s.data, g.key, g.val, g.sid FROM key k, val_int v, sid s, glue_int g WHERE (k.data

Re: [GENERAL] Asking advice on speeding up a big table

enough, but not exciting :-) and in the process, come across some odd misbehavior. I have a writeup, almost ready to post, but I want to make sure I cxross my Is and dot my Ts properly. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman

[GENERAL] Query runs fast or slow

itself, and anything else which helps. Here are the EXPLAIN statements in case it helps. EXPLAIN for the equality WHERE clause: felix= explain analyze SELECT sid.data, glue.key, glue.val, glue.sid FROM key, val, sid, glue WHERE (key.data = 'x6ATArB_k1cgLp1mD5x2nzVVf2DQw4Lw1-Ow5NCzzs5Pupg6K

Re: [GENERAL] Query runs fast or slow

. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o

Re: [GENERAL] Asking advice on speeding up a big table

in comparison to the third table, that wouldn't be of any use, but I will give it a try. Thanks ... -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E

[GENERAL] Asking advice on speeding up a big table

foreign key references to the other three tables' id columns. felix= \d key Table oddtimes.key Column | Type | Modifiers ++--- id | bigint | not null data | text | not null Indexes: key_pkey PRIMARY KEY, btree (id

Re: [GENERAL] Asking advice on speeding up a big table

. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---(end

[GENERAL] ALTER TABLE -- how to add ON DELETE CASCADE?

or Ginger Nuts :-) -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see

Re: [GENERAL] ALTER TABLE -- how to add ON DELETE CASCADE?

. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---(end

Re: [GENERAL] unsubscribe pgsql-general

in the OFF position. You may now make the change and repeat the cycle. When the green exit light goes on, you may log off and have lunch. Please close the door behind you. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon

[GENERAL] Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1

answer without EXPLAIN printouts. I'm hoping there is some generic answer to something simple I have overlooked. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477

Re: [GENERAL] Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1

it take as long as 20 ms... -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last

Re: [GENERAL] Generic Q about max(id) vs ORDER BY ID DESC LIMIT 1 -- SOLVED

thought they would not be special cased. Thanks. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution

Re: [GENERAL] Oracle buys Innobase

the last Innodb GPL release. What am I missing? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution

Re: [GENERAL] Oracle buys Innobase

as $$, even for the exact same piece of gear. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last

Re: [GENERAL] unsubscribe

and repeat the cycle. When the green exit light goes on, you may log off and have lunch. Please close the door behind you. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E

[GENERAL] 7.3.2 closing connections, sometimes

! -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o

Re: [GENERAL] 7.3.2 closing connections, sometimes

? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out

Re: [GENERAL] 7.3.2 closing connections, sometimes

dropdb / creatdb? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see

Re: [GENERAL] 7.3.2 closing connections, sometimes

is in the work mood right now, so we will no doubt follow the general principle of changing many things at once to make tracking things down more fun :-) -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED

[GENERAL] Exception Handling in C-Language Functions?

(tmp_text, VARDATA(text), text_len); tmp_text[text_len] = '\0'; strncpy(tmp_pattern, VARDATA(pattern), pattern_len); tmp_pattern[pattern_len] = '\0'; bool matches = uwildmat(tmp_text, tmp_pattern); free(tmp_pattern); free(tmp_text); PG_RETURN_BOOL(matches); } -- Felix E

Re: [GENERAL] Exception Handling in C-Language Functions?

not deploying 8.0. However, at the moment, out of memory exceptions seem to be the only ones that I've to deal with. -- Felix E. Klee ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs

Re: [GENERAL] Exception Handling in C-Language Functions?

fine, although I'm not certain what DirectFunctionCall1 and DatumGetCString actually do (it seems that the only documentation of these functions is in the source code, and I'm too lazy to sift through it at the moment). -- Felix E. Klee ---(end of broadcast

Re: [GENERAL] Postgresql, SQL server and Oracle. Please, help

for PostgreSQL, Oracle, and MS SQL Server. That is why I got it, and it is pretty handy for me, a non-guru. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9

Re: [GENERAL] off Topic: Looking for a good sql query

you exactly how every single example differs from db to db -- MS Access MS SQL Server MySQL Oracle PostgreSQL If I only had one SQL book, this would be it. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket

Re: [GENERAL] Dropping schemas and illegal seek -- MEA CUPLA

In article [EMAIL PROTECTED], Felix Finch [EMAIL PROTECTED] writes: I have a perl test program ... and began getting this complaint from psql: Can't drop schemas: Illegal seek Ahhh yesss... otherwise known as the subroutine not returning any specific value and the caller expecting

Re: [GENERAL] Clustering for performance and fail over

Hi, Stan, We're in the early stages of testing a new Postgres (7.3) cluster. For background, our database is about 14gb on disk, and we see about a transaction a second (out of about 120 queries/sec.) Our application is a large dynamic Apache-based web system, written in Perl. Our main

[GENERAL] Permission denied while importing data from a file?

in backend with effective uid nr 666, could not open file '/somewhere/somebody/datafile.txt' for reading. Errno = Permission denied (13). Why? I mean how does this happen? Please help... Felix

[GENERAL] Do transactions rollback by default?

is as good as a commit and always has been. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's

Re: [GENERAL] Do transactions rollback by default?

would find it confusing to have the front end default to confirm on exit. I'd rather have it behave the same as a program. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C

[GENERAL] Question about Linux, threads, and Postgres

ual spare time first :-( -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] PGP = 91 B3 94 7C E9 E8 76 2D E1 63 51 AA A0 48 89 2F ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o

Re: [GENERAL] Question about Linux, threads, and Postgres

In article [EMAIL PROTECTED], Adam Haberlach [EMAIL PROTECTED] writes: On Sat, Jan 30, 1999 at 09:08:14PM -0800, Felix Morley Finch wrote: Q 2: Is it necessary and/or sufficient to have only one thread talk to the Postgres library? Well, it would be sufficient--I am not sure