Thanks Pavel. Do you know pgq is compatible with postgresql-server-dev-14
packages? I couldn't see any requirements or something documented for pgq
and postgres 14.
Pavel Stehule , 4 Şub 2022 Cum, 01:17 tarihinde
şunu yazdı:
> Hi
>
> pá 4. 2. 2022 v 7:02 odesílatel rob stan naps
Hello,
We have "pgq" extensions on our clusters when I am trying to upgrade from
9.6.24 to 14.1 with pg_upgrade --link method, i am getting error;
First i was getting this error ;
could not load library "$libdir/pgq_lowlevel": ERROR: could not access
file "$libdir/pgq_lowlevel": No such file o
Hi Tom ;
Thank you for your detailed email.
rob stan writes:
> I have a problem with connecting database via psql;/usr/lib/9.6/bin/psql:
> symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol:
> PQsetErrorContextVisibility
Apparently psql is linking to a pre-9.6 copy of libpq
Hello all,
I have a problem with connecting database via psql;/usr/lib/9.6/bin/psql:
symbol lookup error: /usr/lib/9.6/bin/psql: undefined symbol:
PQsetErrorContextVisibility
OS :Debian GNU/Linux 9
I tried setting it didn't help; export
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/postgresql/9.6/lib
Hello ,
I want to set wal_keep_segments parameter to a value but what should be the
process I follow? I have archiving process on all clusters is on but when a
sudden process comes to postgres wal files will be bigger than i assume. I
don't know what I should do. Could you please help me?
Thanks
How can I catch the errors generated whne I call an INSERT that violates a
constraint? I have coded like this:
my $sth = $dbh->prepare($stmt);
my $rv = $sth->execute() or die $DBI::errstr;
if ( $rv < 0 ) {
OK, I have to admit this is a case of my being influenced by things going on
in the news, which I am not normally influenced by.
All the news about the touch screens on the crew dragon capsule using a
JavaScript app running in Chrome, have me thinking about doing some
testing for a project I am
I am trying to write a query to return the names, and data types of all the
columns in a view. It has been pointed out to me that the best approach
would be using pg_catalog. OK, so I found pg_view, which I can get the names
of a the views from and pg_attribute which can give me the column names,
b
When I run the following query,
SELECT column_name,data_type
FROM information_schema.columns
WHERE table_name = 'mfg_part_view';
I get the following result:
column_name | data_type
--+---
mfg | USER-DEFINED
mfg_part_no | character varying
Worming on a small project, and have been doing a lot of Perl scripting to
parse various types of files to populate the database. Now I need to get
data from a cloud services provider (time-keeping). They have a REST API
that returns data in a JSOSN format.
So here is the question, should I just m
I am confused. given this view:
AS
SELECT
employee.id ,
work_type.type ,
permit ,
work_type.overhead ,
work_type.descrip
from
permitted_work
inner join employee on
employee.employee_key = permitted_work.employee_key
inner join work_type on
Working on a project that has an MS Access front end. I tend to use some
RAISE NOTICE messages to debug things. Turns out these are not propagated
through MS Access. RAISE EXCEPTIONS are, as a pop up.
Anyone know how to change this?
Realize it is a bit off topic for this list.
--
"They that wou
On Thu, Mar 12, 2020 at 06:37:02PM -0700, David G. Johnston wrote:
> On Thursday, March 12, 2020, stan wrote:
> >
> > my $rv3 = spi_exec_query('$stmt');
> > What am I doing wrong here?
> >
>
> Putting a variable name into a single-quoted string and e
On Thu, Mar 12, 2020 at 06:00:01PM -0600, Rob Sargent wrote:
>
>
> > On Mar 12, 2020, at 5:16 PM, stan wrote:
> >
> > On Thu, Mar 12, 2020 at 04:58:08PM -0600, Rob Sargent wrote:
> >>
> >>
> >>> On Mar 12, 2020, at 4:49 PM, stan wrote:
re is the runtime output:
NOTICE: stmt = "SELECT employee_key from employee where id = 'stan' ;"
ERROR: syntax error at or near "$" at line 22.
As you can see, the statement seems correctly formatted, right?
What am I doing wrong here?
--
"They that would
On Sun, Mar 08, 2020 at 10:07:24PM +0100, S??ndor Daku wrote:
> On Sun, 8 Mar 2020 at 21:26, stan wrote:
>
> > On Sun, Mar 08, 2020 at 03:56:56PM +0100, S??ndor Daku wrote:
> > > On Sun, 8 Mar 2020 at 15:31, stan wrote:
> > >
> > > > On Sun, Ma
On Sun, Mar 08, 2020 at 10:29:09AM -0400, stan wrote:
> Still working on updateable views.
>
> Wish list item, a way to see the entire query that caused the trigger to
> fire.
>
> Now on to something i hope I can get. Can I see what the verb that caused
> the trigger
Still working on updateable views.
Wish list item, a way to see the entire query that caused the trigger to
fire.
Now on to something i hope I can get. Can I see what the verb that caused
the trigger to fire is? IE UPDATE, INSERT, DELETE?
--
"They that would give up essential liberty for tempo
On Sat, Mar 07, 2020 at 09:47:39AM -0500, Justin wrote:
> Hi Stan
>
> Rules actual are able to rewrite the SQL query sent to postgresql. Most
> everyone suggestion is avoid rules.
>
> Triggers are just like every other databases Triggers firing off code for
> Insert/U
I used raise(ERROR) in some functions, and it seems to work as expected, in
that it aborts the statement/function and displays the message. Went to
look at the documentation for this as part of my cleanup to find out this is
undocumented. Should I go back and change all these calls to
RAISE(EXCEPTI
Could someone give me a brief description of the intended functionally, and
how the 2 features work of rules, versus triggers? It appears to me that
they are simply 2 different ways to set up triggers, but I am certain that
is just because of my lack of knowledge.
Thank you.
--
"They that would
I have looked at:
https://www.postgresql.org/docs/8.4/plperl-database.html
I am also comfortable querying data from tables in perl. But I do not
quite see how to get the results of a query in plperl. Here is what I
tried, and it is not working:
my $rv2 = spi_exec_query('SELECT current_user');
On Thu, Mar 05, 2020 at 08:58:32AM -0700, David G. Johnston wrote:
> On Thu, Mar 5, 2020 at 7:58 AM stan wrote:
>
> > UPDATE BOM_ITEM SET cost_per_unit = 23.45 , qty = 12345.00
> >
> > So, it appears that I need to create a WHERE clause for the resultant
> > state
I am in the process of trying to set up a function.trigger pair to create
functionally an updateable view.
I would think that the trigger would fire the number of times that the
calling statement's WHERE clause seceded. Is this incorrect>
I have a view called purchase_view, one of the tables in
On Thu, Mar 05, 2020 at 12:27:12AM +, Ravi Krishna wrote:
>
> >
> > how can I determine what the data type of the value element is?
> >
> perl has a ref function which can tell what type of object.
>
> https://perldoc.perl.org/functions/ref.html
> >
>
>
> --
> This email has been checked
On Thu, Mar 05, 2020 at 12:27:12AM +, Ravi Krishna wrote:
>
> >
> > how can I determine what the data type of the value element is?
> >
> perl has a ref function which can tell what type of object.
>
> https://perldoc.perl.org/functions/ref.html
> >
>
>
That was my goto answer, but see
On Wed, Mar 04, 2020 at 05:09:19PM -0700, David G. Johnston wrote:
> On Wed, Mar 4, 2020 at 4:21 PM stan wrote:
>
> > Probably a bit off topic, but I suspect someone on this list knows how to
> > do
> > this.
> >
> > I am in the process of writing a plpe
Probably a bit off topic, but I suspect someone on this list knows how to do
this.
I am in the process of writing a plperl function. In this function I need
to compare the data in the NEW versus OLD structures. I am writing this as a
generic subroutine, so I am looping through and comparing the 2
On Wed, Mar 04, 2020 at 03:04:34PM +0100, Vik Fearing wrote:
> On 04/03/2020 14:05, stan wrote:
> > I am missing something about how to properly create a rule.
>
> What you are missing is that you should not ever use RULEs.
>
> > Thanks to the helpful folks on this list,
On Wed, Mar 04, 2020 at 08:05:06AM -0500, stan wrote:
> I am missing something about how to properly create a rule.
>
> Thanks to the helpful folks on this list, I am looking a creating some
> update able views. So, looks like I need to create a rule and a function
> for this. He
I am missing something about how to properly create a rule.
Thanks to the helpful folks on this list, I am looking a creating some
update able views. So, looks like I need to create a rule and a function
for this. Here is what I am trying as a test.
DROP TRIGGER v_trig_test ON test;
CREATE OR
On Wed, Mar 04, 2020 at 06:03:22AM -0500, stan wrote:
> I am trying to examine the values of $_TD->{new}. I thought the easiest way
> to see what this structure looked like was to use the Dumper functionality.
> To do so I need to include the appropriate Perl module, which I would thin
I am trying to examine the values of $_TD->{new}. I thought the easiest way
to see what this structure looked like was to use the Dumper functionality.
To do so I need to include the appropriate Perl module, which I would think
would be done like this:
use Data::Dumper qw(Dumper);
But inserting t
On Tue, Mar 03, 2020 at 05:31:32PM -0500, stan wrote:
> I did a Google search for using the RAISE functionality in plperl, and all
> the answers I see point to the elog built in function. Looking at this it
> appears to me, I can do things like RAISE NOTICE. But what if I want to do,
I did a Google search for using the RAISE functionality in plperl, and all
the answers I see point to the elog built in function. Looking at this it
appears to me, I can do things like RAISE NOTICE. But what if I want to do,
say, a RAISE EXCEPTION? Or do I need to handle that with the rerun AND an
On Tue, Mar 03, 2020 at 12:59:00PM -0500, Tom Lane wrote:
> stan writes:
> > I need to write a generic function to process data before allowing the
> > insert or update to continue.
> > To do this, I need to be able to examine the NEW, and OLD structures
> > wit
On Mon, Mar 02, 2020 at 01:44:52PM -0700, David G. Johnston wrote:
> On Mon, Mar 2, 2020 at 1:28 PM stan wrote:
>
> > Envision a table with a good many columns. This table represents the "life
> > history" of a part on a project. Some of the columns need to be
I need to write a generic function to process data before allowing the
insert or update to continue.
To do this, I need to be able to examine the NEW, and OLD structures
without prior knowledge of the structure of the table that fired the
trigger.
Can someone show me an example of how to get thes
On Mon, Mar 02, 2020 at 11:02:54AM -0800, Adrian Klaver wrote:
> On 3/2/20 10:59 AM, stan wrote:
> > I need to implement a fairly fine grained security model. Probably a bit
> > finer that I can do with the standard ownership functionality.
> >
> > My thinking on thi
I need to implement a fairly fine grained security model. Probably a bit
finer that I can do with the standard ownership functionality.
My thinking on this is to create a table that contains the users, and a
"permission bit" for each function that they may want to do, vis a vi
altering an existing
On Thu, Feb 27, 2020 at 10:30:15PM +0100, Andrei Zhidenkov wrote:
> Why not to pass TG_TABLE_SCHEMA and TG_TABLE_NAME in its arguments?
>
> > On 27. Feb 2020, at 22:28, stan wrote:
> >
> > I ma considering setting up a function, and triggers to put a record in an
>
I ma considering setting up a function, and triggers to put a record in an
audit table when certain tables are altered. I pretty much think I know how
to do this, with one exception.
Can a function, called by a trigger, determine what table it was called
for?
--
"They that would give up essentia
On Sat, Feb 22, 2020 at 01:06:57PM -0800, Christophe Pettus wrote:
>
>
> > On Feb 22, 2020, at 13:05, Adrian Klaver wrote:
> >
> > On 2/22/20 1:02 PM, stan wrote:
> >> I have a case where if a value does not exist, I am going to use a default,
> >> whi
I have a case where if a value does not exist, I am going to use a default,
which is easy with coalesce. But I would like to warn the user that a
default has been supplied. The default value is reasonable, and could
actually come from the source table, so I can't just check the value.
I'd like to d
How can I get the name of the table that fired a trigger, in the function
called by that trigger?
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
On Sun, Jan 19, 2020 at 08:52:36AM -0800, Adrian Klaver wrote:
> On 1/19/20 2:32 AM, stan wrote:
> Please post to list also.
> Ccing list.
>
> > On Sat, Jan 18, 2020 at 08:56:06AM -0800, Adrian Klaver wrote:
> > > On 1/18/20 8:53 AM, stan wrote:
> > > > So,
So, I just discovered the rules system. As I understand it, it can be used
to rewrite queries before they are passed to the query processor.
I was wondering if I could use this to resolve a long standing frustration
of mine. I often need to declare a column as NON NULL, and create a
trigger/functi
I see how to do this if it is a "dcleared" constraint, but this was just
defined in the table createion as inL
report_no varchar UNIQUE ,
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
I am trying to create a function to automatically create a reference value
when a record is inserted into a table. I want the reference value to
consist of the user that is doing the insert, plus a couple of dates, plus
a sequence number, where the sequence number will increment every time a
given
On Mon, Dec 30, 2019 at 02:47:53PM -0700, Michael Lewis wrote:
> >
> > LEFT join mfg_vendor_relationship on
> > mfg_vendor_relationship.mfg_key = mfg_part.mfg_key
> > AND
> > mfg_vendor_relationship.project_key = bom_item.project_key
> > LEFT join vendor on
> > mfg
I am working on a system whee one group of folks inputs portions of data
into a table, and a 2nd completes the data for each row.
The engineers enter in the items they need into a BOM table, and purchasing
agents get quotes and create PO's. There is not a fixed relationship between
the parts (par
On Thu, Dec 26, 2019 at 10:39:54AM -0700, David G. Johnston wrote:
> You should probably send that reply again using reply-to-all.
>
> Dave
>
>
> On Thu, Dec 26, 2019 at 10:38 AM stan wrote:
>
> > On Thu, Dec 26, 2019 at 10:26:49AM -0700, David G. Johnston wrote:
Thanks to the folks that helped me fix my earlier error today.
I seem to be having a bad day. I am getting an error that I cannot
understand, and I would appreciate another set of eyes looking at it.
Here is the error
Processing -> load_task.sql
DELETE 0
ERROR: column "project_cost_category_ke
On Thu, Dec 26, 2019 at 09:06:03AM -0500, Tom Lane wrote:
> stan writes:
> > When I try to insert this function I get an error on the following line:
> > _bom_name_key = ( SELECT
> > I actually pretty much get a syntax error whatever is at this line.
> > Can someo
On Thu, Dec 26, 2019 at 07:34:28PM +0530, Jayadevan M wrote:
> Hi,
>
>
> On Thu, Dec 26, 2019 at 7:06 PM stan wrote:
>
> >
> >
> > _bom_name_key = ( SELECT
> > project_bom_key
> >FROM inserted )
On Thu, Dec 26, 2019 at 01:55:34PM +, Ray O'Donnell wrote:
> On 26/12/2019 13:36, stan wrote:
> > IF _bom_name_key is NULL
> > THEN
> > WITH inserted AS (
> > INSERT into project_bom
> > (project
I am trying to create a function that checks to see if a value exists in a
table, if it does it returns the key, and fills in a NULL filed in an
INSERT. If the value DOES NOT exist, I want the function to insert the needed
record it into
the 2nd table, then get the resultant key, and fill in the
On Wed, Dec 25, 2019 at 09:17:22PM -0800, Adrian Klaver wrote:
> On 12/25/19 4:48 PM, Rob Sargent wrote:
> >
> >
> > > On Dec 25, 2019, at 3:10 PM, stan wrote:
> > > There is more that that. There is a project number, so the actuall key
> > > represe
On Wed, Dec 25, 2019 at 06:09:55PM -0500, stan wrote:
> On Wed, Dec 25, 2019 at 02:34:43PM -0800, Adrian Klaver wrote:
> > On 12/25/19 12:39 PM, stan wrote:
> > >
> > > On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
> > >
On Wed, Dec 25, 2019 at 02:34:43PM -0800, Adrian Klaver wrote:
> On 12/25/19 12:39 PM, stan wrote:
> >
> > On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
> > > On 12/25/19 11:08 AM, stan wrote:
> > > >
> > > > On Wed, Dec 2
On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
> On 12/25/19 11:08 AM, stan wrote:
> >
> > On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
> > > On 12/25/19 7:26 AM, stan wrote:
> > > > I am writing a trigger/function to
On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
> On 12/25/19 7:26 AM, stan wrote:
> > I am writing a trigger/function to make certain a default item, and its key
> > exist when an insert is called. EG
> >
> > The trigger gets called on insert to T1
I am writing a trigger/function to make certain a default item, and its key
exist when an insert is called. EG
The trigger gets called on insert to T1 If column c1 is NULL in the NEW
structure, I need to check table t2 to get the key associated with the
default for this column. However, if the def
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
> On 10/12/2019 16:11, Adrian Klaver wrote:
> > On 12/10/19 7:32 AM, stan wrote:
> >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
> >>> Hi Stan
> >>>
> >>&
On Tue, Dec 10, 2019 at 04:13:02PM +, Ray O'Donnell wrote:
> On 10/12/2019 16:11, Adrian Klaver wrote:
> > On 12/10/19 7:32 AM, stan wrote:
> >> On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
> >>> Hi Stan
> >>>
> >>&
On Tue, Dec 10, 2019 at 07:46:02AM -0800, Adrian Klaver wrote:
> On 12/10/19 3:21 AM, stan wrote:
> > I upgraded successfully on our test machine from V11 to V12 the other day.
>
> The below indicates that this is not the case.
>
> > Now it is time to upgrade the produ
On Tue, Dec 10, 2019 at 08:55:02AM -0500, Justin wrote:
> Hi Stan
>
> Check security make sure V12 postgres has the correct credentials
>
OK,
postgres@stantest:/var/run/postgresql$ ls -ld
drwxrwsr-x 2 postgres postgres 40 Dec 10 08:35 .
Looks correct to me.
This sun
On Tue, Dec 10, 2019 at 06:48:23AM -0500, stan wrote:
> I just went to do soem work on our test/sandbox instance. I had upgraded
> this ssytem to V12 a few days agao. I found that it was not running:
>
> Here is the last thing in the log:
>
> 2019-12-06 14:16:06.149 EST [37
I just went to do soem work on our test/sandbox instance. I had upgraded
this ssytem to V12 a few days agao. I found that it was not running:
Here is the last thing in the log:
2019-12-06 14:16:06.149 EST [3764] LOG: received fast shutdown request
2019-12-06 14:16:06.154 EST [3764] LOG: abortin
machine I am confused by the state of the V12 server:
If I do sudo apt-get install postgresql-12 I get a message about this
package being marked to be "manually installed: pg_lsclusters reports on a
version 11 instance:
stan@smokey:~/src/pgemailaddr-master$ pg_lsclusters
Ver Cluster Po
On Tue, Dec 03, 2019 at 11:35:40AM -0800, Adrian Klaver wrote:
> On 12/3/19 9:51 AM, stan wrote:
> >
> > On Tue, Dec 03, 2019 at 08:58:58AM -0800, Paul Jungwirth wrote:
> > > On 12/3/19 8:46 AM, stan wrote:> So, I have V12 running as the default on
> > &
On Tue, Dec 03, 2019 at 08:58:58AM -0800, Paul Jungwirth wrote:
> On 12/3/19 8:46 AM, stan wrote:> So, I have V12 running as the default on
> the machine I am testing this on
> > now:
> >
> > Ver Cluster Port Status OwnerData directory Log fil
On Tue, Dec 03, 2019 at 08:58:58AM -0800, Paul Jungwirth wrote:
> On 12/3/19 8:46 AM, stan wrote:> So, I have V12 running as the default on
> the machine I am testing this on
> > now:
> >
> > Ver Cluster Port Status OwnerData directory Log fil
On Tue, Dec 03, 2019 at 08:58:58AM -0800, Paul Jungwirth wrote:
> On 12/3/19 8:46 AM, stan wrote:> So, I have V12 running as the default on
> the machine I am testing this on
> > now:
> >
> > Ver Cluster Port Status OwnerData directory Log fil
On Tue, Dec 03, 2019 at 11:13:55AM -0500, Tom Lane wrote:
> stan writes:
> > I am working on upgrading from V11 to V12 on Debian.
> > My first attempt failed, and I have figured out that this is because I have
> > added extensions to the V11 DB, at least one of which was no
I am working on upgrading from V11 to V12 on Debian.
My first attempt failed, and I have figured out that this is because I have
added extensions to the V11 DB, at least one of which was not installed
using the Debian packages.
So, it looks like i need to install these before doing the upgrade,
I have several machines that have version 11 instances on them. These are
all Debian or Ubuntu machines. All of them are pointed to the Postgres
repositories fro the Postgres binaries
deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main
dpkg -l shows:
ii postgresql-11
Just wanted to point out this article:
https://www.phoronix.com/scan.php?page=news_item&px=Linux-5.5-Early-Performance
Looks like something has changed between 5.4 and 5.5 that is degrading
postgresql performance.
--
"They that would give up essential liberty for temporary safety deserve
neit
Looks like pgmodeler still requires use of the Beta version to work with a
V11 server. I am planing on moving to V12 in the near future. Will this same
Beta version work with V12?
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
On Fri, Nov 22, 2019 at 04:06:14PM -0800, Adrian Klaver wrote:
> On 11/22/19 3:52 PM, stan wrote:
> > A while back I ran into problems caused by security fix related to the
> > search path. I wound up adding a line to. for instance, this function:
> >
> > RE
urs') d;
$$;
And walked away happy, or so I thought. Now I just got this error:
[local] stan@stan=# select * from ttl_avail_hours_by_project_and_employee ;
ERROR: SET is not allowed in a non-volatile function
CONTEXT: SQL function "work_hours" during startup
How can I solve th
On Fri, Nov 22, 2019 at 03:10:42PM +0100, Guillaume Lelarge wrote:
> First, please reply to the list, not me specifically.
>
> Le ven. 22 nov. 2019 ?? 14:51, stan a ??crit :
>
> > On Fri, Nov 22, 2019 at 01:58:11PM +0100, Guillaume Lelarge wrote:
> > > Hi,
>
I am trting to do something, and it ias not working as I think it should.
Consider:
onnected to a database called stan as stan
/dt reports
List of relations
Schema | Name | Type | Owner
+--+---+---
ica| biz_constants
On Thu, Nov 21, 2019 at 12:14:16PM -0800, Adrian Klaver wrote:
> On 11/21/19 11:09 AM, stan wrote:
> >
>
> > > It would help if you could spell out what you want to achieve, as I am
> > > sure
> > > it has been done before by multiple people on this li
On Thu, Nov 21, 2019 at 08:18:08AM -0800, Adrian Klaver wrote:
> On 11/21/19 8:12 AM, stan wrote:
> Please reply to list also
> Ccing list.
> > On Thu, Nov 21, 2019 at 07:56:10AM -0800, Adrian Klaver wrote:
> > > On 11/21/19 6:35 AM, stan wrote:
>
> > > >
On Thu, Nov 21, 2019 at 08:18:21AM -0600, Ron wrote:
> On 11/21/19 5:55 AM, stan wrote:
> > 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
>
On Thu, Nov 21, 2019 at 09:15:02AM -0500, stan wrote:
> 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
> > &g
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
> &
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 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
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 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 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.
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
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
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
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 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 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 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?
1 - 100 of 190 matches
Mail list logo
