ver.x86_64 9.2.13-1
PGDG.rhel6 @/postgresql92-server-9.2.
13-1PGDG.rhel6.x86_64
Regards
Marek
-- Původní zpráva --
Od: Tom Lane
Komu: Marek Petr
Datum: 27. 9. 2016 14:55:44
Předmět: Re: [GENERAL] lost synchroniz
version
PostgreSQL 9.2.13 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-11), 64-bit
(1 row)
Thank you
Marek
ck;t
virtualxid;3/667499;3/667499;25145;ExclusiveLock;t
relation;11874;1098585/101817;25171;AccessShareLock;t
virtualxid;85/101817;85/101817;25171;ExclusiveLock;t
(4 rows)
We are again approaching slowly the point that the server restart will be
needed. If / when this happens,
Hi,
to complement information from the previous message:
Dnia 29 lipca 2012 12:29 Marek Kielar napisał(a):
> Hi,
>
>
> Dnia 28 lipca 2012 1:10 Adrian Klaver napisał(a):
>
> > What where the deleted files?
> >WAL, Logs, other?
>
>
> at this tim
Hi,
Dnia 28 lipca 2012 1:10 Adrian Klaver napisał(a):
> What where the deleted files?
>WAL, Logs, other?
> What type of WAL replication are you doing?
>Streaming, log shipping, etc?
> What are your settings for the WAL replication?
>In particular wal_keep_segments ?
> Is the WAL rep
e note, obviously, the Windows dump came out alright because it was
from the proper database, not the replicated copy.
Best regards,
Marek Kielar
Dnia 27 lipca 2012 4:46 Adrian Klaver napisał(a):
> On 07/26/2012 04:09 PM, Marek Kielar wrote:
> > Hi,
> >
> > we are using &q
currently or previously.
Searching through the archives, I have only stumbled upon a post from 2003
about a similar issue
(http://archives.postgresql.org/pgsql-admin/2003-08/msg00239.php) which might
be connected, however, since the reporter gave up quickly, the issue remained
unsolved.
H
Cezariusz Marek wrote:
> I need to convert timestamp to a format with a time zone offset, like this:
> [...]
I'm very sorry for multiple posting, those messages were holded because of some
filters,
and now apparently someone ap
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
____
Cezariusz Marek mob: +48 608 646 494
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
Cezariusz Marekhttp://midicat.net/
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
Cezariusz Marekhttp://midicat.net/
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
Cezariusz Marek http://midicat.net/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Y-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
____
Cezariusz Marek mob: +48 608 646 494
Adrian Klaver wrote:
> On Friday, December 30, 2011 6:18:05 am Cezariusz Marek wrote:
>> I need to convert timestamp to a format with a time zone offset, like this:
>> select clock_timestamp()::text;
>> and it returns the following value:
>> "2011-12-30 11:59:0
amp(), '-MM-DD HH24:MI:SSTZ');
But it gives me "CET" instead of "+01":
"2011-12-30 11:59:06CET"
--
____
Cezariusz Marek mob: +48 608 646 494
o work on, then I submit that you have problems you ought to be
> fixing on the server side instead.
Agreed. For your information, it does not happen that often, but when it did
(once in two years...) was scary enough to trigger an investigation.
Tom, thank you very much for your help!
Best,
~M
On Wednesday 04 May 2011 18:04:16 Tom Lane wrote:
> Marek Wieckowski writes:
> > If there is a script executed in psql there is no easy way to catch that
> > psql has reconnected in the middle of it...
>
> As far as psql goes, it should certainly abandon executing any scri
just an idea => it would lead to even less handling
in the client programs (like psql => it would just call PQreconnect() and not
have to issue "begin + create and error").
Best,
~Marek
test=# select * from test1 ;
id | value
+---
1 |11
2 |21
3 |31
Hi,
On Monday 02 May 2011 16:43:54 Tom Lane wrote:
> Marek Wieckowski writes:
> > If I understand correctly, Tom's reply in:
> > http://archives.postgresql.org/pgsql-general/2007-06/msg01668.php
> > suggests that temp schemas are kept when a session gets disconnected
&
il "commit" and only then the session actually
disconnects?) I'm anxiously assuming that it's not like the next queries after
reconnection will happily be executed outside of a transaction, but I haven't
found much (recent) info on the subject.
Bes
W dniu 2010-02-04 10:46, Marek Lewczuk pisze:
Hello,
there are a lot of improvements in hstore, that is planned for PG8.5 -
as far I remember it compiles fine with PG8.4 so is it save to use it
with PG8.4 ?
Is it SAFE not "is it save"...
ML
--
Sent via pgsql-general mailing l
Hello,
there are a lot of improvements in hstore, that is planned for PG8.5 -
as far I remember it compiles fine with PG8.4 so is it save to use it
with PG8.4 ?
Thanks.
ML
--
Pozdrawiam
Marek Lewczuk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Hello,
there are a lot of improvements in hstore, that is planned for PG8.5 -
as far I remember it compiles fine with PG8.4 so is it save to use it
with PG8.4 ?
Thanks.
ML
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.po
code with NOTIFY and
select() is all right, then.
Best regards,
Marek
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ction dead.
Well, this is what I wanted to hear. So if I call PQstatus() or PQexec(),
the libpq sends some data to the TCP pipe, and you expect, that my broken
underlying TCP/IP subsystem pretends, that the connection is OK and the
data have been sent. Right?
Thank you very much for your explanat
minutes, couldn't it?
Ordinary telnet or ssh connection will tell me, that I am writing my
characters to TCP line, which has died some time ago.
Thank you for your answers,
Marek.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
same problem in my
configuration... oh no, is there anybody familiar with this kind of error?
Many thanks,
Marek.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
since I need to reset the connection almost always, after _any_ timed-out
select(), it is really harmful to my application.
Please, can you tell me, what am I doing wrong?
Thank you very much.
Best regards,
Marek.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
Hi,
for need of our application we need to get list of tables, that are
used within given SELECT query - we need them in order to track
changes of the data, that may be returned by the query - it is some
kind of caching mechanism, that checks db data modifications. Right
now we create a temporary v
2009/7/13 Tom Lane :
> No, you're misinterpreting the message. What that code likely means
> is that something is trying to use SPI and finding plpgsql already
> connected. In other words, plpgsql forgets to do a SPI_push() before
> calling something that might try to use SPI re-entrantly. It sh
for connections that
are in the pool SPI connection was not closed ??
--
Pozdrawiam
Marek Lewczuk
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2009/7/10 Tom Lane :
> Marek Lewczuk writes:
>> I have made an upgrade to PG 8.4 and following error was thrown during
>> execution of some pl/pgsql function:
>> ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT
>
> Really? Could we see a self-contained example?
Hello,
I have made an upgrade to PG 8.4 and following error was thrown during
execution of some pl/pgsql function:
ERROR: XX000: SPI_connect failed: SPI_ERROR_CONNECT
CONTEXT: PL/pgSQL function "price_aftertrigger" line 30 at IF
SQL statement "update price set validFrom = $1 , validTo =
On Donnerstag, 14. Mai 2009, Philipp Marek wrote:
> On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> > Philipp Marek wrote:
> > > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > > Do say, do you have any long-running transactions, or "idle"
>
On Donnerstag, 14. Mai 2009, Alvaro Herrera wrote:
> Philipp Marek wrote:
> > On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > > Do say, do you have any long-running transactions, or "idle"
> > > transactions? Maybe someone opened a terminal somewhere and
On Mittwoch, 13. Mai 2009, Alvaro Herrera wrote:
> > we're using postgresql 8.3 for some logging framework.
> >
> > There are several tables for each day (which are inherited from a common
> > base), which
> > - are filled during the day,
> > - after midnight the indizes are changed to FILLFACTOR=1
Hello Alvaro,
On Montag, 11. Mai 2009, Alvaro Herrera wrote:
> Philipp Marek wrote:
> > A few days before we found the machine much slower, because of the
> > autovacuum processes that were started automatically ["autovacuum: VACUUM
> > ... (to prevent wraparound)"]
Hello everybody,
we're using postgresql 8.3 for some logging framework.
There are several tables for each day (which are inherited from a common
base), which
- are filled during the day,
- after midnight the indizes are changed to FILLFACTOR=100, and
- the tables get CLUSTERed by the most import
I was wondering if dropping a table is more efficient in PostgreSQL
8.x in comparison to deleting it's content ?
To put you in the picture - I want to schedule via cron job some daily
data materialization. With the resource I got there are only those two
ways:
1) DROP statement:
a) DROP TABLE tmp
Hello,
I can't find SQL definition for OVERLAPS operator so I don't know
whether following expression's result (false) is appropriate
behaviour:
select ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps
('2007-12-01'::TimeStamp, 'Infinity'::TimeStamp)
Can anyone confirm that ? In my under
2009/2/23 Marek Lewczuk :
> Hello,
> I can't find SQL definition for OVERLAPS operator so I don't know
> whether following expression's result (false) is appropriate
> behaviour:
> select ('2006-03-01'::TimeStamp, '2007-12-01'::TimeStamp) overlaps
Zdeněk Kotala pisze:
Hello All,
1) What type of names do you prefer?
b) new one with pg_ prefix - pg_createdb, pg_creteuser ...
b
2) How often do you use these tools?
b) one per week
b
3) What name of initdb do you prefer?
c) pg_init
c
4) How do you perform VACUUM?
a) vacuumdb - shell co
Hi,
I'm using composite types within my database and I sometimes need to
modify type either by adding new column or e.g. renaming a column. Of
course I can't do that on existing composite type (actually I can, but
that is quite complicated) so maybe I should use table instead ? With
tables (th
On 20 Gru, 16:37, [EMAIL PROTECTED] ("Leonel Nunez") wrote:
> you can leave the instalation as is , and create a tablespace in
> /dane/postgresql and create your databases in the NEW tablespace
>
> take a look at
> :http://www.postgresql.org/docs/8.2/static/manage-ag-tablespaces.html
>
> Leone
/dane/postgresq/data, and set in .bashrc file of the
postgres user PGDATA variable to /dane/postgresql/data, and maybe to
move configuration files to /etc/postgresql/8.2/main (just as ubuntu
does when installing the database)? Thanks in advance for answers and
hints :-)
Cheers,
Hello all,
I'm looking for a C developer that is able to rewrite pl/pgsql functions
to PostgreSQL c functions - because we need better performance we would
like to have all important functions rewritten to c (looking from
pl/pgsql point of view they are not complicated, so I thing that an C
ex
Tom Lane pisze:
I'm wondering if you have an example that doesn't work well with the
gist page-splitting heuristic changes that Teodor put in awhile back.
Those are all in 8.2.5 already, though you might have to REINDEX to
really notice a change if the index was first built with an older
8.2.x re
Marek Lewczuk pisze:
Hello,
I'm testing 8.3beta and I think that there is a problem with gist/gin
indexes. The performance of 8.3 is very bad comparing to 8.2. I have a
table with an int[] column indexed using gin (or gist with intarray
module). Table contains about 1.5m rows, int[] leng
Hello,
I'm testing 8.3beta and I think that there is a problem with gist/gin
indexes. The performance of 8.3 is very bad comparing to 8.2. I have a
table with an int[] column indexed using gin (or gist with intarray
module). Table contains about 1.5m rows, int[] length is from 2 to 6
elements.
lp is
needed (in order to have it prepared for 8.3 version) and plan further
development.
Thanks.
Regards,
Marek
---(end of broadcast)---
TIP 6: explain analyze is your friend
7;t vote (unfortunately) :-(
So saying that it's one of the most important features is definitely
wrong. Saying it's important or very important is absolutely not wrong.
You are right, it's very important and I hope that all of us agree with
that statement (may
ing gin or intarray module) ?
Regards,
Marek
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
hould support 1.6 (I'm using it with pljava without problems -
however I'm not using all new features of Java 6).
Would you like to become committers to the PL/Java project?
You can count on me (only as Java coder or tester).
Regards,
Marek
---(e
Thomas Kellerer pisze:
Marek Lewczuk wrote on 23.05.2007 21:37:
I would like to know your opinion about pljava and its future
I have never used Java-in-the-database with any of the DBMS I have used
and I have never understood the reasoning behind it.
My personal opinion is, that it'
e
pljava ready for 8.3 and continue the development. From windows point of
view this is really great feature to have pljava inside the pgInstaller
(I'm using it on my laptop) so for sure we need to make it ready for 8.3.
Best wishes,
Marek
omplicated than
simple trigger.
and the current PL/Java works very well. I know C and Java well, and
would be willing to contribute to keeping PL/Java going. I hadn't heard
Great to hear that, please contact with Thomas, lets try to make a
roadmap what need to be done.
Bes
QL.
Best wishes,
Marek
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi, how is it with privileges for views and sequences? User other from
owner is set to have full access to DB, this is applied to tables and
functions, but not to views and sequences. I have to specifically give
permission to each view and sequence.
---(end of broadcast)--
Tom Lane pisze:
Marek Lewczuk <[EMAIL PROTECTED]> writes:
after suggestions that I should postgres update to the latest (currently
I have 8.2.3) I thought that my problem will be solved. But no, it is
not - postgres still throws warnings:
WARNING: TupleDesc reference leak: Tup
Marek Lewczuk pisze:
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x420
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x420
Hello,
I'm trying to update my database to 8.2 version and have some problems
with intarray module. As far I know PG 8.2 contains many features that
are contained within intarray - indexing array fields (using gin),
operators etc. Currently (in PostgreSQL 8.1) I'm using intarray not only
for i
Hello,
is there any schedule for final 8.2 release ? As far I remember this
should be around November ? I would like to know that in order to plan
my work.
Thanks in advance.
ML
---(end of broadcast)---
TIP 3: Have you checked our extensive FA
Marek Lewczuk napisał(a):
Hi,
I can't understand how java_reset works - the docs says that "..Since
java does not yet support library versions, the PHP/Java Bridge must be
reset after a new library version has been deployed..." - so in other
words, when we have new version of
Hi,
I can't understand how java_reset works - the docs says that "..Since
java does not yet support library versions, the PHP/Java Bridge must be
reset after a new library version has been deployed..." - so in other
words, when we have new version of libraries used by php/java bridge we
can ca
Hello,
I have a question about IntArray contrib package. The docs says:
"...current implementation provides index support for one-dimensional
array of
int4's - gist__int_ops, suitable for small and medium size of arrays
(used on
default), and gist__intbig_ops for indexing large arrays (we use
s
Hello,
I'm implementing db-queries caching system - for this I need to know
each table's modification time (or at least modification counter). I
know that I can make a statement-level trigger, which will update a
table with tables modification times - however this is inefficient if
many insert
Tom Lane napisał(a):
Jason Tesser <[EMAIL PROTECTED]> writes:
3. The tools. PgAdmin does some things well but it is lacking the features of
some of the other gui tools.
I'm sure the pgAdmin guys would love having some more help.
What about sqlmanager.net - it the best GUI with number of great
r 8.0 is not a valid Win32 application.
My postgres account has log on locally and log on as a service rights
granted
so I don't think that this is a problem.
Marek Aleksander Dabek
---(end of broadcast)---
TIP 2: you can get off all lists at
Steve - DND napisał(a):
Simple question I'm sure, but how can I get the transaction ID that a query
is currently running in? I can find all kinds of documentation talking about
transaction ids, but nothing about how to get the current one.
You can compile attached function - this will return cu
Christopher Kings-Lynne napisaÅ(a):
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions
Hi,
I need a db connection pooling in PHP. As far I know persistent
connections are not the best solution so I'm thinking about using
SQLRelay. Does anyone have any experience using PostgreSQL + PHP +
SQLRelay ? Maybe you know other "connection pooling" solutions for PHP ?
Thanks in advance.
ML
fryk napisaÅ(a):
Hi,
How to set such variable after (during?) client connection (PHP)?
I want to use it in view - so view could depends on it:
If I could set client's variable i.e. MY_VAR='hello' then I could do
something like this:
CREATE VIEW my_view AS SELECT * FROM pg_tables WHERE tablename ~*
Hi,
I have a table with many triggers. Now, it can happen that in middle of
execution one of table's triggers there will be unknown error (like
"NEW" is not assigned yet) - is there a way to trace which trigger fired
this error ?
Thanks in advance.
ML
---(end of broadca
Joachim Zobel napisaÅ(a):
Am Mo, den 27.12.2004 schrieb Marek Lewczuk um 20:54:
Michael Fuhr napisaÅ(a):
Why do you want the transaction ID? What problem are you trying
to solve?
I've already solved the problem - I found somewhere on the web a very
simple C function, which returns transacti
Michael Fuhr napisaÅ(a):
On Mon, Dec 27, 2004 at 09:52:57AM +0100, Marek Lewczuk wrote:
is there any way to get current transaction id using plpgsql or sql ?
A couple of people have posted suggestions but I'll ask a question:
Why do you want the transaction ID? What problem are you tryi
Kaloyan Iliev Iliev napisaÅ(a):
Hi
I have the following function:
select int('t'::bool);
ERROR: syntax error at or near "(" at character 11
"int" is reserved for integer type, so you should not use it. However if
you add
namespace before function name "public.int(TRUE)" then it should work.
ML
Hello,
is there any way to get current transaction id using plpgsql or sql ?
Thanks in advance for any help.
ML
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" t
Joe Conway napisaÅ(a):
Marek Lewczuk wrote:
I've made some tests with plperl and I see that when plperl function
is executed for the first time, then it takes much more time. I know
that this is a "shared library" problem - is there a way to preload
plperl every connection or ma
Hi,
I've made some tests with plperl and I see that when plperl function is
executed for the first time, then it takes much more time. I know that
this is a "shared library" problem - is there a way to preload plperl
every connection or maybe I can build plperl into postgresql source ?
Thanks i
reate a view.
Any help would greatly appreciated.
Todd Marek
"If you think you understand something it's habit."
--Gary Kraftsow--
Goutam Paruchuri wrote:
Why can you not use simple insert statements (sql insert).
Copy is meant to transfer large amount of data from text files to
databases and vice versa.
"Insert" is much slower if there are many (hundreds, thousands) data to
be inserted - and in my case there will be thousand
Hello,
I need to use COPY (instead of INSERT) within plperl function. I know
that COPY will work if data will be taken from file - however I need to
use STDIN. I tried this:
spi_exec_query("COPY sometable (field1, field2) FROM
stdin;"."\n"."sometext"."\t"."sometext"."\n"."\.")
But it didn't wor
Hello,
I would like to ask if my problem with sequence is a proper behavior or
this is a bug (probably not)...
I have a table:
CREATE TABLE "testtable" (
"serialfield" SERIAL,
"someotherfield" TEXT,
PRIMARY KEY("serialfield")
) WITH OIDS;
After creation of this table, sequence "testtable_se
Hello,
I've just made successful installation of PostgreSQL 8.0 on Cygwin but I
have some problems with installing tsearch2 contrib module. This is what
make produce:
dict_ispell.o(.text+0x1ec):dict_ispell.c: undefined reference to
`_pg_strcasecmp
'
dict_ispell.o(.text+0x31e):dict_ispell.c: und
.
Thanks to everyone and apologies for my oversight of the seconds clause.
Todd Marek
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
messa
, 'HH:MI:SS AM')
which returns
06:30:00 AM - 07:30:00 AM
I am really looking to get it outputting like this.
6:30 AM - 7:30 AM
I have looked through the documentation and haven't found anything to do this in postgres. I am going to have to do this formating in the application layer?
Th
Hello,
I have a query, which is quite big and there is a huge difference
between execution time in MySQL and PostgreSQL. I think that I have made
all possible steps to increase the speed of the query, but unfortunately
it is still about 100 times slower. I'm out of ideas what to do next,
so ma
containing those records but I don't know the
structure of this file.
This is Postgres 7.2.1 on Mandrake 8.1
Marek Nowiński
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Dave Cramer wrote:
connection failed :(
works for me... :-) (poland)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Csaba Nagy wrote:
Because that's a syntax check, which does NOT evaluate any of the
expressions, only the types of them. Even if it will not be executed
ever, it is still wrong, and it should generate an error, because it
means a mistake on your side which potentially could leave to results
you did
Richard Huxton wrote:
On Friday 19 December 2003 09:02, Marek Lewczuk wrote:
But until it's evaluated ''<>'' it doesn't know it is false. When building the
CASE expression, it's trying to map types to each elements and notes that ''
is not an
Alexander Litvinov wrote:
This is normaol behavior.
I belive that I have found a bug - or maybe it was done on purpose. Have
a look at this query:
SELECT integer_field FROM bugtable WHERE (CASE WHEN '' <> '' THEN
integer_field = '' ELSE integer_field = 0 END);
Result: ERROR: invalid input syntax
I belive that I have found a bug - or maybe it was done on purpose. Have
a look at this query:
SELECT integer_field FROM bugtable WHERE (CASE WHEN '' <> '' THEN
integer_field = '' ELSE integer_field = 0 END);
Result: ERROR: invalid input syntax for integer: ""
SELECT text_field FROM bugtable W
Tom Lane wrote:
Marek Lewczuk <[EMAIL PROTECTED]> writes:
I'm curious if the default scheme for sequence name (which is created
with SERIAL data type) can be changed -- currently all sequences are
named like this: __seq -- can it be changed for
e.g. seq ???
Sure ... just hack
Miso Hlavac wrote:
Hello,
Sorry for just stupid question, but I need use md5 function in 7.4
When I write:
select md5('text');
ERROR: Function md5("unknown") does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecast
I'm curious if the default scheme for sequence name (which is created
with SERIAL data type) can be changed -- currently all sequences are
named like this: __seq -- can it be changed for
e.g. seq ???
Thanks.
ML
---(end of broadcast)---
TIP
Kris Jurka wrote:
On Tue, 16 Dec 2003, Marek Lewczuk wrote:
Another question is about WIN32 native release - currently, all win
users cannot set locales, becouse Cygwin does not support it -- I hope
that it will be solved in native release, so UTF-8 should work as well ??
You may be
I'm looking at "TODO list for PostgreSQL" and "Fix upper()/lower() to
work for multibyte encodings" has no dash (-) -- so it won't be made in
7.5 ?
Another question is about WIN32 native release - currently, all win
users cannot set locales, becouse Cygwin does not support it -- I hope
that it
1 - 100 of 122 matches
Mail list logo
