ple can
only change their own passwords and that only the super-user can change
other peoples' passwords.
5. If passwords are turned on, the -u option must be supplied to psql. If
it is not, psql merely says "Connection to database '' failed.". A
more
gins
'pg:') that is failing.
Run the failing command in an ordinary window to find out what is going
wrong.
If you are not the system administrator, you should pass the problem to
him.
Read the man page on init, to understand what it does.
--
Oliver Elphick
nohup postmaster -o -e -d 2 >> /var/log/postgres.log 2>&1 &
Look at the end of /var/log/postgres.log immediately after a failure to get
an indication of what happened.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
uess I should rebuild postgres with debug info and report the backtrace?
Remember you can also use gdb (or ddd, which is nicer) to attach to a
running process.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/olive
h rules.)
If that would be useful, I'll send you the patch. (If you have already
deleted your old database, it will be of no use to you, because you
will have to install 6.3.2 to use it.)
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
rc: Permission denied
It is bash that is complaining - apparently about the .bashrc in your own
home directory.
Do `su - root' rather than just `su' and try again.
--
Oliver Elphick
ministrator's Guide? (doc/admin.ps.gz) There are also
extensive comments in pg_hba.conf.
Also: `man create_user' and `man alter_user'
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.
even tried modifying
>using my server's ip but still user authentication failed.
>
>what should be the problem with this?
Have you restarted the postmaster after editing pg_hba.conf?
Have you created a password for yourself before trying to connect
using password aut
rence to `crypt'
Newer releases of glibc separate out the crypt library. Just add -lcrypt
to your link options.
--
Vote against SPAM: http://www.politik-digital.de/spam/
========
Oliver Elphick[E
ik-digital.de/spam/
============
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
"I beseech
runs out of space. You need to find where the error is
occurring and correct the dump script.
--
Vote against SPAM: http://www.politik-digital.de/spam/
====
Oliver Elphick[EMAIL PROTECTED]
Isle
cp /var/lib/pgsql/db.bak
/var/lib/pgsql/db.bak.old
so that the copy takes place immediately upon the successful completion of
pg_dumpall.
--
Vote against SPAM: http://www.politik-digital.de/spam/
Oliver Elphick
working.
So edit Makefile.PL and use explicit paths instead of $POSTGRES_HOME/...
then recompile DBD
--
Vote against SPAM: http://www.politik-digital.de/spam/
====
Oliver Elphick[EMAIL PROTE
nts to find the include files and the libraries.
--
Vote against SPAM: http://www.politik-digital.de/spam/
====
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/ol
".
But the PGDATA directory itself has permissions rwx--, so only the
postgres superuser can access any files under it. So, in fact, there is
not a problem.
--
Vote against SPAM: http://www.politik-digital.de/spam/
==
# environment variables
if [ -z "$user" ]
then
dblist=$(psql -t -c "select datname from pg_database order by datname" -d
template1)
else
dblist=$(psql -u -t -c "select datname from pg_database order by datname" -d
template1 <
V
oney datatype.
This uses the current locale (IF postgresql was compiled with locales
enabled - I don't know if the RPMs were). Do `export LANG=en_GB' in the
script that starts the postmaster.
--
Vote against SPAM: http://www.politik-digital.de/spam/
Brad Emerson wrote:
>
>Can anyone tell me how to add users to pg_shadow?
CREATE USER
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32
"Oliver Elphick" wrote:
>Brad Emerson wrote:
> >
> >Can anyone tell me how to add users to pg_shadow?
>
>
>CREATE USER
I tried to cancel this, because it seems far too simplistic;
presumably you already know about CREATE USER.
Are you finding t
ser, postgres assumes you want
your eponymous database, unless you tell it different. So tell it
you want to connect to template1.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
entation,
which I have never seen; of course, the normal PostgreSQL frontend is
psql, not postgres. I think psql[.exe?] is what you should be running.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
eans we are supposed to have the right
>to
>create databases and users).
Have you installed PostgreSQL yourselves, or are you using a Debian package?
If Debian, which version?
Oliver Elphick
Debian maintainer for PostgreSQL
--
Oliver Elphick[E
any suggestions?
PostgreSQL identifiers are case-insensitive (forced to lowercase) unless
they are enclosed in double quotes. If your export routines are putting
out double-quotes around identifiers, get rid of the quotes.
--
Oliver Elphick[
user dan nocreatedb;
ALTER USER
junk=> \connect - dan
connecting as new user: dan
junk=> create table (id integer);
CREATE
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
P
[EMAIL PROTECTED] wrote:
>Also I'd like to know if simple foreign keys are implemented in PostgreSQL
>6.5.3?
use refint from contrib/spi
It isn't as flexible and convenient as the RI that's built into 7.0, but it
will do most of the job
CREATEDB ] [ CREATEUSER | NOCREATEUSER ]
[ VALID UNTIL 'abstime' ]
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP key fro
# update pg_user set usesuper=true, usecatupd=true where
>usename='mtluser';
>UPDATE 0
>
>Why I can't do it?
pg_user is a view; you should be updating pg_shadow
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
I make it to run when I start my Linux
>server?
Define a script under /etc/rc.d (I think that's right for Red Hat).
Look at the documentation for init for a description of what happens
at boot time.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
st with
>the count of how many folks are using it so we know how many brains are
>working on it if we run into a snag.
Well, I do, of course!
There are 8 Debian maintainers who have offered to help me by forming
a Debian maintainers team for PostgreSQL; this is just getting off
l not build if Tk/Tcl support is not present.
This should not stop the rest from building.
What is the error?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47
ntain something like:
local0.* -/var/log/postgresql
You may want to change this to be more selective...
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39
s in a database belong to the PostgreSQL user who
creates the tables.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1
systems but don't know
>the details. (Any help out there?)
Linux kernel 2.4 supports Logical Volumes. As in HP/UX, this enables a
logical partition to be assembled from multiple partitions on multiple
disks.
I haven't tried it yet, though.
--
Oliver Elphick
y
>use a different program to start (pg_ctl):
>
>su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster
>start >/dev/null 2>&1" < /dev/null
pg_ctl has a -o option to send options to the postmaster, so you should
b
You are probably still picking up 6.5.3's libpq.so; you need to set
LD_LIBRARY_PATH to point to where you have the shared library from
your own build. Or remove the libpgsql2 package.
There are, in fact, Debian packages of 7.0.3 for potato. See the pointer
in http://www.debian.org/~elphick/
the script as it is executed.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5
"Oliver Elphick" wrote:
>Silky Mittal wrote:
> >Dear Sir,
> > We are running Linux 6.2 on our machine.
>
>That is horribly old, full of bugs and sadly lacking in features.
Oh no; I read that as PostgreSQL 6.2.
But Linux 6.2 is a misnomer any w
T
w -- UPDATE/DELETE
a -- INSERT
R -- RULE
arwR -- ALL
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97
priya subramaniam wrote:
>Hi All,
>
>I am getting 'too many files open' in postgres
>terminal and I am unable to run the programs. What do
>I do?
Increase the operating system limit on the number of files open per user,
or the number of files open across the
comments in pg_hba.conf and alter it to suit your desired access
policy.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D
"Oliver Elphick" wrote:
> >I use pgaccess and I have created new users with password
...
>Access control is defined by the text file pg_hba.conf. The default setting
>in this file is
>
> local all trust
>
>which means that anyone on the local m
blank in the connection dialog; pgaccess will then
use Unix sockets instead of TCP/IP. localhost is a TCP/IP hostname.
This is not specific to pgaccess; if PGHOST is in your environment and not
empty, any connection to the postmaster will use TCP/IP unless overridden.
--
Oliver Elphick
"Prashant Sinha" wrote:
>I am a new postgre user. I had used sql commands to create database and tab=
>les. Is it possible to create a script or installable version on existing d=
>atabase which I could run on any machine and it would crearte the database =
>with all the tables and everyth
right to create schemas and temporary tables in the
database.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E
x27;GRANT ALL PRIVILEGES ON ' || c.relname || ' TO that_user;' from
pg_catalog.pg_class AS c LEFT JOIN pg_catalog.pg_namespace AS n ON n.oid
= c.relnamespace where relkind = 'r' AND n.nspname NOT IN ('pg_catalog',
'pg_toast') AND pg_catalog.pg_
hether you meant it or not, your initial comment came across as
> patronizing.
Sorry about that.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0
On Wed, 2005-08-24 at 11:50 +0530, sandhya wrote:
> Hi,
> Is there any equivalent command for '\d tablename'.
> Inorder to get the table structure is there any SQL query in postgres?
>
use psql -E to see the SQL commands that are used to implement \d and
other such command
other, the locks will never
be released by the transactions that are holding them. After a preset
interval (about 1 second by default) a deadlock is detected and reported
with this error message and one of the transactions is aborted.
See manual section 12.3.3 in
is its provenance?
It's a standard part of Debian, from the package initscripts.
The default policy is to clean out /tmp at boot. This can be varied by
changing TMPTIME in /etc/default/rcS.
--
Oliver Elphick olly@lfix.co.uk
Isle of Wight
them.
Your packaging will need to be redone on each flavour of rpm and again
for Debian-based distributions.
Oliver Elphick
---(end of broadcast)---
TIP 6: explain analyze is your friend
. Once the dump is loaded into the new database and working OK,
the old directory and software can be deleted.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A
ostgresql.conf.
When you connect to the server (with psql or another frontend) you
specify the correct port for the server you want.
psql -p 5433 -d mydatabase
or
export PGPORT=5433
psql -d mydatabase
--
Oliver Elphick[EMAIL PROTECT
ple to have their own separate database structures,
which could be subject to disk quotas; they will not want to queue up to
use them, will they?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D
ome
editing, but I estimate that to be less of a cost overall.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8
policy.
> Now I am not a DBA, but I have been around enough databases to know
> that most of them have their own system tables. Does postgres have
> system tables? If so, where do I find a list of them and their
> usage?
They are in the documentation.
In psql, the command \dS
On Fri, 2003-11-21 at 02:45, Leif K-Brooks wrote:
> I just installed PgSQL and PhpPgAdmin with apt-get on Debian. How do I
> login to PhpPgAdmin, since I have no idea of the login information?
/usr/share/doc/phppgadmin/README.Debian
--
Oliver Elphick
l, then make, then install make - or is there
> another way to do this?
That is what you have to do.
> Will this create a pgtclsh.so file in the lib directory?
It creates an executable "pgtclsh"
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
lib/pgsql/data/postgresql.conf the logging stopped completely. Works with
> local0 though. Anyhow
The log-levels (panic,...info,...local0,...) are enumerated values
hardcoded in syslog; pgsql is not one of those, so syslog would not
recognise it or act on it.
--
Oliver Elphick
rows anymore which
> is pretty bad. I had a look at the backup-file, the data is still
> there. Do I have any chance to recover the data? Perhaps by
> manipulating the backup file?
Eidt the backup file first (since you have the line numbers in it) to
correct the err
status
> make: *** [aa] Error 1
These are link errors. You need to add -lpq to the link command line
(and possibly -Lpath for the libpq library path as well).
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/
02986aa9e7d82b4fae1dc postgresql_7.4-0.woody.1.tar.gz
ce3fa832028e16dd8e2593a290b12c25 postgresql_7.4-0.woody.1_i386.changes
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C
Warning: This message has had one or more attachments removed
Warning: (the entire message).
Warning: Please read the "LFIX-Attachment-Warning.txt" attachment(s) for more
information.
This is a message from the MailScanner E-Mail Virus Protection Service
--
utput error suggests that you urgently need a new disk.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5
hing already
done in the whole transaction. A function must be entirely inside a
transaction and cannot start a transaction, so there can never be any
problem about this.
Within a transaction, you cannot see data committed by any _other_
transaction that had not already committed when your transact
On Sun, 2004-01-25 at 16:31, V i s h a l Kashyap @ [Sai Hertz And
Control Systems] wrote:
> Dear Oliver Elphick ,
> > > If I am not wrong PostgreSQL select statements works on committed data
> > > thus the new
> > > inserted data at #3 must not be ava
On Thu, 2004-06-03 at 12:01, lise chhay wrote:
> - I've a problem when I launched the command psql testdb. I get a error message :
> psql:relocation error: psql : undefined symbol : PQgetSSL
When you build PostgreSQL, you need to add --with-openssl to the
configure command.
Oli
M]Please fix the problems and try again.
This is not relevant. Add:
stats_row_level = true
in /etc/postgresql/postgresql/conf
Autovacuum needs those statistics to work out what to vacuum.
--
Oliver Elphick [EMAIL
ne in postgres?
>
> Yes, it's possible with PostgreSQL.
>
> See contrib/dblink.
But a more convenient alternative is to use schemas, which MySQL does
not (I think) support.
Oliver Elphick
---(end of broadcast)---
TIP 2: you can get
xpression
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
"God i
mes from
> table_names. I tried:
>
> select * from (select name from table_names where id=1) as something;
>
> but i received only:
>
> table_names
> --
> table1
> (1 row)
>
> And i wanted to receive everything from table1.
>
> How c
#x27;,'v','S') AND
n.nspname NOT IN ('pg_catalog', 'pg_toast') AND
pg_catalog.pg_table_is_visible(c.oid)
ORDER BY n.nspname, c.relname;
\o
\i /tmp/grant.sql
The above could be put in a script and run from a Unix comma
restarted/signalled the postmaster after changing
postgresql.conf?
Oliver Elphick
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
On Fri, 2004-07-23 at 13:36, Terry Hampton wrote:
>
> Everyone,
>
> Just ran across an odd situation.
> I have defined a field:
>
> amount | money| not null default ''
>
> Works fine until the dollar amounts get
> very large - into the
RESTRICT,
...
);
This says that if the foreign key field changes its value in table the
corresponding value in other_table should be changed too. If an attempt
is made to delete the value in table when it is referenced by any rows
in other_table, the del
On Tue, 2004-08-24 at 17:36, Eduardo S. Fontanetti wrote:
> I am using pg_dump.
>
> It means that I can't restore to a different name
> database??
If you use pg_dump[all] without other options it will dump to a text
file. Just edit the database name.
-
e person who deleted or changed the
> record in my BackUp (undo) table...
CURRENT_USER will give you the user id; if that's what you mean.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wi
he database, to restrict it to a user of
the same name as the database.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7
On Thu, 2004-09-16 at 15:09, "Lic. Guillermo González" wrote:
> Hi,
>
> I would like to know if there is a script or software that can bring me
> information about the connections on my PostgreSQL databases.
select * from pg_stat_activity
004 07:59:12
-
Date: 10 Nov 2004 07:59:12 -
Message-ID: <[EMAIL PROTECTED]>
To: List <[EMAIL PROTECTED]>
Subject: [ADMIN] These Lists Are Being Cut To FOUR
From: Mike Cox <[EMAIL PROTECTED]>
lidya.net is a Turkis
On Wed, 2004-11-10 at 12:15 +0200, Ivan Dimitrov wrote:
> Yes, it is there
> 127.0.0.1localhost
> but when i strace postmaster on startup it never looks in /etc/hosts
Look at the "hosts:" line in /etc/nsswitch.conf. It needs to have the
word "files"
\a
\o /tmp/sqlscript
SELECT 'GRANT SELECT ON ' || schemaname || '.' || tablename ||
' TO PUBLIC ;'
FROM pg_tables
WHERE tableowner = CURRENT_USER;
\o
\i /tmp/sqlscript
--
Oliver Elphick
the postgres user at some stage?
Then the hard-coded sysid in the installation would orphan user-created
functions when the database was upgraded.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/3
[EMAIL PROTECTED] wrote:
>pg_hba.confg?
>
>My Postgresql is unable to read the one which i have.
Do give more details than that! What is the error?
Spelling? It is pg_hba.conf
If you have that, are the file permissions right? Is the file in the
right place?
--
Olive
nda:.../debian$ sudo du -s $PGDATA/base/12585534
Password:
1831/usr1/postgres/data/base/12585534
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC
x27;PGDATA2' not set
>
>despite it being set, obviously. Trying to SET it again from within psql
>resulted in being told that 'pgdata2' was not a valid option name.
Was it set and exported in the postmaster's environment?
--
Oliver Elphick
ALTER USER.
Passwords do not take effect unless pg_hba.conf is set up to use them. If
it is, and you have not assigned a password to postgres, you will not be
able to connect as postgres.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
g/~elphick/postgresql
Alternatively, get the source package of 7.1.3-4 and build it yourself.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D
ety into every new database when it is created. (And
so the rest of the advice is redundant, too.)
A better choice is to run the regression tests and use the regression
database for your experiments, since it will have a lot of tables
already containing data.
--
Oliver
at least, configures
PostgreSQL with locales and multibyte, which make it more useful to
international community but which slow it down to some extent.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D
The Debian packages of PostgreSQL 7.2 have now been installed in the
Debian archive (non-US unstable).
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A
any table
'less' is a pager program, like 'more' but with more capabilities. Just
tell psql to use a different pager:
$ PAGER=more psql ...
or install 'less'.
According to the psql man page, 'more' is used by default, but this no
longer seems to be the case
m src/backend/utils/misc/guc.c, if you want
confirmation.)
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Let your light s
using.) locale must be set
correctly for initdb, to ensure that indexes don't get broken by changes
of locale.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 887
> Is it possible to change this after you've run initdb?
No. You have to dump the database, destroy everything, do initdb again
(with locale set correctly) and reload from your dump.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
de followed by a
country code and an optional supplement.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Why are you downcast,
ithout amendment.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Why are you downcast, O my soul? Why so disturbed
wit
)
> ||/ Name VersionDescription
> +++-==-==-
> ii postgresql 7.1.3-7Object-relational SQL database, descended fr
7.2.1 is available in Debian unstable.
It might be better to run tests on the latest
er this
adequately protects real UTF-8 characters that may be mingled in the
data. I suppose the alternative is to run a Perl script to check for
high-bit characters that are not valid UTF-8 for characters below
0x1.
--
Oliver Elphick[EMAIL PROTECTED]
Isl
affected by other users at all.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
"Therefore being justified by faith, we
^^
You should probably be using COALESCE() here.
The string concatenation operator is not + but ||
All those capital letters will be folded to lower-case. If you have
actually created things in the database whose names contain capitals,
you will need to enclo
1 - 100 of 139 matches
Mail list logo
