Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Chuck Martin
> On Oct 10, 2015, at 3:44 PM, Adrian Klaver wrote: > > On 10/10/2015 12:02 PM, Chuck Martin wrote: >> >>> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 02:27 PM, Chuck Martin wrote: >>>>> On Sep 5, 2015, at 4:

Re: [GENERAL] Trouble setting up replication

2015-10-10 Thread Chuck Martin
> On Sep 5, 2015, at 5:37 PM, Adrian Klaver wrote: > > On 09/05/2015 02:27 PM, Chuck Martin wrote: >>> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: >>> >>> On 09/05/2015 11:00 AM, Chuck Martin wrote: > >>>> >>>> I had

Re: [GENERAL] Trouble setting up replication

2015-09-05 Thread Chuck Martin
> On Sep 5, 2015, at 4:29 PM, Adrian Klaver wrote: > > On 09/05/2015 11:00 AM, Chuck Martin wrote: >> Thanks for responding Adrian. >> >> After writing this, I noticed that the list is configure to reply to sender. >> I hope this is not inappropriate. P

Re: [GENERAL] Forms for entering data into postgresql

2013-10-12 Thread Chuck Davis
Hi Chuck, > > Could you explain the acronym AP? > > I understand that there are lots of situations I have not met yet, so > this might explain my ignorance, but I don't see what you get from using > a client-side app over a browser for most databases uses; after all, >

Re: [GENERAL] Forms for entering data into postgresql

2013-10-12 Thread Chuck Davis
Browsers are fine for displaying informaiton that is already in a database. They are the ultimate crap for entering data that has to be typed into a "form" and processed for persistence. It will be a long time before I ask my users to enter data into a browser. Just for an example: If you have

Re: [GENERAL] compile of 8.1.15

2009-01-10 Thread Chuck Davis
I have been trying to install 8.1.14 and 15 and it seems like there is an infinite loop in the make file. I do not have the skills to find it. Has anyone else had success compiling for Linux with gmake? Thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make chang

[GENERAL] Function to return both integer and SETOF refcursor

2008-05-16 Thread Chuck Bai
I got the following error when try to create a function to return an integer and SETOF refcursor. I want to get refcursors back along with an Out parameter in one function. There seems to be a conflict on return type. How do I fix it? Thanks. ERROR: function result type must be integer becaus

Re: [GENERAL] How to create a function with multiple RefCursor OUT parameters

2008-05-15 Thread Chuck Bai
I got only thing like "43 | | portal 4>" returned as a single row to my .NET client. Any other clients can use the function? Please advise. Albe Laurenz *EXTERN* wrote: Chuck Bai wrote: I have the following function: CREATE OR REPLACE FUNCTION test_refcursor(INOUT tcount integer

Re: [GENERAL] How to create a function with multiple RefCursor OUT parameters

2008-05-12 Thread Chuck Bai
t integer, refcursor, refcursor). I want to add logic to my INOUT parameter inside the function and return it back to client, as well as returning the two refcursor results. How to modify this function and how to test it in SQL to achieve my goal? Merlin Moncure wrote: On Sun, May 11, 2008 a

[GENERAL] How to create a function with multiple RefCursor OUT parameters

2008-05-11 Thread Chuck Bai
I have the following function: CREATE OR REPLACE FUNCTION test_refcursor(INOUT tcount integer, OUT o_user refcursor, OUT o_name refcursor) RETURNS record AS $BODY$ BEGIN tcount := tcount + 1; OPEN o_user FOR SELECT * FROM user_table; OPEN o_name FOR SELECT * FROM name_table; END; $BOD

[GENERAL] Postgres with daemontools or similar

2008-02-04 Thread Chuck D.
Greetings everyone. I would like to know what the correct position is on the use of Postgres with DJB's daemontools or other monitoring prgrams? I tried to set it up the other day and was successful in getting it to start and log, and even refresh the config files, but I could not get it to sh

Re: [GENERAL] basic questions: Postgres with yum on CentOS 5.1

2008-01-06 Thread Chuck
I'm sorry for my delayed response. Tomasz, thanks for your email. At 2:38 PM +0100 1/3/08, Tomasz Ostrowski wrote: On Tue, 01 Jan 2008, Chuck wrote: I'm not sure how to "make sure automatic updates are turned on" as Tometzky recommended. Is that a yum setting? You

Re: [GENERAL] basic questions: Postgres with yum on CentOS 5.1

2008-01-01 Thread Chuck
uestion: I think that need to figure where initdb is being called from to modify its parameters. Or, I need to determine how to set the default encoding to be UTF8. This might be more of a yum package question. Thanks for your help, Chuck ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] basic questions: Postgres with yum on CentOS 5.1

2007-12-31 Thread Chuck
quot; LC_MEASUREMENT="POSIX" LC_IDENTIFICATION="POSIX" LC_ALL= I have more questions about environment variables and starting the database server at reboot, but for the time being I just need to create three databases. I'll read the manual more before asking those question

Re: [GENERAL] installation on Mac OS X 10.5.1

2007-12-22 Thread Chuck
At 7:08 PM + 12/22/07, Dave Page wrote: > --- Original Message --- From: Chuck <[EMAIL PROTECTED]> To: Dave Page <[EMAIL PROTECTED]> Sent: 22/12/07, 18:51:09 Subject: Re: [GENERAL] installation on Mac OS X 10.5.1 Thanks. If I take this approach will it be str

Re: [GENERAL] installation on Mac OS X 10.5.1

2007-12-22 Thread Chuck
At 11:03 AM + 12/22/07, Dave Page wrote: Chuck wrote: Hello, What is the best way to install PostgreSQL on Mac OS X 10.5.1? Or, perhaps I should ask is there a preferred way to PostgreSQL on Mac OS X? Well I can't say this (or any other) is a 'preferred' way, but you mi

[GENERAL] installation on Mac OS X 10.5.1

2007-12-21 Thread Chuck
ch. Or, Should I use MacPorts or Fink? Thanks and happy holidays, Chuck ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] Geographic data sources, queries and questions

2007-10-26 Thread Chuck D.
On May 24, 2007 01:02:42 pm John D. Burger wrote: > Tilmann Singer wrote: > > We are using this data which seems to be fairly extensive and > > accurate, and is free: > > > > http://earth-info.nga.mil/gns/html/gis_countryfiles.htm > > We use that, but it is only non-US, so we combine it with this:

[GENERAL] Need help with bash script and postgresql

2007-07-23 Thread Chuck Payne
Hey, I have spend the last several days looking for a website or how to that would show me how to call postgresql in bash script. I know that in mysql I can do like this for i in `cat myfile.txt` ; do mysql -uxxx -p -Asse mydatabase  "insert into mytable  (aaa,bbb) values ("xxx", "yyy");

Re: [GENERAL] Geographic data sources, queries and questions

2007-05-27 Thread Chuck D.
On Thursday 24 May 2007 13:02, John D. Burger wrote: > > We also have a hodge-podge of other sources, but those are the main > ones. (By the way, we have found USGS to very amenable to dumping > their data in arbitrary ways. Those state files essentially try to > fit everything into a single CSV

Re: [GENERAL] Geographic data sources, queries and questions

2007-05-23 Thread Chuck D.
On Wednesday 23 May 2007 18:59, you wrote: > > I don't believe this is good design. You'll have to have a trigger or > something to verify that the country_id+state_id on the city table are > exactly equal to the country_id+state_id on the state table. If you > don't, you might have something li

Re: [GENERAL] Geographic data sources, queries and questions

2007-05-23 Thread Chuck D.
which, if you are using a similar database what source did you use for geographic data? I'm having troubles with a reliable set. > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Chuck D. > > Sent: Wednesday, May 23, 2

[GENERAL] Geographic data sources, queries and questions

2007-05-23 Thread Chuck D.
Greetings all, I have a couple issues regarding geographic names databases. 1) The first is this. I have 3 tables. Country, state and city. Country has a country_id to identify a country, state has a state_id and country_id to identify a state, and city has a city_id, state_id and country_id

[GENERAL] unsubscribe pgsql-general

2004-12-17 Thread Chuck Bernardes
unsubscribe pgsql-general  

Re: [GENERAL] Horology & stats tests fail in 7.4.3/RH 9

2004-07-25 Thread Chuck Bearden
On Mon, Jul 19, 2004 at 12:33:40AM -0400, Tom Lane wrote: > Chuck Bearden <[EMAIL PROTECTED]> writes: > > I am building from a freshly downloaded tar.gz of 7.4.3. The machine is > > a 4CPU Dell with an unsupported RH 9 install. > > > When I ran the regression t

[GENERAL] cygpopt-0.dll problem, ipc-daemon2

2004-07-01 Thread Chuck Bernardes
the application may fix this problem”   I downloaded the following file and extracted the contents:    cygipc-2.03-2.tar.bz2   I am a newbie to this so any help would be appreciated.   Thanks in advance. -Chuck    

Re: [GENERAL] PostgreSQL 7.4.3 on a windows XP Pro environment Installation

2004-07-01 Thread Chuck Bernardes
off one by one. Sorry for being long winded, but just wanted to inform everyone that I was finally able to get it running on XP pro. Now on to configuring the database and its tables for my Company's website. Thanks, Chuck -Original Message- From: Raymond O'Donnell [mailto:[EMAIL

[GENERAL] PostreSQL SQL for MySQL SQL

2001-02-06 Thread Chuck Esterbrook
reate database Foo; What I'm missing is: * "if exists" for the drop, in order to avoid an error the very first time this program runs * the "use Foo;" Can I do these things in PostreSQL from SQL (e.g., not from the command line)? -Chuck