It works great!
Thanks!
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Thursday, June 30, 2005 7:45 PM
Subject: Re: [GENERAL] PostgreSQL, WIndows, regular backup
This works to put the date in the filename on Windows 2000:
In a .bat file:
@echo off
for /f "tokens=1-4
thanks.
- Original Message -
From: "Matt Van Mater" <[EMAIL PROTECTED]>
To: "Zlatko Matic" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, June 30, 2005 7:25 PM
Subject: Re: [GENERAL] how to use pg_dump and then restored onto development
server
On 6/29/05, Douglas McNaught <[EMAIL PROTECTE
hi.
does postgresql support calling stored procedures with input and output
parameters ?
like example_proc(in1,in2,out1,out2);
if it does not - will it be possible in some time ?
is someone planning it ?
thanks.
---(end of broadcast)---
TIP 2: you
I found SQL sources which refers to some functions (like pg_file_read) in an
"admin" library. Are there somewhere in the PG sources ?
Jacques Massé
Diadfish: http://www.diadfish.org
PostgreSQL : http://www.postgresqlfr.org
---(end
Hello all,
I am having PostGreSql version 7.3.4
I am currently installing slony 1.1.0 package, whcih is used for
replication for PostGreSql.
While installing it is refereing certain utility files such as pg_config
and some .h files.
While installing it I am getting an error that pg_config_os.h
KubaTyszko <[EMAIL PROTECTED]> writes:
> hi.
> does postgresql support calling stored procedures with input and output
> parameters ?
> like example_proc(in1,in2,out1,out2);
> if it does not - will it be possible in some time ?
> is someone planning it ?
It's not supported in the current version
Hello all,
I am having POstGreSql version 7.2
Please tell me the procedure to uninstall PostGreSql
-Ajay
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi
I have 2 table
table1:
id
column1
table2:
id
column2
I perform this query
SELECT column1, column2 FROM table1 LEFT JOIN table2 USING (id)
ORDER BY column1, column2
In the rows where column1 is not null postgres perform ORDER BY column1,
column2
Problem:
I have table of documents
CREATE TABLE document ( DocumentType CHARACTER(1), )
DocumentType field determines the document type stored in record.
I want to restrict access to this table based on the user name, document
type and access level. I have 3 levels: no access, view only, modify acc
Russ Brown <[EMAIL PROTECTED]> writes:
> This just made me think. If I was writing this function, I would have
> written it as an SQL function like this:
> CREATE or REPLACE FUNCTION getSeq() RETURNS int AS $$
> SELECT nextval('myseq');
> $$ LANGUAGE SQL;
> Does anybody know which version is actu
On Fri, Jul 01, 2005 at 11:21:06AM +0200, Alessandro Vincelli wrote:
>
> SELECT column1, column2 FROM table1 LEFT JOIN table2 USING (id)
> ORDER BY column1, column2
>
> In the rows where column1 is not null postgres perform ORDER BY column1,
> column2
>
> Problem:
> In the rows where Column1 is
Found on pgadmin3 cvs
Jacques Massé
Diadfish: http://www.diadfish.org
PostgreSQL : http://www.postgresqlfr.org
> -Message d'origine-
> De : [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] la part de Masse Jacques
> Envoyé : vendredi 1 juillet 2005
> Out of curiosity, what other backends do you consider and what is their
> syntax for such problems.
Most folks that use Oracle's PL/SQL like it. I have a sneaking suspicion
Oracle used the GNAT parser for Ada as a starting point, but that is pure
conjecture. Oracle does document that PL/SQL is
Hello all.
In MSAccess there is a type of query that directly can create a view in which
every distinct value of a column in a table becomes the name of a diferent
column in the view.
It is something like:
Table:
date point value1 value2
-
12/03/1999
I have used PL/SQL for years. It's a great language that is easy to pick up and offers lots of ability/promise. The syntax seems very easy for new people to pick up who might know another language or are just starting out. Of course the same can be said of Ada code. It's just very easy to read.
On Fri, Jul 01, 2005 at 01:56:41PM +0300, Andrus wrote:
>
> I want to restrict access to this table based on the user name, document
> type and access level. I have 3 levels: no access, view only, modify access.
>
> Example:
>
> User A can only view documents of type X and modify documents of t
I am new to databases and would like to gain some idea of the sizes of
a typical singal database.
For instance what are the number of schemas, tables and views
that would constitute a databse considered to be small, medium or large?
Bob Pawley
On Fri, 2005-07-01 at 07:50 -0700, Bob Pawley wrote:
> what are the number of schemas, tables and views that would
> constitute a databse considered to be small, medium or large?
Totally subjective opinion:
Small database: few dozen tables/views
Medium database: 100 tables/views
Large database:
On Fri, Jul 01, 2005 at 08:46:04 -0600,
Michael Fuhr <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 01, 2005 at 01:56:41PM +0300, Andrus wrote:
>
> > 2. Postgres should allow access from my application only. Is it possible to
> > use authentication method which allows access from my application only
> [EMAIL PROTECTED] wrote:
> > Is there a similar command in Postgresql so that the client
application
> > can find out if there's an unresolved transaction before it starts a
new
> > one?
>
> See PQtransactionStatus() in libpq; if you're using a different language
> interface, it should provide s
Matt Miller wrote:
On Fri, 2005-07-01 at 07:50 -0700, Bob Pawley wrote:
what are the number of schemas, tables and views that would
constitute a databse considered to be small, medium or large?
Totally subjective opinion:
Small database: few dozen tables/views
Medium database: 100 tables/
After years of administering single-site PostgreSQL, I'm finally getting started on a PostgreSQL hosting project. I just wanted to check to see how our approach jives with what other folks in the community have done.Much of this is derived from the "hardening" techniques derived from phpPgAdmin.pat
I'm working on a PL/SQL set of functions to handle user access
restrictions to particular tables and am wondering:
- Is it "safe" to use postgresql authentication? Should I (like a LOT
of apps do) build my own authentication tables and just use a common
login/password for the application?
The solutions provided by Mr. Glaeserman and Mr. Lane worked
perfectly. So that's how NULL works!
Thanks so much for the help.
On Fri, Jul 01, 2005 at 04:38:39PM +0200, javier garcia wrote:
>
> In MSAccess there is a type of query that directly can create a view in which
> every distinct value of a column in a table becomes the name of a diferent
> column in the view.
The contrib/tablefunc module might be able to do wha
On Thu, Jun 30, 2005 at 10:56:21AM -0700, Derry Bryson wrote:
>
> Is it possible to get the text of the query that
> caused the trigger within a statement level trigger?
Not as far as I know -- somebody please correct me if I'm mistaken.
Querying pg_stat_activity or calling pg_stat_get_backend_ac
David Pratt <[EMAIL PROTECTED]> writes:
> It was suggested that I look at an array.
I think that was me. I tried not to say there's only one way to do it. Only
that I chose to go this way and I think it has worked a lot better for me.
Having the text right there in the column saves a *lot* of
27 matches
Mail list logo
