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 that
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 happening:
- In
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 query
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
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
a crawl.
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
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
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)
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
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
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
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
default in
Hi,whats 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)?LudwigHi,there is a problem with foreign key (PG 8.3RC2). Please, look at
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%3B316649x=12y=14
Unfortunately, it does not connect..although when you test connection, using
test connection switch, VB displays test
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
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
[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
present
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
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
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 now PL/Java,
Hi,
I know about the -E option to psql and did that to get the following,
which is what psql does for a \d tablename:
* 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
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
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 *
-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,
I recall
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
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 turn
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
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
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
snip
The question is:
Is it a normal behaviour? Because I think that if
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
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't, but
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 tablename:
* QUERY **
SELECT c.oid,
n.nspname,
c.relname
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid =
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
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
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
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:
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 that
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
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.
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
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
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
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
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
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
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
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:
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
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
-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
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 4237
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
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 text ,
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
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:
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 !
I
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
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
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,
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 (I'm
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
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
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 there some
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]
Sent
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
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 8818)
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
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
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
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:
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 (I'm
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
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
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 trigger
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 about
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
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
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.
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 -1
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
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 trigger from
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 my
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
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 and working, I
-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 fires in
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 disabled,
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,
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
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
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:
--
From: Kevin Martins [EMAIL PROTECTED]
Sent: Thursday, April 10, 2008 12:03 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pain of postgres upgrade with extensions
Hello everybody,
First off all I am new in postgres but allready
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. The cast problem is
94 matches
Mail list logo
