Re: [GENERAL] Oracle to PostgreSQL

2017-11-09 Thread Felix Kunde
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 P

Re: [GENERAL] Trigger based logging alternative to table_log

2017-03-27 Thread Felix Kunde
t now, is 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

2015-02-25 Thread Felix Ivan Romero Rodríguez
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)

2015-01-22 Thread Felix Kunde
Then I've also found this nice example, which might do the things you are looking 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" An: "pgsql-general@postgresql.org"

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

2014-10-01 Thread Felix Kunde
014 um 21:16 Uhr Von: "Adam Brusselback" An: "Felix Kunde" Cc: "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, and gave it a sho

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

2014-09-30 Thread Felix Kunde
gy is too 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:

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

2014-09-29 Thread Felix Kunde
ers are all working with their version 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: Mon

[GENERAL] memory issues with BYTEAs in JSON and hstore

2014-05-27 Thread Felix Kunde
MB | 31 MB| 21 MB Thanks in advance for any 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

2014-05-12 Thread Felix Kunde
xt OR new.key IS NULL;   Everything works as expected, but it feels kinda ugly to me. Any PG-JSON experts around to tell me a better solution? Did i trapped into some "YouShouldNot"s?   Regards! Felix Kunde

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

2014-02-23 Thread Felix . 徐
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 string

Re: [GENERAL] Temporary table already exists

2014-01-31 Thread Felix Kunde
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 = tmpTableId.su

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

2014-01-20 Thread Felix . 徐
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 *va

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

2014-01-16 Thread Felix . 徐
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

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

2014-01-15 Thread Felix . 徐
function or hook? If I ran the query like: UPDATE pg_statistic SET stavalues2=array[1,2,8] WHERE ... Then I will get error 42804 indicates that the expected type is anyarry but text[] is found in the query. Thanks very much! 2014/1/15 Amit Langote > On Wed, Jan 15, 2014 at 11:08 PM

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

2014-01-15 Thread Felix . 徐
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!

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

2014-01-14 Thread Felix Kunde
Jürgen Schönig (http://www.cybertec.at/) 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

2014-01-12 Thread Felix . 徐
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 hard

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

2013-01-09 Thread felix
a superuser). I'll have to play 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

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

2013-01-09 Thread felix
s, but none as easy as the 9.1 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

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

2012-06-20 Thread felix
h 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: 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] Feature discussion: Should syntax errors abort a transaction?

2012-06-20 Thread felix
ons. Personally, I like the idea of BEGIN INTERACTIVE, 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

[GENERAL] Slow COMMIT statements

2011-12-07 Thread Felix Feinhals
oints = on checkpoint_segments = 40 Regards, Felix

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

2010-01-09 Thread felix
I fumbled a lot 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 76E

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

2010-01-09 Thread felix
se in /tmp? 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 &

Re: [GENERAL] Database schema dumper

2009-06-29 Thread felix
he trick. I'll explore 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

Re: [GENERAL] Database schema dumper

2009-06-29 Thread felix
uch 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

[GENERAL] Database schema dumper

2009-06-29 Thread felix
alone program, none of that matters much. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. 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 ou

Re: [GENERAL] Alias name from subquery

2008-09-30 Thread Felix Homann
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] Alias name from subquery

2008-09-30 Thread Felix Homann
given number of players. (Think of something like a sparse interaction matrix representation.) Maybe it's the "wrong" problem I'm trying to solve, but at least I would like 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

2008-09-30 Thread Felix Homann
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

Re: [GENERAL] Alias name from subquery

2008-09-30 Thread Felix Homann
third (3 rows) _But_, I don't 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

[GENERAL] Alias name from subquery

2008-09-30 Thread Felix Homann
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 ma

Re: [GENERAL] psqlodbc on Vista Ultimate 64

2008-08-11 Thread Lucas Felix
l > > Regards, > Hiroshi Saito > > - Original Message - 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 reconhec

[GENERAL] psqlodbc on Vista Ultimate 64

2008-08-08 Thread Lucas Felix
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 h

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

2007-08-18 Thread Felix Ji
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 somethin

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

2007-08-18 Thread Felix
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

2007-06-08 Thread felix
ls me to wonder how 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? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._

[GENERAL] How access table by tableoid

2007-05-13 Thread Felix Kater
So, I worked around 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 -

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

2007-05-09 Thread Felix Kater
, for what I have learned now, 'foreign keys' can *not* be substituted by indeces, so I have to implement them. Thanks again. Felix ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

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

2007-05-09 Thread Felix Kater
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

[GENERAL] pg_contraint: 'action code' ?

2007-05-08 Thread Felix Kater
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

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

2007-05-08 Thread Felix Kater
bunch of work...). Thank You 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 column's datatypes do not match

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

2007-05-08 Thread Felix Kater
using *indexes* since I'd 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 c

[GENERAL] are foreign keys realized as indexes?

2007-05-08 Thread Felix Kater
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: if

[GENERAL] binary representation of date and numeric

2007-04-27 Thread Felix Kater
about 'date', '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?

2007-04-24 Thread Felix Kater
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

[GENERAL] PQerrorMessage: suppress trailing new line?

2007-04-23 Thread Felix Kater
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 broa

[GENERAL] unique ID across all columns

2007-04-17 Thread Felix Kater
ttnum -- 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 PROTECTE

Re: [GENERAL] postgresl for mysql?

2007-04-01 Thread felix
> I don't think it's a new idea - IIRC, Aprile Pazzo did something > 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 ... --

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

2007-01-04 Thread felix
column, 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] Tabbed data in tab-separated output

2007-01-03 Thread felix
h column, 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

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

2006-10-17 Thread Felix Zhang
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

[GENERAL] Any documatation about porting from Oracle to PostgreSQL

2006-10-17 Thread Felix Zhang
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

[GENERAL] How to split a table?

2006-10-17 Thread Felix Zhang
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] Is it possible to have multiple names for a column?

2006-09-14 Thread felix
and so 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 se

[GENERAL] Query optimization and indexes

2006-08-18 Thread felix
, which 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 #493

Re: [GENERAL] Query runs fast or slow

2006-04-17 Thread felix
tion where it may be best > to absorb the hit of re-planning each time instead 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 SELEC

Re: [GENERAL] Query runs fast or slow

2006-04-16 Thread felix
ge of, say, 75-77. That just seems way too 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

[GENERAL] Query runs fast or slow

2006-04-16 Thread felix-accts-pgsql
g, the packet capture file, the test program 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.dat

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

2006-04-16 Thread felix-accts-pgsql
to around 15-20 lookups/sec, good 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. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.

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

2006-04-11 Thread felix
at's an idea ... I had thought that since my two referenced tables are small 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

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

2006-04-10 Thread felix
an't be solved as presented. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. 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

[GENERAL] Asking advice on speeding up a big table

2006-04-09 Thread felix
IGINT 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_

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

2006-03-07 Thread felix
he minimum necessary. 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 to Fermat's La

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

2006-03-07 Thread felix
u some Oreos 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&

Re: [GENERAL] unsubscribe pgsql-general

2005-11-17 Thread felix
nsubscribing operation you wish to change the settings, place the "manual off" override switch 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. --

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

2005-10-24 Thread felix
had never 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'v

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

2005-10-24 Thread felix
time: 11501.096 ms And that's a good one - I've seen 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 81

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

2005-10-24 Thread felix
, or no one can 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 4

Re: [GENERAL] Oracle buys Innobase

2005-10-08 Thread felix
$ not as good 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 fou

Re: [GENERAL] Oracle buys Innobase

2005-10-08 Thread felix
ll the GPL changes they want o 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

Re: [GENERAL] unsubscribe

2005-08-25 Thread felix
lace the "manual off" override switch 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. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ ..

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
n after for the rest of us, and the problem 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

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
itself into the mood of always working, so it might have to wait a while. Could a corrupt db cause these mood swings? And if so, would that persist even across dropdb / creatdb? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
de_version_id) where class = ? AND version = ? AND it_data_version > ? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I&#x

[GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
B of log file, too much for me! -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. 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 L

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

2005-05-21 Thread Felix E. Klee
ose hints! I've now adapted my code as you recommended and it works 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 mom

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

2005-05-21 Thread Felix E. Klee
error via PG_TRY() in 8.0 [...] Nice, but we're 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

[GENERAL] Exception Handling in C-Language Functions?

2005-05-21 Thread Felix E. Klee
if (tmp_pattern == NULL) ; /* What now? */ strncpy(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); fre

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

2005-01-25 Thread felix
hich also includes all the variations in SQL 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 PROTE

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

2004-11-25 Thread felix
tabases and tells 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 repairm

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

2004-06-07 Thread felix-lists
>>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 a

Re: [GENERAL] Clustering for performance and fail over

2003-10-23 Thread James Felix Black
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 data

[GENERAL] Insert into a table with only a SERIAL

2000-06-25 Thread felix
ot known to the sequence. (** This seems a bug to me **) This also works: insert into aaa values (nextval('aaa_id_seq')); but sort of defeats the purpose of using a type SERIAL rather than hand rolling my own sequence. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. .

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

2000-04-09 Thread Felix Slager
command, running 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

Re: [GENERAL] Do transactions rollback by default?

2000-03-16 Thread felix
fault to confirm, which is fine with me. I personally 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 &

[GENERAL] Do transactions rollback by default?

2000-03-16 Thread felix
ct 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

[GENERAL] Re: Problems compiling

1999-02-12 Thread Felix Morley Finch
as my fault, and it hasn't been fixed in the year since then.) -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. 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

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

1999-01-31 Thread Felix Morley Finch
>>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? >

[GENERAL] Question about Linux, threads, and Postgres

1999-01-31 Thread Felix Morley Finch
ind the usual 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

[GENERAL] primary key attribute

1998-05-29 Thread Joao Paulo Felix
Hi there, I am having trouble trying to alter a class and update an column constraint to PRIMARY KEY. I decided to create a new table using the following, still it does seem work: CREATE TABLE my_table (my_column INT PRIMARY KEY, my_column2 TEXT); Could any one help me please. Thanks i