2006 at 11:12:21PM -0400, Tom Lane wrote:
> The patch submitter has neither provided an updated patch nor defended
> his original submission as being the right thing. If he doesn't take it
> seriously enough to have done any followup, why should the rest of us?
--
Karel Zak <[EMAIL
On Tue, Aug 22, 2006 at 01:11:22PM -0400, Andrew Dunstan wrote:
> There's nothing hidden (unless it's also hidden from me ;-) )
>
> I take it that when you talk about "we did this" you are referring to
> the patch from Karel Zak.
Hans has been original author
all problem that the
current to_char() output is possible use as argument for to_timestamp()
or to_date() function. It means you should implement vice-versa
conversion from string with TMMonth/TMDay to timestamp.
to_timestamp('Domingo, 25 Dezembro 2005', 'TMDay, DD TMMonth YYY
rd compatibility the locale sensitive to_char()
should be implemented as separate call "to_char(datetime, format,
locale)" or we should add new modifiers to the current to_char,
something like "to_char(datetime, "LCMonth") or both.
I don't have any
ortal stuff.
Tom, do you think that there's any other (better) way how we can
implement it?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
est (cost=0.00..0.00 rows=1 width=0) (actual
time=0.004..0.004 rows=0 loops=1)
Filter: ((_time)::date = '2005-04-06'::date)
Total runtime: 0.065 ms
Karel
--
Karel Zak <[EMAIL PROTECTED]>
---(end of broadcast)-
0s', 'MI "min"') -> '70.5 min'
BTW, for numbers to_char() disable extraction:
test=# select to_char(123.4::float, '.999');
to_char
-
.###
the result is not '.4'. I think important is always tradition how people
work with selected datetype. For TIMESTAMP is it common that you work
with extraction from full date/time description, but it's unusual for
numbers and I think for INTERVALs too.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Sun, 2005-03-27 at 12:03 +0200, Karel Zak wrote:
> On Sat, 2005-03-26 at 15:56 -0800, Josh Berkus wrote:
> > Alvaro,
> >
> > > On Sat, Mar 26, 2005 at 02:04:14PM -0800, Josh Berkus wrote:
> > > > SELECT to_char( INTERVAL '43 hours 20 minutes',
lready supported by
to_char() format parser.
I think to_char(interval) should be support split interval to more
items, like:
to_char(INTERVAL '1d 3h 65s', 'HHh MIm SSs') ---> '27h 1m 5s'
Well, I'm going to check how difficult will be implement correct t
On Sat, 2005-03-26 at 02:32 +0100, Karel Zak wrote:
> On Fri, 2005-03-25 at 20:03 -0500, Tom Lane wrote:
> > Steve Crawford <[EMAIL PROTECTED]> writes:
> > > In digging around I discovered that it appears a decision was made to
> > > remove to_char(interval)
ent for this functionality. This alarms me.
>
> Yeah. Karel Zak, who wrote that code, is convinced we should remove it,
> but I don't think anyone else is ...
I think I was Peter and Josh Berkus who convinced me that the code is
bed. "we should remove..." i
me to the same conclusion a little while ago:
> http://archives.postgresql.org/pgsql-hackers/2005-03/msg00908.php
>
> > Also the general to_char() Interval formatting seems broken anyway.
>
> Karel Zak has stated repeatedly that interval_to_char is fundamentally
> wrong an
On Fri, 2005-03-25 at 14:08 -0500, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > On Fri, 2005-03-25 at 03:29 -0500, Tom Lane wrote:
> >> I intend to look at that tomorrow. Meanwhile, have you got a fix
> >> for bug#1500?
> >> http://
On Fri, 2005-03-25 at 03:29 -0500, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > http://archives.postgresql.org/pgsql-patches/2005-03/msg00176.php
>
> I intend to look at that tomorrow. Meanwhile, have you got a fix
> for bug#1500?
> http://archives.pos
http://archives.postgresql.org/pgsql-patches/2005-03/msg00176.php
Add it to 8.0.2 or 8.1?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
a complications
> (e.g. resource management).
It was already implemented as experiment and I think better is keep
plans separate.
karel
--
Karel Zak <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: Have you search
e
> malloc has to be freed in the code. Why do you want to make the
> switch?
Right. And it's definitely faster use palloc() than malloc(). I think
the current code is really based on memory contexts and I'm sure that
(strange:-) s/palloc/malloc/ is not enough.
he
> official names vs. the common names.
Yes. I said already. For example "WIN" is extremely bad alias. It all is
heritage from old versions.
> I will work on a patch that people can review and test.
Thanks.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
---
On Sat, 2005-02-19 at 00:27 +1300, Oliver Jowett wrote:
> Karel Zak wrote:
>
> > Yes, I think we should fix it and remove UNICODE and WIN encoding names
> > from PG code.
>
> The JDBC driver asks for a UNICODE client encoding before it knows the
> server version i
On Tue, 2005-02-15 at 14:33 +0100, Peter Eisentraut wrote:
> Am Dienstag, 15. Februar 2005 10:22 schrieb Karel Zak:
> > in PG: unicode = utf8 = utf-8
> >
> > Our internal routines in src/backend/utils/mb/encnames.c accept all
> > synonyms. The "official" i
in src/backend/utils/mb/encnames.c accept all
synonyms. The "official" internal PG name for UTF-8 is "UNICODE" :-(
It's historical reason that UTF8 = UNICODE, because there was "UNICODE"
first. It's same like "WIN" for WIN1251 (in sources it's
> eating a percent or three of most profiles.
Sounds good.
I think we can inlining all MemoryContext functions which check memory
context header and call context->metods->...() only. An example
MemoryContextAlloc() that is very often called from code too.
Karel
there. The conversion
from string to number is less stable part of formatting.c...
I have already 2000 lines of code of new generation of to_..()
functions. But all will available in 8.1.
The patch is in the attachment.
Karel
--
Karel Zak
http://home.zf.jcu.cz/~zakkr
--- pgsql/src/backend/u
then I'd replace the postgres function
> with the OS provided function.
>
> I'd add some __builtin_constant_p() optimizations, but I guess Tom won't
> like gcc hacks ;-)
I think it cannot be problem if you write it to some .h file (in port
directory?) as macro with &qu
On Mon, Aug 23, 2004 at 02:52:44PM +0200, Dennis Bjorklund wrote:
> On Mon, 23 Aug 2004, Karel Zak wrote:
>
> > I think it's pretty extendable solution in contrast to the current
> > hardcoded in/out datetypes functions.
>
> Who are we formatting for? If t
ntrast to the current
hardcoded in/out datetypes functions.
Comments?
Is there any plan for locale-per-column setting syntax?
> The idea behind the money type is to format per the lc_monetary locale
> setting, which seems perfectly reasonable to me. Further down the road
Why &quo
lltime job for RH next week. Note RH
constitute new team of developers in Czech Republic. Maybe I will have
again more time for PostgreSQL (or maybe not if they assign me to some
other project -- but PostgreSQL is my wish :-) So to_char() familly
will again better maintained.
Karel
isn't compiled in PostgreSQL client libs,
but the get_home_path() is used there.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
about it is already in 7.4 docs. Maybe we can remove
it in 7.5/8.0. Comments?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
case all start
discussion if something is already done and they try use it.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
is well-founded idea. I think
:-)
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
?news_id=174
Jan, the link
http://postgresql.org/~wieck/slony1/Slony-I-concept.pdf
that is used on project pages doesn't work :-(
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TI
ecause I can detect it by error message and it's too academic problem
for me. I don't change DB schema in stable and production server and I
think ALTER/DROP/CREATE is nothing often in running and good designed
databases.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
me of MySQL.
>
> That seems like a good idea.
Agree. The page should be describe basic PostgreSQL features and
step-by-step introduction from download to a first user's "SELECT ...
FROM".
Do you expect translate PostgreSQL-win installer to foreign languages?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
on't understand why MySQL developers want to leave
their current possition and want to fight with PostgreSQL, Oracle, DB2
.. etc.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
ng?
The contrib tree is basic selection of interesting small thigs from
PostgreSQL world.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Tue, Apr 20, 2004 at 08:59:20AM -0400, Bruce Momjian wrote:
> Karel Zak wrote:
> > On Mon, Apr 19, 2004 at 08:41:18PM -0400, Bruce Momjian wrote:
> > > With initdb written now in C, we don't need a pg_encoding binary
> > > anymore.
> >
> > By the w
others things in
pgsql/src/bin)
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Wed, Apr 07, 2004 at 02:20:55PM -0400, Tom Lane wrote:
>
> I've committed changes to do the right thing in CVS tip.
Thanks man!
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)
On Tue, Apr 06, 2004 at 10:33:25AM -0400, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > I'm surprise with query plan that PostgreSQL planner prepare for
> > selects with ORDER BY if all data are from sub-select that is already
> > sorted.
Subquery Scan "*SELECT* 2"
-> Seq Scan on addr2
Or order of data which returns "unique" is for UNION diffrent that data
from DISTINCT? (see first example).
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
d nice. You can use "GRANT TO LOCAL foo" rather than
connect more commands together.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 8: explain analyze is your friend
and not CPU only.
(sorry of this pontification:-)
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
to forget about
lightly-used tables.) The auto vacuumer could look at the FSM
numbers to decide which tables are highest priority to vacuum.
(2002-09-03 08:10:32)
I looked at the code and I think extend FSM tables will pretty simple,
but I unsure how
On Fri, Mar 19, 2004 at 09:54:37AM -0500, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > The problem with CSV is that it will correctly work with new protocol
> > only. Because old versions of clients are newline sensitive.
>
> Why? The client-side
On Fri, Mar 19, 2004 at 09:39:58AM -0500, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> >>> It's pity that main idea of current COPY is based on separated lines
> >>> and it is not more common interface for streaming data between FE and BE.
>
keep the COPY option syntax to be just
> FORMAT csv
> is to create an arbitrary difference in the signatures of the input
> functions. Then we could have coexisting functions
> csv(text[]) returns text
> csv(text) returns text[]
> csv(text, ...) return
was right that in this case it will C functions
only. As I said I will try implement it without user defined function
call for format conversion, but I will do it modular and in future we
can create some interface for user defined formats.
Karel
--
Karel Zak <[EMAI
On Thu, Mar 18, 2004 at 07:48:40AM +0100, Karel Zak wrote:
> On Wed, Mar 17, 2004 at 11:02:38AM -0500, Tom Lane wrote:
> > Karel Zak <[EMAIL PROTECTED]> writes:
> > > The formatting function API can be pretty simple:
> > > text *my_copy_for
On Wed, Mar 17, 2004 at 11:02:38AM -0500, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > The formatting function API can be pretty simple:
> > text *my_copy_format(text *attrdata, int direction,
> > int nattrs, int attr, oid attrtype, oid rel
The formatting function API can be pretty simple:
text *my_copy_format(text *attrdata, int direction,
int nattrs, int attr, oid attrtype, oid relation)
-- it's pseudocode of course, it should be use standard fmgr
interface.
It's probably interesting for
On Thu, Feb 26, 2004 at 09:16:03AM -0500, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > I think possible solution is special function used ORDER BY clause
> > which knows to switch by safe way to wanted locales, convert string by
> > strxfrm()
ale
*/
if (!setlocale(LC_COLLATE, lc_collate_cache))
elog(ERROR, "invalid LC_COLLATE setting: %s", lc_collate_cache);
PG_RETURN_TEXT_P(txt_out);
}
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Thu, Feb 26, 2004 at 09:16:03AM -0500, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > I think possible solution is special function used ORDER BY clause
> > which knows to switch by safe way to wanted locales, convert string by
> > strxfrm()
I claim the format is
> docbook.
Yes, it's simular "jade" way that we use for SGML now. The "fop"
advantage is direct conversion without huge TeX stuff.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
Informatio
l good about it. The important thing is support in Makefiles XML
conversion to other formats like HTML, PDF and man. It's strange if
after release almost nobody has idea how create PDF docs.
> almost equivalent. I've also tried out the po2xml thingy and it seems
> to work, b
testxml" stuff in the
doc/src/sgml/Makefile. I tested it and it works -- but for example
conversion from XML to PDF by "fop" failed, but it's might be fop
problem.
Peter, what's your planns?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home
(end of broadcast)---
> > TIP 8: explain analyze is your friend
> >
>
> ---(end of broadcast)-------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
--
Ka
current
RI solution that save plans in own hash table. I think we can add
support for work with query cache to SPI and use it in more places (RI,
PL, etc.), something like SPI_saveplan_bykey().
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---
'0001-01-01 BC'::date, '/MM/DD AD');
to_char
---
/01/01 AD
# SELECT EXTRACT(YEAR from '0001-01-01 BC'::date);
date_part
---
0
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zak
DD BC');
to_date
0020-01-10
test=# select to_char('0020-01-10 BC'::date, '-MM-DD AD');
to_char
---
0020-01-10 BC
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Fri, Nov 28, 2003 at 02:35:11PM +0100, Peter Eisentraut wrote:
> Karel Zak writes:
>
> > in our TODO is the item: "Add PL/PgSQL packages".
>
> I think the interesting part are the package-global variables. The
> name hierarchy seems completely redundant with
een the
schemas and possible package contents referencing:
SELECT xyz.funcname();
^^^
Is it some function in schema 'xyz' or some function in package 'xyz'
in the current schema? Or is needful check both alternatives?
Do you have any experience with it?
K
('23:20:30', 'HH24:MI:SS.US')::time;
> to_timestamp
> -
> 23:20:30.123459
> (1 row)
I think it's fixed in 7.4.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadca
if in the PostgreSQL docs is something special what disable
use XML instead SGML.
> Follow-up to [EMAIL PROTECTED] please.
Hmm.. I must subscribe first :-)
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
--
On Fri, Nov 14, 2003 at 09:57:16AM +0100, Jean-Michel POURE wrote:
> Le Vendredi 14 Novembre 2003 09:26, Karel Zak a écrit :
> > What use pure XML Docbook (non-SGML) for 7.5 PostgreSQL docs?
>
> Dear Karel,
>
> For information, how do you plan to translate XML Docbook form
.pdf
ps:
fop -xsl /path/to/stylesheet/xsl/fo/docbook.xsl -xml book.xml -ps book.ps
html:
xsltproc -o htmldir/ /path/to/stylesheet/html/chunk.xsl book.xml
man:
xsltproc /path/to/stylesheet/manpages/docbook.xsl ref.xml
Comments?
Karel
--
Karel Zak <[EMAIL PROT
7.5, but at present you are going to need to use a
> single-byte encoding within the server. (Nothing to stop you from using
> UTF-8 on the client side though.)
You can use mutibyte on server side too, but you must to use for
example convert() function for upper/lower argument
haracter set.)
Why cannot do PostgreSQL as 100% pure Unicode system? We can do
conversion from/to others encodings as client/server communication
extension, but internaly in BE we can use only pure Unicode data. I
think a lot of things will more simple...
Karel
--
; > for difference backends.
>
> The decision to store prepared statements per-backend, rather than in
> shared memory, was made deliberately. In fact, an early version of the
> PREPARE/EXECUTE patch (written by Karel Zak) stored prepared statements
> in shared memory. But I decided to
ferences
between OS. The best it's if libc support nl_langinfo(CODESET) call.
The complete code of charset detection you can found in libcharset or
glib (I use simplification of these codes and it's 300 lines:-).
Karel
--
Karel Zak <[EMAIL PROTECTED]&
On Wed, Jul 23, 2003 at 12:42:36PM +0200, Peter Eisentraut wrote:
> Karel Zak writes:
>
> > Thanks. What time will "freeze" backend messages? I think after beta
> > release.
>
> Typically (meaning in other large projects that care about these things),
> a
On Tue, Jul 22, 2003 at 10:31:36AM -0400, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > ./configure --prefix=/usr/lib/postgresql --enable-nls
>
> I think you must have done --enable-recode too.
Oops.. you're right :-)
Karel
--
Karel Zak
miscinit.o] Error 1
It's problem with:
MyProcPort->raddr.in.sin_addr.s_addr
^^
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Mon, Jul 14, 2003 at 10:37:24AM -0400, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > I start translate rest of all non-translated PostgreSQL's LC_MESSAGES
> > from http://developer.postgresql.org/~petere/nls.php.
> > Please, if someone other wi
Hi,
I start translate rest of all non-translated PostgreSQL's LC_MESSAGES
from http://developer.postgresql.org/~petere/nls.php.
Please, if someone other will do this work connect me first. I want
to prevent duplicated work...
Karel
--
Karel Zak <[EMAIL PROTECTED
slow??
I don't think to_char() is so slow. What happen with performance
if you use t.dt without formatting or if try some other function
an example extract()?
SELECT t.x, t.y, t.dt FROM ( SELECT x, y, dt FROM ) AS t;
SELECT t.x, t.y, EXTRACT(year from t.dt)
FROM ( SELECT x,
deset = buf;
}
}
#endif
if (codeset == NULL)
/* The canonical name cannot be determined. */
codeset = "";
else
codeset = mp_charset_aliases (codeset);
/* Don't return an empty string. GNU libc and GNU libiconv interpret
* the empty string as denoting "the locale's character encoding",
* thus GNU libiconv would call this function a second time.
*/
if (codeset[0] == '\0')
{
/*
* Last possibility is 'CHARSET' enviroment variable
*/
if (!(codeset = getenv ("CHARSET")))
codeset = "ASCII";
}
if (charset)
*charset = (char *) codeset;
if (strcasecmp(codeset, "UTF8")==0 || strcasecmp(codeset, "UTF-8")==0)
return TRUE;
return FALSE;
}
autoconf part:
-
AC_DEFUN(jm_LANGINFO_CODESET,
[
AC_CHECK_HEADERS(langinfo.h)
AC_CHECK_FUNCS(nl_langinfo)
AC_CACHE_CHECK([for nl_langinfo and CODESET], jm_cv_langinfo_codeset,
[AC_TRY_LINK([#include ],
[char* cs = nl_langinfo(CODESET);],
jm_cv_langinfo_codeset=yes,
jm_cv_langinfo_codeset=no)
])
if test $jm_cv_langinfo_codeset = yes; then
AC_DEFINE(HAVE_LANGINFO_CODESET, 1,
[Define if you have and nl_langinfo(CODESET).])
fi
])
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
e if SQL standard knows something like this and write
something for "interval" only is not good idea (IMHO) if there is a lot of
code which already know formatting data to string.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakk
O list, though; does
> that mean it's already been fixed in 7.4?
No. There was short discussion about it last week.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 1: subscr
]: Leaving directory `/var/home/PG_DEVEL/pgsql/src/bin/psql'
make[2]: *** [all] Error 2
The "cancelConn" has defined to the file common.c as static and in
the common.h as extern.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
-
On Mon, Dec 02, 2002 at 12:48:38PM -0800, Christopher Kings-Lynne wrote:
> But if there is, then the sum/count(*) is nonsensical anyway.
You must to use it in SERIALIZABLE transaction isolation.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.
On Mon, Dec 02, 2002 at 08:56:41AM -0800, Joe Conway wrote:
> Karel Zak wrote:
> >On Sat, Nov 30, 2002 at 01:11:20PM -0800, Joe Conway wrote:
> >
> >>As I said, this is all very preliminary; comments, suggestions, requests
> >>are all welcome.
> >
> &
s. It's very interesting that nobody other wants it...
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
ns ...;
SELECT * FROM myschema.tabname;
This solution allows use dblink as really transparent.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
---(end of broadcast)---
TIP 3: if posting/reading through
s is PostgreSQL useless in real DB aplication
(9) Think about full dynamic charset encoding (add new encoding on
the fly)
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
;"
>
> The methods will probably have problems with syntax clashes with
> existing stuff.
Hmm, p.pay.tax() ?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
--
,
age int
);
Comments? I nothinig found about OO in the current TODO. BTW, my
examples are only small part of possible OO features, the others
ideas are for example define PRIVATE/PUBLIC attributes in composite
types and methods, "SELECT p.name FROM person p WHERE p.pay->tax
;t want
to maintain my databases by SET command.
> profname
> session_per_user
> cpu_per_session
> cpu_per_call
> connect_time
> idle_time
> logical_reads_per_session
> logical_reads_per_call
... and a lot of others things in future.
Karel
--
Karel Zak <[EMAIL
but worse.
Right.
There's solution: persisten backend (for example like classic
apache). This solve problem with lifetime of all persistent caches.
It's already in TODO.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, Postgre
(BTW backend is
multithread:-). IMHO use memory-context design for FE is good idea
if FE a lot works with memory. I already long time think about shared
lib with PostgreSQL mmgr...
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http
On Wed, Oct 16, 2002 at 09:25:37AM -0400, Rod Taylor wrote:
> On Wed, 2002-10-16 at 09:19, Karel Zak wrote:
> >
> > Hi,
> >
> > I have SQL query:
> >
> > SELECT * FROM ii WHERE i1='a' AND i2='b';
> >
> > There're
i1 on ii a (cost=0.00..52.00 rows=1000 width=24)
-> Index Scan using i2 on ii b (cost=0.00..52.00 rows=1000 width=24)
Thanks,
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
-
test=# select to_char('30-SEP-02'::date, 'WW IW Day D');
to_char
---
39 40 Monday2
SVRMGR> select to_char(to_date('29-SEP-02'), 'WW IW Day D') from dual;
TO_CHAR(TO_DATE('
ate('402002', 'IWYYYY');
to_date
2002-09-30
(1 row)
test=# select to_date('012002', 'WW');
to_date
2002-01-01
(1 row)
test=# select to_date('012002', 'IW');
to_date
2001-12-31
(1 row)
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Fri, Sep 20, 2002 at 09:24:00PM +0200, Peter Eisentraut wrote:
> Karel Zak writes:
>
> > test=# select to_char(0,'FM9.9');
> > to_char
> > -
> > 0.
> > (1 row)
> >
> > test=# select to_char(1,'FM9.9');
> >
t; ! +
> > ! | 456.
> > ! | 4567890123456789.
> > ! | 123.
> > ! | 4567890123456789.
> > ! | -4567890123456789.
The results like this are right.
Karel
--
SQL and to_ascii() in
main tree. Comment?
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
In the server log file is:
TRAP: FailedAssertion("!(len > 0)", File: "utf8_and_iso8859_1.c", Line: 45)
If I use INSERT instead COPY it's OK.
Karel
--
Karel Zak <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.c
On Mon, Sep 09, 2002 at 11:51:08AM -0400, Tom Lane wrote:
> Karel Zak <[EMAIL PROTECTED]> writes:
> > 1/ ExecuteQuery() (line 110). Why is needful use copyObject()? The
> > PostgreSQL executor modify query planns?
>
> Yes, and yes. Unfortunately.
Hmm, it'
1 - 100 of 262 matches
Mail list logo
