On Sunday, January 2nd, 2022 at 3:54 PM, Francisco Olarte
wrote:
>
> Inherits does not copy things. LIKE on creation does, but AFAIK it can
>
> copy nearly everything except data.
>
Thanks, had read that part of the documentation.
So far it seems that functions 'joins' may be used to view data,
Recipients,
A table was created:
CREATE TABLE exampletable (
name varchar(200)
);
Table 'exampletable' _already_ contains data, e.g. 'Jane Bloggs'
A new table was created with inheritance of 'exampletable':
CREATE TABLE exampletablechild (dates DATE) INHERITS (exampletable);
SET DATESTYLE TO '
Recipients,
How to create a query such that when a date value is entered, the date may be
associated with the result of another query.
The scenario is that a date value is entered (the plan is these dates should be
a separate table), then a query result is joined with the date value.
Please ad
On Thursday, December 30th, 2021 at 7:30 AM, Guillaume Lelarge
wrote:
> Hi,
>
> Le mer. 29 déc. 2021 à 22:08, ourdiaspora a
> écrit :
>
> >
> > \copy exampletable from '/local/path/to/examplefile.csv';
> >
>
> You should tell the CSV
Readers,
Please could anyone help with the following error produced:
"
ERROR: invalid input syntax for integer: "1,m "
CONTEXT: COPY exampletable, line 1, column examplenumber: "1,m "
The database commands:
"
CREATE TABLE exampletable (examplenumber smallint,
exampletitle varchar(500)
);
"
"
On Sunday, August 29th, 2021 at 5:56 PM, Ray O'Donnell
wrote:
>
- or do they connect only to the web server, which then
>
> uses its own account on the database server?
Thank you; was not aware of this consideration and this option seems most
appropriate for the simple sql commands envisaged.
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:38 PM, Ray O'Donnell
wrote:
>
> I'd save a timestamp with the session data, and then run a cron job
>
> which deletes sessions older than whatever lifetime you want.
>
Is it prudent in this scenario for the user to create (a)
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:30 PM, Adrian Klaver
wrote:
> On 8/29/21 9:24 AM, Adrian Klaver wrote:
>
>
> Whoops, unfinished thought. What I was going to ask is:
>
> The above is not clear to me. Are you asking about the Postgres
>
> documentation?
>
Yes
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:24 PM, Adrian Klaver
wrote:
>
> Presumably not. Temporary tables only live at most for the length of a
>
> session. It would be a really bad idea to hold sessions open for 24
>
> hours.
Is there an alternative scenario, such as
Readers,
Some advice would be appreciated about appropriate tables to store temporary
data.
Scenario:
User copies csv file of user data, presumably into some temporary table(s);
User selects data (read-only) from extant tables;
Web server combines user data with read-only data to produce content
On Saturday, August 28th, 2021 at 5:52 PM, Adrian Klaver
wrote:
>
> You are asking the user to select a file, so there should be some sort
>
> of file reference at that point, correct?
>
This is what causes confusion. If a user has a file named 'mydatafile.csv', why
does the manual make refe
‐‐‐ Original Message ‐‐‐
On Friday, August 27th, 2021 at 11:10 PM, Adrian Klaver
wrote:
> https://www.php.net/manual/en/pdo.pgsqlcopyfromfile.php
>
"
public PDO::pgsqlCopyFromFile(
string $table_name,
string $filename,
"
Sorry but do not understand; the line does not explain
Readers,
Objective, to import a csv file into postgresql database. If understood
correctly, the manual section 'fopen'
(https://www.php.net/manual/en/function.fopen.php) shows that the file has a
"known resource" extant name.
Please what is the syntax to assign an unknown file name to the 'fop
‐‐‐ Original Message ‐‐‐
On Wednesday, August 11th, 2021 at 3:13 PM, Adrian Klaver
wrote:
>
> Are you using some form of container/VM on the machine for either server?
>
The machine is a chromebook, GNU/Linux via 'crouton' chroot. Is this the
potential cause of blockage of port 5432
On Wednesday, August 11th, 2021 at 3:09 PM, Adrian Klaver
wrote:
>
> Is the Web server/PHP app on the same machine as the Postgres server?
>
All programs about this question are installed on a single computer; the
intention is to test and learn first on a local machine.
> If it is on the sa
‐‐‐ Original Message ‐‐‐
On Wednesday, August 11th, 2021 at 2:10 PM, rob stone
wrote:
>
> the call to pg_connect as a try . . . catch block so that the exact
>
Sorry but do not understand "try catch block"
>
> Are you sure postgres is configured to use port 5432?
No, but the impres
‐‐‐ Original Message ‐‐‐
On Tuesday, August 10th, 2021 at 3:44 PM, Adrian Klaver
wrote:
> 1. There is another local line with peer that you missed.
> 2. You changed the wrong pg_hba.conf file.
>
Frow within postgresql 'psql' terminal:
SHOW hba_file;
/etc/postgresql/9.6/main/
‐‐‐ Original Message ‐‐‐
On Tuesday, August 10th, 2021 at 2:14 PM, Tom Lane wrote:
> The postgres process is listening, but this has nothing to do with
>
> whether the kernel will allow any packets to arrive there.
>
Installed 'nftables'. According to the documentation
(https://wiki.de
On Sunday, August 8th, 2021 at 2:15 AM, Tom Lane wrote:
> ourdiaspora ourdiasp...@protonmail.com writes:
>
> > psql -d cpacweb -U cpaca
> >
> > psql: FATAL: Peer authentication failed for user "cpaca"
>
> It's a gold
>
> plated cer
On Sunday, August 8th, 2021 at 1:51 AM, Adrian Klaver
wrote:
> 1. Get rid of the first local line .
> 2. Then for the remaining local line below change peer to trust and
>
> restart Postgres.
Thank you, but repeat error occurred:
sudo sudo service postgresql restart
[ ok ] Restarting P
On Sunday, August 8th, 2021 at 1:02 AM, Adrian Klaver
wrote:
> What did you change listen_addresses from?
>
New line; same line had hash (#) to comment out.
> What if you do?:
>
> psql -d cpacweb -U cpaca
>
psql -d cpacweb -U cpaca
psql: FATAL: Peer authentication failed for user "cpaca"
On Sunday, August 8th, 2021 at 12:50 AM, David G. Johnston
wrote:
> On Saturday, August 7, 2021, ourdiaspora wrote:
>
> > SHOW hba_file;
> >
> > /etc/postgresql/9.6/main/pg_hba.conf
>
> Please post the contents of this file. The one shown at the
On Sunday, August 8th, 2021 at 12:26 AM, Tom Lane wrote:
>
> Hm --- this suggests that you've got a kernel packet filter (i.e.
>
> software firewall) that is not passing traffic for 5432.
Don't know anything about that, so perhaps it can be assumed unchanged from
whatever the default system con
On Sunday, August 8th, 2021 at 12:11 AM, Tom Lane wrote:
>
> If php is trying to connect to something else, like say the
>
> machine's external IP address, that could be your issue.
Excuse the ignorance, but if the instruction in the php file is:
"
...$dbconn = pg_connect("dbname=cpacweb user=cp
On Saturday, August 7th, 2021 at 11:20 PM, Adrian Klaver
wrote:
>
> 1. OS and version?
Same local machine as described
> 2. The contents of /etc/hosts
127.0.0.1 localhost
::1 localhost ip6-localhost ip6-loopback
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
>
On Saturday, August 7th, 2021 at 10:17 PM, Adrian Klaver
wrote:
> On 8/7/21 1:09 PM, ourdiaspora wrote:
>
> > On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver
> > adrian.kla...@aklaver.com wrote:
>
> > Changes were made to the function 'listen_
On Saturday, August 7th, 2021 at 8:23 PM, Adrian Klaver
wrote:
> > Since further configuration, remain unable to connect to the php database.
>
> Further configuration of what?
>
The postgresql configuration file:
SHOW hba_file;
/etc/postgresql/9.6/main/pg_hba.conf
SHOW config_file;
Readers,
Background: http://news-web.php.net/php.general/327600
Since further configuration, remain unable to connect to the php database.
Software system is debian, xfce, postgresql, php. Database created on local
machine with directory of web server content in extant normal user account.
The
28 matches
Mail list logo
