Re: [help] Error in database import

2024-04-19 Thread Adrian Klaver
On 4/19/24 20:58, Tu Ho wrote: Hi, I am currently having a project where I need to combine 2 large database. I was not however able to import an excel file .csv into the There are Excel files(.xls/.xlsx) and there are *.csv files. database. The error was ERROR: syntax error at or near

Re: [help] Error in database import

2024-04-19 Thread Ron Johnson
On Fri, Apr 19, 2024 at 11:58 PM Tu Ho wrote: > Hi, > > I am currently having a project where I need to combine 2 large database. > I was not however able to import an excel file .csv into the database. The > error was ERROR: syntax error at or near "OIDS" LINE 1: ...ing Site" , > "International

[help] Error in database import

2024-04-19 Thread Tu Ho
Hi, I am currently having a project where I need to combine 2 large database. I was not however able to import an excel file .csv into the database. The error was ERROR: syntax error at or near "OIDS" LINE 1: ...ing Site" , "International Name(s)" ) FROM STDIN OIDS DELI... ^" I have no idea how

Re: Foreign Key error between two partitioned tables

2024-04-19 Thread David Rowley
On Fri, 19 Apr 2024 at 05:48, Michael Corey wrote: > ALTER TABLE ONLY par_log_file > ADD CONSTRAINT plf_pk PRIMARY KEY (par_file_id); > ALTER TABLE par_log_definition > ADD CONSTRAINT pld_fk FOREIGN KEY (par_file_id) REFERENCES > par_log_file(par_file_id); > I receive the following

Re: Can you refresh a materialized view from a materialized view on another server?

2024-04-19 Thread Adrian Klaver
On 4/18/24 19:49, Michael Nolan wrote: My production server has a materialized view that is refreshed from a mysql_fdw several times a day. What I'd like to be able to do is refresh the materialized view on the testbed server from the one on the production server so that they are the same.

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-19 Thread Adrian Klaver
On 4/18/24 22:48, Saksham Joshi wrote: Hi, We have created an azure postgresql flexible server and we have added an ad admin as a user and Created our database using this admin user.However,When are running this command: 'Grant pg_signal_backend To adminUser' we are getting an error that says

Re: Not able to grant access on pg_signal_backend on azure flexible server

2024-04-19 Thread Tom Lane
Saksham Joshi writes: > We have created an azure postgresql flexible server and we have added an ad > admin as a user and Created our database using this admin user.However,When > are running this command: 'Grant pg_signal_backend To adminUser' we are > getting an error that says 'permission

Re: SSPI Feature Request

2024-04-19 Thread Justin Clift
On 2024-04-19 11:53, Buoro, John wrote: SSPI Kerberos\NTLM authentication (Windows environment) currently only authenticates users, however, it does not authenticate a user against an LDAP \ Active Directory group. Can you please look at making this possible? Sounds like it'd be pretty

SSPI Feature Request

2024-04-19 Thread Buoro, John
Hi, SSPI Kerberos\NTLM authentication (Windows environment) currently only authenticates users, however, it does not authenticate a user against an LDAP \ Active Directory group. This makes administration complex because an administrator would need to add\remove each user to\from an instance

Re: Why does it sort rows after a nested loop that uses already-sorted indexes?

2024-04-19 Thread negora
> That's a level of analysis that it doesn't do... Great. I suspected that, but I needed a confirmation from a reliable source. Thank you! > ...and TBH I'm not even > entirely sure it's correct to assume that the output is sorted like > that. At minimum you'd need an additional assumption