Re: [GENERAL] Locking question?

Well... if the application crashes then normally the TCP connection would drop as well. The problem is that in many environments it can take a *long* time for the backend to realize that the client went away. The tcp_keepalives_* settings are intended to try and reduce that time to a more

Re: [GENERAL] tsearch2 parser configuration

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/HOWTO-parser-tsearch2.html On Tue, 6 Feb 2007, Worky Workerson wrote: Is it possible to configure the tsearch2 parser? I'd like a very dumb parser that splits on everything that is not [a-zA-Z0-9.]. The default parser seems to work w

[GENERAL] Postgres training down under.

Are there any companies in the great land of Australia that offer Postgres training courses? I see a number listed for around the US on the postgresql.org website - just curious if anything similar goes on down under. Cheers, P. -- Paul Lambert Database Administrator AutoLedgers --

[GENERAL] Footprints on Postgres

Our help desk uses a job tracking system called Footprints, developed by Unipress (now Numara Software) which I have discovered this morning can run on Postgres. Does anyone on this list have any experience with this software, in particular using it with Postgres as it's backend. We currentl

Re: [GENERAL] pg_dump/restore and functions/triggers/trigger functions

Jeff Amiel <[EMAIL PROTECTED]> writes: > I guess the real question is (other than related to this issue), it there > any need to dump the catalog/informational schemas? There isn't, but pg_dump won't dump them anyway; you have no need to specify switches for that. The whole business of partia

Re: [GENERAL] getting status transaction error

This part... > repeated roughly once a minute. I've never seen this before. this is ...might mean some connection with autovacuum, maybe? I have no clue beyond that. Hope things go well for you. Kev ---(end of broadcast)--- TIP 2: Don't 'kill

Re: [GENERAL] replication choices

Just to be clear, this effectively means I double my database writes, correct? On Tue, 6 Feb 2007, Andrew Sullivan wrote: On Wed, Jan 31, 2007 at 03:17:40PM -0800, Ben wrote: the remote sites back to the central site, each remote site needs to have a normal slony node first, which I don't hav

Re: [GENERAL] leaving this group

Rafael Alves <[EMAIL PROTECTED]> writes: > How I leave this discussion group... ? Every message explains: List-Archive: List-Help: List-ID: List-Owner: List-Post:

Re: [GENERAL] pg_dump/restore and functions/triggers/trigger functions

Tom Lane <[EMAIL PROTECTED]> wrote:I think that would have excluded anything that didn't demonstrably belong to schema public, such as procedural languages. Is it possible that *all* your functions failed to load, and you only noted the ensuing GRANT/REVOKE failures? yes...ALL my functions did i

[GENERAL] Limit for number of Joins in a View? Version 8.1.4 on Redhat 9

I am wondering what the limit is on the number of joins in a View or a Select. Background: I have many tables with similar flags such as Active, Inactive, High, Medium, Low. I am storing the flags in a flag table and then putting an int4 foreign key to the flag in the data tables. Some data ta

[GENERAL] leaving this group

How I leave this discussion group... ? __ Fale com seus amigos de graça com o novo Yahoo! Messenger http://br.messenger.yahoo.com/

Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 03:23:29PM -0300, Alvaro Herrera wrote: > The fix is already in the REL8_2_STABLE branch, so Andrea can certainly > update and confirm if his problem is fixed. Confirmed, after the last cvs checkout it works fine. thanks! ---(end of broadcast)--

Re: [GENERAL] pg_dump/restore and functions/triggers/trigger functions

Jeff Amiel <[EMAIL PROTECTED]> writes: > The original pg_dump used --schema="public" . I think that would have excluded anything that didn't demonstrably belong to schema public, such as procedural languages. Is it possible that *all* your functions failed to load, and you only noted the ensuing

Re: [GENERAL] pg_dump/restore and functions/triggers/trigger functions

Jeff Amiel <[EMAIL PROTECTED]> writes: > did a pg_dump --format=c for a production database (on a 8.1.2 server) and > attempted to pg_restore on a 8.2.0 server. > Things seemed to go fine with the exception of functions, triggers and > trigger functions. Seems pretty strange. Can you strip thi

Re: [GENERAL] Array OUT columns in a record returned from a function

Ged <[EMAIL PROTECTED]> writes: > SELECT > q.id, q.name, q.summary, q.instructions, q.experience, q.notes, > q.starts, q.ends > , q.stage, st.description > , q.series, r.name > , COALESCE('../zones/' || q.zone, '../instances/' || q.instance) > , COALESCE(z.name, i.name) > INTO

Re: [GENERAL] pg_dump/restore and functions/triggers/trigger functions

The original pg_dump used --schema="public" . Could the fact that pg_catalog or information_schema weren't included cause these kinds of issues? (I can't imagine why) <[EMAIL PROTECTED]> wrote: did a pg_dump --format=c for a production database (on a 8.1.2 server) and attempted to pg_restore

[GENERAL] pg_dump/restore and functions/triggers/trigger functions

did a pg_dump --format=c for a production database (on a 8.1.2 server) and attempted to pg_restore on a 8.2.0 server. Things seemed to go fine with the exception of functions, triggers and trigger functions. It was apparently doing a bunch of ACL work towards the end and spewed a slew of error

[GENERAL] Array OUT columns in a record returned from a function

I have a web site devoted to quest guides for World of Warcraft players. There is a view that gets all the data needed for the quest details page from several tables. The view currently looks like this (joins indicating non-null columns and left joins indicating nullable columns): SELECT q.id, q.

[GENERAL] Npgsql and 57014 query_canceled error message

I'm doing some testing on a larger dataset, and I've started getting a 57014 error message when I catch an NpgsqlException. I thought it might be timing out on me, so in the connection string I've set the time out settings to the maximum of 1024 seconds before timeout. Has anyone else experienced

Re: [GENERAL] Postgres SQL Syntax

Jim C. wrote: Richard Huxton wrote: Jim C. wrote: You probably want one of the mysql converter projects, e.g. http://pgfoundry.org/projects/mysql2pgsql/ Also read the "converting from other databases" section here: http://www.postgresql.org/docs/techdocs I tried several conversion tools an

Re: [GENERAL] 8.2.2 Announcement?

Thomas F. O'Connell wrote: > Shouldn't there be an announcement about the buggy 8.2.2 announced > yesterday preceding the availability of new binaries, or is the bug > not considered severe enough to invalidate the 8.2.2 sources that are > currently in distribution? The sources and binaries

Re: [GENERAL] PostgreSQL/FireBird

>> With all their talk about "community this" and "community that", >> what else could they be but communists? > > I think you missed my joke there... Yeah, Ron Johnson wrote me about that already. Sorry for that, I'm probably too touchy when it comes to marking someone as a communist, especially

Re: [GENERAL] PostgreSQL/FireBird

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/06/07 14:51, Scott Marlowe wrote: > On Tue, 2007-02-06 at 11:59, Ron Johnson wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> On 02/06/07 10:59, Scott Marlowe wrote: >>> On Tue, 2007-02-06 at 10:19, Tim Tassonis wrote: >> [snip] >

Re: [GENERAL] PostgreSQL/FireBird

On Tue, 2007-02-06 at 11:59, Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/06/07 10:59, Scott Marlowe wrote: > > On Tue, 2007-02-06 at 10:19, Tim Tassonis wrote: > [snip] > >> It's been said a million times by BSD advocats: put one line of code > >> under GPL and

Re: [HACKERS] [GENERAL] getting status transaction error

On 2/6/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Merlin Moncure wrote: > On 2/6/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > >> actually, here is some more relevant bits from the log. > >> Feb 6 06:31:33 mojo postgres[1088]: [1-1] :: LOG: autovacuum: > >> processing database "template0"

[GENERAL] 8.2.2 Announcement?

Shouldn't there be an announcement about the buggy 8.2.2 announced yesterday preceding the availability of new binaries, or is the bug not considered severe enough to invalidate the 8.2.2 sources that are currently in distribution? -- Thomas F. O'Connell optimizing modern web applications

[GENERAL] tsearch2 parser configuration

Is it possible to configure the tsearch2 parser? I'd like a very dumb parser that splits on everything that is not [a-zA-Z0-9.]. The default parser seems to work well on my dataset except for the '/' character ... it doesn't split mike/john into two lexemes. And ideas? Thanks! ---

Re: [GENERAL] partitioning / rules - strange behavior

> If there´s only the insert_850 RULE then everything works as expected - > the > insert prints "INSERT 0 0", the row is inserted into the correct partition > which is sessions_850 - I can fetch it using either > > SELECT * FROM sessions WHERE id = currval('sessions_id_seq'); > > or dire

Re: [GENERAL] [HACKERS] getting status transaction error

Merlin Moncure wrote: > n 2/6/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > >Merlin Moncure wrote: > > > >> ya, it doesn't seem to match, as this seems to be repeating quite > >> regularly. interesting that my 'clog' files start at 06B6 and count > >> up. 0207 is way off the charts. > >> > >> a

Re: [HACKERS] [GENERAL] getting status transaction error

Merlin Moncure wrote: > On 2/6/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > >> actually, here is some more relevant bits from the log. > >> Feb 6 06:31:33 mojo postgres[1088]: [1-1] :: LOG: autovacuum: > >> processing database "template0" > >> Feb 6 06:31:33 mojo postgres[1088]: [2-1] :: ERRO

Re: [GENERAL] [HACKERS] getting status transaction error

n 2/6/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Merlin Moncure wrote: > ya, it doesn't seem to match, as this seems to be repeating quite > regularly. interesting that my 'clog' files start at 06B6 and count > up. 0207 is way off the charts. > > a lot of applications are hitting this databa

Re: [GENERAL] [HACKERS] getting status transaction error

Merlin Moncure wrote: > ya, it doesn't seem to match, as this seems to be repeating quite > regularly. interesting that my 'clog' files start at 06B6 and count > up. 0207 is way off the charts. > > a lot of applications are hitting this database, and so far everything > seems to be running ok (i

Re: [GENERAL] replication choices

Yeah, log shipping looks like it solves the network problem, except for the part about how how I must replicate to a normal slony node before I can get logs to ship. We don't have the hardware to have a secondary database at every site. :( On Tue, 6 Feb 2007, Andrew Sullivan wrote: On Thu, J

Re: [GENERAL] getting status transaction error

On 2/6/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > actually, here is some more relevant bits from the log. > Feb 6 06:31:33 mojo postgres[1088]: [1-1] :: LOG: autovacuum: > processing database "template0" > Feb 6 06:31:33 mojo postgres[1088]: [2-1] :: ERROR: could not access > status of t

Re: [GENERAL] [HACKERS] getting status transaction error

On 2/6/07, Stefan Kaltenbrunner <[EMAIL PROTECTED]> wrote: Merlin Moncure wrote: > On 2/6/07, Merlin Moncure <[EMAIL PROTECTED]> wrote: >> around 6:30 this morning, I started getting the following messages in >> my log: >> >> Feb 6 06:33:34 mojo postgres[1117]: [2-1] :: ERROR: could not access

Re: [GENERAL] getting status transaction error

Merlin Moncure wrote: > On 2/6/07, Merlin Moncure <[EMAIL PROTECTED]> wrote: > >around 6:30 this morning, I started getting the following messages in my > >log: > > > >Feb 6 06:33:34 mojo postgres[1117]: [2-1] :: ERROR: could not access > >status of transaction 51911 > >Feb 6 06:34:35 mojo

Re: [GENERAL] [HACKERS] getting status transaction error

Merlin Moncure wrote: > On 2/6/07, Merlin Moncure <[EMAIL PROTECTED]> wrote: >> around 6:30 this morning, I started getting the following messages in >> my log: >> >> Feb 6 06:33:34 mojo postgres[1117]: [2-1] :: ERROR: could not access >> status of transaction 51911 >> Feb 6 06:34:35 mojo po

Re: [GENERAL] getting status transaction error

On 2/6/07, Merlin Moncure <[EMAIL PROTECTED]> wrote: around 6:30 this morning, I started getting the following messages in my log: Feb 6 06:33:34 mojo postgres[1117]: [2-1] :: ERROR: could not access status of transaction 51911 Feb 6 06:34:35 mojo postgres[1128]: [2-1] :: ERROR: could no

[GENERAL] getting status transaction error

around 6:30 this morning, I started getting the following messages in my log: Feb 6 06:33:34 mojo postgres[1117]: [2-1] :: ERROR: could not access status of transaction 51911 Feb 6 06:34:35 mojo postgres[1128]: [2-1] :: ERROR: could not access status of transaction 51911 [...] repeat

Re: [GENERAL] Hardware

On Tue, 6 Feb 2007, Walter Vaughan wrote: CPUs ? The more CPUs the better, however if your database does not use many complex functions your money is best spent on a better disk subsystem. Also, avoid Intel Xeon processors with PostgreSQL as there is a problem with the context switching in t

Re: [GENERAL] PostgreSQL/FireBird

> On 02/06/07 10:59, Scott Marlowe wrote: >> On Tue, 2007-02-06 at 10:19, Tim Tassonis wrote: > [snip] >>> It's been said a million times by BSD advocats: put one line of code >>> under GPL and you instantly become a willingless slave of Richard >>> Stallmans hoards of children-eating communists.

Re: [GENERAL] daylight savings patches needed?

> I was trying to avoid getting into the gory details of which releases > had which timezone fixes, but it seems I can't avoid it. The new FAQ > item has the details: > > USA daylight saving time changes are included in PostgreSQL release > 8.0.[4+], and all later major releases, e.g. 8.1

Re: [GENERAL] daylight savings patches needed?

Peter Eisentraut wrote: > Bruce Momjian wrote: > > USA daylight saving time changes are included in PostgreSQL > > release 8.0.[4+], and all later major releases, e.g. 8.1. Canada and > > Western Australia changes are included in 8.0.[10+], 8.1.[6+], and > > all later major releases. PostgreS

Re: [GENERAL] daylight savings patches needed?

Bruce Momjian wrote: > USA daylight saving time changes are included in PostgreSQL > release 8.0.[4+], and all later major releases, e.g. 8.1. Canada and > Western Australia changes are included in 8.0.[10+], 8.1.[6+], and > all later major releases. PostgreSQL releases prior to 8.0 use the >

Re: [GENERAL] daylight savings patches needed?

Bruce Momjian <[EMAIL PROTECTED]> writes: > Steve Crawford wrote: >> 1. What, exactly, was the point of moving away from the system zoneinfo >> files and requiring PG admins to maintain yet another apparently >> identical set of files? The fact that not all systems use the zic database. We were t

Re: [GENERAL] daylight savings patches needed?

Steve Crawford wrote: > > I was trying to avoid getting into the gory details of which releases > > had which timezone fixes, but it seems I can't avoid it. The new FAQ > > item has the details: > > > > USA daylight saving time changes are included in PostgreSQL release > > 8.0.[4+], and

Re: [GENERAL] daylight savings patches needed?

Ed L. wrote: > > >From the FAQ: > > > 1.14) Will PostgreSQL handle recent daylight saving time changes > in various countries? > > PostgreSQL versions prior to 8.0 use the operating system's > timezone database for daylight saving information. All current > versions of Po

Re: [GENERAL] daylight savings patches needed?

On Tuesday 06 February 2007 13:16, Ed L. wrote: > From the FAQ: > > > 1.14) Will PostgreSQL handle recent daylight saving time changes > in various countries? > > PostgreSQL versions prior to 8.0 use the operating system's > timezone database for daylight saving information. Al

Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

Bruce Momjian wrote: > Andrea Arcangeli wrote: > > Actually I'm using the REL8_2_STABLE branch in CVS which may be a bit > > more advanced than the plain 8.2.2, but still it's supposedly a stable > > branch. > > > > The easiest way for me to reproduce is this: > > > > cpushare=> create table x (

Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 01:19:28PM -0500, Bruce Momjian wrote: > This is a known bug in 8.2.2 and we are discussing methods of > distributing the fix as quickly as possible. Ok great! Take your time, thanks. ---(end of broadcast)--- TIP 3: Have you

Re: regression in 8.8.2 [was Re: [GENERAL] Very strange error]

Andrea Arcangeli wrote: > On Tue, Feb 06, 2007 at 10:09:16AM -0500, Michael Slattery wrote: > > When does this error crop up? What is the query? Does this select > > involve more than one table, or does it involve any homemade > > functions? Or overriden functions? > > My application broke

[GENERAL] daylight savings patches needed?

From the FAQ: 1.14) Will PostgreSQL handle recent daylight saving time changes in various countries? PostgreSQL versions prior to 8.0 use the operating system's timezone database for daylight saving information. All current versions of PostgreSQL 8.0 and later contain up-

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

Thomas F. O'Connell wrote: > On Feb 6, 10:33 am, [EMAIL PROTECTED] (Tom Lane) wrote: > > "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: > > > > > but we just built 8.2.2 from source using cc, and now we're seeing > > > this type of error in the logs: > > > ERROR: attribute 3 has wrong type

regression in 8.8.2 [was Re: [GENERAL] Very strange error]

On Tue, Feb 06, 2007 at 10:09:16AM -0500, Michael Slattery wrote: > When does this error crop up? What is the query? Does this select > involve more than one table, or does it involve any homemade > functions? Or overriden functions? My application broke in a big way with the security updat

Re: [GENERAL] Cursor timeout in postgres

Tim Tassonis <[EMAIL PROTECTED]> writes: > I try to reproduce the situation tomorrow and will also check on any > odbc_errmsg() messages and the postmaster log. OK. A couple of comments: the only timeout within Postgres itself is statement_timeout, which I think wouldn't apply to your situation

Re: [GENERAL] Cursor timeout in postgres

Hi Tom Tom Lane wrote: Tim Tassonis <[EMAIL PROTECTED]> writes: When examining strange behaviour in one of my programs I found out that I must have somehow gotten into a timeout situation when fetching rows from a cursor. My program read the first row, did some stuff for six minutes and then

Re: [GENERAL] PostgreSQL/FireBird

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/06/07 10:59, Scott Marlowe wrote: > On Tue, 2007-02-06 at 10:19, Tim Tassonis wrote: [snip] >> It's been said a million times by BSD advocats: put one line of code >> under GPL and you instantly become a willingless slave of Richard >> Stallman

Re: [GENERAL] Creating an index on a live database

On Tuesday 06 February 2007 09:38, John McCawley <[EMAIL PROTECTED]> wrote: > I have a table with a few million rows which has inserts performed on it > roughly 50 or so times a minute. It contains a heavily-queried column > that I would like to add an index to, but I am concerned about a > deadl

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

On Feb 6, 10:33 am, [EMAIL PROTECTED] (Tom Lane) wrote: > "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: > > > but we just built 8.2.2 from source using cc, and now we're seeing > > this type of error in the logs: > > ERROR: attribute 3 has wrong type > > DETAIL: Table has type character vary

Re: [GENERAL] Cursor timeout in postgres

Tim Tassonis <[EMAIL PROTECTED]> writes: > When examining strange behaviour in one of my programs I found out that > I must have somehow gotten into a timeout situation when fetching rows > from a cursor. My program read the first row, did some stuff for six > minutes and then tried to fetch the

Re: [GENERAL] pg_restore single table privileges/indexes

On Tuesday 06 February 2007 09:32, Jeff Amiel <[EMAIL PROTECTED]> wrote: > We just switched from 'pg_dumpall" to "pg_dump -format=c" for our nightly > backups. I wanted to experiment with restoring a single table (if the > need should ever arise) from the dump file. > I also notice that the index

[GENERAL] Creating an index on a live database

I have a table with a few million rows which has inserts performed on it roughly 50 or so times a minute. It contains a heavily-queried column that I would like to add an index to, but I am concerned about a deadlock occurring. Should I wait until downtime to add the index, or is the Postgres

[GENERAL] pg_restore single table privileges/indexes

"PostgreSQL 8.2.0 on i386-portbld-freebsd6.0, compiled by GCC cc (GCC) 3.4.4 [FreeBSD] 20050518" We just switched from 'pg_dumpall" to "pg_dump -format=c" for our nightly backups. I wanted to experiment with restoring a single table (if the need should ever arise) from the dump file. I use the

[GENERAL] Cursor timeout in postgres

Hi all When examining strange behaviour in one of my programs I found out that I must have somehow gotten into a timeout situation when fetching rows from a cursor. My program read the first row, did some stuff for six minutes and then tried to fetch the second row, which failed. The connecti

Re: [GENERAL] Hardware

On Tue, 2007-02-06 at 10:33, Lars Heidieker wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > On 6 Feb 2007, at 15:59, Walter Vaughan wrote: > > > I need to purchase a new server to put posgresql on that will be > > acting as the DBMS server for Apache ofBiz soon. While googling

Re: [GENERAL] Postgres SQL Syntax

Jim C. wrote: You probably want one of the mysql converter projects, e.g. http://pgfoundry.org/projects/mysql2pgsql/ Also read the "converting from other databases" section here: http://www.postgresql.org/docs/techdocs I tried several conversion tools and did get some minor success with one

Re: [GENERAL] Hardware

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 6 Feb 2007, at 15:59, Walter Vaughan wrote: I need to purchase a new server to put posgresql on that will be acting as the DBMS server for Apache ofBiz soon. While googling around for performance tweaks I saw this at http://revsys.com/ writi

Re: [GENERAL] PostgreSQL/FireBird

On Tue, 2007-02-06 at 10:19, Tim Tassonis wrote: > > The FSF says the MPL is not compatible with the GPL, but, well, the FSF > > generally finds **all** non-GPL licenses incompatible with the GPL (BSD, > > MPL, Apache, etc.). The only truly GPL-compatible license I know of is > > LGPL (and ther

Re: [GENERAL] PostgreSQL/FireBird

The FSF says the MPL is not compatible with the GPL, but, well, the FSF generally finds **all** non-GPL licenses incompatible with the GPL (BSD, MPL, Apache, etc.). The only truly GPL-compatible license I know of is LGPL (and there have been arguments about that). That’s the problem with the

Re: [GENERAL] replication choices

On Wed, Jan 31, 2007 at 03:17:40PM -0800, Ben wrote: > the remote sites back to the central site, each remote site needs to have > a normal slony node first, which I don't have the hardware for. An answer for this, though a dirty kludge, is to replicate to another database in the same cluster. T

Re: [GENERAL] Help compile pgmemcache against PG 8.2

On 06.02.2007 17:04, Richard Huxton wrote: Chander Ganesan wrote: Richard Huxton wrote: Hannes Dorbath wrote: http://pgfoundry.org/projects/pgmemcache/ We'd like to use pgmemcache with PG 8.2. The memcached version doesn't matter much (1.2.x is current, 1.1.x would be fine as well). It fai

Re: [GENERAL] Help compile pgmemcache against PG 8.2

Chander Ganesan wrote: Richard Huxton wrote: Hannes Dorbath wrote: http://pgfoundry.org/projects/pgmemcache/ We'd like to use pgmemcache with PG 8.2. The memcached version doesn't matter much (1.2.x is current, 1.1.x would be fine as well). It fails to build against 8.2 with various errors.

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: > but we just built 8.2.2 from source using cc, and now we're seeing > this type of error in the logs: > ERROR: attribute 3 has wrong type > DETAIL: Table has type character varying, but query expects > character varying. This has nothing to

Re: [GENERAL] replication choices

On Thu, Jan 25, 2007 at 12:17:52PM -0800, Ben wrote: > familiar with Slony, and from what I understand, using Slony with bad > networks leads to bad problems. I'm also not sure that Slony supports > replicating from multiple sources to the same postgres install, even if > each replication proces

Re: [GENERAL] Hardware

On 06.02.2007, at 08:59, Walter Vaughan wrote: Is this still true in regards to Xeon's? I was looking at a server with Quad Core Xeon 2 5335 @ 2.0GHz. No, it's not true anymore. See http://tweakers.net/reviews/657/1 for an interesting comparison. cug ---(end of bro

Re: [GENERAL] Hardware

On Tue, Feb 06, 2007 at 10:59:21AM -0500, Walter Vaughan wrote: > > Is this still true in regards to Xeon's? I was looking at a server with > Quad Core Xeon 2 5335 @ 2.0GHz. Multi-core Xeons are not as affected, and are somewhat different "under the hood". So no, you're probably ok there. > A

Re: [GENERAL] Storing database in cluster (Memory)

You might take a look at index anding for speeding up your selects -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Huxton Sent: Tuesday, February 06, 2007 7:24 AM To: roopa perumalraja Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Storing

Re: [GENERAL] Very strange error

Have you installed any updates for PostgreSQL? The latest security update fixed something with type checks or so. I've seen the same error message also on the BUGS mailing list concerning a broken CHECK constraint on a table row. Perhaps this is the cause of the error messages. Well, I've just

Re: [GENERAL] Postgres SQL Syntax

> You probably want one of the mysql converter projects, e.g. > http://pgfoundry.org/projects/mysql2pgsql/ > Also read the "converting from other databases" section here: > http://www.postgresql.org/docs/techdocs I tried several conversion tools and did get some minor success with one or two b

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

On Feb 6, 2007, at 9:54 AM, Andrew Sullivan wrote: On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: DETAIL: Table has type character varying, but query expects character varying. In another thread, someone else is reporting this too. I'm wondering whether something went w

Re: [GENERAL] create operator class problem

On Tue, Feb 06, 2007 at 10:45:23AM -0500, Tom Lane wrote: > Ron Peterson <[EMAIL PROTECTED]> writes: > > I wanted to play with ltree, but I'm having trouble running ltree.sql. > > Everything in ltree.sql seems to work, except for the CREATE OPERATOR > > CLASS statements, which error out like: > >

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: > DETAIL: Table has type character varying, but query expects > character varying. In another thread, someone else is reporting this too. I'm wondering whether something went wrong in the 8.2.2 release. Is this the other thr

Re: [GENERAL] Postgres SQL Syntax

Jim C. wrote: I'm doing this table by table, line by line. Each table, I learn something new about the differences between MySQL and Postgres, I mentally catalog it and I can always look it up in my own code next time for examples. I've a tool that is providing some help but sometimes it choke

[GENERAL] Hardware

I need to purchase a new server to put posgresql on that will be acting as the DBMS server for Apache ofBiz soon. While googling around for performance tweaks I saw this at http://revsys.com/writings/postgresql-performance.html CPUs — The more CPUs the better, however if your database does not

Re: [GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

On Tue, Feb 06, 2007 at 09:43:01AM -0600, Thomas F. O'Connell wrote: > DETAIL: Table has type character varying, but query expects > character varying. In another thread, someone else is reporting this too. I'm wondering whether something went wrong in the 8.2.2 release. A -- Andrew Sulliva

Re: [GENERAL] Help compile pgmemcache against PG 8.2

Richard Huxton wrote: Hannes Dorbath wrote: http://pgfoundry.org/projects/pgmemcache/ We'd like to use pgmemcache with PG 8.2. The memcached version doesn't matter much (1.2.x is current, 1.1.x would be fine as well). It fails to build against 8.2 with various errors. The project seems unma

Re: [GENERAL] create operator class problem

Ron Peterson <[EMAIL PROTECTED]> writes: > I wanted to play with ltree, but I'm having trouble running ltree.sql. > Everything in ltree.sql seems to work, except for the CREATE OPERATOR > CLASS statements, which error out like: > ERROR: syntax error at or near "OPERATOR10" > LINE 3: OPERATOR10<@

[GENERAL] PostgreSQL on Solaris: Changing Compilers During Point Upgrade

I'm working on a system where postgres 8.2.1 was built from source on Solaris 10 using gcc. Based on a number of recommendations, we decided to rebuild postgres Sun Studio cc. Without changing platforms, I wouldn't've expected the compiler to make a difference, but we just built 8.2.2 from

Re: [GENERAL] Very strange error

Hello there! I suggest to post this on the BUGS mailing list. As said before, there has been some other mail with exact the same error message and with the latest version something concerning data type checks had been fixed. Greetings, Matthias I'm writing a seperate e-mail to the pgsql-bu

[GENERAL] create operator class problem

I wanted to play with ltree, but I'm having trouble running ltree.sql. Everything in ltree.sql seems to work, except for the CREATE OPERATOR CLASS statements, which error out like: ERROR: syntax error at or near "OPERATOR10" LINE 3: OPERATOR10<@ (_ltree, ltree)RECHECK , ...which is generated fro

Re: [GENERAL] Very strange error

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ümit Öztosun Sent: Tuesday, February 06, 2007 3:59 PM To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Very strange error Have you installed any updates for PostgreSQL? The

Re: [GENERAL] Retrieving affected tables

On 06.02.2007 15:00, Richard Huxton wrote: Hannes Dorbath wrote: On 06.02.2007 14:19, Richard Huxton wrote: What is best way to retrieve all affected tables of an select statement? (Besides parsing the raw SQL). From where? As a client-application function? As a user-callable function in th

Re: [GENERAL] Very strange error

When does this error crop up? What is the query? Does this select involve more than one table, or does it involve any homemade functions? Or overriden functions? On Feb 6, 2007, at 9:58 AM, Ümit Öztosun wrote: Have you installed any updates for PostgreSQL? The latest security update

Re: [GENERAL] Very strange error

Have you installed any updates for PostgreSQL? The latest security update fixed something with type checks or so. I've seen the same error message also on the BUGS mailing list concerning a broken CHECK constraint on a table row. Perhaps this is the cause of the error messages. Well, I've just

Re: [GENERAL] Postgres SQL Syntax

This is one instance where I think PGAdmin would really help. You know what the schema needs to be, yes? Create it will PGAdmin and you can see what some well-formatted PG code looks like. The majority of the differences in syntax between MySQL and PG are *generally* MySQL's fault. MySQL has mo

Re: [GENERAL] PostgreSQL/FireBird

Borland simply chose a modified MPL to release their InterBase 6 under. They have since release InterBase 6 under a commercial license, and have also released InterBase 7 under a commercial license. MPL is a fairly common license. Sun's CDDL is a modified MPL, for example. The MPL is somewhere b

Re: [GENERAL] Retrieving affected tables

Hannes Dorbath wrote: On 06.02.2007 14:19, Richard Huxton wrote: What is best way to retrieve all affected tables of an select statement? (Besides parsing the raw SQL). From where? As a client-application function? As a user-callable function in the server? From within the parse/execute code

Re: [GENERAL] Retrieving affected tables

On 06.02.2007 14:19, Richard Huxton wrote: What is best way to retrieve all affected tables of an select statement? (Besides parsing the raw SQL). From where? As a client-application function? As a user-callable function in the server? From within the parse/execute code? From a client appli

Re: [GENERAL] Storing database in cluster (Memory)

roopa perumalraja wrote: Hi all, As I am inserting 100million rows daily into partitioned tables (daily wise), it is getting slower. What is - the inserts? By how much? What tables? What indexes? How are you inserting these rows? > Even the retrivel of data, select statement on those table

Re: [GENERAL] Very strange error

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ümit Öztosun > Sent: Tuesday, February 06, 2007 2:50 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Very strange error > > > Hi, > > Today suddenly our PostgreSQL 8.1 server started produci

  1   2   >