Re: [GENERAL] psqlodbc problem Urgent

Hi all, We use postgres version 7.5.9-2 with psqlodbc version 7.3-3 that comes as built in package with RHEL3 for our application.We found a bug in psqlodbc. When we try to execute a query while the postgres database is down or crashed (Note: This condition occurs after calling SQLConnect onc

Re: [GENERAL] create view problem

On 6/2/06, Tom Lane wrote: "Chris Velevitch" writes: > I'm using pg 7.4.5 (cygwin) on win xp sp1. > When I enter:- > create view v1 as select * from t1; > I get:- > ERROR: syntax error at or near "view" at character 16 Repeatably? "view" is not nearly 16 characters into that command.

[GENERAL] New version of DBD::Pg for 8.1.4?

Hello, Will there need to be a new version of DBD::Pg released for 8.1.4? Mike -- Open WebMail Project (http://openwebmail.org) ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] How to do a "CREATE DATABASE" and then connect to it?

Joseph Brenner wrote: After you do a "CREATE DATABASE", how do you programatically connect to what you just created? In the psql monitor, you'd use the "\c" command. If the DATABASE already exists when you connect to postgresql, you use the name when you connect (e.g. "dbname=..."). I'm g

Re: [GENERAL] Querying for strings that match after prefix

badlydrawnbhoy <[EMAIL PROTECTED]> wrote: > I hope this is the right forum for this, but please correct me if > somewhere else is more appropriate. > > I need to locate all the entries in a table that match , but only after > a number of characters have been ignored. I have a table of email > ad

[GENERAL] How to do a "CREATE DATABASE" and then connect to it?

After you do a "CREATE DATABASE", how do you programatically connect to what you just created? In the psql monitor, you'd use the "\c" command. If the DATABASE already exists when you connect to postgresql, you use the name when you connect (e.g. "dbname=..."). I'm getting the impression

Re: [GENERAL] Best open source tool for database design / ERDs?

On Fri, 2 Jun 2006, Michael Dean wrote: a caveat: I don't believe, from my reading of the license, that this is an open source software product. May not be. I don't recall. Neither is Java. But, if you're using it for your own purposes, what's the issue? Rich -- Richard B. Shepard, Ph.D.

Re: [GENERAL] Best open source tool for database design / ERDs?

Rich Shepard wrote: On Fri, 2 Jun 2006, Dany De Bontridder wrote: On Thursday 01 June 2006 15:39, Sean Davis wrote: Would you mind give me the plugin name (or url) ? Dany, It was mentioned yesterday; the name is 'clay' and if you aim your browser at

Re: [GENERAL] Best open source tool for database design / ERDs?

On Fri, 2 Jun 2006, Dany De Bontridder wrote: On Thursday 01 June 2006 15:39, Sean Davis wrote: Would you mind give me the plugin name (or url) ? Dany, It was mentioned yesterday; the name is 'clay' and if you aim your browser at you can read all

Re: [GENERAL] Best open source tool for database design / ERDs?

On Thursday 01 June 2006 15:39, Sean Davis wrote: > You might look into Eclipse (the java-based IDE). It has at least one ERD > design plugin that allows graphical layout, editing of schema, and > generation of DDL directly from the schema. It works with many DB > platforms and is FREE!!! Would y

Re: [GENERAL] Migrate Postgres 7.2 to Postgres 8.1

Marin Alonso, David wrote: Hi all All people have advised me that I should migrate my database Postgres 7.2.2 /PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (/ /Red Hat Linux 8.0 3.2-7)/ *to new version 8.1.4.* // I have downloaded * /postgre

Re: [GENERAL] Java Triggers

John, Thanks for the referral. The link is a bit outdated since all web content has moved to a wiki. Please use: http://wiki.tada.se/display/pljava/Home instead. Kind regards, Thomas Hallgren John Sidney-Woollett wrote: I would think the answer is yes. pljava allows you to create java functi

Re: [GENERAL] Best high availability solution ?

Scott Ribe a écrit : I prefer the approach of keeping the backup server up to date, whether using PITR or Slony or your own home-grown synching, and then changing IPs. My process involves someone making the decision that server is indeed down, then UNPLUGGING it from the network, then changing th

Re: [GENERAL] Best high availability solution ?

> I guess the users would start over anyway. So easiest if you > provide a copy of the app with that other connection and > signal them if the first server dies to just close the first > and start the backup-application. This requires that all the users do the right thing. Problem is, what if ther

Re: [GENERAL] Postmaster shuts down after rebuilding database via psql

"Averbukh Stella" <[EMAIL PROTECTED]> writes: > After database was recreated, I do the same ps command but the output is > completely different. The main postmaster process is gone and there are > couple of subprocesses that are still hanging there. Crashes of the main postmaster process are pret

[GENERAL] Postmaster shuts down after rebuilding database via psql

Title: Postmaster shuts down after rebuilding database via psql Hello, I experience following problem.  I have postgreSQL installed on sparc10.  During the day, I have to drop and create 100+ tables several times per day.  After I do it in psql, quit it and run my application I get followin

Re: [GENERAL] Querying for strings that match after prefix

John Sidney-Woollett wrote: brian ally wrote: John Sidney-Woollett wrote: I need to locate all the entries in a table that match , but only after a number of characters have been ignored. I have a table of email addresses, and someone else has erroneously entered some addresses prefixed with

Re: [GENERAL] Getting "timeout expired" error almost immediately (20-200ms)

"Eric Brown" <[EMAIL PROTECTED]> writes: > I'm running 8.0.3 on Linux 2.6. Once my application starts to get a bit > of load, I start getting application exceptions with the "timeout > expired" string from postgresql. I think it is coming from > src/interfaces/libpq/fe-misc.c. I don't think so. l

Re: [GENERAL] create view problem

"Chris Velevitch" <[EMAIL PROTECTED]> writes: > I'm using pg 7.4.5 (cygwin) on win xp sp1. > When I enter:- > create view v1 as select * from t1; > I get:- > ERROR: syntax error at or near "view" at character 16 Repeatably? "view" is not nearly 16 characters into that command. I think y

Re: [GENERAL] Querying for strings that match after prefix

1) select ltrim(substr(address, 8)) from people where address like 'mailto:%' gives all addresses that start with "mailto:"; but first strips off the prefix leaving only the email address 2) select address from people where address not like 'mailto:%' produces all email address that don't nee

Re: [GENERAL] Querying for strings that match after prefix

John Sidney-Woollett wrote: I need to locate all the entries in a table that match , but only after a number of characters have been ignored. I have a table of email addresses, and someone else has erroneously entered some addresses prefixed with 'mailto:', which I'd like to ignore. > Or someth

Re: [GENERAL] Querying for strings that match after prefix

Or something like select ltrim(substr(address, 8)) from people where address like 'mailto:%' union select address from people where address not like 'mailto:%' John John Sidney-Woollett wrote: Do you mean? select replace(address, 'mailto:', '') from people ... and if you only want to find th

Re: [GENERAL] Querying for strings that match after prefix

Do you mean? select replace(address, 'mailto:', '') from people ... and if you only want to find the ones that start with "mailto:"; select replace(address, 'mailto:', '') from people where address like 'mailto:%' John badlydrawnbhoy wrote: Hi all, I hope this is the right forum for this, b

Re: [GENERAL] Querying for strings that match after prefix

On Fri, Jun 02, 2006 at 02:47:22AM -0700, badlydrawnbhoy wrote: > I need to locate all the entries in a table that match , but only after > a number of characters have been ignored. I have a table of email > addresses, and someone else has erroneously entered some addresses > prefixed with 'mailto:

Re: [GENERAL] Java Triggers

I would think the answer is yes. pljava allows you to create java functions, and triggers invoke functions eg CREATE TRIGGER sometrigger BEFORE UPDATE ON schema.table FOR EACH ROW EXECUTE PROCEDURE yourfunction(); Here's a link for the pljava language. http://gborg.postgresql.org/proj

[GENERAL] Migrate Postgres 7.2 to Postgres 8.1

Hi all   All people have advised me that I should migrate my database Postgres 7.2.2   PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 ( Red Hat Linux 8.0 3.2-7)   to new version 8.1.4.   I have downloaded postgresql-8.1.4-1PGDG.i686.rpm postgresql-co

[GENERAL] Reinstalling Postgres 8.1 on Window problem

Hi,   I had been using postgres 8.1 for few months without problem. However, due to my administrator request, I need to change my existing postgres account to have a better account name and password.   I tried the following   Manually modification Manual add a new account and

[GENERAL] Java Triggers

Hi there, I'm a very competent Oracle developer, but have never used Postgres. There's currently a project taking place where I'm working that is developing on an Oracle database, but could potentially be migrated to an open source database in the future; possibly Postgres. There are two question

[GENERAL] Querying for strings that match after prefix

Hi all, I hope this is the right forum for this, but please correct me if somewhere else is more appropriate. I need to locate all the entries in a table that match , but only after a number of characters have been ignored. I have a table of email addresses, and someone else has erroneously enter

[GENERAL] Getting "timeout expired" error almost immediately (20-200ms)

I'm running 8.0.3 on Linux 2.6. Once my application starts to get a bit of load, I start getting application exceptions with the "timeout expired" string from postgresql. I think it is coming from src/interfaces/libpq/fe-misc.c. There is an interesting comment in that function (hasn't changed since

[GENERAL] How to extract data from files in pg_xlog

Dear Mr.: I want to exchange data in many DB (between one Central DB and many Remote DBs). The DBs are in individual LAN and not in WAN (INet), so they cannot transfer data directly. I can palce a host in INet. The DBs can access INet host and transfer data by the host. Now I want exctra

Re: [GENERAL] Best open source tool for database design / ERDs?

Anyone here used both DIA and schema export extensions for it as well as the Eclipse ERD plug-in for creating and exporting schemas - I mean outputting DDL statements in PostgreSQL? Or Druid? Which do you like best and why? Thanks. ---(end of broadcast)--

Re: [GENERAL] Best open source tool for database design / ERDs?

Thanks for all the great suggestions. Dana ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[GENERAL] create view problem

I'm using pg 7.4.5 (cygwin) on win xp sp1. When I enter:- create view v1 as select * from t1; I get:- ERROR: syntax error at or near "view" at character 16 Why? Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group www.flashdev.org.au ---(

Re: [GENERAL] review SQL command history?

Am Freitag, 2. Juni 2006 10:30 schrieb Tomi NA: > Is there a way to see SQL command history (specifically, a number of > INSERTS in a batch command) that happened a couple of weeks ago? I > need to see if a database was initialized with the correct data... If you turned on statement logging, it's

[GENERAL] review SQL command history?

Is there a way to see SQL command history (specifically, a number of INSERTS in a batch command) that happened a couple of weeks ago? I need to see if a database was initialized with the correct data... TIA, t.n.a. ---(end of broadcast)--- TIP 9: I

Re: [GENERAL] help me on a trigger

On Friday 02 June 2006 02:09 am, Pedro <[EMAIL PROTECTED]> thus communicated: --> I need to create a trigger that decreases on a "stocks" table the amount --> that have been inserted on the "tooken_from_stock" table. --> --> the trigger should be something like: --> --> CREATE TRIGGER triggerdecrea