Hello everybody.
I've got some kind of PostgreSQL copyright related question.
Our company is developing an commercial product for PostgreSQL administration.
We want to include some utilities (i.e. pg_dump.exe, pg_restore.exe etc)
from PostgreSQL for Windows installation package to installation pa
On Wed, Apr 9, 2008 at 1:31 PM, Francisco Figueiredo Jr.
<[EMAIL PROTECTED]> wrote:
> > >
> > >
> >
> > Ask the .npgsql mailing lists. They'll be able to tell you. There must be
> a
> > way of handling "non-standard" types in any case.
> >
>
> Hi all!
>
> We are already working on that. Th
--
From: "Kevin Martins" <[EMAIL PROTECTED]>
Sent: Thursday, April 10, 2008 12:03 AM
To:
Subject: Re: [GENERAL] pain of postgres upgrade with extensions
Hello everybody,
First off all I am new in postgres but allready got some questions. It's
Hello everybody,
First off all I am new in postgres but allready got some questions. It's
possible to wirte in a file from postgres?
Kevin Martins
--
From: "Dave Potts" <[EMAIL PROTECTED]>
Sent: Wednesday, March 12, 2008 8:46 PM
To:
Subject: Re:
"Greg Sabino Mullane" <[EMAIL PROTECTED]> writes:
> You should be using ALTER TABLE and not worry about changing tgenabled
> yourself, in case it wasn't obvious.
Yeah. I had imagined Terry was hacking some backend code to do this,
in which case invoking CacheInvalidateRelcache directly might be
r
Terry Lee Tucker wrote:
Greetings:
We have been working diligently toward integrating Slony into our production
databases. We've been having trouble with various tables, although being
replicated perfectly in the initial replication stage, afterwards, getting
out of sync.
I have finally fig
On Wed, Apr 9, 2008 at 7:20 AM, leoabhi <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
Hello Abhi!
> I wish to connect Visual Studio 2008(VB) to PostgreSQL..
>
Have you tried Npgsql?
http://www.npgsql.org
http://project.npgsql.org
http://documentation.npgsql.org
I hope it helps.
--
Regards,
Fr
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
I see the following in the documentation for pg_trigger related
to tgenabled: "Controls in which session_replication_role modes the
trigger fires. O = trigger fires in "origin" and "local" modes,
D = trigger is disab
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I see the following in the documentation for pg_trigger related
> to tgenabled: "Controls in which session_replication_role modes the
> trigger fires. O = trigger fires in "origin" and "local" modes,
> D = trigger is disabled, R = trigger fire
On Wed, 9 Apr 2008 19:11:57 +0200
Alban Hertroys <[EMAIL PROTECTED]> wrote:
> On Apr 9, 2008, at 5:27 PM, Jozef Ševčík wrote:
> > In MSSQL I had something like:
> > SELECT Column1,Column2 from MyTable
> >
> > In PgSQL I write:
> > SELECT “Column1”, “Column2” from “MyTable”
> >
> > Which is fine an
Abhishek MANDHANA wrote:
Did 30 seconds search worked ? for me its didnt ?
Please just dont test the connection, the applet shows Connection successful
, Are you able to create it and see it under Server Explorer?
I mostly use Linux. I'm on Vista right now, but I have never used Visual
Ba
On Wednesday 09 April 2008 13:12, Tom Lane wrote:
> Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> > My question is: When tgenabled is set to "D", how does that setting
> > interact with session_replication_role and, is there a way to use
> > tgenabled with a setting of "D" to prevent a particular
Did 30 seconds search worked ? for me its didnt ?
Please just dont test the connection, the applet shows Connection successful
, Are you able to create it and see it under Server Explorer?
Abhi
On Wed, Apr 9, 2008 at 7:39 PM, Craig Ringer <[EMAIL PROTECTED]>
wrote:
> leoabhi wrote:
>
> now m
leoabhi wrote:
now my first 2 posts speak about this setup and problem/error i had while
setting up connection..it gives OLE-DB error which we already spoke
about..STILL UNRESOLVED.
All goes around setup required to connect to postgreSQL using VB ,Server
Explorer.
I need the settings to be done
Maxim Boguk <[EMAIL PROTECTED]> writes:
> ktrace/kdump this process show just one sequence:
> 69360 postgres CALL poll(0x7fffd4e0,0x1,0x7d0)
> 69360 postgres RET poll -1 errno 4 Interrupted system call
> 69360 postgres CALL poll(0x7fffd4e0,0x1,0x7d0)
> 69360 postgres RET poll
Jozef Ševčík wrote:
So it all depends on how table is exactly created, thank you.
A last question - is there any way how to 'switch' this for
table without re-creating table again ?
ALTER TABLE "MixedCase" RENAME TO "lowercase";
The double quotes are optional on all lower case identifiers.
Hello,
In brief.
TASK : Write a code in VB so that i can connect to postgreSQL and then
execute some stataments from my VB application.
I didnt want to code it ..I found the other way round very similar but
without coding.
Visual basic has a server explorer .. which can be used to connect to
v
Hi Alban,
If I do:
select * from SourceCategory
pgAdmin gives me an error: ERROR: relation "sourcecategory" does not exist
If I do:
select * from "SourceCategory"
It works OK.
As Richard mentioned, it's because table was probably created with CREATE TABLE
"SourceCategory".
I was not sure abo
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> My question is: When tgenabled is set to "D", how does that setting interact
> with session_replication_role and, is there a way to use tgenabled with a
> setting of "D" to prevent a particular trigger from firing. Using ALTER TABLE
> to disable the
On Apr 9, 2008, at 5:27 PM, Jozef Ševčík wrote:
In MSSQL I had something like:
SELECT Column1,Column2 from MyTable
In PgSQL I write:
SELECT “Column1”, “Column2” from “MyTable”
Which is fine and working, I have no doubt about it. I’m just
guessing if this does not affect performance
in any wa
Richard,
thanks for the great explanation. I'm sorry because I missed your notes to
performance
in previous e-mail between the lines.
Cast (in)sensitivity is much more clear for me now.
When I moved project from MSSQL to Postgres I did not create tables manually,
I used some mssql-to-postgres mi
Jozef Ševčík wrote:
Richard,
thanks for the answer.
In fact, I double-quoted identifiers only because PgSQL forced me to do so
when using capitalized letters in table/column name.
Well, if you don't quote them they get folded to lower-case and you get
case-insensitive matching.
CREATE TABLE
On Wednesday 09 April 2008 11:00, Greg Sabino Mullane wrote:
> > I have a situation where an external process needs to disable the firing
> > of triggers on a table.
>
> ...
>
> > session_replication_role is set to "origin". I thought this was supposed
> > to be fixed in later versions of Postgres
> >
> >
>
> Ask the .npgsql mailing lists. They'll be able to tell you. There must be a
> way of handling "non-standard" types in any case.
>
Hi all!
We are already working on that. The cast problem is indeed a bug in
Npgsql. We already have a one line fix for it.
Check it out here:
http://pgf
If I get the install to the point where it prompts me "Service
'PostgreSQL Database Server 8.3'(pgsql-8.3) failed to start.
Verify that you have sufficient priveleges to start system services",
I can connect to the database with pgAdmin III without any apparent
issues. Soif you close the instal
Richard,
thanks for the answer.
In fact, I double-quoted identifiers only because PgSQL forced me to do so
when using capitalized letters in table/column name.
I'm OK with this if it's PgSQL requirement (app runs on NHibernate so I just
change
column="MyColumn" to column="`MyColumn`" in mapping f
Jozef Ševčík wrote:
Hi all,
I just switched from MS SQL to PostgreSQL on project and have
question about double-quoting names of fields/tables regarding to
performance.
If the cost of quoting column-names is a significant part of your query
costs, you must have some very fast queries. I would
Hi!
Tom Lane wrote:
>
> Well, you could probably get away with an "update pg_attribute set
> atttypid ..." but it might be safer to just wait for 8.3.2.
I like it safe :) Thanks for the advice!
Kind regards
Markus
Computec Media AG
Sitz der Gesellschaft und Registergericht: Fürth (HRB 8
Stefan Schwarzer wrote:
Hi,
I am using Navicat to transfer data from one database to another. But it
soon gives me an error message like the following:
I think you'll probably have to ask the navicat people.
If you want to use pg_dump to transfer data from 8.1 to 8.2 though, use
the version
No, at least not that I know
you can start the secondary logon service from command line with:
net start seclogon
- Syra Didelez -
Apogee Portal Deployment Manager
Apogee Portal Hotfix Manager
Agfa-Gevaert N.V.
Tel.: +32 3 444 4237
http://www.agfa.com
"Martin Gainty" <[EMAIL PROTECTED]>
Sen
"Markus Wollny" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> It should work if you explicitly change the column's type to
>> pg_catalog.tsvector. (There's a fix in place for 8.3.2, also.)
> Which would probably be not such a good idea to try on a 7GB table in
> production, I think. Or is th
Thanks Syra
I do not see netsvcs or svchost command...are these commands specific to Vista?
Bedankt
Martin-
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org ; [EMAIL PROTECTED]
Sent: Wednesday, April 09, 2008 11:17 AM
Subj
Hi all,
I just switched from MS SQL to PostgreSQL on project and have question about
double-quoting names of fields/tables
regarding to performance.
In MSSQL I had something like:
SELECT Column1,Column2 from MyTable
In PgSQL I write:
SELECT "Column1", "Column2" from "MyTable"
Which is fine and
Syra,
No, I'm not running a silent install.
Regards,
Peter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Syra,
Yes, the svchost.exe process is running. Back to the drawing board
Regards,
Peter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is it also running, being enabled only is not enough,
if that's not it, I'm afraid I can't help you
- Syra Didelez -
Apogee Portal Deployment Manager
Apogee Portal Hotfix Manager
Agfa-Gevaert N.V.
Tel.: +32 3 444 4237
http://www.agfa.com
You can find it out by goign to Computer Management -> Services and
Applications -> Services
there's a list with all the services running on your system.
If you must check that out programmatically, see if there is any
svchost.exe process running,
start with the -k netsvcs option.
Good Luck !
Syra,
I can confirm that secondary logon appears as enabled under
"Services". I guess that narrows down the problem...
Regards,
Peter
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wednesday 09 April 2008 11:00, Greg Sabino Mullane wrote:
> > I have a situation where an external process needs to disable the firing
> > of triggers on a table.
>
> ...
>
> > session_replication_role is set to "origin". I thought this was supposed
> > to be fixed in later versions of Postgres
Syra,
It is my machine, and I have exclusive access to it. I cannot think of
why it would be disabled. I'm trying to figure out how to verify that
it is running. I found a Korean blog post that discusses the problem,
but the google translate isn't great:
http://www.google.com/translate?u=http%3A%
details:
db version: postgres (PostgreSQL) 8.3.0
OS version: FreeBSD 7.0-RELEASE
stats collector eating whole single CPU last week or so...
TOP lookin like:
PID USERNAME THR PRI NICE SIZERES STATE C TIME WCPU COMMAND
69360 pgsql 1 1240 22380K 5548K CPU0 1 258.6H 99.0
Hi,
I am using Navicat to transfer data from one database to another. But
it soon gives me an error message like the following:
[Err] [Dtf] Transfer Data [create table "admin"."news" ( "id" int4
not null default nextval('news_id_seq1'::regclass) , "date" date ,
"text_en" text , "text_fr
No, it is not, there are always the 'smart' sys admins who block
everything everywhere ...
- Syra Didelez -
Apogee Portal Deployment Manager
Apogee Portal Hotfix Manager
Agfa-Gevaert N.V.
Tel.: +32 3 444 4237
http://www.agfa.com
Syra,
Is it not on by default?
Regards,
Peter
On Wed, Apr 9, 2008 at 3:55 PM, <[EMAIL PROTECTED]> wrote:
>
> Is the secondary logon service running on your system ?
>
> - Syra Didelez -
> Apogee Portal Deployment Manager
> Apogee Portal Hotfix Manager
> Agfa-Gevaert N.V.
>
> Tel.: +32 3 444
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> I have a situation where an external process needs to disable the firing of
> triggers on a table.
...
> session_replication_role is set to "origin". I thought this was supposed to
> be fixed in later versions of Postgres (I'm converting from
Hardwick, Joe wrote:
> We have a cronjob that runs nightly to do the VACUUM FULL ANALYZE on a
> few tables in each schema and occasionally we'll cancel one if they take
> longer than usual to run and block our morning loads.. This is the first
> time Postgres has had any trouble with it. Is canc
Is the secondary logon service running on your system ?
- Syra Didelez -
Apogee Portal Deployment Manager
Apogee Portal Hotfix Manager
Agfa-Gevaert N.V.
Tel.: +32 3 444 4237
http://www.agfa.com
"Peter Geoghegan" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/09/2008 04:34 PM
To
pgsql-gene
Thanks for the help guys,
I should clear up a little what I am trying to achieve I think.
The primary users of this db and application will be located in an
office, each user with a desktop machine, all networked. They need to
work with this DB in a fairly heavy kind of way, in so far as to say
t
Turns out someone had placed a second line further down in the file I
didn't realize was there... So it set it, then reset it.
Thanks,
Joe
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 08, 2008 8:53 AM
To: Hardwick, Joe
Cc: pgsql-general@postgresql.org
I realize this is very little info to go on but our server had some
trouble this morning..
Postgres 8.2.4
Linux unicron.marketingsolutionsinc.com 2.6.15-1.2054_FC5smp #1 SMP Tue
Mar 14 16:05:46 EST 2006 i686 i686 i386 GNU/Linux
PID: 15980 - 2008-04-09 07:49:20 CDT - USER: postgres - DB: maver
Tom Lane wrote:
> It should work if you explicitly change the column's type to
> pg_catalog.tsvector. (There's a fix in place for 8.3.2, also.)
Which would probably be not such a good idea to try on a 7GB table in
production, I think. Or is there some way hacking the system catalog to correct
Hello,
I have a problem with the windows Postgres 8.3.1 MSI binary
distribution. When I attempt to install postgres 8.3.1
with postgres automatically creating its own user account, the
installer complains:
"Service 'PostgreSQL Database Server 8.3'(pgsql-8.3) failed to start.
Verify that you have
leoabhi wrote:
Hi Richard,
is it possible to check them individually how ?
No idea - you're one using .net - how would you normally check?
> well..!! I think it has
something to do with settings. couldnt even add a connection because once i
click ok, it show the OLE-DB error, so no quest
Greetings:
I have a situation where an external process needs to disable the firing of
triggers on a table. I have two backend functions which handle this task:
disable_triggers ('table_name')
enable_triggers ('table_name')
These functions are called inside a transaction. The first, stores vario
Andrus wrote:
ALTER TABLE...ALTER COLUMN...TYPE will do it within one statement. It will
require a lock on the table though.
1. This is part of composite primary key. It is discriminator column and
cannot contain empty string, only single char is allowed.
char(1) doesn't enforce that. It enf
How is your foreign key defined?
From a quick look it seems the column is named "_stamp" not
"_tmp_stamp" in the tmp_stamp table.
[EMAIL PROTECTED] wrote:
Hi,
there is a problem with foreign key (PG 8.3RC2). Please, look at below. I don't
understand this behavior. Why this INSERT is ending
"Markus Wollny" <[EMAIL PROTECTED]> writes:
> Everything works fine. It's sort of less elegant though than having just the
> one generic trigger function and configuring the needed fields in the trigger
> itself.
It should work if you explicitly change the column's type to
pg_catalog.tsvector.
Manuel Sugawara wrote:
> Ok, will do that. Thanks a lot Alvaro. Want me to send more details to
> debug the problem?.
Yes, it would be good to know why the shared catalogs were not being
vacuumed, if you can find that out. I would have guessed that they
weren't being vacuumed due to the fact tha
Paolo,
Oh yes, I see it now. It was necessary to re-initialise the database
in order for that to appear, which I have not done until now.
Now I have a new problem. When I attempt to install postgres 8.3.1
with postgres automatically creating its own user account, the
installer complains:
"Servic
Ivano Luberti wrote:
On client1 we execute
begin;
insert into table1
and a message of correct execution for both statements is returned
On client2 we execute
begin;
insert into table2
and the client receives a correct execution message for the begin stmt
but waits for the insert statement u
On 09/04/2008 11:50, Peter Geoghegan wrote:
I recall that in earlier versions of the PostgreSQL windows binary
distribution, I had finer grained control of what modules were
installed. The only optional module is now PL/Java, which I don't use,
and things like headers and libraries. I cannot spe
Hello everybody, I have searched for a long time about this issue but I
was not able to find what is the cause. Maybe because I have not been
able to identify the right keywords.
We are experiencing the following problem using postgres8.3 and postgres8.1
On client1 we execute
begin;
insert int
> ALTER TABLE...ALTER COLUMN...TYPE will do it within one statement. It will
> require a lock on the table though.
1. This is part of composite primary key. It is discriminator column and
cannot contain empty string, only single char is allowed.
2. I'm afraid that this will broke existing applic
Andrew Falanga wrote:
>
> I know about the -E option to psql and did that to get the following,
> which is what psql does for a \d :
>
> * QUERY **
> SELECT c.oid,
> n.nspname,
> c.relname
> FROM pg_catalog.pg_class c
> LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.rel
Hi!
Tom Lane wrote:
> I wrote:
>> Would you confirm that
>> select atttypid from pg_attribute where attrelid =
>> 'public.ct_com_board_message'::regclass and attname = 'idxfti';
>> gives 3614 (the preassigned OID for pg_catalog.tsvector)?
>
> Actually, I'll bet a nickel that you'll find it doesn
Andrus wrote:
> Any idea why the following select statement does not return rows ?
> This select statement is generated by npgsql2 beta 3 so I
> cannot change it in my application.
> How to fix without changing select statement ?
>
> Andrus.
>
> create temp table test ( tc char(1) );
> insert int
josep porres wrote:
> select clau, lecact-lecant as m3, m3any, ta, tc, 3 as mesos, persones, true
> as clavegueram
> from fac_abonats
> where clau in (select clau from tmp_claus_prova)
> order by clau
>
> the thing is that the result of the query returns the same
> number of rows as the table fa
On Wed, Apr 9, 2008 at 12:22 PM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Peter Geoghegan wrote:
>
> > Richard,
> >
> > I recall that in earlier versions of the PostgreSQL windows binary
> > distribution, I had finer grained control of what modules were
> > installed. The only optional module is
Hi Richard,
is it possible to check them individually how ? well..!! I think it has
something to do with settings. couldnt even add a connection because once i
click ok, it show the OLE-DB error, so no question about executing
statements..
In tried with mdb database it works.
Found some more
Peter Geoghegan wrote:
Richard,
I recall that in earlier versions of the PostgreSQL windows binary
distribution, I had finer grained control of what modules were
installed. The only optional module is now PL/Java, which I don't use,
and things like headers and libraries. I cannot specify install
>-Messaggio originale-
>Da: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Per conto di Peter Geoghegan
>Inviato: mercoledì 9 aprile 2008 12.50
>A: Richard Huxton
>Cc: pgsql-general@postgresql.org
>Oggetto: Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib
module
>
>Richard,
>
<[EMAIL PROTECTED]> writes:
> Could it be that something like this is happening:
> - In the early morning a new DB connection is opened.
> - While running VACUUM ANALYZE the planner uses different plans because some
> index could not be used or the statistics are right in that moment not
> prese
Richard,
I recall that in earlier versions of the PostgreSQL windows binary
distribution, I had finer grained control of what modules were
installed. The only optional module is now PL/Java, which I don't use,
and things like headers and libraries. I cannot specify installing
Pl/PgSQL, Pl/Perl etc
Peter Geoghegan wrote:
Hello,
I'm developing a large postgreSQL database front end application on
win32. I'd consider the ability to debug Pl/PgSQL functions highly
desirable. Until now, I've been using RAISE NOTICE debugging, which is
equivalent to printf debugging, and is sub optimal.
"Sub o
leoabhi wrote:
The error in English means
"Multiple-step OLE DB operation generated errors.
Check each OLE DB status value, if available. No work was done."
Well, did you "check each OLE DB status value"? Which failed and what
was it doing? Are there any errors logged at the server? Did you t
Hello,
I wish to connect Visual Studio 2008(VB) to PostgreSQL..
I used the following help file to do it ..
http://support.microsoft.com/?scid=kb%3Ben-us%3B316649&x=12&y=14
Unfortunately, it does not connect..although when you test connection, using
test connection switch, VB displays test con
Hello,
I'm developing a large postgreSQL database front end application on
win32. I'd consider the ability to debug Pl/PgSQL functions highly
desirable. Until now, I've been using RAISE NOTICE debugging, which is
equivalent to printf debugging, and is sub optimal.
I am aware of the possibility of
Andrus Moor wrote:
Richard,
It doesn't return rows because you're using a space-padded type (char)
to try and store a space.
I think you probably want varchar(1) instead.
thank you.
I have production database whose schema cannot changed easily.
ALTER TABLE...ALTER COLUMN...TYPE will do it
Hi,
The setup in question includes PostGRESQL v8.2.4, Java based web servers and
MS.NET based web servers. Following is the fuzzy situation:
1. Our SQL queries run very fast using PSQL (both, from the server as
well as the client).
2. The Java app also retrieves the results very fast
Hi, what's the result of SELECT * from tmp_stamp where _stamp = '2f980de9f2297c7902f3415f6537c6be';?Perhaps different fieldtypes (f. e. VARCHAR in table www_es_orderhead_cs versus CHAR(n) in Table _stamp filled up with blanks)? Ludwig Hi,there is a problem with foreign key (PG 8.3RC2). Please, lo
At 11:12p -0400 on Tue, 08 Apr 2008), Otakarek wrote:
> there is a problem with foreign key (PG 8.3RC2). Please, look at
^^
Before you go any further, I'd highly suggest updating. 8.3 was
released over 2 months ago, and has already progressed to 8.3.1
Andrus wrote:
Any idea why the following select statement does not return rows ?
This select statement is generated by npgsql2 beta 3 so I cannot change it
in my application.
How to fix without changing select statement ?
Andrus.
create temp table test ( tc char(1) );
insert into test values(
On Wed, Apr 09, 2008 at 10:20:18AM +0200, josep porres wrote:
> At the end I've realized that there is no column named 'clau'. It has
> another name.
> So the subselect query is wrong, if I execute it alone, an error appears
> The question is:
> Is it a normal behaviour? Because I think that if
On Apr 8, 11:08 am, [EMAIL PROTECTED] (Alvaro Herrera) wrote:
> Kev escribió:
>
> > > Recompile PG? Even if I'm running 8.3.1, released well after that?
>
> > Oh, sorry, do you mean, it's ready for 5.10 but still compiled with
> > 5.8 for now? If so, is there a timeline for compiling with 5.10 by
Hi,
there is a problem with foreign key (PG 8.3RC2). Please, look at below. I don't
understand this behavior. Why this INSERT is ending with this error message. In
my opinion, the key is obviously present. Thank you.
--
Otakarek
# INSERT INTO www_es_orderhead_cs(_status,_tmp_ip,_tmp_stamp)
VAL
"PostgreSQL 8.2.4 on i386-pc-solaris2.10, compiled by GCC gcc (GCC) 3.4.3
(csl-sol210-3_4-branch+sol_rpath)"
As the proud author of this previous post:
http://archives.postgresql.org/pgsql-general/2007-08/msg01911.php
I never found a real answer except to disable SSL on the connections between my
On Apr 8, 11:48 am, [EMAIL PROTECTED] (Richard Huxton) wrote:
> Kev wrote:
> >> Recompile PG? Even if I'm running 8.3.1, released well after that?
>
> > Oh, sorry, do you mean, it's ready for 5.10 but still compiled with
> > 5.8 for now? If so, is there a timeline for compiling with 5.10 by
> > d
Hi,
I know about the -E option to psql and did that to get the following,
which is what psql does for a \d :
* QUERY **
SELECT c.oid,
n.nspname,
c.relname
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE pg_catalog.pg_table_is
Any idea why the following select statement does not return rows ?
This select statement is generated by npgsql2 beta 3 so I cannot change it
in my application.
How to fix without changing select statement ?
Andrus.
create temp table test ( tc char(1) );
insert into test values(' ');
select * fr
josep porres wrote:
select clau, lecact-lecant as m3, m3any, ta, tc, 3 as mesos, persones, true
as clavegueram
from fac_abonats
where clau in (select clau from tmp_claus_prova)
order by clau
At the end I've realized that there is no column named 'clau'. It has
another name.
The question is:
Am Mittwoch, 9. April 2008 10:11 schrieb David Wilson:
> On Wed, Apr 9, 2008 at 3:29 AM, <[EMAIL PROTECTED]> wrote:
> > But if i do "VACUUM ANALYZE" without concurrent queries, everything runs
> > fine afterwards.
> >
> > If i run "VACUUM ANALYZE" with few concurrent queries, it slows down to
>
Hi
I just want to let you know one thing.
By the way, I'm running Postgres 8.3.1 on windows
I was making a query using pgadmin:
select clau, lecact-lecant as m3, m3any, ta, tc, 3 as mesos, persones, true
as clavegueram
from fac_abonats
where clau in (select clau from tmp_claus_prova)
order by c
On Wed, Apr 9, 2008 at 1:41 PM, David Wilson <[EMAIL PROTECTED]> wrote:
>
>
> I've run into a very similar problem. I have some long-running
> processes that generate a large amount of data and then query that
> data that must periodically drop their connections and rebuild to
> ensure that qu
On Wed, Apr 9, 2008 at 3:29 AM, <[EMAIL PROTECTED]> wrote:
> But if i do "VACUUM ANALYZE" without concurrent queries, everything runs fine
> afterwards.
>
> If i run "VACUUM ANALYZE" with few concurrent queries, it slows down to a
> crawl.
>
> Could it be that something like this is happeni
Am Dienstag, 8. April 2008 18:38 schrieb Scott Marlowe:
> It sounds to me like two possible problems, maybe combined.
>
> One possibility is that you have a data distribution that results in
> statistics being gathered that don't really represent your data. Try
> increasing the stats target for th
95 matches
Mail list logo
