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 . What
> should I do to make i
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 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
-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=
=v
-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.
> "chan
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 broadcast)-
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
"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,
> .
> .
> .
> P
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 . What
should I do to make it append?
---(end of broadcast)
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: po
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:
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_s
-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
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, rebuil
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, do
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, a
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 d
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,
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
-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.
Tar
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 remembe
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 prof
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. Man
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
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
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 s
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 'k
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
-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 there
-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-consist
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 intern
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 wrote:
roopa perumalraja wrote:
> Hi all,
>
> While there are inserts & updat
> --- 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 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 villager
<[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 pro
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 con
> > 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 .p
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
> automatical
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
p
> --- 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 w
> > 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: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 opt
> --- 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/
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 pg_resto
> --- 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 (whic
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 rea
<[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
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*,
>
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
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
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 dime
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
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:
http://www.nabble.com/PGSQL-backup-type
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
> >> 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 ?
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 some
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)
"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 l
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\bin>psql template1 -U postgres
DEBUG: InitPostgres
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState:
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
FRO
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
FROM
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, howeve
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;
$B
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 rig
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';
"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 cstrin
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 passwor
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 addd
"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
-
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, The
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
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 ind
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
HH.MI.SSX
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
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
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
> http://www.postgresql.org/docs/8.2/interactive/d
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 tha
> 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
> a
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
"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 e
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 int
> 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 databa
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?
Yes, that's the whole point of PITR. The filesystem backup + WAL files
gives you a working database when re
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
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 \df+
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
--++--+-
86 matches
Mail list logo