Hello List, I am setting up Postgres 9.6 for streaming replication. The OS is Solaris X86 I downloaded the postgres solaris binaries from the Postres site and installed on 2 instances of Solaris 10. I then used pg_dumpall to load the master server with data from our devel0pment server. That
will return the correct value only in the usr login. The question then is if postgres is running as usr postgres how does it know the value of LD_LIBRARY_PATH. Isn't there another place where it must be set?Regards,Rich Rutkowskir...@salepointdata.com
Original Message
S
beginning to suspect there is a problem with the binary that I downloaded from the postgres site. When I execute ldd -r /usr/postgres/9.6-pgdg/lib/libpqwalreceiver.so there are many symbols not found. I do not know what to make of it just yet. I did reinstall.Regards,Rich Rutkowskir
r each of many permits.)
Table 'Monitoring': Contains columns for date, location, parameter,
quantity, and other attributes. FK references permit number. (Many rows for
each permit.)
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
r each of many permits.)
Table 'Monitoring': Contains columns for date, location, parameter,
quantity, and other attributes. FK references permit number. (Many rows for
each permit.)
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
s
straight. I'll ponder this and make sure I set the proper FKs on the
appropriate tables.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
feed the
conditions table (where additional attributes are added), then a row from
that table is added to the monitoring table where quantities and other
attributes are entered.
Sometimes we get so deep in a rut we can't see over the edge and find the
correct path.
Thanks very much,
Rich
-
tcp_keepalives_count = 5
I don't see the disconnect problem for long-running queries that use a local
database connection.
Any advice on what might be causing remote database connections to drop
after 12 hours (and how to work around the issue)?
Kind regards,
Rich
I am using the default TIMEOUTidle setting in stunnel so that seems plausible.
Thanks very much for pointing me in what sounds like the right direction!
Kind regards,
Rich
From: Steve Crawford [mailto:scrawf...@pinpointresearch.com]
Sent: Friday, August 21, 2015 6:25 PM
To: Rich
icker and easier.
Your thoughts?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
using Python3 and Phoenix.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ources to learn what I need; if there
are ways to better integrate postgres with PHP I'd certainly like to learn
about them.
As always, I look forward to learning from those who know more than I do.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
bin
directory now is; /usr/bin/postgres is a soft link to
/usr/lib/postgresql/9.4/bin/postgres. This suggests that I need to use
pg_dumpall, then read in the file using psql with the 9.4.5 version. I've
dumped all databases to a .sql file and am unsure how to proceed.
Clue stick needed,
Rich
do you suggest as the procedure for me to follow to clean this all
up?
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you verify that the new instance is running and you can connect to it
Not sure how I do this. Don't I need to kill the postgres-9.3.4 process
then start the -9.5.4 process?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
-d postgres -p 5442 -f your_dumpall.sql
In /tmp there's only
.s.PGSQL.5432=
.s.PGSQL.5432.lock
and since only 9.5.4 is now running that port should be available.
The above command failed when run as both me (as user owning/granted all
privileges on all databases) and as superuser postgr
"rshepard"
What was the error message?
As above.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-reading that file.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sun, 4 Sep 2016, Charles Clavadetscher wrote:
Does the user rshepard exist in the new 9.5 instance?
I assume so but do not know how to check this.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
paragraph of comments as
different. I'll try attaching them; they're ~100 lines each. If the
attachments are stripped off my the mlm I'll list them within the message
body.
Rich
# PostgreSQL Client Authentication Configuration File
# ===
ntion when I initially ran initdb I
used a commandline found on a web site (rather than just reading the man
page) and used the -W option which requires a password for everything. So
starting over from scratch _should_ remove all issues and successfully end
this thread.
Thanks,
Rich
--
Sen
hepard | UTF8 | C | en_US.UTF-8 | rshepard=CT
I did not recognize this as the answer to Charles' question.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ADIR
--locale=en_US.UTF-8 -A md5 -W\""
exit 6
fi
Note the '-W' at the end. But, I ran initdb from the command line as user
postgres.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
user postgres:
psql (9.5.4)
Type "help" for help.
postgres=#
So, it appears to be a password issue. Please advise me how to get the
running postmaster process to accept my accessing databases without a
password being required.
Thanks again,
Rich
--
Sent via pgsql-general mailing list
start does not work[1] I
stopped the process then restarted it. I can now access my databases and the
financial software via the browser UI.
Now I can remove the 9.3.4 directory and be comfortable that the next
upgrade will be smooth.
Thanks very much for your patient help!
Much appreciated,
fore set
a password specifically for postgresql. Since I'm the only user and the
trust authentification has worked for the same period, I'll leve it that
way.
Thanks for your help,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
system tables pg_user and pg_shadow:
https://www.postgresql.org/docs/9.5/static/catalogs.html
Adrian,
I did not know this. Thanks for the information.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
he URL you provided and add a password for
me, too.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
system tables pg_user and pg_shadow:
https://www.postgresql.org/docs/9.5/static/catalogs.html
I see the pg_user in Section 49.79 but don't know how to correctly
configure it. It seems that pg_shadow is unnecessary since I don't need to
provide compatibility with versions < 8.1.
R
with the authorization method set to md5 was because
the password field was missing.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, given my single-user situation do you think that I should ALTER ROLE
to add my password? Adding it to ~/.pgpass did nothing positive when I
changed auth method to md5; my attempt to open a database failed because
that password was rejected. Strange ... to me.
Rich
--
Sent via pgsql-general ma
t is not a mechanism for entering that information into
the database. So yes, you will need to use ALTER ROLE to create the
password inside Postgres.
OK. I'll try that for the learning experience.
So much to learn and so little time ...
Thanks,
Rich
--
Sent via pgsql-general mail
and I enter my username and password on the login
page. It works with auth method trust. I've no idea exactly how it connects
to the database. Since it ain't broke I won't futz with it and possibly
break it. I've other things with higher priorities.
Rich
--
Sent via pgsql-
On Wed, 7 Sep 2016, Patrick B wrote:
2 - I've never done a Postgres upgrade before, can you give some guide
here? Is usually a easy thing? How long can it take? Is a downtime needed?
Patrick,
I suggest the place to start is 'man pg_upgrade.' It is helpful.
Rich
--
Sent vi
open shared memory segment
"/PostgreSQL.1804289383": Permission denied
Not before encountering this problem I've no idea where to look to see how
to fix it. Please advise.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
sions
(755). Thanks to your response I remembered that chromium does not run until
I follow its advice to chmod 1777 /dev/shm. Sure enough, chromium would not
load.
So, I changed the perms on /dev/shm/ and now both postgres and chromium
work.
Very much appreciated,
Rich
--
Sent via pgsql-general ma
On Mon, 12 Sep 2016, Tom Lane wrote:
Hmm, AFAIK that's what it should be out of the box. Certainly on my RHEL6
machine I see
Until I make the time to upgrade this host from Slackware-14.1 to -14.2
the kernel is 3.10.17-smp.
Rich
--
Sent via pgsql-general mailing list (pgsql-ge
PostgreSQL.1804289383": Permission denied
Please advise me on how I proceed to clear this and restart the
application.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Fri, 30 Sep 2016, Adrian Klaver wrote:
See here:
https://www.postgresql.org/message-id/24208.1473724630%40sss.pgh.pa.us
Ah, shoot! I completely forgot about this. Yes, I reset the perms on
/dev/shm and that fixed the problem.
My apologies to all,
Rich
--
Sent via pgsql-general
On Fri, 30 Sep 2016, Tom Lane wrote:
Wrong permissions on /dev/shm, perhaps?
Tom,
Yes. I keep forgetting about this since I don't reboot this
server/workstation often.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
7;Cr' or
param = 'Cu';
If you point me to the appropriate page in the 9.5.x manual I'll figure it
out.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 27 Oct 2016, John R Pierce wrote:
CREATE TABLE newtable AS SELECT ...
https://www.postgresql.org/docs/9.5/static/sql-createtableas.html
Thank you, John.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
using (but suspect Oracle). My
web search used in-effective terms so I could not find the answer there.
What does U1 represent?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, 29 Oct 2016, Tom Lane wrote:
What does U1 represent?
Unique constraint, perhaps? I'm just guessing.
Tom,
That's my guess, too. I've not seen it used before now and did not know if
it's a standard code for something or one specific to this agency.
Thanks,
expressing my
search terms.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
do I look for the two bindirs?
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
re no /bin directories associated with postgres.
So, I'll go the pg_dumpall route then.
Thanks very much,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ake life easier.
Currently, only 9.5.4 is running; 9.6.1 is installed and initiated but not
running. When I invoke 'psql -l' I see the clusters installed in 9.5.4.
Will use pg_dumpall and pg_restore ... tomorrow morning.
Thanks very much,
Rich
--
Sent via pgsql-general mailin
On Tue, 15 Nov 2016, Adrian Klaver wrote:
Rich is using Slackware and I am pretty sure it marches to a different
drummer.
Adrian,
And a different band. Pat likes MariaDB which replaced MySQL so PostgreSQL
is not part of the base distribution. But, SlackBuilds.org provides a build
script
r/bin/pg_ctl ->
../lib/postgresql/9.6/bin/pg_ctl*
Aha! That's where the bin/ directories are. There's a 9.3.4/ and 9.5/
subdirectory there, too.
Will do a pg_dumpall and then run pg_upgrade.
Thanks, both of you. I learned valuable lessons,
Rich
--
Sent via pgsql-general mailing l
On Tue, 15 Nov 2016, Rich Shepard wrote:
$ /usr/bin/pg_ctl --version
pg_ctl (PostgreSQL) 9.6.1
ls -al /usr/bin/pg_ctl
lrwxrwxrwx 1 root root 32 Nov 15 14:16 /usr/bin/pg_ctl ->
../lib/postgresql/9.6/bin/pg_ctl*
To increase my understanding I want to resolve an apparent discrepancy
only list them, but access them from the command line. This is what
I'm trying to understand.
Regardless, I'll stop the running postgres, run pg_upgrade, then start it
from the /9.6/data/ directory.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
:)
Adrian, et al.:
Did a pg_dumpall and stored it with my database-backups. Now that I know
where to find the bin/ directories pg_upgrade ran flawlessly. Quick and
easy.
Thanks all,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription
oe Celko's
books; they're very helpful.
Only you and your client know just what's needed. This approach will open
your client to data/information they need that is not provided by their
current software and will provide you the basis for designing the postgres
schemas.
Rich
--
Sent
you'll need customer, invoice, line-item tables at the minimum. But
since I use it only to generate service invoices and post them to accounts
payable I don't know the details of how it works. I do use postgres
(currently -9.6.1) and httpd with it.
HTH,
Rich
--
Sent via pgsql-gene
efore being imported into Base?
All tips and gotcha's for a new user are certainly welcome.
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
My clients all run Windows about which I know nothing. Is there a GUI for
postgres that works on all platforms and suitable for someone like me?
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
over the past few years looking for a simpler
solution and they just don't exist.
I'll learn django and take it step-by-step.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
this for mine). I would provide some guidance on installing necessary
software, but it's theirs to use as they choose.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
at my clients use. Long ago I looked at flask; that might be worth a
second look. I'm also seriously looking at peewee, which is an ORM simpler
than SQLAlchemy, and the Phoenix toolkit for the UI.
Thanks very much,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
of the
time. But, I'll look again at the Python3 version called Phoenix and Peewee
(a lighter ORM than SQLAlchemy).
Sorry if I went off into left field on this.
That's fine. All ideas are always welcome.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general
On Mon, 5 Dec 2016, Johann Spies wrote:
Web2py is another (and maybe simpler) alternative to Django.
Johann,
Thank you. I'll look at it.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
in a stand-alone application
that can be packaged for easy installation and use by clients.
Thanks very much for your suggestions,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
tenance records, etc.
My thinking is to not store these documents in the database, but to store
them in subdirectories outside the database.
Your thoughts?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgres
On Tue, 6 Dec 2016, Joshua D. Drake wrote:
Due to the widely variable size of a PDF document, I would say no. I would
store the metadata and file location.
Joshua,
I read your answer as "don't store them in the database, but store the
location in a column."
Thanks for co
same as a bytea (page 217 of the
9.6 PDF manual), and I cannot find BLOB as a postgres data type. Please
point me in the right direction to learn how to store PDFs as BLOBs.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
On Tue, 6 Dec 2016, John R Pierce wrote:
indeed BYTEA is postgres's type for storing arbitrary binary objects that
are called BLOB in certain other databases.
John,
I thought so.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
I have used '-- ' to enter comments about tables or columns and am curious
about the value of storing comments in tables using the COMMENT key word.
When is the latter more appropriate than the former?
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
l see only the entire application.
Thanks for explaining,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
;ll read how to work with it.
Thanks very much for your insights,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 8 Dec 2016, Adrian Klaver wrote:
http://initd.org/psycopg/docs/usage.html?highlight=binary#adapt-binary
Thanks again, Adrian.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
much more pleasant to work with.
They're not referenced frequently, only occasionally.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
between the database back
end and the user interface, and a widget set (PyQt5 is a good one) for the
UI.
If you want to develop a web-based application then replace the UI with
django.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
rogramming, too), you'd be better off learning Python first and
looking beyond that only when you hit a dead end.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to make my CRM a stand-alone application.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
cade of wxPython use with
Python2 and am just about ready to start creating the UI.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
traint matching given keys for referenced
table "weather_params".
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
that what you wanted to put in Weather_Data is a two-column FK:
FOREIGN KEY (site_id, param) REFERENCES Weather_Params (site_id, param)
That would match Weather_Params' pkey, so it's enough to identify a
unique row of Weather_Params.
Thanks, Tom. Yes, I do want a 2-colum
'City',...
^
Having a default value or a named constraint makes no difference, and the
maximum size of the org_lvl column is that of the longest string so I am not
seeing the source of my error.
Where, other than Section 5.3.1 of the manual can I learn why
mples in 5.3.1 have a "(" following the word CHECK as well...
Yes, I see now that I misplaced the opening parenthesis and missed the
second closing parenthesis at the end of the IN list.
I thought I had tested this syntax; obviously I did not.
Thanks,
Rich
--
Sent via pgsql-
ed on each table's schema?
TIA,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ach work for you?
Greg,
I work in Python, not Ruby, so this might be too big of a hurdle.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
streets, etc.
Steve,
Thanks very much for the URL. One application is small (7 tables), the
other is three times that size (23 tables). If I need to find public domain
data on the Web, I'll do that.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
neric
data of the appropriate types myself.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, 27 Dec 2016, Adrian Klaver wrote:
As it happens there is a Python version of the a fore mentioned faker:
https://pypi.python.org/pypi/Faker/0.7.7
It was I use to generate fake/sample data.
Adrian,
Aha! That's a great start for me.
Many thanks,
Rich
--
Sent via pgsql-ge
On Tue, 27 Dec 2016, Adrian Klaver wrote:
As it happens there is a Python version of the a fore mentioned faker:
https://pypi.python.org/pypi/Faker/0.7.7
Adrian,
Impressive and complete. It will generate all the data I need.
Many thanks,
Rich
--
Sent via pgsql-general mailing list
en I get the large database application
up and running I'll post it on github and turn it loose into the F/OSS world
under the GPL.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ails.
HTH,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nd my wishes for a healthy, happy, and
prosperous 2017 to you and all who responded to my question,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I can test as I
develop.
Happy new year to you,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 29 Dec 2016, Nicolas Paris wrote:
Hi I'd like to tell about Sql Power Architect
Nicholas,
SPA was going to be my next re-examination after dbeaver. Since the latter
easily accomplished what I needed I stopped there.
Thanks for the reminder,
Rich
--
Sent via pgsql-ge
On Thu, 29 Dec 2016, Guyren Howe wrote:
I would like to find a book or other resource about SQL server-side
programming (stored procedures etc) best practices in general and for
Postgres in particular.
Start here:
<http://www.postgresqltutorial.com/postgresql-stored-procedures/>
Reading the 9.6 docs suggests an answer to my question, but does not
explicitly answer it, so I ask here.
If a column has a default value specified does this mean the column cannot
contain a NULL value? In other words, is DEFAULT NOT NULL
redundant?
TIA,
Rich
--
Sent via pgsql-general
default value.
Much appreciated,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.
Happy New Year,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
m', 'gpm')),
Seems to me that if values are constrained by a list a NULL cannot be
entered by the user. Is this correct?
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
David,
I forgot about that. Thanks for pointing it out to me.
Regards,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ng that is column 2. The error message does not print
the integer PK. If it matters, I have all 14 columns specified but not
explicitly named in the INSERT INTO command.
I've looked in the manual without learning how to INSERT data in a table
with a serial PK and need to learn how to
ies VALUES (AG Spray Inc.,,PO Box 12129,Sa...
If you're not specifying the column names, then the VALUES list must
have the same number of values, in the same order as the columns
defined on the table.
As I wrote in the original message, I did this.
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
nicipalities',
'Ports/Marine Services', 'Transportation')),
status varchar(20) NOT NULL
CONSTRAINT invalid_status
CHECK (status in ('Client', 'Proposal submitted', 'Prospect',
'Referral', 'Opportunity', 'No further contact')),
comment text
);
Also, you can't just write double commas to leave out a item in the
value list. You could write DEFAULT there, ie
I tried with ,, and ,'', and ,' '. Same error each time. Also, listing
each column name does not fix the problem.
Thanks,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 720 matches
Mail list logo
