Title: RE: [GENERAL] Automate Postgres Backup In windows -> resolved
Thanks Richard.
For anyone interested
The link Richard was referring to can be found below.
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.Html
Kind Regards,
Shaun Clements
-Original Mess
I am trying to automate a postgres database data and schema
dump through windows.
Does anyone have any suggestions on best way to do
so.
Thanks
Kind Regards,Shaun
Clements
Apologies if this post is a repeat.
I am trying to automate a postgres database data and schema
dump through windows.
Does anyone have any suggestions on best way to do
so.
Thanks
Kind Regards,Shaun
Clements
, even if 100 isnt always used.
Kind Regards,
Shaun Clements
-Original Message-
From: Richard Huxton [mailto:dev@archonet.com]
Sent: 23 May 2005 03:29 PM
To: Shaun Clements
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] Postgres PHP error
Shaun Clements wrote:
> H
this means?
Is there a performance setting I need to set under the postgresql conf file.
I have checked, and its set to 100 users.
This error strangely has only happened once. Last week Monday.
Kind Regards,
Shaun Clements
Title: RE: [GENERAL] Postgres 8.02 connectivity
Hi Richard
I worked out what the problem was.
I needed an IP Mask(subnet) after the IP.
255.255.255.0 solved that
Thanks again for you help!!
Kind Regards,
Shaun Clements
-Original Message-
From: Richard Huxton [mailto:dev
that option, so I can connect over the network to the database, but I cant connect. It cant find the database. Giving that usual, listening on port 5432, failed to find database...etc
Any suggestions, on what needs to be configured further.
Kind Regards,
Shaun Clements
Title: RE: : [GENERAL] Postgres order by into a RECORD, not ordering
Ignore last email.
must
have been delayed.
Kind Regards,Shaun
Clements
-Original Message-From: Shaun Clements
[mailto:[EMAIL PROTECTED]Sent: 01 April 2005 12:22
PMTo: 'Richard Huxton'Cc:
.
Kind Regards,
Shaun Clements
-Original Message-
From: Shaun Clements
Sent: 01 April 2005 12:22 PM
To: 'Richard Huxton'
Cc: PostgreSQL General
Subject: RE: : [GENERAL] Postgres order by into a RECORD, not ordering
Hi Again.
I hope you can explain this.
I have a stored proce
ordered by the columns specified, because when I loop through the record, the columns returned in the row are different, to when I manually do a Select query using order by.
I assumed this may have something to do with the index.
Is there any reason why this is so ?
Kind Regards,
Shaun Clements
Title: FW: [GENERAL] Help with order by into a RECORD
Hi
I have a questions regarding my order by problem.
If you index a table, can you query the table using ORDER BY. ?
Kind Regards,
Shaun Clements
indexed, and COLUMN2 isnt.
Thanks in advance
Kind Regards,Shaun
Clements
Title: : [GENERAL] Postgres IX
Can someone please explain to me , the use of
CONSTRAINT ix_tablename
Kind Regards,
Shaun Clements
.
Any suggestions,
the postgres version is 7.3
Thanks in
advance.
Kind Regards,Shaun
Clements
.
Kind Regards,
Shaun Clements
-Original Message-
From: Richard Huxton [mailto:dev@archonet.com]
Sent: 31 March 2005 09:10 AM
To: Shaun Clements; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Catch of ERROR in PLPGSQL
Shaun Clements wrote:
> Thanks for your response.
> I unfortu
Hi
All
Does
anyone know if Postgres supports Catching of errors, from an EXECUTE, for
Procedural Language Postgres.
Thanks in advance
Kind Regards,Shaun
Clements
'''||quote_literal(VARIABLE2)||'''';
IF NOT FOUND THEN
The statement is failing to perform the check in the function.
Kind Regards,
Shaun Clements
-Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: 30 March 2005 03:56 PM
To: Shaun
LENAME SET ''||quote_ident(variable1)||''=''||quote_literal(Variable2)||'' where columnname1 =''||quote_literal(variable3)||'' and columnname2 = ''||quote_literal(variable4)||'' and month = ''''07'''' and year = ''''2004'''''';
There is clearly a need for a debugging facility.
Kind Regards,
Shaun Clements
Hi
Guys
Thanks again for
your responses.
You were all RIGHT
.. again!
a null column was
returned, which bombed out the stored procedure.
This was resolved
using ur advice.
Kind Regards,Shaun
Clements
B.Com
(Hons) IST
Software Developer
Relyant Group ITBusiness ConneXion (Pty)
LtdAs
2, column3, ''||quote_ident(column4)||'') values (''||quote_literal(RECORDNAME.column1)||'',''||quote_literal(RECORDNAME.column2)||'',''''stringvalue'''',''||quote_literal(RECORDNAME.column2)||'
to be done dynamically as part of a loop. So the column name needs to be called as a variable.
Im stuck.
Any suggestions
Kind Regards,
Shaun Clements
-Original Message-
From: Sean Davis [mailto:[EMAIL PROTECTED]]
Sent: 23 March 2005 03:33 PM
To: Shaun Clements
Cc: 'pgsql-ge
Title: [GENERAL] PLPGSQL
Is there no way in pgplsql
to call on a dynamic column.
I need to be able to dynamically determine the latest month column within a dataset, and to get that columns data.
I am unfamiliar with other languages within Postgres
Kind Regards,
Shaun Clements
mic column of the record.
Thanks in advance.
Kind Regards,
Shaun Clements
ariable is called
variable_2004
where name, represents the year
RESULT WANTED: variable1 gets assigned the value of variable_2004.
Any help is appreciated.Thanks
Kind Regards,
Shaun Clements
Title: RE: [GENERAL] PHP SQL
Thanks for your response.
It is as you mentioned, within the same database.
I will get working on a stored procedure this morning.
Thanks for your response.
Kind Regards,
Shaun Clements
-Original Message-
From: Jeff Davis [mailto:[EMAIL PROTECTED
application.
The reason for asking, is I plan on taking, 350 000 rows, and transforming them, into hopefully about 50% smaller number (in a new schema)
It is critical, that I dont DOS the database server, because it is being used in a PRODUCTION enviroment
Kind Regards,
Shaun Clements
-Original
individual column values to variables, and then inserting a new row into the new table.
pg_fetch_row
pg_fetch_assoc
pg_fetch_object
pg_fetch_result
pg_fetch_array
Are there performance differences, which are noticeable?
Kind Regards,
Shaun Clements
Title: RE: [GENERAL] pl sql to check if table of table_name exists
Hi
Sim
Thanks for your input.
Kind Regards,Shaun
Clements
-Original
Message-From: Sim Zacks
[mailto:[EMAIL PROTECTED]Sent: 10 March 2005 02:47 PMTo:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] pl sql
les
WHERE schemaname='...' AND tablename='...'
Your
response does not work for me. Perhaps you can explain the posted
command
* from pg_class where
relkind='r' and relname=your_tablename
Kind
Regards,Shaun Clements
-Original Message-From: Si
Title: RE: [GENERAL] pl sql to check if table of table_name exists
Much appreciated.
Thanks
Kind Regards,
Shaun Clements
-Original Message-
From: Adam Tomjack [mailto:[EMAIL PROTECTED]]
Sent: 10 March 2005 11:04 AM
To: Shaun Clements
Cc: postgresql
Subject: Re: [GENERAL] pl sql to
Title: RE: [GENERAL] pl sql to check if table of table_name exists
Hi
Hate to ask, but it isnt obvious to me from the documentation.
How do I perform a query in pgplsql, to check it a table exists of a particular name.
Thanks in advance
Kind Regards,
Shaun Clements
Title: RE: [GENERAL] Porting MySQL PHP to Postgres
Hi Russel
I assumed as much. I was hoping there was a tool available which someone had used and (or) what kind of stumbling blocks to run into.
Thanks again.
Kind Regards,
Shaun Clements
-Original Message-
From: Russell Smith
had this problem.
Thanks in advance.
Kind Regards,
Shaun Clements
Title: RE: [GENERAL]
You would need to use EXCEPTION, to trap the error.
Kind Regards,
Shaun Clements
-Original Message-
From: Jan Poslusny [mailto:pajout@gingerall.cz]
Sent: 08 February 2005 12:01 PM
To: Surabhi Ahuja
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
You
Title: RE: [GENERAL] Problem performing a restore of a data schema in Windows
Hi John
Thanks for the suggestion. It worked perfectly.
Thanks
Kind Regards,
Shaun Clements
-Original Message-
From: John DeSoi [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2005 04:21 PM
To: Shaun
Title: RE: [GENERAL] Problem performing a restore of a data schema in Windows
Yeah, thats right.
Sorry, Typo.
Any suggestions.
Kind Regards,
Shaun Clements
-Original Message-
From: Shridhar Daithankar [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2005 03:33 PM
To: Shaun Clements
the database, db1
I did create the database before restoring the data schema. And its not working.
Am I missing something?
Thanks in advance.
Kind Regards,
Shaun Clements
Subject to www.relyant.co.za/edisclaim.htm
37 matches
Mail list logo
