Have table that contains employee keys, paired up with work type keys
(both foreign keys) and a 3rd column that you enter a billing rate in.
Then I have a table where employees enter their work. I need to validate
that the employee, work type pair exists, before allowing the new record
to be i
I am in the process of defining an application for a very small company
that uses Postgresql for the backend DB. This DB will eventually run on a
hosted machine. As you imagine all of the employees have Windows machines
for their normal work asks. Frankly I am not very strong on Windows. so I
am wo
I apologize for asking, what I suspect will turn out to be a newbie
question, but I have managed to get myself quite confused on this.
I am defining a view as follows
CREATE OR REPLACE view purchase_view as
select
project.proj_no ,
qty ,
mfg_part.mfg_part_no ,
m
Sorry, I got the list address wrong the first time, and when I corected it,
I forget to fix the subject line.
I apologize for asking, what I suspect will turn out to be a newbie
question, but I have managed to get myself quite confused on this.
I am defining a view as follows
CREATE OR REPLACE
On Sat, Aug 10, 2019 at 02:57:14PM -0400, stan wrote:
> Sorry, I got the list address wrong the first time, and when I corrected it,
> I forget to fix the subject line.
>
> I apologize for asking, what I suspect will turn out to be a newbie
> question, but I have managed to g
Good morning (at least is is morning East Coast USA time).
I am trying to create a function to validate an attempted record
insert, and I am having a hard time coming up with syntax that
is acceptable.
Here is the scenario I have a table that has (among other items) employee_key
and work_type_ke
On Sun, Aug 11, 2019 at 08:56:13AM -0400, stan wrote:
> Good morning (at least is is morning East Coast USA time).
>
> I am trying to create a function to validate an attempted record
> insert, and I am having a hard time coming up with syntax that
> is acceptable.
>
> H
I trimmed this thread quite a bit.
Thanks to the help I have received, I am making progress. I have looked a the
recommended documentation, and I believe I am close. I have utilized the
"debugging printf" capability here. Here is where I am. I have the following
function create.
DROP TRIGGER val
On Sun, Aug 11, 2019 at 05:31:13PM -0400, stan wrote:
> I trimmed this thread quite a bit.
>
> Thanks to the help I have received, I am making progress. I have looked a the
> recommended documentation, and I believe I am close. I have utilized the
> "debugging printf"
I am creating a table that has 2 values in it which are keys pointing to 2
other tables. I need for the UNIQUE combination of these 2 keys to exist in
a fourth table. It has been recommended to use a foreign key constraint with
the MATCH FULL parameter.
Here is my question, does this deal with NU
Cc: pgsql-general.lists.postgresql@panix.com
Subject: Re: constrain with MATCH full and NULL values in referenced table
User-Agent: Mutt/1.12.1 (2019-06-15)
X-Editor: gVim
On Mon, Aug 12, 2019 at 06:22:54PM +0200, Francisco Olarte wrote:
> Stan:
>
> On Mon, Aug 12, 2019 at 5:1
On Mon, Aug 12, 2019 at 10:16:41AM -0700, Adrian Klaver wrote:
> On 8/12/19 10:06 AM, stan wrote:
> > Cc: pgsql-general.lists.postgresql@panix.com
> > Subject: Re: constrain with MATCH full and NULL values in referenced table
> > User-Agent: Mutt/1.12.1 (2019-06-1
On Mon, Aug 12, 2019 at 10:40:20AM -0700, Adrian Klaver wrote:
> On 8/12/19 10:30 AM, stan wrote:
> > > > The task_instance table is the one the original question was in
> > > > reference
> > > > to.
> > > >
> > > > CREATE TABLE e
I have a customer requirement/desire. The system is (among other things)
essentially a employee time sheet. The manager wants for an employee to not
be able to modify a given row in the table they enter time into once it is
committed. I personally see issues with this, but I am willing to try to gi
I am trying to write, what is for me, a fairly complex query. It uses JOINS,
and also GROUP BY. I have this working with the exception of adding the
GROUP BY clause.
Is there some reason I cannot add a GROUP BY function to a JOIN?
Here is what I have:
CREATE OR REPLACE view tasks_view as
sele
On Tue, Aug 13, 2019 at 05:54:03AM -0400, stan wrote:
> I am trying to write, what is for me, a fairly complex query. It uses JOINS,
> and also GROUP BY. I have this working with the exception of adding the
> GROUP BY clause.
>
> Is there some reason I cannot add a GROUP BY fun
I need to put a few bossiness constants, such as a labor rate multiplier in an
application. I am adverse to hard coding these things. The best plan i have
come up with so far is to store them in a table, which would have only 1
row, and a column for each needed constant.
Anyone have a better way t
that shows the total project cost.
Here is the test data from each of the 3 streams:
stan=> select * from labor_cost_sum_view ;
proj_no | labor_bill_sum | labor_cost_sum
-++
45 | 10810. | 3133.1750
764 | 8712. | 810.7
On Sat, Aug 17, 2019 at 12:24:31AM +1000, rob stone wrote:
> Hello,
>
> On Fri, 2019-08-16 at 07:39 -0400, stan wrote:
> > First let me say a huge THANK YOU to all the helpful people that
> > hanging out
> > on this.
> >
> > I am changing from one type of
On Fri, Aug 16, 2019 at 12:30:33PM -0700, Ken Tanzer wrote:
> On Fri, Aug 16, 2019 at 7:24 AM rob stone wrote:
>
> > Hello,
> >
> > On Fri, 2019-08-16 at 07:39 -0400, stan wrote:
> > > What am I doing wrong here?
> > >
> >
> >
> >
Just starting to expore setting up roles & useres. I ran this statement:
GRANT CONNECT ON DATABASE stan TO employee;
But yet \du still reports:
employee| Cannot login
What am I doing wrong?
--
"They that would give up essential liberty for temporary safety deserve
neithe
I created some roles that I think are badly named, as my understanding of
them increases.
I have deleted, what i thought were all the objects referenced by these roles,
but I still get an error saying there is one object they reference.
How can I find out what this object is?
--
"They that
I am creating an application that will need to have access control. There
will basically be the groups (roles ?):
* normal user (can do insert on a limited sate of tables, and select on a
slightly larger set
* project manager will have some increased insert and select capabilities
* sysadmin wil
DATABASE pertest TO employee;
and I have verifed tht the user employee does exst, I have also doen a few
more GRABTs to allow specific acces. But I cannot conect, or swith to user
employee:
stan@smokey:/etc/postgresql/11/main$ psql -U employee
psql: FATAL: Peer authentication failed for user "emp
I do know a way to solve this. I could create a view "B" that is a view of
tab;e "A" without column "C" on the select, and give a user permissions on
B, but not on A, or at least I think that would work.
What I specifically need to do is "hide" one column of a table from a set
of users.
Any bette
I have a situation where we need to import data, as an interim measure,
from spreadsheets.
I have read up on \copy and COPY, but I do not see that either of these can
use the header from a CSV file to define a new table. Am I missing
something?
Also downloaded something called pgfutter, which I
I am using Postgresql version 11 on Ubuntu 18.04. I am considering using an
extension called libphonenumber. It needs Postgresql-server-dev to build. I
found postgresql-server-dev-all in the list of available packages, BUT when
I ask apt-get to lad it, a dependency is postgresql-server-dev-10.
Se
Subject basically says it all.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
If anyone has installed the package for this on 18.04, and gotten it working,
I'd like to discuss what you had to do.
When I use apt-get to install it, I get a a couple of errors:
Warning: The home directory /var/log/pgcharts you specified can't be accessed:
No
such file or directory
Not creati
I am just starting to explore the power of PostgreSQL's time and date
functionality. I must say they seem very powerful.
I need to write a function that, given a month, and a year as input returns
the "work hours" in that month. In other words something like
8 * the count of all days in the range
I have created a function (PLSQL) that does a complex select with joins on
various
tables and views, and returns a table.
In the resultant table, I have raw data, and adjusted data. The adjusted data i
all adjusted by a common factor, which is calculated in the select. Presently, I
calculate this
I thought this would be common. But a quick Google only revealed what look to be
workarounds.
I am defining a bunch of functions, and I would prefer to store them in a
separate file, which then gets "source" by the main DB init file.
Is there a standard way to do this?
--
"They that would gi
I need to encapsulate, what are basically 2 related function calls into a single
function. The result of each of th calls is a date type.
y current thinking is to return a 2 row table with the 2 dates in it. But, I
seem to
be having issues getting this to work.
Is it possible for a function to r
On Fri, Aug 30, 2019 at 04:03:15PM -0400, stan wrote:
> I need to encapsulate, what are basically 2 related function calls into a
> single
> function. The result of each of th calls is a date type.
>
> y current thinking is to return a 2 row table with the 2 dates in it. But, I
OK, I am doing enough of this to start using some debug error messages.
I put the following in a function declaration:
RAISE notice 'Called with %', $1 ;
But, when I call the function I do not see anything. I edited postgresql.conf
Like this:
client_min_messages = notice
#client_min_messages =
On Fri, Aug 30, 2019 at 06:22:14PM -0400, stan wrote:
> OK, I am doing enough of this to start using some debug error messages.
>
> I put the following in a function declaration:
>
> RAISE notice 'Called with %', $1 ;
>
> But, when I call the function
I have been chasing a bug for a bit now. I even wound up completely rewriting
the
function, which in the end turns out to be a good thing, as it is much cleaner
and
easy to read.
I now believe that the bug is in how I am using an input parameter to the
function. Here is the function deceleratio
On Sat, Aug 31, 2019 at 10:05:10AM -0400, stan wrote:
> I have been chasing a bug for a bit now. I even wound up completely rewriting
> the
> function, which in the end turns out to be a good thing, as it is much
> cleaner and
> easy to read.
>
> I now believe that the bug
Just started using the RAISE functionality to help in debugging.
Tried to add it to an SQL script, only to realize it is a PLPGSQL extension.
Is there a way to get a string to appear in the output f an SQL script?
Can I do some sort of select?
--
"They that would give up essential liberty for
I apologize, as this is a bit off topic for this list.
pgmodeler got mention in a thread that I started a day or two ago, and it looks
like it might be very useful
I am running on Ubuntu 18.04 (latest STABLE), and I found that there is a
package,
which I downloaded. The idea is to import the pr
On Sun, Sep 01, 2019 at 06:30:23AM -0400, stan wrote:
> I apologize, as this is a bit off topic for this list.
>
> pgmodeler got mention in a thread that I started a day or two ago, and it
> looks
> like it might be very useful
>
> I am running on Ubuntu 18.04 (latest STAB
Some very helpful folks pointed me to pgmodeler recently.
I realize this list may not be the appropriate forum for discussing this, and
would welcome pointers to a more appropriate forum.
Having said that, this discussion may be a bit more generic.
I have seen a number of open source products
I am having a hard time figuring out to do this, the SQL way. Doing in a
procedural way with a foreach would be deasy, but I suspect that a
properly formulated SQL query can achieve this.
I have a table that contains a series of rows. Each row has a project key,
a start date, and an end date. Th
I am creating some views, that have columns with fairly complex calculations
in them. The I want to do further calculations using the result of this
calculation. Right now, I am just duplicating the first calculation in the
select fro the 2nd calculated column. There must be a batter way to do
th
I am working on a system that will support internal bossiness work for a
company. Periodicly things will change in their "world". For example they
periodically recalculate the "mark up" of various components, of their
bushiness, such as labor and or purchased materials. Presently I am keeping
the
My development methodology is to create scripts that init the db, and load
test data, as I make changes.
Now, I am starting to move toward a test instance with real data. The end
user has provided "real" test data, n spreadsheets. I have the inputing of
data from these working OK. (takes a bit of
;
stan@smokey:~/pm_db/live_data$ psql < import_employee.sql
ERROR: invalid input syntax for type numeric: "$1.00"
CONTEXT: COPY employee, line 2, column hourly_rate: "$1.00"
How can I work around this?
--
"They that would give up essential liberty for temporary safety
I would like to write a generic function that I can place as a BEFORE trigger
on several tables. It would do a max() on the column it was triggered for, and
return(max + 1) unless max returns a NULL, in which case it would return one.
Yes, I know this looks a lot like a sequence, but normally thi
I have several enumerated types that look like:
CREATE TYPE confidence_level AS ENUM ('HIGH' ,
'MEDIUM' ,
'LOW' ,
'WAG');
I have someone cr
On Sun, Sep 15, 2019 at 09:58:45AM -0300, Olivier Gautherot wrote:
> El dom., 15 de septiembre de 2019 09:37, stan escribi??:
>
> > I have several enumerated types that look like:
> >
> > CREATE TYPE confidence_level AS ENUM ('HIGH' ,
> >
I have defined this function:
CREATE FUNCTION fix_customer_types_case()
and this trigger:
CREATE TRIGGER fix_customer_types_case_trig BEFORE INSERT OR UPDATE ON customer
FOR EACH ROW EXECUTE FUNCTION fix_customer_types_case();
and I put a RAISE NOTICE so I cna tell if the function is called. Ye
On Sun, Sep 15, 2019 at 11:33:09AM -0400, stan wrote:
> I have defined this function:
>
> CREATE FUNCTION fix_customer_types_case()
>
> and this trigger:
>
> CREATE TRIGGER fix_customer_types_case_trig BEFORE INSERT OR UPDATE ON
> customer
> FO
Sorry forgot to cc the list
On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote:
> On 9/15/19 8:33 AM, stan wrote:
> > I have defined this function:
> >
> > CREATE FUNCTION fix_customer_types_case()
> >
> > and this trigger:
> >
> >
On Sun, Sep 15, 2019 at 08:59:43AM -0700, Adrian Klaver wrote:
> On 9/15/19 8:55 AM, stan wrote:
> >
> > Sorry forgot to cc the list
> >
> > On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote:
> > > On 9/15/19 8:33 AM, stan wrote:
Forgot to cc the list again. Have to look at settings in mutt.
> > >
> > > Sorry forgot to cc the list
> > >
> > > On Sun, Sep 15, 2019 at 08:42:02AM -0700, Adrian Klaver wrote:
> > > > On 9/15/19 8:33 AM, stan wrote:
> > > > > I h
On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote:
> On 9/15/19 10:46 AM, stan wrote:
> > Forgot to cc the list again. Have to look at settings in mutt.
> >
> > > > >
> > > > > Sorry forgot to cc the list
> > > > >
>
On Mon, Sep 16, 2019 at 12:12:34AM -0400, Tom Lane wrote:
> stan writes:
> > On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klaver wrote:
> >> On 9/15/19 10:46 AM, stan wrote:
> >>> So, my test tell me that the validity check is done BEFORE an attempt to
> &g
On Mon, Sep 16, 2019 at 12:44:49PM -0700, Adrian Klaver wrote:
> On 9/16/19 11:53 AM, stan wrote:
> > On Sun, Sep 15, 2019 at 09:16:35PM -0700, Adrian Klaver wrote:
> > > On 9/15/19 6:04 PM, stan wrote:
> > > > On Sun, Sep 15, 2019 at 12:27:14PM -0700, Adrian Klav
On Mon, Sep 16, 2019 at 03:19:27PM -0700, Adrian Klaver wrote:
> On 9/16/19 12:55 PM, stan wrote:
> >
> > On Mon, Sep 16, 2019 at 12:44:49PM -0700, Adrian Klaver wrote:
> > > On 9/16/19 11:53 AM, stan wrote:
> > > > On Sun, Sep 15, 2019 at 09:16:35PM -0700,
On Thu, Sep 19, 2019 at 03:54:40PM -0600, Michael Lewis wrote:
> You can also look at citext type to avoid the casting.
Oh, that looks really useful I think I will go back and use that type quite
a bit.
Thanks for pointing it out to me.
>
> customer_keyinteger DEFAULT
> next
On Thu, Sep 19, 2019 at 03:54:40PM -0600, Michael Lewis wrote:
> You can also look at citext type to avoid the casting.
>
> customer_keyinteger DEFAULT
> nextval('customer_key_serial') PRIMARY KEY ,
> cust_no smallint NOT NULL UNIQUE ,
> name
On Fri, Sep 20, 2019 at 08:52:00PM +1000, Morris de Oryx wrote:
> I see that you've already been pointed at citext, but I don't think a CHECK
> constraint has been mentioned. In case it hasn't, what about something like
> this?
>
>ADD CONSTRAINT check_activity_status
> CHECK (activity_st
EXISTS citext WITH SCHEMA public;
CREATE EXTENSION
and as the superuser it shows up in the \dx display
BUT as a normal user:
stan=> \dx
List of installed extensions
Name | Version | Schema | Descript
Is there any currently supported version of this? I found one using google,
but it looks like it was last updated around version 8 of Postgres.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
I have a table that consists of 3 columns.
vendor_key
mfg_key
preferred (boolean)
The idea is that a given vendor is the vendor we want to use for each
manufacturer for a given project.
I need to constrain such that only on row of mfg, vendor and project can
be set to TRUE.
I would be interest
I was going to try to do some testing on very large databases, and I tried to
load the Mouse Gerome DB. It failed, and now I know why :-) I filled the
disk up. Presently, with virtually nothing in any database the postgres
storage location has 43G allocated. The DB was also crashed but i did free
u
On Wed, Oct 09, 2019 at 02:59:17PM -0400, melvin6925 wrote:
> Have you tried a VACUUM FULL of the db?Sent via the Samsung Galaxy S?? 6, an
> AT&T 4G LTE smartphone
> Original message ----From: stan Date: 10/9/19
> 14:54 (GMT-05:00) To: melvin6925 Subject: Re: I
have a bit of disk space.
Looks like I see the mad schema both in the postfres db, and in my own
stan db/ I did a drop schema cascade on both as the db superuser, and ran
vacuum full on both. This command came back almost instantly, which
surprises me.
However, my 50G disk is still 96% full. How
OOK, after a period of time, I recovered my disk space.
On Thu, Oct 10, 2019 at 03:57:00AM -0400, stan wrote:
> Sorry to repeat this, I am still in trouble on it.
>
> I made the mistake of trying to import the mouse gnome database in an
> effort to do some testing with very lar
I used to be able to return a constant value in a SELECT statement in
ORACLE. I need to populate a table for testing, and I was going to do so
like this:
SELECT
employee.id ,
project.proj_no ,
work_type.type ,
'rate' 1
FROM employee
CROSS JO
On Tue, Oct 15, 2019 at 09:28:51AM -0400, stan wrote:
> I used to be able to return a constant value in a SELECT statement in
> ORACLE. I need to populate a table for testing, and I was going to do so
> like this:
>
> SELECT
> employee.id ,
>
OK, now that figured out how to return the constant, this is the final
query I need to run.
INSERT into rate
(
employee_key ,
project_key ,
work_type_key ,
rate
)
VALUES
(
(
SELECT
employee.employee_key ,
pr
I typically design a system with primary keys defined, like this:
CREATE TABLE employee (
employee_key integer DEFAULT nextval('employee_key_serial')
PRIMARY KEY ,
I use scripts to build the database structures and load the data. I am
careful to get the dependencies i
On Mon, Oct 21, 2019 at 05:24:37PM -0700, Adrian Klaver wrote:
> On 10/21/19 5:13 PM, stan wrote:
> >
> > I typically design a system with primary keys defined, like this:
> >
> >
> > CREATE TABLE employee (
> > employee_key integ
OK, this seems a stupid question, but I do not see the answer.
I downloaded pg-libphonenumber, and am going to try to build it for PG
version 11. Looks like the last build was against version 9.6.
It builds fine, the issue comes in when I try to do a make install. It
wants to install in the app
On Tue, Oct 22, 2019 at 02:19:15PM +0200, Pavel Stehule wrote:
> Hi
>
> ??t 22. 10. 2019 v 14:15 odes??latel stan napsal:
>
> > OK, this seems a stupid question, but I do not see the answer.
> >
> >
> > I downloaded pg-libphonenumber, and am going to try to b
- Forwarded message from Pavel Stehule -
Date: Tue, 22 Oct 2019 14:43:17 +0200
From: Pavel Stehule
To: stan
Cc: pgsql-general
Subject: Re: A question about building pg-libphonenumber
List-Id:
??t 22. 10. 2019 v 14:37 odes??latel stan napsal:
> On Tue, Oct 22, 2019 at 02:19:1
1/lib/pg_libphonenumber.so": libphonenumber.so.7:
cannot open shared object file: No such file or directory
icadb=# ls -l /usr/lib/postgresql/11/lib/pg_libphonenumber.so
Yet,
root@ica-db:/home/stan/BUILD/pg-libphonenumber-master# ls -l
/usr/lib/postgresql/11/lib/pg_libphonenumber.so
-rwxr-xr-x 1 root root
I started doing the following to define my primary keys long ago and in a
universe far away:
CREATE TABLE employee (
employee_key integer DEFAULT nextval('employee_key_serial')
PRIMARY KEY ,
WEE ran into a scenario, after a total db restore on a project where we got
errors inserting ne
On Tue, Oct 22, 2019 at 12:48:41PM -0700, Adrian Klaver wrote:
> On 10/22/19 10:48 AM, stan wrote:
> Please reply to list also:
> Ccing list.
>
>
> >
> > Sorry if my description was not clear.
> >
> > No, we do not mix test, and production data. Let me t
I have a very confusing isse. I am trying to backup and restre a signle
table .
first I dump the table.
Script started on 2019-10-24 06:29:12-0400
]0;stan@smokey: ~stan@smokey:~$ pg_dump -a --table task_instance >
task_instance.dump
Then I connect to the db, and verify that things
hat is going on. I will try to use pg_restore, and make certain
that resolves my issue.
In the meantime, I found that if I deleted all the SET lines from the dump
I could restore with psql. But that is probably not the right way to do
this.
>
> On 10/24/19 5:52 AM, stan wrote:
> >
On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
> On 10/24/19 3:52 AM, stan wrote:
> >
> >
> > I have a very confusing isse. I am trying to backup and restre a signle
> > table .
> >
> > first I dump the table.
>
> Actually you are
I just was educated on the security issues of search path. As a result
I am going to define a schema for the project we are working on.
I set this in postgresql.conf
search_path = 'ica , "$user", public'
Here is the question. Will this path be in effect for users connecting from
MS Access client
On Thu, Oct 24, 2019 at 07:40:29AM -0700, Adrian Klaver wrote:
> On 10/24/19 7:32 AM, stan wrote:
> > On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote:
> > > On 10/24/19 3:52 AM, stan wrote:
> > > >
> > > >
> > > > I have a v
I have a presentation later in the week, and i plan on printing out some
files containing SQL commands. I have used some "pretty printers" in the
past for things like Perl scripts. What I am thinking of s something that
bolds keywords, handles page breaks, and does some formatting.
Development be
I am in the middle of a project, and it looks like version 12 is now what
the Debian/Ubuntu package managers want to update to.
I of course, will do this first on a test machine, not the "production", or
"develop,met" machines, but I thought i would solicit the group wisdom on
this.
Are there an
On Thu, Nov 07, 2019 at 07:52:14AM -0800, Adrian Klaver wrote:
> On 11/7/19 7:45 AM, stan wrote:
> > I am in the middle of a project, and it looks like version 12 is now what
> > the Debian/Ubuntu package managers want to update to.
>
> This should be a dist-upgrade correct?
I need to create a table to store terms and conditions for purchase
orders.
Some of the attributes of a PO include payment terms. Quite often these will
be 2 periods associated with these, the first is a period on which if you
pay, you receive a discount, and the 2nd is when payment is due with no
On Fri, Nov 08, 2019 at 12:12:59PM -0800, Adrian Klaver wrote:
> On 11/8/19 11:57 AM, Michael Lewis wrote:
> > You certainly could choose to store as??tstzrange, but why not use two
> > fields?
> >
> > https://www.postgresql.org/docs/current/rangetypes.html
>
> I would lean more to a composite ty
I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
getting the following error:
ERROR: cannot change name of view column "descrip" to "contact_person_1"
I suppose I can drop the view, and recreate it, but that seems to indicate
that the create or replace functionality i
On Thu, Nov 14, 2019 at 06:31:48AM -0800, Adrian Klaver wrote:
> On 11/14/19 5:53 AM, stan wrote:
> > I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
> > getting the following error:
> >
> > ERROR: cannot change name of view column &qu
On Thu, Nov 14, 2019 at 10:12:22AM -0500, Tom Lane wrote:
> Adrian Klaver writes:
> > On 11/14/19 5:53 AM, stan wrote:
> >> I am trying to add columns to a view using CREATE OR REPLACE VIEW, and I am
> >> getting the following error:
> >> ERROR: cannot cha
I am presently running on a Ubuntu 18.04 instance, and as you know
Debian/Ubuntu have upgraded to version 12. i have not completed the
upgrade yet, so I am in the situation of still having a version 11 server,
attaching from vversion 12 psql.
I was troubleshooting something a few minutes ago, a
I added a column to an existing table, so there should be nothing (actually
the default, I suppose) in this column for all existing rows.
However if I do:
select new_column from modified_table ;
I get the total number of rows in the table, but the lines on the screen
have no visible characters.
On Wed, Nov 20, 2019 at 09:22:02AM -0500, Brian Dunavant wrote:
> On Wed, Nov 20, 2019 at 9:16 AM stan wrote:
>
> >
> > How can i make these "invisible" characters visible?
> >
> >
> >
> In psql, by default it displays nulls as nothing. Y
I am working on a fairly small application to use for managing a companies
business.
I have a "production" instance hosted by one of the cloud providers, and 2
other instances. This is fairly new to me. In the past, I have created
applications by keeping a set of scripts that can be used to rebu
On Wed, Nov 20, 2019 at 04:24:40PM -0600, Ron wrote:
> On 11/20/19 4:03 PM, stan wrote:
> > I am working on a fairly small application to use for managing a companies
> > business.
> >
> > I have a "production" instance hosted by one of the cloud provider
all 0.0.0.0/0 md5
But when I try to login like this:
psql stan postgres -W
I get the following error, and yes, I set postgres'es password to something
I know:
tan@stantest:~$ psql stan postgres -W
Password:
psql: error: could not connect to server: FATAL:
On Thu, Nov 21, 2019 at 02:05:09PM +0100, Magnus Hagander wrote:
> On Thu, Nov 21, 2019 at 1:46 PM stan wrote:
>
> > I am trying to set up to do some work with pg_dump, and I would like to be
> > able to connect from my normal user to do this. This is on a Ubunt 18.04
> &
1 - 100 of 190 matches
Mail list logo
