alternatives - Search results in mailing lists

alternative to using parameterized queries, sanitized user input or any other injection mitigation measures, but would

desired constraints maybe an alternative approach for that use case could be suggested. David J.

alternative software that does virtual patching for PostgreSQL DB servers to the Trellix Database Security

alternatives. All those companies were at Pgconf2024.eu , unfortunately at the time, this project was still

swapping the tables is robust. Do you mean alternatives to table-cloning-and-swapping? Regards, - Marcelo

alternative is to use COPY, which gets your the rows as they come, but then

alternative solution. I think, we can update xmin horizon in checkpoint only but the horizon

Alternatively, one could use: #define READ_U32_UNALIGNED(src) \ ({ \ uint32 _tmp; \ memcpy(&_tmp, (src), sizeof

alternative plan but I'm still learning this. For example: create table t(x int); create

like pg_probackup. Any thoughts or alternative suggestions would be greatly appreciated! -- Regards, Japin Li

alternative approach would be to turn on C11 and add another option to explicitly turn

alternative data sources, or e.g. calling a user-defined SECURITY INVOKER function. PG18 still seems

alternative chain" they put in place back in 2021 for backwards compatibility with older clients

Alternatively, we could switch to using /usr/bin/env, but I'm not sure how universal it is. And if you want

Alternatively, reduce PostgreSQL's consumption of semaphores by reducing its max_connections parameter. The PostgreSQL

alternative suggestions and I look forward to hearing from you soon. Best regards, Rohit Bhati

alternative approach would be to initially take the X_AXIS_LENGTH-1 elements from the end of the array

Hi Hackers/Dave, Master password was added to encrypt passwords saved in pgAdmin config DB. While

alternative authentication sources. Fixes #7012" This reverts commit 0c823455a0ee74fca2af08abae10186b3733990d. Branch ------ master Details ------- https:///gitweb?p=pgadmin4.git;a=commitdiff;h=faff8d1fb31967624e7cdb1c46c9ec237e30aaef Modified

alternative encryption key. People can run their scripts to export those config vars. On Fri, Apr 22, 2022 at 2:38 PM Khushboo

alternative authentication sources. Fixes #7012 Branch ------ master Details ------- https:///gitweb?p=pgadmin4.git;a=commitdiff;h=0c823455a0ee74fca2af08abae10186b3733990d Author: Khushboo Vashi Modified

Alternatively, if I select 'CREATE Script' via context menu, it emits the same error - '>' not supported

alternatives, I don't overthink it anymore. Pretty much my lookup tables consist of an autogenerated

Alternatively (or additionally), provide a "jump to row..." button (similar to what Usman is suggesting

alternative method or a workaround, I would greatly appreciate your advice. Thank you for your

Alternatively , you can open a query for the same table in the query tool to cross

there an arm64 pgadmin4 for Linux? If not could you suggest an alternative? Thanks Ron.

alternative synchronization methods (e.g., HTTP/S, Git) recommended for maintaining mirrors? Background As a service provider

alternative email clients. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Do not let urgent

alternatives to this when someone runs a slim / stripped version of the OS in a docker

Alternatively, has anyone has success implementing an extension or periodic process to monitor the memory

alternative, if you have unix sockets configured and keep the superuser password empty, Patroni will

alternative solutions to minimize down time (one month)or another solution alternative for rebuild replica

Alternative: "This release expands on functionality for managing data in partitions or data spread out between

alternatives do job well nowadays) https:///en/company/flant/blog/527524/ All of them are being developed very actively

alternative wording. Anyway, please include with greater prominence, the existence of community If you know

alternative OAuth provider, before completely deleting the account. Obviously, you have a different opinion. ;) + Justin

alternative to a GUI, because both are for direct user interaction with the database without

alternative to dedicated text search technologies for web search and data mining" sound rather boring

alternative to cloud-managed databases (DBaaS) like Amazon RDS, Google Cloud SQL, and Azure Database

alternative. Links: [Website](https:///) | [GitHub](https:///Vonng/pigsty) | [Demo](https:///) | [Get Started](https:///docs/setup/install/)

alternative to cloud-managed databases (DBaaS) like Amazon RDS, Google Cloud SQL, and Azure Database

alternative. Links: [Website](https:///) | [GitHub](https:///Vonng/pigsty) | [Demo](https:///) | [Get Started](https:///docs/setup/install/)

alternative [`Supabase`](https:///docs/kernel/supabase/), which is newly available on Debian/Ubuntu in addition to EL distros

alternative for legacy multi-master replication technologies, offering greater throughput, flexibility, and control for users

Alternative idea is to lower the constant value when using an assertion build. That way, we don't need

alternative LEFT JOIN: SELECT count(*) FROM gaia_edr3_aux.panstarrs1bestneighbour AS gaps1 LEFT JOIN gaia

Alternatively, if VACUUM is likely to set incorrect reltuples, another just idea is to introduce

alternative, we could set recovery_target_inclusive to false in the setup_recovery function. This

alternative, you can download the latest *15.12-2* installer from the website and proceed with

know if this bug is being fixed or is there any other alternative. Thank you! - Pratik

alternative to ask them to cancel over; we really need them at the BOF instead

Alternatively, DDL versioning makes a certain amount of sense except that it's pretty hard

alternatively teach pg_restore_relation_stats() to translate reltuples based on the version argument, but since

alternative fix would have been to completely disallow the presorted optimization for Aggrefs with any FILTER

alternative fix would have been to completely disallow the presorted optimization for Aggrefs with any FILTER

alternative fix would have been to completely disallow the presorted optimization for Aggrefs with any FILTER

alternative approach considered was to take a strong lock on each affected table during publication

alternative approach considered was to take a strong lock on each affected table during publication

alternatives 1.3.20a-2 OK ash 20040127-3 OK autoconf 2.59-2 OK autoconf2.1 2.13-1 OK autoconf2.5

alternative method to the createdb command? Thanks, Mike Quoting Mike G : ---------------------------------------- This mail sent

alternative is Mysql but pgsql has way more features. Thank you in advance. Andrei Bintintan

alternative to saving data in regular files. I could have easily created a storage solution

Alternatively the commands can be placed in a batch file: del "c:\program files\postgresql

alternatively, chmod them to give write permissions to other groups; but I don't think

alternative I suggest adding this to Compatibility: In PostgreSQL, the concept of relation encompassess the various

alternative(s). I do get we are on the overview page but if we use either

alternatives such as pgAdmin, maybe should be moved here with some suitable alterations (or added

Alternatively, the password file to use can be specified using the connection parameter passfile

Alternatively, the password file to use ... I"m somewhat loath to repeat that in: https:///docs/16/libpq-connect.html#LIBPQ-CONNECT-PASSFILE

alternatively decide that that's a code bug and make ALTER DOMAIN take it, but I don't think

alternative tool) on the $PGDATA directory tree --- you could optionally exclude the pg_xlog directory

alternative to SQLServer, Oracle or even mySQL, an easy copy/move/replicate feature is a must. You agree

alternatives here are (a) to change the default max_stack_depth for Windows, or (b) to make

alternatives: 1. Setup PGPASSWORD in environment variables 2. use set to do a temporary version

alternatives. I would strip any leading dot and leave the rest up to the installer

alternative proposed, I think we have to go with the CSIDL_APPDATA reference point. Given

alternative is to rewrite pg_atoi, which doesn't seem worth the trouble. */ if( res<0 || res>TINY

alternative section to a section introduced by - either EXEC SQL ifdef name or - EXEC SQL ifndef

alternative to the 'dump to disk' approach which is to pipe the dump from the old DB to the new DB as outlined

useful and on-topic, and the alternatives less so. I'll be disappointed if you kill it.

Alternatively if your operating system has it you could install a precompiled DBD::Pg packages

alternative, because one of the motivations for dividing COPY data into messages in the V3 protocol

alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834

alternative option is to take downtime for DDL and restart the application. Or to chppse

alternative to blindly disabling PostgreSQL's use of a generic plan: you could examine the generic

Alternatively, I can create a fresh PR with the same changes against current master branch

alternatives, of course. Even for a fairly wide table of say 100 columns you could

alternative is of course the NUMERIC data type. On 2020-10-20 20:51, Andreas

Alternatively, a custom class name can be specified that implements org.postgresql.xml.PGXmlFactoryFactory and takes

alternative database products such as NoSQL, Oracle, MongoDB, GreenPlum * Two years of experience using Python

alternative instances sizes that would be sufficient, if not as cheap, but the system will

alternative solutions and/or workarounds *Additional Advantageous Skills * * Experience with NoSQL databases (e.g. Redis ) and NoSQL

alternatives -- is a crucial quality of our team members. Our work is organised in cross

alternative technical solutions. Contact: James Trefz | jtrefz@eccoselect.com | Senior Technical Recruiter | ECCO Select | 4100 N. Mulberry

alternative technology (SQL Server, Oracle) is a big Plus. Thank you, Stephanie Martel Senior Technical

alternative to using a psql script, with limitations, such as this one. It either handles

alternatives." fi if test ! -x "$POSTGRES"; then exit 1 fi opensuse:tumbleweed:20231031 Qt: 5.15.11 KDE Frameworks

pgREST or similar / alternative and what are the experiences? Thanks In advance! Kindest regards, Dionysis Kontominas

alternative loation for log_directory and permissions, so that I can use a script to sniff

alternative locales. On my RHEL box, "locale -a" reports 865 entries, and I'm pretty

alternatives and shortcuts in addition to its support for standard SQL. The best documentation I know

Alternatively you can use a file DSN or simply make a connection string from your

alternative ODBC drivers available in the market. While some minor improvements were observed in a few queries

Alternatively these could be serial and bigserial. A similar link for Oracle on data types

alternatives such as Devart, but it comes at a cost of $250. I am considering

Alternatively, the driver code is available and you may decide to find and fix the issue

Alternatively, just build with the latest code from the master branch. I'm not part

alternative and less robust. The code now waits at the end of recovery if we are in the middle

alternative that involved storing both hashcode and indexed value. We now see a possible production

present them as available alternatives and let add_path sort it out. regards, tom lane

alternative way to fetch the patch? I would have thought that anybody who can compile

alternative to getpeereid/getupeercred is password-based or certificate-based authenticated - which seem *less* secure because

alternative, but I wonder if anyone has a better idea? * The DROP code now requires

chance we would design an alternative MVCC system just to accommodate this use case. Cheers, Greg

alternative. I'm not sure how you expect that to be significantly cheaper than scanning

alternatives won't be better in terms of performance impact. Really, if this is a problem

alternatives that you should consider. Below, I'll outline some key points to Table Inheritance

alternative you might consider is pgEdge Platform. Specifically tailored for robust PostgreSQL MMR replication and high

Alternatively, if I strip some of the joins out, then I can leave the original

Alternatively, does pg_errormessage() have the same flaw, or does that give you the error

alternative. Is this a limitation of libpq or a flawed implementation in the php library

alternative database systems. (see http:///group/joomla-dev-cms/browse_thread/thread/1382dc6f4af56278#msg_9b95648941ef6fa7 for this

alternatively: UPDATE active_sessions SET access_time = current_timestamp::timestamp without time zone WHERE id = 469 I'm surprised

Alternatives? Insights? In Postgres, is there any way to use named params in my stored

On May 9, 2007, at 1:04 AM, Lynna Landstreet wrote: I think you might

alternative would have been to add *-pgdg-testing to sources.list, but let's keep

Alternatively, would providing Dockerfiles for respective distributions be a viable option? We’re open to any suggestions

alternatives in RPM when updating package. [ Michael Banck ] * pg_createcluster: Do not remove existing data

alternative WAL segment sizes for PostgreSQL <= 10. * Add hint to check SFTP authorization log. - Documentation

alternatives command line. Hopefully fixes "link and path can't be the same" errors. * debian/maintscripts-functions

alternatives trees for the manpages, where moving "slave" links from one tree to another is quite

alternatives (gdal33, 34, 35 ) too against the armadillo 12? Only in that case the next

alternative if you use the (RHCSL) Red Hat Software Collection version of this package. This

Alternatively remove llvmjit package until CentOS 8.3 is out. I am trying to rebuild LLVM

Alternatively we might be able to build with --enable-tap-tests and make 'perl(Test

alternative way to sign the packages. I updated my script for that. As a consequence

alternative could be "trust", because I am not holding my breath for the majority of our users

Alternatively, use 'sudo apt-get install postgresql-8.1' to display the list of necessary dependencies

alternative source - www.sunfreeware.com or www.blastwave.org. If you look for pgAdmin community

Alternatively I get the same messages as above but an additional WARNING regarding the crash

alternative; are there any options? (I don't yet know about how I'm going

Alternatively, bounce the details over to myself and/or Andrew Hammond, and we can see about

alternative fuels to reduce dependence on foreign oil sources. Reporting by Roddy Scheer http:///view/?2528

alternatively, what if Alice (knowing that Bob is her mentor) emails him repeatedly for advice

alternative default database\n" msgstr " -l, --database=ИМЯ_БД выбор другой базы данных по умолчанию

alternatively 2) you're facing a different problem that I don't understand. We try very

copies of one state from pg_stat_activity. Please suggest alternatives if any. Regards Prabhu David

allowed in a do statement. Any alternative to do that in a do statement? Regards, David

Alternatively, can we generate an empty table and append each newly generated table to it so that

alternative query does not have the hanging problem: WITH store_ids AS ( SELECT id FROM

According to the docs , the semantics of "`AT TIME ZONE" on timestamps is

would vote for it or not, alternative project ideas if not, etc. Thanks, Tan Tran

alternative expected output files still need to be updated. Stas couldn't find a system

alternative, in case we have difficulties. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

alternative interfaces for GiST/SP-GiST/GIN which deal with composite types and arrays. Then users can write

come up with an alternative proposal that you could work on and submit that. Regards Thom

Alternatively a small test case with which I can reproduce the problem on my system

alternative to *sqlparse*, for Python use, there is [*pglast*](https:///lelit/pglast), which, like [*pg_query

Alternatively there is link top middle which points to WikiEditing - PostgreSQL wiki Dave

alternative is gathering the data for other years from every mentor. Regards, -- Andreas 'ads' Scherbaum

alternative to that, since it apparently doesn't impact all machines the same way, would

alternative links. That should be https:///docs/current/features.html Edited. This is probably now https:///flex/manual/index.html I updated

alternative should not present the attachment. But one presenting the HTML body would present the attachment

alternative I keep forgetting about, the function make_interval(): https:///docs/current/functions-datetime.html make_interval ( [ years int [, months

alternative record factories. We can review if the best way is to create cursor subclasses

Alternatively (or in complement), how about renaming connection.cursor() as connection.client() for client-side

alternative: ``text``) - cast Python ``int`` to ``numeric`` by default (alternatives: ``int4``, ``int8``, ``unknown``). Being the adaptation

alternative to Python's builtin datetime. - No longer use 2to3 during installation for Python 2 & 3 compatibility

Alternatively, you can explicitly reference the schema in your query. (ie SELECT *schema_name*.func