Hello all,
Currently PostgreSQL doesn't support data change delta tables. For example, it
doesn't support this type of query:
SELECT * FROM NEW TABLE (
INSERT INTO phone_book
VALUES ( 'Peter Doe', '555-2323' )
) AS t
PostgreSQL has RETURNING that provides only a subset of this function
Hi
po 15. 1. 2024 v 11:00 odesílatel PavelTurk
napsal:
> Hello all,
>
>
> Currently PostgreSQL doesn't support data change delta tables. For example,
> it doesn't support this type of query:
>
> SELECT * FROM NEW TABLE (
> INSERT INTO phone_book
> VALUES ( 'Peter Doe', '555-2323' )
>
On 1/15/24 12:05 PM, Pavel Stehule wrote:
Hi
po 15. 1. 2024 v 11:00 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal:
Hello all,
Currently PostgreSQL doesn't support data change delta tables. For example,
it doesn't support this type of query:
SELECT * FROM NEW TABLE
po 15. 1. 2024 v 11:11 odesílatel PavelTurk
napsal:
>
> On 1/15/24 12:05 PM, Pavel Stehule wrote:
>
> Hi
>
> po 15. 1. 2024 v 11:00 odesílatel PavelTurk
> napsal:
>
>> Hello all,
>>
>>
>> Currently PostgreSQL doesn't support data change delta tables. For example,
>> it doesn't support this type
Hi,
On Sat, 2024-01-13 at 13:23 -0800, Joseph G wrote:
> If we look, gdal35 or 36 is asking for libarmadillo.so.10 which
> doesn't look like its available for EL8 just an older EL7? I can't
> get past this error at the moment.
Pushed GDAL 3.6.4-6 RPMS to the repos built against armadillo 12 for
On 1/15/24 12:17 PM, Pavel Stehule wrote:
po 15. 1. 2024 v 11:11 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal:
On 1/15/24 12:05 PM, Pavel Stehule wrote:
Hi
po 15. 1. 2024 v 11:00 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal:
Hello all,
po 15. 1. 2024 v 11:27 odesílatel PavelTurk
napsal:
>
> On 1/15/24 12:17 PM, Pavel Stehule wrote:
>
>
>
> po 15. 1. 2024 v 11:11 odesílatel PavelTurk
> napsal:
>
>>
>> On 1/15/24 12:05 PM, Pavel Stehule wrote:
>>
>> Hi
>>
>> po 15. 1. 2024 v 11:00 odesílatel PavelTurk
>> napsal:
>>
>>> Hello al
PavelTurk schrieb am 15.01.2024 um 11:00:
> Currently PostgreSQL doesn't support data change delta tables. For example,
> it doesn't support this type of query:
>
> SELECT * FROM NEW TABLE (
> INSERT INTO phone_book
> VALUES ( 'Peter Doe', '555-2323' )
> ) AS t
>
> PostgreSQL has RETURNI
Hello,
I have worked on migrate a table from sql server 2017 to postgresql 15 . İ have
completed all steps. But when i try to migrate some columns , i got error;
NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting results
ERROR: DB-Library error: DB #: 2403, DB Msg: Some characte
Hello
I wondering about login to postgres with different method such ldap connected
with ident. Same ldap don't make problem but I think about authorization by
ldap and further automatic switch usera to another user. I think about
authorization for only one group of active directory. Does it is
On 1/14/24 10:55, Eyüp Liste wrote:
Hello,
I have worked on migrate a table from sql server 2017 to postgresql 15 .
İ have completed all steps. But when i try to migrate some columns , i
got error;
NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting
results ERROR: DB-Library
On 1/15/24 02:44, Thomas Kellerer wrote:
PavelTurk schrieb am 15.01.2024 um 11:00:
Currently PostgreSQL doesn't support data change delta tables. For example, it
doesn't support this type of query:
SELECT * FROM NEW TABLE (
INSERT INTO phone_book
VALUES ( 'Peter Doe', '555-2323' )
)
Dear all,
I have a table automobile which has a column id.
Table consists of id,make,year of manufacturing
I use dbeaver for querying..
Select * from automobile provides me results
However select id from automobile yields column doesn't exists.
I tried double quotes on id As well but same err
On Mon, Jan 15, 2024 at 8:17 AM arun chirappurath
wrote:
> Dear all,
>
> I have a table automobile which has a column id.
>
> Table consists of id,make,year of manufacturing
>
> I use dbeaver for querying..
>
> Select * from automobile provides me results
>
> However select id from automobile yie
On 1/15/24 08:16, arun chirappurath wrote:
Dear all,
I have a table automobile which has a column id.
Table consists of id,make,year of manufacturing
I use dbeaver for querying..
Select * from automobile provides me results
However select id from automobile yields column doesn't exists.
I t
Hi Adrian,
\d shows the tables and this id which is a sequence.
Regards,
Arun
On Mon, 15 Jan 2024 at 22:03, Adrian Klaver
wrote:
> On 1/15/24 08:16, arun chirappurath wrote:
> > Dear all,
> >
> > I have a table automobile which has a column id.
> >
> > Table consists of id,make,year of manufac
On 1/15/24 09:26, arun chirappurath wrote:
Hi Adrian,
\d shows the tables and this id which is a sequence.
What I asked for was the output of:
\d automobile
Add that output to your reply.
Regards,
Arun
--
Adrian Klaver
adrian.kla...@aklaver.com
On 1/15/24 11:03 AM, Eyüp Liste wrote:
Hello,
1)TURKISH_CI_AS at sql server database
2)Encoding : UTF8 Collate: en_US.UTF-8 at Postgresql
I don't use tds_fdw, so the best I can do is point you at information
Hopefully someone with practical experience will chime in with more
specific inf
I can confirm everything works now, Thank you!
Sent via mobile, please excuse typos and brevity.
On Mon, Jan 15, 2024, 02:20 Devrim Gündüz wrote:
> Hi,
>
> On Sat, 2024-01-13 at 13:23 -0800, Joseph G wrote:
> > If we look, gdal35 or 36 is asking for libarmadillo.so.10 which
> > doesn't look lik
On 2024-01-15 14:16, veem v wrote:
Hello Experts,
If some teams are well versed with the Oracle database architecture and
its
optimizers working and designing applications on top of this. Now
moving
same team to work on AWS aurora postgresql databases design/development
projects. Is any key de
On Mon, Jan 15, 2024 at 11:32 AM Sasmit Utkarsh
wrote:
> Hi Team,
>
> I am trying to test a code which basically tries to read some data from
> postgresql db in a loop through a function SQL_get_tpf_rw() whose
> definition and other details are shared in the attached file along with the
> memory
Hi Adrian and Ian,
Thank you for responding!
OS: CentOS 7.9.2009
Postgres: 14.5
It was an upgrade from an older version.
Thanks again! Thank you for your guidance!
Lan
> On Jan 14, 2024, at 8:50 AM, Adrian Klaver wrote:
>
> On 1/13/24 21:52, Lan Xu wrote:
>> With CREATE EXTENSION unaccen
You can find a lot information in this link
https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.html
To actually perform the migration, you can use some AWS tools such as SCT +
DMS:
https://docs.aws.amazon.com/prescriptive-guidance/latest/p
On 1/15/24 12:04, Lan Xu wrote:
Hi Adrian and Ian,
Thank you for responding!
OS: CentOS 7.9.2009
Postgres: 14.5
It was an upgrade from an older version.
From what repo?
And was that same repo as the older version was installed from?
Thanks again! Thank you for your guidance!
Lan
On Ja
I am working on an application using NB-20,
PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian
15.5-1.pgdg120+1)),
postgresql-42.7.0.jar.
openjdk 17.0.9 2023-10-17
OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1)
OpenJDK 64-Bit Server VM (build 17.0.9+9-Debian-1deb12u1, mix
On 1/15/24 13:33, Arbol One wrote:
I am working on an application using NB-20,
PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian
15.5-1.pgdg120+1)),
postgresql-42.7.0.jar.
openjdk 17.0.9 2023-10-17
OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1)
OpenJDK 64-Bit Server VM
Netbeans 20. Sorry, my bad.
On 2024-01-15 4:48 p.m., Adrian Klaver wrote:
On 1/15/24 13:33, Arbol One wrote:
I am working on an application using NB-20,
PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian
15.5-1.pgdg120+1)),
postgresql-42.7.0.jar.
openjdk 17.0.9 2023-10-17
OpenJDK Ru
On 1/15/24 14:38, Arbol One wrote:
Netbeans 20. Sorry, my bad.
And the rest of the questions?
On 2024-01-15 4:48 p.m., Adrian Klaver wrote:
On 1/15/24 13:33, Arbol One wrote:
I am working on an application using NB-20,
PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian
15.5-1.pg
Bro., is in the OP.
-
I am working on an application using NB-20,
PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian
15.5-1.pgdg120+1)),
postgresql-42.7.0.jar.
openjdk 17.0.9 2023-10-17
OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1)
OpenJDK 64-Bit Server VM
On Mon, Jan 15, 2024 at 2:33 PM Arbol One wrote:
> I am working on an application using NB-20,
> PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian
> 15.5-1.pgdg120+1)),
> postgresql-42.7.0.jar.
> openjdk 17.0.9 2023-10-17
> OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1)
>
On 1/15/24 17:59, Arbol One wrote:
Bro., is in the OP.
1) I am not your Bro.
2) When troubleshooting explicit is better then implicit. What is
obvious to you might not be obvious others. I have more then once
assumed and not verified and gone down a long trail of troubleshooting
only to fin
31 matches
Mail list logo
