"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> I am checking the indexStruct->indisprimary field, but it always resolves to
> false. indisunique works fine. It is a trivial change to the ADD UNIQUE
> code, but it doesn't work. Viewing the system catalogs and '\d' both show
> the indice
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Would it be an idea to add timestamps to the PostgreSQL error/debug/notice
> log?
Already done, see log_timestamp entry in postgresql.conf.
regards, tom lane
---(end of broadcast)
-Original Message-
From: Jonathan Stanford
> Guys,
> I have some odd behaviour with VB6 & postgresql that may be a bug - I
would appreciate someone else > > replicating this; or any other suggestions
anyone might have.
[snip]
> PostgreSQL code:
> CREATE TABLE tb_search (
> session_id
I spent an hour or two trying to get my ADD PRIMARY KEY patch to work but
I'm beginning to think my code is suffering from bit rot. Basically, during
the iteration over the indices on the table, looking for other primary
indices, none are found.
I am checking the indexStruct->indisprimary field,
I am still unable to update my cvs tree! What server, username, password,
cvsroot and module do I need to use?
Thanks,
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Marc G. Fournier
> Sent: Monday, 17 September 2001 8:03 PM
> To: Thomas L
Would it be an idea to add timestamps to the PostgreSQL error/debug/notice
log?
Sometimes I would really like to know when an event has occurred!
Chris
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Lamar Owen writes:
> And, while your list is a usable list of things, the lack of addressing any
> of these items in no way prevents a package of 7.2 from being 'useful' for
> various degrees of usefulness.
...useful in the sense that the work I'm doing becomes useful.
> > * Is libpgtcl.a suppo
On Monday 17 September 2001 05:40 pm, Trond Eivind Glomsrød wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > You don't break binary compatibility by providing a shared library
> > alongside a static one.
> This mean backward as well... eg. perl packages for RHL 7.1 should run
> on RHL 7
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød writes:
>
> > > There are provisions in the source for figuring this out automatically.
> > > Currently, the only "figuring" it does is to allow it on Linux. (It is my
> > > understanding that it works on Linux independent of
On Monday 17 September 2001 05:44 pm, Peter Eisentraut wrote:
> ...useful in the sense that the work I'm doing becomes useful.
Ok. My mind is a little muddy right now, and different interpretations of
wordings aren't coming easily.
> The other thing is that no matter how you arrange it, libp
Quick question... Am I the only person getting
rather annoyed by these messages that have
started coming through recently? Once was
okay, but this is getting rediculous.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http
On Monday 17 September 2001 02:21 pm, Peter Eisentraut wrote:
> Trond Eivind Glomsrød writes:
>>
> Given that pgtksh is rather small in size I don't know if that's worth the
> contortions. However, note that pgaccess is still built if you turn on Tk
> but turn off %pgaccess. (There was also a p
Alex Pilosov <[EMAIL PROTECTED]> writes:
> Attached patch does the above.
Alex, could we have this resubmitted in "diff -c" format? Plain diff
format is way too risky to apply.
regards, tom lane
---(end of broadcast)---
TI
> I want to mention that the number of patches submitted has dropped off
> dramatically. Seems people are prepared for beta and we should start
> beta as soon as we can. I think the current plan is Friday.
I'm doing a substantial amount of work on the date/time types. Not
certain it will be rea
Trond Eivind Glomsrød writes:
> > * The {pgaccess} parameter doesn't do anything AFAICT. PgAccess is
> > installed whenever Tk support is configured (which is correct, IMO).
> > Maybe this is just a legacy item?
>
> For 7.1.3, it does make a difference
>
> %if %pgaccess
[...]
> %endif
>
> (i
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> 2. Using strcasecmp() on strings that were parsed as keywords. See CREATE
> OPERATOR, CREATE AGGREGATE, CREATE TYPE, commands/define.c.
But the real point is that they were parsed as identifiers, *not*
keywords, and therefore have already been throu
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Trond Eivind Glomsrød writes:
>
> > > * The {pgaccess} parameter doesn't do anything AFAICT. PgAccess is
> > > installed whenever Tk support is configured (which is correct, IMO).
> > > Maybe this is just a legacy item?
> >
> > For 7.1.3, it does m
Tom Lane writes:
> I think our problems are worse than that: once the identifier has been
> through a locale-dependent case conversion we really have a problem
> matching it to an ASCII string. The only real solution may be to
> require *all* keywords to be matched in the lexer, and forbid strcm
On Sunday 16 September 2001 11:22 pm, Peter Eisentraut wrote:
> I just took a dreadful look at the RPMs. I've managed to build something
> that resembles a 7.2 package, but there are a number of things that we
> should talk about so this ends up being useful.
First, thanks for taking a look. Ho
Thus spake Turbo Fredriksson
> Justin> http://pgreplicator.sourceforge.net
>
> Unfortunatly this seems to be asynchronous replication (you manually
> have to initiate the syncronization)...
And it also uses the GNU license.
--
D'Arcy J.M. Cain| Democracy is three wolves
http://www.dr
I want to mention that the number of patches submitted has dropped off
dramatically. Seems people are prepared for beta and we should start
beta as soon as we can. I think the current plan is Friday.
Also, I will be on vacation this week. Tom will apply any patches that
look good.
--
Bruce
>
>
> Unfortunatly this seems to be asynchronous replication (you manually
> have to initiate the syncronization)...
>
> I'd like to have synchronous replication...
There is a synchronous replication project here...
http://www.greatbridge.org/project/pgreplication/projdisplay.php
We currentl
This is probably the worst post I have seen in a newsgroup ever.
Using this tragedy so promote a product is disgusting.
You are not doing the product you are promoting a favor with this.
I will not comment on the technical content of this post.
Serge
---(end of broadca
Hi All,
(sorry for the .questions/.hackers crosspost)
I'm a relatively new Linux / PostgreSQL user, and I've been scouring for a
few weeks now to find an answer to my problem -- bugging newsgroups with
my newbie questions is my last resort.
I have a Postgres DB that I wish to have automagical
Have a look into the system tables
pg_proc
pg_trigger
Have a look into the documentation,
refer to System Catalogs
Within psql you get
System Catalogs listed by \dS
specific information about a table
by i. e. \d pg_proc
Regards, Christoph
---(end of broadcast)-
Not to mention that PostgreSQL is WAY ahead on technology.
peace_flower wrote:
> I can bet that open-source code SQL server like PostgreSQL is bomb-proof
> and even in case of nuclear war world-wide,
> the source code of PostgreSQL will be very safe at some point on the
> planet and can easily b
I suppose that a user group would be more appropriate for this question,
but I think there is some potential for further development here.
I want to port a program that makes extensive use of
BindColumn/DefineColumn semantics of ODBC, as well as bulk copy
operations. My problem is that the curre
This is a immediate order to COMPLETELY STOP and CEASE all development
of MySQL database server.
This is due to rapid changes in the Global Economic conditions..
You do not have time to deal with one powerful SQL server like
PostgreSQL, where do you have time to
deal with two types of SQL servers
Hi Friends,I'm just a beginner, partaking in a project.Is
there any way to list or edit the user-definedprocedures, functions and
triggers?I have already loaded them into the postgres databaseand
trying to edit and list
it.thanks,francis
I can bet that open-source code SQL server like PostgreSQL is bomb-proof
and even in case of nuclear war world-wide,
the source code of PostgreSQL will be very safe at some point on the
planet and can easily be distributed and multiplied rapidly.
The reason being internet is nuclear-bomb proof s
> "Justin" == Justin Clift <[EMAIL PROTECTED]> writes:
Justin> Hi, There's also "PostgreSQL Replicator", which is at :
Justin> http://pgreplicator.sourceforge.net
Unfortunatly this seems to be asynchronous replication (you manually
have to initiate the syncronization)...
I'd like
On Mon, 17 Sep 2001, Thomas Lockhart wrote:
> > Got it upgraded on the cvsup.postgresql.org server ... still have to do
> > the other servers ...
>
> I'm hopelessly confused on what servers we have, and whether that one is
> new, old, online, offline, being built, or being decommissioned. Can I
>
I'd like to have a hot standby server for our main PSQL...
I've seen that there are a number of products that might do the trick,
Mission Critical Linux (and their Convolu Cluster/IBM FC SAN), Usogres
and DBBalancer.
All seem (at least 'on paper') to solve this problem. The Convolu seem
a little
Hi all,
I was just looking through libpq large object code an noticed what seemed
to be a bug. The function lo_create() is declared as Oid yet it contains
the following code:
if (conn->lobjfuncs == (PGlobjfuncs *) NULL)
{
if (lo_initialize(conn) < 0)
return -1;
}
34 matches
Mail list logo
