Gauthier, Dave dave.gauth...@intel.com :
Again, the audience is managers. Is there an
impartial, 3rd party evaluation of the 2 DBs out there that
identifies PG as being more reliable? It might mention things like
fewer incidences of corrupt tables/indexes, fewer deamon crashes,
better
Christine Penner christ...@ingenioussoftware.com :
If we have clients that are going to buy new computers or upgrade
current ones, what we can recommend to them for optimal system
performance to run Postgres.
Make them buy the biggest, run virtual machine that dont use all the
ressources on
Have you sent us you talk proposal for FOSDEM yet? If not, there is
just one day left to prepare and send your submission for presentation
in the PostgreSQL devroom at FOSDEM 2010!
Not sure if your topic is appropriate? Send it anyway and let us decide!
Never spoken to a room full of geeks
Hi!
2009/12/19 Albe Laurenz laurenz.a...@wien.gv.at
If you need the data in WIN1250 on the client side, change the client
encoding to WIN1250.
So:
- Create the database with UTF8.
- Change the client encoding to WIN1250 (e.g. by setting the environment
variable PGCLIENTENCODING).
-
Thanks,I am already have started doing that. i.e. running the dummy task to get
the tables loaded again and it worked fine today.
regardsAlex
To: ainto...@hotmail.com
CC: scott.marl...@gmail.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PL/Perl Performance Problems
Date: Sun,
On Mon, Dec 21, 2009 at 10:26:51AM +0100, Durumdara wrote:
So if I have Python and pygresql, can I set this value in Python?
The main problem that I don't want to set this value globally - possible
another applications want to use another encoding...
Each connection can set the encoding to
On 21 Dec 2009, at 10:26, Durumdara wrote:
So if I have Python and pygresql, can I set this value in Python?
The main problem that I don't want to set this value globally - possible
another applications want to use another encoding
Sure you can, just execute SET client_encoding TO
I'm having trouble figuring out the ANY operator.. Basically I want to
return rows that match any of the given IDs:
select Name from Users where UserId = ANY
ARRAY['948aeda5--41bd-af4e-71d1c740db76',
'5ee315ea-7ef6-4fa5-809a-dc9931a01ed1']::uuid[];
I get the syntax error:
ERROR: syntax
John R Pierce wrote:
Andre Lopes wrote:
Hi,
I need to know if there is something like Oracle Forms in the Open
Source world that works with PostgreSQL.
If do you know something, please let me know.
perhaps OpenOffice Data could do what you need. I'm not real familiar
with Oracle Forms,
On Mon, Dec 21, 2009 at 02:46:59AM -0800, Mike Christensen wrote:
I'm having trouble figuring out the ANY operator.. Basically I want to
return rows that match any of the given IDs:
select Name from Users where UserId = ANY
ARRAY['948aeda5--41bd-af4e-71d1c740db76',
Hi list,
I'm using FWTOOLS ogr2gr to import a s57 chart. Im getting a warning when I'm
importing in Linux but not in Windows XP, see below.
Could anyone tell me why and what the difference is in the result (I can't see
it because the lnam_refs is empty), will I miss anything?
ogr2ogr -f
Uggghhh.. Yea I figured that out about 30 seconds before your reply.. I
guess it would be way too much trouble for Postgres to just say Expected
parenthesis or some sort of error that would actually be helpful to noobs
like me.
But thanks :)
Mike
On Mon, Dec 21, 2009 at 2:49 AM, Martijn van
Hi,
What I need is some CRUD app that allows me to be quick in developp forms to
insert, update and delete information in the database. I will be using this
in a website database, but for now I don't have time to develop the forms
and the admin side on the website, so I need to use an temporary
On Mon, Dec 21, 2009 at 1:59 PM, Andre Lopes lopes80an...@gmail.com wrote:
Hi,
What I need is some CRUD app that allows me to be quick in developp forms to
insert, update and delete information in the database. I will be using this
in a website database, but for now I don't have time to
On Mon, 2009-12-21 at 10:59 +, Andre Lopes wrote:
Hi,
What I need is some CRUD app that allows me to be quick in developp
forms to insert, update and delete information in the database. I will
be using this in a website database,
What do you mean by website database? A database is a
Durumdara wrote:
- Change the client encoding to WIN1250 (e.g. by
setting the environment variable PGCLIENTENCODING).
So if I have Python and pygresql, can I set this value in Python?
The main problem that I don't want to set this value globally
- possible another applications want to use
On 21 Dec 2009, at 11:59, Andre Lopes wrote:
Hi,
What I need is some CRUD app that allows me to be quick in developp forms to
insert, update and delete information in the database. I will be using this
in a website database, but for now I don't have time to develop the forms and
the
Hi!
2009/12/21 Albe Laurenz laurenz.a...@wien.gv.at
Durumdara wrote:
- Change the client encoding to WIN1250 (e.g. by
setting the environment variable PGCLIENTENCODING).
So if I have Python and pygresql, can I set this value in Python?
The main problem that I don't want to set this
Dimitri Fontaine wrote:
Le 19 déc. 2009 à 16:20, Chris Ernst a écrit :
Hmm.. That does look very interesting. The only thing that concerns me
is where it says it supports Basic Queries (Extended queries not yet
supported). I'm not sure what is meant by Extended queries. Any idea?
I
On Sat, Dec 19, 2009 at 7:08 PM, Postgres User
postgres.develo...@gmail.com wrote:
Great call, someone did hose the data. Oddly enough the circular
reference caused no problem when running the stand alone recursive SQL
(with clause).
no problem. I would advise guarding against circular
On Monday 21 December 2009 2:24:02 am Malm Paul wrote:
Hi list,
I'm using FWTOOLS ogr2gr to import a s57 chart. Im getting a warning when
I'm importing in Linux but not in Windows XP, see below. Could anyone tell
me why and what the difference is in the result (I can't see it because the
Hello,
when defining functions, why can't they take table-valued arguments? I
do not see the sense of this restriction. When a function takes a table
as an argument, whole tables could be transformed in an obvious way.
Currently functions must operate row-wise (at least I haven't found
another
Hello all,
I am trying to debug a plperlu set of stored procedures. in pg 8.3.7.
When I launch a procedure I see messages, in the output window,
beginning with the string CONTEXT: SQL statement SELECT ...
Which procedure or predefined function prints this kind of messages ? Is
this a standard
I dont know if it's a plus or a minus, but:
Well, the fact that Monty secretly tried to persuade the EC toward forcing
Oracle to release MySQL under a license other than the GPL, while lying
denying that in public, really shouldn't be considered a plus for MySQL, I
would think ;-)
Seriously,
Ivan Voras wrote:
John R Pierce wrote:
Andre Lopes wrote:
Hi,
I need to know if there is something like Oracle Forms in the Open
Source world that works with PostgreSQL.
If do you know something, please let me know.
perhaps OpenOffice Data could do what you need. I'm not real familiar
2009/12/21 Nicola Farina nicola.far...@info-line.it
Hello all,
I am trying to debug a plperlu set of stored procedures. in pg 8.3.7.
When I launch a procedure I see messages, in the output window, beginning
with the string CONTEXT: SQL statement SELECT ...
Which procedure or predefined
On Dec 19, 2009, at 2:59 AM, Filip Rembiałkowski wrote:2009/12/18 Gauthier, Dave dave.gauth...@intel.com Can you define your own commands in PG. In psql, yes:\set sel 'SELECT * FROM':sel clients;\set desc '\\d' :desc table E.g., if users from other DBs use “describe foo” to get the metadata for
2009/12/21 Wappler, Robert rwapp...@ophardt.com
Hello,
when defining functions, why can’t they take table-valued arguments? I do
not see the sense of this restriction. When a function takes a table as an
argument, whole tables could be transformed in an obvious way. Currently
functions
On Dec 21, 2009, at 8:44 AM, Scott Ribe wrote:
Well, the fact that Monty secretly tried to persuade the EC toward forcing
Oracle to release MySQL under a license other than the GPL, while lying
denying that in public, really shouldn't be considered a plus for MySQL, I
would think ;-)
Hi Guilliame,
What is the problem you are having using iODBC on SPARC 64bit (I presume
running Solaris), as it has been ported to Solaris SPARC 64bit for over a
decade and bundle with the OpenLink ODBC Drivers for this OS across the
various Solaris releases over the same period.
The Version of
Hello,
On 19/12/2009, at 4:31, John DeSoi wrote:
On Dec 18, 2009, at 4:44 PM, Raimon Fernandez wrote:
It's not clear for me if I have to issue a flush or sync after each process
of an extended query.
It's almost working for me only when I send a sync, but not when I send a
flush.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 18/12/2009, at 22:55, Tom Lane wrote:
Raimon Fernandez co...@montx.com writes:
It's not clear for me if I have to issue a flush or sync after each process
of an extended query.
Basically, you send one of these at the points where you're going to
wait for an answer back. Sync is
Hello,
I am running PostgreSQL 8.4.2. For the testcase I have a database, a
user, and two schemas within the database. Two tables in those two
different schemas have the same name, but only on of those tables
shows up using the \dt command.
How-To-Repeat:
-- psql template1
CREATE ROLE
On Dec 19, 2009, at 2:40 AM, Raimon Fernandez wrote:
I send:
parse
bind
describe
execute
sync
and then loop on the connection stream to receive the responses.
And do you get the parseComplete after sending the parse or after sending the
sync ?
I don't really know or care. I send
On Dec 18, 2009, at 4:44 PM, Raimon Fernandez wrote:
It's not clear for me if I have to issue a flush or sync after each process
of an extended query.
It's almost working for me only when I send a sync, but not when I send a
flush. With the flush, the connection seems freezed, or at
Hi All
I am using postgres-8.1.2 and slony-1.1.5 for replication.
I have 1 master and 1 slave in my cluster.
Sometimes I see problem of missing logtriggers and denyaccess triggers
on master table and slave tables respectively. Replication don't take place in
that
state though systems are
Raimon Fernandez co...@montx.com writes:
It's not clear for me if I have to issue a flush or sync after each process
of an extended query.
Basically, you send one of these at the points where you're going to
wait for an answer back. Sync is different from Flush in that it also
provides a
Hi John,
I'm not seeing my e-mails on the PostgreSQL General List ...
??
On 19/12/2009, at 16:32, John DeSoi wrote:
On Dec 19, 2009, at 2:40 AM, Raimon Fernandez wrote:
I send:
parse
bind
describe
execute
sync
and then loop on the connection stream to receive the
2009/12/21 Israel Brewster isr...@frontierflying.com:
On Dec 19, 2009, at 2:59 AM, Filip Rembiałkowski wrote:
2009/12/18 Gauthier, Dave dave.gauth...@intel.com
Can you define your own commands in PG.
In psql, yes:
\set sel 'SELECT * FROM'
:sel clients;
\set desc '\\d'
:desc table
On Mon, Dec 21, 2009 at 10:55 AM, Erik Jones ejo...@engineyard.com wrote:
On Dec 21, 2009, at 8:44 AM, Scott Ribe wrote:
Well, the fact that Monty secretly tried to persuade the EC toward forcing
Oracle to release MySQL under a license other than the GPL, while lying
denying that in public,
On Fri, Dec 18, 2009 at 6:59 PM, tamanna madaan
tamanna.ma...@globallogic.com wrote:
I am using postgres-8.1.2 and slony-1.1.5 for replication.
I don't know about your Slony problems but the current bug-fix release
for 8.1 is 8.1.19. That's 17 releases to fix security holes, crashes,
data
I was wondering...
In head-to-head comparisons, do DBs get stree tested, not only in terms of
performance, but in terms of corruptions, down time, recovery time, lost data,
etc... .?
I've heard it said that MySQL is superior to MySQL in this regard. But if this
were stated in an article
On Mon, Dec 21, 2009 at 12:23 PM, Gauthier, Dave
dave.gauth...@intel.com wrote:
They have ways to cope with this. Since they all code in perl/DBI, they
could simpy open handles to the 2 DBs. Or there's an op sys level app out
there that they could use to get the same data. But I was
2009/12/19 Ralph Graulich ralph.graul...@t-online.de
-- Only one of the two relations is shown
http://www.postgresql.org/mailpref/pgsql-general
I would call it a bug. Reproduced here, on 8.4.2 and 8.3.8
--
Filip Rembiałkowski
JID,mailto:filip.rembialkow...@gmail.com
- Filip Rembiałkowski plk.zu...@gmail.com wrote:
2009/12/19 Ralph Graulich ralph.graul...@t-online.de
-- Only one of the two relations is shown
I would call it a bug. Reproduced here, on 8.4.2 and 8.3.8
Try \dt *.table1
--
Sent via pgsql-general mailing list
According to the docs,
http://www.postgresql.org/docs/8.4/interactive/app-psql.html says in
part:
Whenever the pattern parameter is omitted completely, the \d commands
display all objects that are visible in the current schema search path
— this is equivalent to using the pattern *. To see all
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2009/12/21 Adrian Klaver akla...@comcast.net:
- Filip Rembiałkowski plk.zu...@gmail.com wrote:
2009/12/19 Ralph Graulich ralph.graul...@t-online.de
-- Only one of the two relations is shown
I would call it a bug. Reproduced here, on 8.4.2 and 8.3.8
Try \dt *.table1
- Scott Marlowe scott.marl...@gmail.com wrote:
2009/12/21 Adrian Klaver akla...@comcast.net:
- Filip Rembiałkowski plk.zu...@gmail.com wrote:
2009/12/19 Ralph Graulich ralph.graul...@t-online.de
-- Only one of the two relations is shown
I would call it
On Mon, Dec 21, 2009 at 3:06 PM, Adrian Klaver akla...@comcast.net wrote:
- Scott Marlowe scott.marl...@gmail.com wrote:
2009/12/21 Adrian Klaver akla...@comcast.net:
- Filip Rembiałkowski plk.zu...@gmail.com wrote:
2009/12/19 Ralph Graulich ralph.graul...@t-online.de
Le 21 déc. 2009 à 15:24, Chris Ernst a écrit :
Ouch! You're right. And that's would be a deal killer for me. About
90% of the traffic is prepared queries that are run over and over with
different parameters.
The driver project and code are now there it seems:
http://frihjul.net/pgsql
Scott Marlowe scott.marl...@gmail.com writes:
So, either the docs for \dt need fixing to reflect reality, or they're
right and psql \dt needs fixing.
The documentation says
Whenever the pattern parameter
is omitted completely, the \d commands display all objects
that are visible in
On Monday 21 December 2009 3:42:10 pm Tom Lane wrote:
Scott Marlowe scott.marl...@gmail.com writes:
So, either the docs for \dt need fixing to reflect reality, or they're
right and psql \dt needs fixing.
The documentation says
Whenever the pattern parameter
is omitted completely,
Adrian Klaver akla...@comcast.net writes:
On Monday 21 December 2009 3:42:10 pm Tom Lane wrote:
Seems clear enough to me.
Well yes and no. The first couple of times I read this I was tripped
up by layout: the pattern *. To see all objects in the database, use
the pattern *.*. I took it to
On 12/21/09 11:23 AM PST, Gauthier, Dave dave.gauth...@intel.com wrote:
I was wondering...
In head-to-head comparisons, do DBs get stree tested, not only in terms of
performance, but in terms of corruptions, down time, recovery time, lost data,
etc... .?
I've heard it said that MySQL is
On Mon, Dec 21, 2009 at 4:42 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
So, either the docs for \dt need fixing to reflect reality, or they're
right and psql \dt needs fixing.
The documentation says
Whenever the pattern parameter
is omitted
Scott Marlowe scott.marl...@gmail.com writes:
Then you should see BOTH tables with the same name in different
schemas, right? Cause the OP was saying that it picks only the first
one to display.
Well, yes, because only the first one is visible. The second one is
masked by the first.
On Mon, Dec 21, 2009 at 6:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
Then you should see BOTH tables with the same name in different
schemas, right? Cause the OP was saying that it picks only the first
one to display.
Well, yes, because only the
Scott Marlowe scott.marl...@gmail.com writes:
On Mon, Dec 21, 2009 at 6:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Well, yes, because only the first one is visible. The second one is
masked by the first.
But the docs say that ALL objects in the schema path will be shown.
So, my point stands,
On Mon, Dec 21, 2009 at 6:14 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Mon, Dec 21, 2009 at 6:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Well, yes, because only the first one is visible. The second one is
masked by the first.
But the docs say
On Monday 21 December 2009 5:17:49 pm Scott Marlowe wrote:
On Mon, Dec 21, 2009 at 6:14 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Scott Marlowe scott.marl...@gmail.com writes:
On Mon, Dec 21, 2009 at 6:10 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Well, yes, because only the first one is visible.
Adrian Klaver akla...@comcast.net writes:
On Monday 21 December 2009 5:17:49 pm Scott Marlowe wrote:
Ahh, right, it's about visibility. Hadn't caught that part.
I think that is where the biggest misunderstanding lies.
On looking at the page some more, it strikes me that part of the problem
On Monday 21 December 2009 6:17:22 pm Tom Lane wrote:
Adrian Klaver akla...@comcast.net writes:
On Monday 21 December 2009 5:17:49 pm Scott Marlowe wrote:
Ahh, right, it's about visibility. Hadn't caught that part.
I think that is where the biggest misunderstanding lies.
On looking at
Le 20/12/2009 19:27, OpenLink Support a écrit :
[...]
What is the problem you are having using iODBC on SPARC 64bit (I presume
running Solaris), as it has been ported to Solaris SPARC 64bit for over a
decade and bundle with the OpenLink ODBC Drivers for this OS across the
various Solaris
Le 10/12/2009 05:56, Tom Lane a écrit :
Guillaume Lelarge guilla...@lelarge.info writes:
I'm searching for a Unix implementation of ODBC working on SPARC 64 bits?
iodbc doesn't seem to work well. DataDirect is really good but not free. And
UnixODBC doesn't seem to compile.
What unixODBC
66 matches
Mail list logo