Hello David,
This is a simplified version of my own attempt:
SELECT *
FROM ("oxford", "webster")
WHERE NOT ( columnName = ANY (SELECT name FROM dictionaries))
The idea is that "oxford" and "webster" come from the Java program
end up in the column c
Dear Bill!
I don't want to raise flame - I only reflect.
As I see we misunderstand ourselves, and I want to correct this
"question", and show my viewpoint.
Preface:
1.) DataBases need to close the resources kept by Sessions.
2.) There is need some "border", or a rule to split - which Session is
Hi;
I was wondering When is a PREPARE statement planned? On first
execution? At the time the PREPARE statement is called?
How does the planner decide what sorts of plans to use when the ideal
plan might change based on future runs?
Is this the same wrt PLPGSQL cached plans? Or are they p
On Sunday 03 July 2011 07:47:01 Chris Travers wrote:
> On Sun, Jul 3, 2011 at 7:25 AM, Ireneusz Pluta wrote:
> > You may use dense_rank() (or even rank()) window function to map your
> > sequence-with-gaps to a no-gap-id which will be used for exports.
>
> The typical case where gapless numbering
On Monday 04 July 2011 10:48:48 Durumdara wrote:
> 1.) DataBases need to close the resources kept by Sessions.
> 2.) There is need some "border", or a rule to split - which Session is
> considered as "finished".
So far so good.
> The FireBird is uses "DummyPacketInterval" to recognize dead sessi
Hi!
2011/7/4 Vincent de Phily :
> On Monday 04 July 2011 10:48:48 Durumdara wrote:
>> 1.) DataBases need to close the resources kept by Sessions.
>> 2.) There is need some "border", or a rule to split - which Session is
>> considered as "finished".
>
> So far so good.
...so what! (Megadeth).
:-)
On Monday 04 July 2011 12:49:24 Durumdara wrote:
> What happens with running statements and stored procs at Session's end?
>
> They will be aborted and destroyed, or they can continue the running?
>
> For example:
> User X starts a long Query/STP.
> But he is lost "in deep space" (like in "Space
Ahoj!
2011/7/4 Vincent de Phily :
> On Monday 04 July 2011 12:49:24 Durumdara wrote:
>> What happens with running statements and stored procs at Session's end?
>>
>> They will be aborted and destroyed, or they can continue the running?
>>
>> For example:
>> User X starts a long Query/STP.
>> But h
On Monday 04 July 2011 13:50:46 Durumdara wrote:
> > The running query will be rolled back when the session ends. Note that
> > "when the session ends" must be understood from the server's point of
> > view, not the client's.
>
> As I understand you then running Queries forced to abort on the end
On 4/07/2011 7:50 PM, Durumdara wrote:
As I understand you then running Queries forced to abort on the end of
Session and no more Query running over the session's ending point (or
after TCP connection broken).
Correct. The server might not notice that the client broke it's
connection for a wh
In article <4e116e11.1030...@gmail.com>,
Daron Ryan writes:
> Hello David,
> This is a simplified version of my own attempt:
> SELECT *
> FROM ("oxford", "webster")
> WHERE NOT ( columnName = ANY (SELECT name FROM dictionaries))
> The idea is that "oxford" and "webster" come from the Java progr
I am getting the following error when I run the install from stackbuilder.
Error trying to install file destination ${installdir} resolves to empty
value.
Does anyone know what might be causing this and how I can fix it.
This is the developer's mailing list. You should ask this question o
I'm having a issue installing or should I say uninstalling these 3 drivers.
I have both 8.4.2 and 9.1 b2 installed. When I brought up the stack
building to install these three drivers they say they are already
installed. Well the drivers don't show up in the unistall a program window
and the ODB
Greetings
I'm trying to set up Cybertec's ODBC_LINK program
(http://www.cybertec.at/download/odbc_link/2010_03_16_odbc_link.pdf )
so I can read MS-SQL data into my Postgresql 8.4.8 database. I'm using
Ubuntu 10.04 LTS Server.
Their build instructions say to Compile the module using make USE_PGXS=1
Greetings
I'd like to INSERT data into my Postgresql 8.4.8 table directly from an
ODBC-linked MS-SQL table or view.
I'm looking at using the Cybertec tool "ODBC-LINK"
(http://www.cybertec.at/en/postgresql_products/odbc-link) but I'm wondering
if there isn't a way to do this through Postgresql di
This is basically exactly the same as
http://archives.postgresql.org/pgsql-sql/2008-10/msg9.php; I'm
just asking again, to see if thinking on the problem has changed:
The basic problem, restated, is one has a relation with tuples like this:
(key, recency_stamp, other_columns*)
Some example d
Hi Jonathan,
I haven't done this from MySQL, but have from Postgres & from Oracle
>From a command line client, extract the data from the source table, so you get
>a stream of csv style records.
Then pipe these directly into a psql statement to load them into the target
table.
A simple pg2pg ex
On Jul 4, 2011, at 19:48, Daniel Farina wrote:
> This is basically exactly the same as
> http://archives.postgresql.org/pgsql-sql/2008-10/msg9.php; I'm
> just asking again, to see if thinking on the problem has changed:
>
> The basic problem, restated, is one has a relation with tuples lik
May I know what is the difference among cidr and inet? I read through Network
Address Type (http://www.postgresql.org/docs/8.3/static/datatype-net-types.html)
"""The essential difference between inet and cidr data types is that inet
accepts values with nonzero bits to the right of the netmask, wh
On 5 Jul 2011, at 3:23, David Johnston wrote:
>> Does anyone have fresh thoughts or suggestions for dealing with
>> INSERT-mostly tables conceived in this manner?
You're struggling with read-performance in an INSERT-mostly table? Where are
your performance priorities, on INSERT or on SELECT?
>
20 matches
Mail list logo
