I know the function is there.
What am I doing wrong?
galvdb=#
galvdb=# \df+ delete_old
List of functions
Result data type | Schema | Name | Argument data types | Owner | Language |
Source code | Description
That actually depends on the nature of function as well. According to the
PostgreSQL manual:
\df [ pattern ]
\df+ [ pattern ]
Lists available functions, together with their argument and return types. If
pattern is specified, only functions whose names match the pattern are
shown. If the form
Hi all,
While there are inserts updates happening into the database, is it possible
to make the base backup without losing any of the updates in the database?
What does select pg_start_backup('label'); pg_stop_backup(); do actually?
I am worried if the file system backup tool
Please keep us posted on your archiveopteryx experience!
I just install aox on a soekris ! with openbsd 4.0 with a remote postgresl
db and setup sendmail to forward by lmtp.
Really nice. No problem to compile (just a postgresql.h in a obsd specific
location).
The installer (wich cretae the
Jean-Gérard Pailloncy wrote:
I do not have test numbers rigth now, because I need first to configure
the box for virtual hosting, then dspam.
It would be really wonderful if someone managed to combine this with
dspams own database. Maybe it'd be possible to pull dspam's algorithms
as a lib into
Angva [EMAIL PROTECTED] writes:
As others have said, sequences can have gaps. In fact, the thought of
a gap-free sequence is scary to me. Unless you do very few inserts,
gap-free sequence is pretty much synonymous with not scalable. If
your goal is to generate a unique number for each row
On Wednesday 31 January 2007 8:46 pm, Harvey, Allan AC wrote:
I know the function is there.
What am I doing wrong?
galvdb=#
galvdb=# \df+ delete_old
List of functions
Result data type | Schema | Name | Argument data types | Owner | Language
|
Jean-Gérard Pailloncy wrote:
I do not have test numbers rigth now, because I need first to configure
the box for virtual hosting, then dspam.
It would be really wonderful if someone managed to combine this with
dspams own database. Maybe it'd be possible to pull dspam's algorithms
as a lib
Hello List,
Is it possible to import in a TIMESTAMP(6) field a timestamp in which
the format of hour is HH.MM.SS (and not HH:MM:SS) ?
In the documentation, at
http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-TIMEZONES,
I didn't find this format.
So can I think
am Thu, dem 01.02.2007, um 15:58:08 +0100 mailte DANTE Alexandra folgendes:
Hello List,
Is it possible to import in a TIMESTAMP(6) field a timestamp in which
the format of hour is HH.MM.SS (and not HH:MM:SS) ?
In the documentation, at
On Thu, Feb 01, 2007 at 10:24:51 +0900,
Paul Lambert [EMAIL PROTECTED] wrote:
If you hide the database username and password within your application
(i.e. encrypted within the source code) so they cannot see the
credentials that you connect to the database with internally then they
have
am Thu, dem 01.02.2007, um 16:13:28 +0100 mailte A. Kretschmer folgendes:
am Thu, dem 01.02.2007, um 15:58:08 +0100 mailte DANTE Alexandra folgendes:
Hello List,
Is it possible to import in a TIMESTAMP(6) field a timestamp in which
the format of hour is HH.MM.SS (and not HH:MM:SS) ?
Thank you Andreas, I had thought about this solution but in my case, it
is not really possible to do that...
I am converting an Oracle database to PostgreSQL 8.2.0 via ora2pg which
allows me to extract the tables, data, ...
The timestamp extracted from Oracle have the format DD-MON-YY
On Thu, Feb 01, 2007 at 09:33:59AM -0600, Hiltibidal, Robert wrote:
I am getting this error
You really need to take questions about compiling to the -general
list. I've put a Reply-To to that list, and have moved this
discussion there. Also, it's really not a good idea to send emails
to
I had installed the win32 version awhile ago, but I had the pg_hba.conf
set to trust. Then I started to test SSL on win32 so I changed it to this:
hostall all 127.0.0.1/32 md5
hostall all 192.168.15.131/32 md5 #my pcs adddress
And I ensured
I need some basic advice on how to run a subquery, or if there's a
better way. Let me set up a situation, and get some advice on it. This
is my first post on this list, so I hope this kind of noob question is
ok.
Say I have a table of customers and table of accounts receivable
transactions,
Hakan Kocaman [EMAIL PROTECTED] writes:
If you want to get the OUT-Params each as columns, you got to call it
this way:
=# select (public.check_notice(2,'hello')).*;
Try this way instead:
select * from public.check_notice(2,'hello');
regards, tom lane
Tony Caduto wrote:
I had installed the win32 version awhile ago, but I had the pg_hba.conf
set to trust. Then I started to test SSL on win32 so I changed it to this:
hostall all 127.0.0.1/32 md5
hostall all 192.168.15.131/32 md5 #my pcs
Question, I hope stupid, postgres user HAS a password right?
Yes, it has a password, I set the password from the installer, and I
even reset it after the install was complete.
I just tried this from the command line and it let me right in:
psql template1 -U postgres
Didn't ask for a
Shoaib Mir [EMAIL PROTECTED] writes:
On 2/1/07, Harvey, Allan AC [EMAIL PROTECTED] wrote:
I know the function is there.
What am I doing wrong?
To reduce clutter, \df does not show data type I/O functions. This is
implemented by ignoring functions that accept or return type cstring.
That
try this approach:
SELECT
c.id,
c.firstname,
c.lastname,
a.latest_billdate
FROM
customers c
INNER JOIN -- or LEFT if you want the NULLs
(
SELECT
customer_id,
max(billdate) as latest_billdate
FROM
ar
) a
ON
c.customerid = a.customerid
WHERE
c.status = 'new';
In response to Tony Caduto [EMAIL PROTECTED]:
Question, I hope stupid, postgres user HAS a password right?
Yes, it has a password, I set the password from the installer, and I
even reset it after the install was complete.
I just tried this from the command line and it let me right in:
I have a function like the follwoing:
CREATE OR REPLACE FUNCTION sp_insert_raw_email(bool, text, text, text,
int4,text,text,text,text,text,text,text,timestamp)
RETURNS void AS
$BODY$
BEGIN
-- SELECT STATEMENT GOES HERE--
INSERT INTO tbl_email(option_public,
agency , id)
VALUES ($1,$2) ;
END;
Bill Moran wrote:
Will only apply if you connect via loopback networking (which is not
psql's default). Try your connect command like this:
psql template1 -U postgres -h 127.0.0.1
and see if the results change.
Hi Bill,
Using the -h 127.0.0.1 does cause the password prompt to fire,
sorry, missing GROUP BY and some column naming was messed up but
hopefully you get the idea:
SELECT
c.id,
c.firstname,
c.lastname,
a.latest_billdate
FROM
customers c
INNER JOIN -- or LEFT if you want the NULLs
(
SELECT
customerid,
max(billdate) as latest_billdate
This works, I just need to run some checks and benchmarks.
What do you guys think?
SELECT c.customerid, c.regionid, c.districtid, c.first_name,
c.last_name, a.latest_bill_date
FROM customers c
INNER JOIN (SELECT max(bill_date) AS latest_bill_date, customerid,
regionid, districtid
Well, there is something weird going on here:
If I change the postgres users password to the one I used during install
I get this when using psql:
C:\Program Files\PostgreSQL\8.2\binpsql template1 -U postgres
DEBUG: InitPostgres
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState:
Demel, Jeff [EMAIL PROTECTED] writes:
Here's what I came up with:
SELECT customers.id, customers.firstname,
customers.lastname, customers.phone number,
(SELECT ar.billdate FROM ar
WHERE customers.customerid = ar.customerid
ORDER BY ar.billdate LIMIT 1)
AS
Tony Caduto [EMAIL PROTECTED] writes:
I just tried this from the command line and it let me right in:
psql template1 -U postgres
Didn't ask for a password or anything, and the localhost entry in
pg_hba.conf is also set for md5.
You sure you restarted the postmaster (or did pg_ctl reload)
Never mind,
somehow a application setup a pgpass.conf file for me
without my knowledge.
Sorry it's not a bug. However I wonder if it might be a good idea if
psql would raise a warning after logon that a pgpass.conf file was used
for authentication or have it written to the log.
I am sure
My application implements field and row level security.
I have custom table of users where user privileges are described.
However user can login directly to database using pgAdmin. This bypasses
the security.
How to allow users to login only from my application ?
I think I must
Tony Caduto wrote:
Never mind,
somehow a application setup a pgpass.conf file for me
without my knowledge.
Have you been leaving the dark side lately?
(pgAdmin does this..)
Sorry it's not a bug. However I wonder if it might be a good idea if
psql would raise a warning after logon that a
I want to know how many types of backup/restore options are in PGSQL. I use
VB.NET as front-end and want to schedule backup on time-basis from within
VB.NET. How can it be done?
Please suggest any link for more on Backups.
--
View this message in context:
Magnus Hagander wrote:
Have you been leaving the dark side lately?
(pgAdmin does this..)
I still have pgAdmin installed :-) it's a good reference tool.
I imagine you guys are using it for the pg_restore/pg_dump? There
really should be a pg_dump.dll and a pg_restore.dll so a pgpass
file
Hello,
I have what seems to be a massively complicated problem. If I were to
try to write it out, I think the description of it would go on for
pages. Before I go into it, I think I will ask a much simplified
version of my question and hopefully work my way out from there.
How can I index 2
On 2/1/07 10:42 AM, Carl Lerche [EMAIL PROTECTED] wrote:
How can I index 2 dimensional data (latitude / longitude) with a
status_id column too (integer) so that I can perform the following
query as fast as possible:
SELECT * FROM profiles WHERE status_id = 1 AND latitude BETWEEN
y_1
On Thu, Feb 01, 2007 at 10:42:30 -0800,
Carl Lerche [EMAIL PROTECTED] wrote:
How can I index 2 dimensional data (latitude / longitude) with a
status_id column too (integer) so that I can perform the following
query as fast as possible:
SELECT * FROM profiles WHERE status_id = 1 AND
Richard Broersma Jr wrote:
on the link:
http://www.postgresql.org/docs/8.2/static/rules-update.html
you will notice that from items are repeated. Is this correct?
...
FROM shoelace_arrive shoelace_arrive, shoelace_ok shoelace_ok,
shoelace_ok *OLD*, shoelace_ok *NEW*,
[EMAIL PROTECTED] wrote:
Say that your application offers a way for each user to set/change
his own password.
When I (using your application) change my password, you could
combine my new password with a secret value and then send the
result to the PG server (so now the PG server thinks
Tony Caduto [EMAIL PROTECTED] writes:
Is there a way to tell libpq in the connection string or something not
to use a pgpass.conf file? I looked in the libpq docs but didn't really
see anything.
Making pgpass files harder or more annoying to use does not strike me as
a good idea. I realize
--- Original Message ---
From: Tony Caduto [EMAIL PROTECTED]
To: Bill Moran [EMAIL PROTECTED]
Sent: 01/02/07, 17:13:25
Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32
Bill Moran wrote:
Will only apply if you connect via loopback networking (which is not
Dave Page wrote:
Could this be proof of you using pgAdmin ( :-) ) and checking the Store
Password option? That'll save it in pgpass.conf in your profile.
/D
I won't deny I have it installed :-) I don't remember using the stored
password option though.
Do you also use that for the
--- Original Message ---
From: Tony Caduto [EMAIL PROTECTED]
To: Magnus Hagander [EMAIL PROTECTED], pgsql-general@postgresql.org
Sent: 01/02/07, 18:38:22
Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32
I imagine you guys are using it for the pg_restore/pg_dump?
--- Original Message ---
From: Tony Caduto [EMAIL PROTECTED]
To: Dave Page [EMAIL PROTECTED]
Sent: 01/02/07, 20:17:00
Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32
I won't deny I have it installed :-) I don't remember using the stored
password option though.
Say that your application offers a way for each user to set/change
his own password.
When I (using your application) change my password, you could
combine my new password with a secret value and then send the
result to the PG server (so now the PG server thinks that my
--- Original Message ---
From: Tony Caduto [EMAIL PROTECTED]
To: Dave Page [EMAIL PROTECTED]
Sent: 01/02/07, 20:37:18
Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32
Dave Page wrote:
A non-admin user wouldn't necessarily be able to edit it, and it would be
Hello All,
it was recently brought to my attention that last year the U.S. altered
the dates when Daylight Savings Time starts and ends. Many if not most
computers presume the old change dates and therefore, if left to change
automatically, will change at the wrong times. This will be vital for
On Thu, 2007-02-01 at 15:15, Richard Troy wrote:
Hello All,
it was recently brought to my attention that last year the U.S. altered
the dates when Daylight Savings Time starts and ends. Many if not most
computers presume the old change dates and therefore, if left to change
automatically,
Is there a way to tell the libpq connect function not to use a pgpass
file?
No, as Tom already said.
I think you could effectively disable the pgpass file (for a given
application) if the application always requires an explicit, non-blank
password from the user.
libpq won't use .pgpass
Richard Troy [EMAIL PROTECTED] writes:
I've never investigated how NTP servers handle DST changes - that is,
I'm pretty sure that NTP runs strictly in UTC. They're more interested
in leap seconds than DST changes ;-). Your NTP clients will still know
what time it is UTC; whether they can
[EMAIL PROTECTED] writes:
I think you could effectively disable the pgpass file (for a given
application) if the application always requires an explicit, non-blank
password from the user.
If he does that, his users who do not use password-based authentication
will be after him with the
I think you could effectively disable the pgpass file (for a given
application) if the application always requires an explicit, non-blank
password from the user.
If he does that, his users who do not use password-based authentication
will be after him with the proverbial villagers'
--- Original Message ---
From: Tony Caduto [EMAIL PROTECTED]
To: Dave Page [EMAIL PROTECTED]
Sent: 01/02/07, 21:18:49
Subject: Re: [GENERAL] I might have found a bug on 8.2.1 win32
I may be forced to start deleting the pgpass file unless we can work
something out.
I must Be
Thanks a lot for your reply. To make it more clear will the be no loss of data
or data corruption when taking a base backup while there is inserts updates
happening in the database?
--
Roopa
Richard Huxton dev@archonet.com wrote:
roopa perumalraja wrote:
Hi all,
While there are
Bruno Wolff III wrote:
On Thu, Feb 01, 2007 at 10:24:51 +0900,
Paul Lambert [EMAIL PROTECTED] wrote:
If you hide the database username and password within your application
(i.e. encrypted within the source code) so they cannot see the
credentials that you connect to the database with
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 03:02, roopa perumalraja wrote:
Hi all,
While there are inserts updates happening into the database, is
it possible to make the base backup without losing any of the
updates in the database?
pg_dump does transactionaly-consistent
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 15:15, Richard Troy wrote:
Hello All,
it was recently brought to my attention that last year the U.S. altered
the dates when Daylight Savings Time starts and ends. Many if not most
computers presume the old change dates and
Thank you all,
I know the function is there.
What am I doing wrong?
Talking to a 8.2.0 server with a 7.4.5 client.
Sorry for the noise, I sometimes get lost on which versions I have where
of this wonderful software.
Allan
The material contained in this email may be confidential, privileged
Open-database file-level backups might work with PITR, but I
wouldn't trust it.
IME, it does work, and very well. Inconsistencies in the heap files are
trumped by the WAL archive during recovery.
-Glen
---(end of broadcast)---
TIP 2: Don't
On Thu, Feb 01, 2007 at 12:38:22PM -0600, Tony Caduto wrote:
Magnus Hagander wrote:
Have you been leaving the dark side lately?
(pgAdmin does this..)
I still have pgAdmin installed :-) it's a good reference tool.
:-)
Is there a way to tell libpq in the connection string or
I'm curious. How do you feel about having a scrambling algorithm
embedded in your application, but having the scrambled password publicly
readable in a config file? Does that seem secure? This is what you
have to do if you want your users to connect to different databases
choosing their own
I just wanted to say thanks to everyone for your help.
-Jeff
This email is intended only for the individual or entity to which it is
addressed. This email may contain information that is privileged, confidential
or otherwise protected from disclosure. Dissemination, distribution or copying
of
On Thu, 2007-02-01 at 16:40, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 15:15, Richard Troy wrote:
Hello All,
it was recently brought to my attention that last year the U.S. altered
the dates when Daylight Savings Time starts and ends. Many if not
On Thu, Feb 01, 2007 at 09:53:26PM -, Dave Page wrote:
Not to mention that the whole pgpass thing is a huge security hole, it
would be different if the passwords where encrypted or hashed, but they
are just sitting there in plain text.
In an 0600 file on *nix, or in your profile on
On Thu, Feb 01, 2007 at 02:17:00PM -0600, Tony Caduto wrote:
Dave Page wrote:
Could this be proof of you using pgAdmin ( :-) ) and checking the Store
Password option? That'll save it in pgpass.conf in your profile.
/D
I won't deny I have it installed :-) I don't remember using the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 16:27, Glen Parker wrote:
Open-database file-level backups might work with PITR, but I
wouldn't trust it.
IME, it does work, and very well. Inconsistencies in the heap files are
trumped by the WAL archive during recovery.
Tarring
Mark Walker wrote:
I'm curious. How do you feel about having a scrambling algorithm
embedded in your application, but having the scrambled password publicly
readable in a config file? Does that seem secure? This is what you
have to do if you want your users to connect to different databases
Tarring hot database files still gives me the willies. But then, I
wear belt and suspenders.
I understand. A list of file changed while we read it errors is just
a little unnerving at first!
I did quite a few end to end backup/PITR tests, and no matter what I did
to the DB during backup,
OK, I've thought about this a bit more and have come to the conclusion
that storing the password locally in any way is completely insecure.
Here are simple ways of hacking it:
1. If you use libpq in a shared lib(dll, etc). Replace PQconnectdb with
your own version, rebuild and use your new
Glen Parker [EMAIL PROTECTED] writes:
Tarring hot database files still gives me the willies. But then, I
wear belt and suspenders.
I understand. A list of file changed while we read it errors is just
a little unnerving at first!
I did quite a few end to end backup/PITR tests, and no
Dave Page wrote:
I must Be missing the point - why should I work something out with your app for
using a documented feature of libpq in pgAdmin?
Dave,
The whole point is pgAdmin III is storing the password in the pgpass
file which is global for every single application that uses it,
Mark Walker wrote:
OK, I've thought about this a bit more and have come to the conclusion
that storing the password locally in any way is completely insecure.
Here are simple ways of hacking it:
1. If you use libpq in a shared lib(dll, etc). Replace PQconnectdb with
your own version,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 18:04, Glen Parker wrote:
Tarring hot database files still gives me the willies. But then, I
wear belt and suspenders.
I understand. A list of file changed while we read it errors is just
a little unnerving at first!
I did quite
I've a postgres statement that reads:
CREATE TABLE channel (
chanid int NOT NULL default '0',
channum varchar(10) NOT NULL default '',
freqid varchar(10) default NULL,
sourceid int default NULL,
.
.
.
PRIMARY KEY (chanid),
KEY channel_src
sqldetach, is there some equvivalent to this command in postgres, or
is it just to close the connection $CLOSE database when I have
forked? I porting from informix to postgresql, eqsl this is what I
have left...
/M
---(end of broadcast)---
TIP 1:
Thanks for moving this to the correct list
Any ideas? Requested info is below.
To begin with, what gcc version are you using?
I am using the GCC packaged by
http://aixpdslib.seas.ucla.edu/packages/gcc.html
My AIX level is
# oslevel -s
5200-09-03
# gcc -v
Using built-in specs.
Target:
I'm trying to append new text on a field using the concat function.
On the Set statement I use something like this:
Set Field = Concat(Field,'ABC')
And when I check the results 'ABC' wasn't appended to Field. What
should I do to make it append?
---(end of
Jim C. [EMAIL PROTECTED] writes:
I've a postgres statement that reads:
CREATE TABLE channel (
chanid int NOT NULL default '0',
channum varchar(10) NOT NULL default '',
freqid varchar(10) default NULL,
sourceid int default NULL,
.
.
.
PRIMARY KEY (chanid),
On 1/29/07, Andrus [EMAIL PROTECTED] wrote:
My application implements field and row level security.
I have custom table of users where user privileges are described.
However user can login directly to database using pgAdmin. This bypasses
the security.
How to allow users to login only from my
How is FireBird rated when compared with PostgreSQL?
--
View this message in context:
http://www.nabble.com/PostgreSQL-FireBird-tf3158857.html#a8761237
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 19:02, Jim C. wrote:
I've a postgres statement that reads:
CREATE TABLE channel (
Do you *need* object names to be case-sensitive?
If not, it's a bad habit to get in to. Makes more work for you and
the developers.
chanid int
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 21:31, RPK wrote:
How is FireBird rated when compared with PostgreSQL?
Rated?
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFFwrSGS9HxQb37XmcRAj+lAJ9uFM+hNm+ink5SeOaaNRjCuASMaACgiBeE
PmhLjdXNwlPKRHHYpGuK+c4=
On 2/1/07, RPK [EMAIL PROTECTED] wrote:
How is FireBird rated when compared with PostgreSQL?
I don't know how it is rated, but honestly I looked at Firebird and it is
way too quirky and I could never get it to compile embedded. The
documentation is very very poor for that project when it
firebird is a 7.3 and postgresql is a 9.7
On 2/1/07, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/01/07 21:31, RPK wrote:
How is FireBird rated when compared with PostgreSQL?
Rated?
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
On Thu, Feb 01, 2007 at 05:03:43PM -0800, d wrote:
I'm trying to append new text on a field using the concat function.
On the Set statement I use something like this:
Set Field = Concat(Field,'ABC')
And when I check the results 'ABC' wasn't appended to Field. What
should I do to make it
85 matches
Mail list logo